where is my message?

[wkim]

Failure communicating with remote server. Please try again later.

Debug message: 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 'SQL090217102454930' defined on 'IMAP_FOLDER'.

Exception:

com.zimbra.common.service.ServiceException: system failure: Synchronization of folder 'Inbox/CallFire Notifier' failed
ExceptionId:btpool0-11:1234913688548:c280bd1c1e9409f6
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:277)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:200)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:172)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:131)
at com.zimbra.cs.OfflineImapImport.importData(Offline ImapImport.java:48)
at com.zimbra.cs.offline.GMailImport.importData(GMail Import.java:53)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:154)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:417)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:389)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:431)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:49)
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-11:1234913688541:c280bd1c1e9409f6
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:320)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:518)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:128)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:195)
... 35 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 'SQL090217102454930' 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)
... 39 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 'SQL090217102454930' 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)
... 44 more

If issue persists please post description and debug information here.

[jjzhuang]

please follow these steps to collect debug trace: http://wiki.zimbra.com/index.php?tit...by_an_error.3F

[gagik]

Originally Posted by jjzhuang

please follow these steps to collect debug trace: Yahoo! Zimbra Desktop FAQ - Zimbra :: Wiki

I have the same problem with my yahoo account. I reinstalled ZD without deleting data, but it did not help

Debug message: 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 'SQL090726163502460' defined on 'IMAP_FOLDER'.
Exception:
com.zimbra.common.service.ServiceException: system failure: Synchronization of folder 'Ysent_1' failed
ExceptionId:mid=2:1248732320309:25d2568ee3f3d704
Code:service.FAILURE

Thanks for help

[rev.derek]

Me too but I have an Exchange IMAP, Gmail and Zimbra account setup. This appears on the Zimbra account.

============================== SYNC DEBUG TRACE START ==============================
2009-08-27 13:24:16,723 INFO [btpool0-21] [mid=2;] offline - >>>>>>>> name=derek@nativity.org.nz;version=1.0;build=1593; release=R;os=Linux i386 2.6.28-15-generic;server=5.0.18
2009-08-27 13:24:16,731 DEBUG [btpool0-21] [mid=2;] request - <SyncRequest typed="1" token="1557" xmlns="urn:zimbraMail"/>
2009-08-27 13:24:16,767 DEBUG [btpool0-21] [mid=2;] response - <SyncResponse md="1251336261" token="1585" xmlns="urn:zimbraMail"><folder view="message" i4ms="1558" ms="1558" md="1251330428" i4next="263" l="2" id="262" rev="1558" color="0" f="" u="0" url="" n="0" name="ipcop" s="0"><acl/></folder><m ms="1578" md="1251334720" l="2" id="263" rev="1560"/><m d="1251328968000" ms="1579" md="1251334729" f="" t="" l="2" cid="-261" id="261" rev="1551"/></SyncResponse>
2009-08-27 13:24:16,768 DEBUG [btpool0-21] [mid=2;] offline - starting delta sync [token 1557]
2009-08-27 13:24:16,805 ERROR [btpool0-21] [mid=2;] offline - sync failure: derek@nativity.org.nz
com.zimbra.common.service.ServiceException: system failure: renumbering folder (1073741841 => 262)
ExceptionId:btpool0-21:1251336256783:def397f7ea3f7cd5
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbOfflineMailbox.renumberItemManu al(DbOfflineMailbox.java:148)
at com.zimbra.cs.db.DbOfflineMailbox.renumberItem(DbO fflineMailbox.java:43)
at com.zimbra.cs.mailbox.OfflineMailbox.renumberItem( OfflineMailbox.java:342)
at com.zimbra.cs.mailbox.OfflineMailbox.renumberItem( OfflineMailbox.java:303)
at com.zimbra.cs.mailbox.DeltaSync.resolveFolderConfl icts(DeltaSync.java:560)
at com.zimbra.cs.mailbox.DeltaSync.syncFolder(DeltaSy nc.java:477)
at com.zimbra.cs.mailbox.DeltaSync.syncContainer(Delt aSync.java:404)
at com.zimbra.cs.mailbox.DeltaSync.deltaSync(DeltaSyn c.java:222)
at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.jav a:92)
at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.jav a:76)
at com.zimbra.cs.mailbox.MailboxSync.sync(MailboxSync .java:188)
at com.zimbra.cs.mailbox.OfflineMailbox.sync(OfflineM ailbox.java:140)
at com.zimbra.cs.service.offline.OfflineSync.handle(O fflineSync.java:47)
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:275)
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 'PK_MAIL_ITEM' defined on 'MAIL_ITEM'.
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.DbOfflineMailbox.renumberItemManu al(DbOfflineMailbox.java:66)
... 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 'PK_MAIL_ITEM' defined on 'MAIL_ITEM'.
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-08-27 13:24:16,807 DEBUG [btpool0-21] [mid=2;] offline - ============================== SYNC DEBUG TRACE END ================================