logs provided SYNC DEBUG TRACE START ==============================
2009-01-22 09:42:53,724 INFO [btpool0-16] [mid=2;] offline - >>>>>>>> name=randhirv@yahoo.com;version=0.92;build=1433;re lease=BETA;os=Mac OS X i386 10.5.6;type=imap
2009-01-22 09:42:53,725 INFO [btpool0-16] [mid=2;] datasource - Importing data for data source 'Randhirv@yahoo'
2009-01-22 09:42:54,067 DEBUG [btpool0-16] [mid=2;] imap - S: * OK IMAP4rev1 server ready (3.5.39)
2009-01-22 09:42:54,067 DEBUG [btpool0-16] [mid=2;] imap - C: C01 CAPABILITY
2009-01-22 09:42:54,097 DEBUG [btpool0-16] [mid=2;] imap - S: * CAPABILITY IMAP4rev1 LOGIN-REFERRALS AUTH=XYMCOOKIE AUTH=XYMCOOKIEB64 AUTH=XYMPKI AUTH=XYMECOOKIE ID
2009-01-22 09:42:54,097 DEBUG [btpool0-16] [mid=2;] imap - S: C01 OK CAPABILITY completed
2009-01-22 09:42:54,098 DEBUG [btpool0-16] [mid=2;] imap - C: C02 AUTHENTICATE XYMECOOKIE
2009-01-22 09:42:54,124 DEBUG [Thread-48] [] imap - S: +
2009-01-22 09:42:54,124 DEBUG [btpool0-16] [mid=2;] imap - C: <authentication data>
2009-01-22 09:42:56,214 DEBUG [Thread-48] [] imap - S: C02 OK AUTHENTICATE completed
2009-01-22 09:42:56,214 DEBUG [btpool0-16] [mid=2;] imap - C: C03 LIST "" ""
2009-01-22 09:42:56,296 DEBUG [Thread-48] [] imap - S: * LIST (\Noselect) NIL ""
2009-01-22 09:42:56,296 DEBUG [Thread-48] [] imap - S: C03 OK LIST completed
2009-01-22 09:42:56,298 DEBUG [btpool0-16] [mid=2;] datasource - Found 18 folders for DataSource: { id=614bf482-bd5b-401a-a8d1-ceb5ca93a2b5, type=imap, isEnabled=true, name=Randhirv@yahoo, host=zimbra.imap.mail.yahoo.com, port=993, connectionType=ssl, username=randhirv, folderId=1 }
2009-01-22 09:42:56,298 DEBUG [btpool0-16] [mid=2;] imap - C: C04 LIST "" "*"
2009-01-22 09:42:57,853 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Bulk Mail"
2009-01-22 09:42:57,854 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Action items"
2009-01-22 09:42:57,854 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Anjali"
2009-01-22 09:42:57,854 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Archive"
2009-01-22 09:42:57,855 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Babysitters"
2009-01-22 09:42:57,855 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Car"
2009-01-22 09:42:57,855 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Career"
2009-01-22 09:42:57,855 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Craigslist"
2009-01-22 09:42:57,856 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Draft"
2009-01-22 09:42:57,856 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Drafts"
2009-01-22 09:42:57,856 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Dream Dinners"
2009-01-22 09:42:57,856 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Finance"
2009-01-22 09:42:57,856 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Home buying"
2009-01-22 09:42:57,857 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Inbox"
2009-01-22 09:42:57,857 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Luke"
2009-01-22 09:42:57,857 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "MAS LLC"
2009-01-22 09:42:57,858 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Marriage Encounter"
2009-01-22 09:42:57,858 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Maryville"
2009-01-22 09:42:57,858 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Passwords"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Purchases"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "RestaurantDotcom"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Resumes"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Sent"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Sent Items"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Trash"
2009-01-22 09:42:57,859 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "Travel"
2009-01-22 09:42:57,860 DEBUG [Thread-48] [] imap - S: * LIST (\HasNoChildren) NIL "vine99"
2009-01-22 09:42:57,860 DEBUG [Thread-48] [] imap - S: C04 OK LIST completed
2009-01-22 09:42:57,861 DEBUG [btpool0-16] [mid=2;] imap - C: C05 SELECT Draft
2009-01-22 09:43:00,312 DEBUG [Thread-48] [] imap - S: * 0 EXISTS
2009-01-22 09:43:00,312 DEBUG [Thread-48] [] imap - S: * 0 RECENT
2009-01-22 09:43:00,312 DEBUG [Thread-48] [] imap - S: * OK [UNSEEN 0] Message 0 is first unseen
2009-01-22 09:43:00,312 DEBUG [Thread-48] [] imap - S: * OK [UIDVALIDITY 3] UIDs valid
2009-01-22 09:43:00,313 DEBUG [Thread-48] [] imap - S: * OK [UIDNEXT 14915] Predicted next UID
2009-01-22 09:43:00,313 DEBUG [Thread-48] [] imap - S: * FLAGS (\Answered \Flagged \Deleted \Seen \Draft)
2009-01-22 09:43:00,313 DEBUG [Thread-48] [] imap - S: * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen \Draft)] Permanent flags
2009-01-22 09:43:00,313 DEBUG [Thread-48] [] imap - S: C05 OK [READ-WRITE] SELECT completed; now in selected state
2009-01-22 09:43:00,314 DEBUG [btpool0-16] [mid=2;] datasource - Local folder '/Drafts': Setting NO_INFERIORS flag on local folder
2009-01-22 09:43:00,316 DEBUG [btpool0-16] [mid=2;] datasource - createImapFolder: itemId = 6, localPath = /Drafts, remotePath = Draft, uidValidity = 3
2009-01-22 09:43:00,328 ERROR [btpool0-16] [mid=2;] datasource - Synchronization of folder 'Draft' failed
com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:btpool0-16:1232646180323:3c5f921fe369c7a4
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:111)
at com.zimbra.cs.account.DataSource.createImapFolder( DataSource.java:324)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:496)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:126)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:179)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:156)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:119)
at com.zimbra.cs.offline.YMailImport.importData(YMail Import.java:56)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:154)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:367)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:340)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:401)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:48)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:269)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:190)
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.handle(Se rvletHandler.java:362)
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:211)
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: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090119203716470' defined on 'IMAP_FOLDER'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:106)
... 38 more
Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090119203716470' defined on 'IMAP_FOLDER'.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ertAndCheckDups(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doI nsert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger. insert(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.i nsertRow(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. normalInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 43 more
2009-01-22 09:43:00,331 INFO [btpool0-16] [mid=2;] datasource - Import completed for data source 'Randhirv@yahoo'
2009-01-22 09:43:00,339 ERROR [btpool0-16] [mid=2;] offline - sync failure: Randhirv@yahoo
com.zimbra.common.service.ServiceException: system failure: Synchronization of folder 'Draft' failed
ExceptionId:btpool0-16:1232646180331:3c5f921fe369c7a4
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:261)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:184)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:156)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:119)
at com.zimbra.cs.offline.YMailImport.importData(YMail Import.java:56)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:154)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:367)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:340)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:401)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:48)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng ine.java:429)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:286)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:160)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:269)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:190)
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.handle(Se rvletHandler.java:362)
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:211)
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: com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:btpool0-16:1232646180323:3c5f921fe369c7a4
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:111)
at com.zimbra.cs.account.DataSource.createImapFolder( DataSource.java:324)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:496)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:126)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:179)
... 34 more
Caused by: java.sql.SQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090119203716470' defined on 'IMAP_FOLDER'.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.get SQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLExcep tion(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl .handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleE xception(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeS tatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement. executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
at com.zimbra.cs.db.DbImapFolder.createImapFolder(DbI mapFolder.java:106)
... 38 more
Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL090119203716470' defined on 'IMAP_FOLDER'.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ertAndCheckDups(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.doI nsert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexChanger.ins ert(Unknown Source)
at org.apache.derby.impl.sql.execute.IndexSetChanger. insert(Unknown Source)
at org.apache.derby.impl.sql.execute.RowChangerImpl.i nsertRow(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. normalInsertCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet. open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 43 more
2009-01-22 09:43:00,340 DEBUG [btpool0-16] [mid=2;] offline - ============================== SYNC DEBUG TRACE END ================================ |