Thread: IMAP error: unable to store IMAP message data
View Single Post
  #9 (permalink)  
Old 04-27-2008, 10:50 PM
mbd mbd is offline
Senior Member
  
Posts: 58
Default
Quote:
Originally Posted by jholder View Post
Sorry it's not working well enough. There's a bug. I suggest you wait for it to get fixed.
I think this information may be of assistance - I was getting similar errors and it appeared that the external mail service wasn't coping with the name of one of the mailboxes on the remote IMAP server (Apple's .Mac mail service). It was called Junk (.Mac). I've since removed that folder from the remote server since it had no messages.

Excerpt from the mailbox.log

Quote:
our.company.com2008-04-28 13:57:29,473 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Importing data.
2008-04-28 13:57:31,006 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Found new remote folder things I need to keep. Creating local folder /MacMail/things I need to keep.
2008-04-28 13:57:31,007 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] mailbox - Created folder /MacMail/things I need to keep, id=2613
2008-04-28 13:57:31,232 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Found new remote folder Email before 2008. Creating local folder /MacMail/Email before 2008.
2008-04-28 13:57:31,233 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] mailbox - Created folder /MacMail/Email before 2008, id=2614
2008-04-28 13:57:31,435 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Found new remote folder Apple Mail To Do. Creating local folder /MacMail/Apple Mail To Do.
2008-04-28 13:57:31,436 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] mailbox - Created folder /MacMail/Apple Mail To Do, id=2615
2008-04-28 13:57:31,635 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Found new remote folder Deleted Messages. Creating local folder /MacMail/Deleted Messages.
2008-04-28 13:57:31,636 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] mailbox - Created folder /MacMail/Deleted Messages, id=2616
2008-04-28 13:57:31,825 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Found new remote folder Sent Messages. Creating local folder /MacMail/Sent Messages.
2008-04-28 13:57:31,826 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] mailbox - Created folder /MacMail/Sent Messages, id=2617
2008-04-28 13:57:32,025 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Found new remote folder Junk (.Mac). Creating local folder /MacMail/Junk (.Mac).
2008-04-28 13:57:32,026 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] mailbox - Created folder /MacMail/Junk (.Mac), id=2618
2008-04-28 13:57:32,035 WARN [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] datasource - Import failed
com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:183)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:108)
at com.zimbra.cs.datasource.ImapImport.importData(Ima pImport.java:263)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:149)
at com.zimbra.cs.service.mail.ImportData.handle(Impor tData.java:62)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:342)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:208)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:113)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:272)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:174)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1093)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: Data truncation: Out of range value adjusted for column 'uid_validity' at row 1

Query being executed when exception was thrown:

com.mysql.jdbc.ServerPreparedStatement[1879] - INSERT INTO mboxgroup22.imap_folder (mailbox_id, item_id, data_source_id, local_path, remote_path, uid_validity) VALUES (22, 2618, '86be469a-aa5e-45d5-8b62-3de54973c6d3', '/MacMail/Junk (.Mac)', 'Junk (.Mac)', -1)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2868)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1299)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:103)
... 33 more
2008-04-28 13:57:32,036 INFO [btpool0-284] [name=username@our.company.com;aname=admin@our.comp any.com;mid=22;ip=192.168.1.1;ds=MacMail;ua=Zimbra WebClient - FF2.0 (Mac)/5.0.1_GA_1902.MACOSXx86;] SoapEngine - handler exception
com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:183)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:108)
at com.zimbra.cs.datasource.ImapImport.importData(Ima pImport.java:263)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:149)
at com.zimbra.cs.service.mail.ImportData.handle(Impor tData.java:62)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:342)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:208)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:113)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:272)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:174)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1093)
at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:132)
at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:716)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:406)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
at org.mortbay.jetty.Server.handle(Server.java:313)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
Caused by: java.sql.SQLException: Data truncation: Out of range value adjusted for column 'uid_validity' at row 1

Query being executed when exception was thrown:

com.mysql.jdbc.ServerPreparedStatement[1879] - INSERT INTO mboxgroup22.imap_folder (mailbox_id, item_id, data_source_id, local_path, remote_path, uid_validity) VALUES (22, 2618, '86be469a-aa5e-45d5-8b62-3de54973c6d3', '/MacMail/Junk (.Mac)', 'Junk (.Mac)', -1)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2868)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1299)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:103)
... 33 more
2008-04-28 13:57:45,062 INFO [IndexWritersSweeperThread] [] index - open index writers sweep: before=3, closed=0, after=3 (0ms)
Reply With Quote