Results 1 to 4 of 4

Thread: where is my message?

  1. #1
    Join Date
    Feb 2009
    Posts
    1
    Rep Power
    6

    Default where is my message?

    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.

  2. #2
    Join Date
    Jan 2007
    Posts
    1,688
    Rep Power
    11

    Default

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

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    Rep Power
    6

    Default

    Quote Originally Posted by jjzhuang View Post
    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

  4. #4
    Join Date
    Aug 2009
    Location
    New Zealand
    Posts
    32
    Rep Power
    6

    Default

    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 ================================

Similar Threads

  1. Confused On Maximum Message Size
    By soxfan in forum Administrators
    Replies: 6
    Last Post: 06-25-2013, 08:20 PM
  2. Message disappears between MTA and mailbox server
    By andrew_l in forum Administrators
    Replies: 12
    Last Post: 07-09-2010, 12:26 AM
  3. Error with NAS
    By Drox in forum Installation
    Replies: 4
    Last Post: 11-06-2008, 11:32 AM
  4. Replies: 3
    Last Post: 07-19-2007, 03:00 AM
  5. Replies: 4
    Last Post: 08-10-2006, 11:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •