Results 1 to 9 of 9

Thread: [SOLVED] Sudden problem synching with gmail

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

    Default [SOLVED] Sudden problem synching with gmail

    Hi,

    New user and although initially all was well, my acct stopped synching. I get this error:

    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 'SQL090216125412870' defined on 'IMAP_FOLDER'.

    Exception:

    com.zimbra.common.service.ServiceException: system failure: Synchronization of folder '[Gmail]/Spam' failed
    ExceptionId:mid=2:1234806976230:3bcce933b9a7bf6e
    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.mailbox.LocalMailbox.syncOnTimer(Loc alMailbox.java:361)
    at com.zimbra.cs.mailbox.DesktopMailbox$1.run(Desktop Mailbox.java:436)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
    Caused by: com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
    ExceptionId:mid=2:1234806976225:3bcce933b9a7bf6e
    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)
    ... 12 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 'SQL090216125412870' 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)
    ... 16 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 'SQL090216125412870' 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)
    ... 21 more

    If issue persists please post description and debug information here.



    Can anyone help?
    Thanks,
    -Pierre Bouchard

  2. #2
    Join Date
    May 2008
    Posts
    63
    Rep Power
    7

    Default

    Hi Pierre,

    Could you please enable debug trace in account settings and then send us the log file? It looks like your GMail Spam folder is not getting mapped to a local folder name correctly. The output from IMAP LIST should show us which remote folder names exist for your account.

  3. #3
    Join Date
    Feb 2009
    Posts
    5
    Rep Power
    6

    Default Synch problem - SPAM folder related in gMail

    Quote Originally Posted by dac View Post
    Hi Pierre,

    Could you please enable debug trace in account settings and then send us the log file? It looks like your GMail Spam folder is not getting mapped to a local folder name correctly. The output from IMAP LIST should show us which remote folder names exist for your account.
    DAC,
    Here's the text after turning debug on:

    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 'SQL090216145347340' defined on 'IMAP_FOLDER'.

    Exception:

    com.zimbra.common.service.ServiceException: system failure: Synchronization of folder '[Gmail]/Spam' failed
    ExceptionId:btpool0-7:1234878117708:6e320ea912073993
    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-7:1234878117704:6e320ea912073993
    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 'SQL090216145347340' 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:233)
    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 'SQL090216145347340' 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.


    Thanks,
    -Pierre Bouchard

  4. #4
    Join Date
    May 2008
    Posts
    63
    Rep Power
    7

    Default

    Pierre,

    Unfortunately, there is still not enough information to go on. If you can, please follow these instructions to collect a debug trace: Yahoo! Zimbra Desktop FAQ - Zimbra :: Wiki

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

    Default

    Here's the debug trace. I thought I had found the problem in that it seemed to be not liking ":" that I had as part of several label names. But I removed all of those and it seems to always come back to [GMail]/Spam folder not synching.

    Here's the lastest trace...

    2009-02-18 10:38:22,902 DEBUG [btpool0-25] [mid=7;] offline - ============================== SYNC DEBUG TRACE START ==============================
    2009-02-18 10:38:22,902 INFO [btpool0-25] [mid=7;] offline - >>>>>>>> name=bouchardpie@gmail.com;version=1.0;build=1482; release=RC1;os=Windows Vista x86 6.0;type=imap
    2009-02-18 10:38:22,903 INFO [btpool0-25] [mid=7;] datasource - Importing data for data source 'bouchardpie@gmail.com'
    2009-02-18 10:38:22,904 INFO [btpool0-25] [mid=7;] datasource - IMAP response timeout is 60 seconds
    2009-02-18 10:38:23,189 DEBUG [btpool0-25] [mid=7;] imap - S: * OK Gimap ready for requests from 74.69.241.69 s27if849181qbs.8
    2009-02-18 10:38:23,189 DEBUG [btpool0-25] [mid=7;] imap - C: C01 CAPABILITY
    2009-02-18 10:38:23,246 DEBUG [btpool0-25] [mid=7;] imap - S: * CAPABILITY IMAP4rev1 UNSELECT IDLE NAMESPACE QUOTA XLIST CHILDREN XYZZY
    2009-02-18 10:38:23,246 DEBUG [btpool0-25] [mid=7;] imap - S: C01 OK Thats all she wrote! s27if849181qbs.8
    2009-02-18 10:38:23,246 DEBUG [btpool0-25] [mid=7;] imap - C: C02 LOGIN bouchardpie@gmail.com <password>
    2009-02-18 10:38:23,470 DEBUG [btpool0-25] [mid=7;] imap - S: C02 OK bouchardpie@gmail.com authenticated (Success)
    2009-02-18 10:38:23,470 DEBUG [btpool0-25] [mid=7;] imap - C: C03 LIST "" ""
    2009-02-18 10:38:23,569 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\Noselect) "/" "/"
    2009-02-18 10:38:23,570 DEBUG [btpool0-25] [mid=7;] imap - S: C03 OK Success
    2009-02-18 10:38:23,607 DEBUG [btpool0-25] [mid=7;] datasource - Found 37 folders for DataSource: { id=66478667-6731-4afd-a109-061cf622043e, type=imap, isEnabled=true, name=bouchardpie@gmail.com, host=imap.gmail.com, port=993, connectionType=ssl, username=bouchardpie@gmail.com, folderId=1 }
    2009-02-18 10:38:23,607 DEBUG [btpool0-25] [mid=7;] imap - C: C04 LIST "" "*"
    2009-02-18 10:38:23,706 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasChildren) "/" "972 Project Related"
    2009-02-18 10:38:23,706 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "972 Project Related/MLS Listing related"
    2009-02-18 10:38:23,706 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Arts and Entertainment"
    2009-02-18 10:38:23,706 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Attached Documents"
    2009-02-18 10:38:23,706 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "BOGUS MAIL SENT"
    2009-02-18 10:38:23,706 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Charity I Gave to"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Contact - High Tech"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Countrywide Mortgage"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Drafts"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "FAMILY"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "FRIEND"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Facebook or Twitter related"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasChildren) "/" "Financial"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Financial/Financial - Addison Avenue"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Financial/Financial - Credit Card"
    2009-02-18 10:38:23,707 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Financial/Financial - Fidelity"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Financial/Financial - ING Direct"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Google Alerts"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "INBOX"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Internet Domains I Own Related"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Kennebunk Bill-Pay"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Library"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Netflix"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "News"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Online Accounts"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Proulx Oil and Propane"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "STUFF I BUY ON THE WEB"
    2009-02-18 10:38:23,708 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Sent"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Subscription Data"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "TREE Gear"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Trash"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Travel"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Utilites-telephone"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Utilities"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "Zimbra-related"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\Noselect \HasChildren) "/" "[Gmail]"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "[Gmail]/All Mail"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "[Gmail]/Drafts"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "[Gmail]/Sent Mail"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "[Gmail]/Spam"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "[Gmail]/Starred"
    2009-02-18 10:38:23,709 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "[Gmail]/Trash"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "_Charlotte new car search"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "_MarketWatch Alerts"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "_Skilmer"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "bouchardpie@maine.rr.com"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "junk"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: * LIST (\HasNoChildren) "/" "pbouchard@maine.rr.com"
    2009-02-18 10:38:23,744 DEBUG [btpool0-25] [mid=7;] imap - S: C04 OK Success
    2009-02-18 10:38:23,745 DEBUG [btpool0-25] [mid=7;] imap - C: C05 SELECT [Gmail]/Spam
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * FLAGS (\Answered \Flagged \Draft \Deleted \Seen)
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * OK [PERMANENTFLAGS (\Answered \Flagged \Draft \Deleted \Seen \*)]
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * OK [UIDVALIDITY 6]
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * 0 EXISTS
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * 0 RECENT
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * OK [UNSEEN 0]
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: * OK [UIDNEXT 9183]
    2009-02-18 10:38:23,897 DEBUG [btpool0-25] [mid=7;] imap - S: C05 OK [READ-WRITE] [Gmail]/Spam selected. (Success)
    2009-02-18 10:38:23,898 DEBUG [btpool0-25] [mid=7;] datasource - createImapFolder: itemId = 4, localPath = /Junk, remotePath = [Gmail]/Spam, uidValidity = 6
    2009-02-18 10:38:23,905 ERROR [btpool0-25] [mid=7;] datasource - Synchronization of folder '[Gmail]/Spam' failed
    com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
    ExceptionId:btpool0-25:1234971503901:6e320ea912073993
    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)
    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: 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 'SQL090218103627680' 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 'SQL090218103627680' 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
    2009-02-18 10:38:23,907 INFO [btpool0-25] [mid=7;] datasource - Import completed for data source 'bouchardpie@gmail.com'
    2009-02-18 10:38:23,908 ERROR [btpool0-25] [mid=7;] offline - sync failure: bouchardpie@gmail.com
    com.zimbra.common.service.ServiceException: system failure: Synchronization of folder '[Gmail]/Spam' failed
    ExceptionId:btpool0-25:1234971503907:6e320ea912073993
    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-25:1234971503901:6e320ea912073993
    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 'SQL090218103627680' 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 'SQL090218103627680' 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
    2009-02-18 10:38:23,909 DEBUG [btpool0-25] [mid=7;] offline - ============================== SYNC DEBUG TRACE END ================================


    Thanks,
    -Pierre Bouchard

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

    Default

    I resolved the issue. It appears that Zimbra renames the Spam folder "Junk" and I had an existing Gmail label called "junk". Eliminating that allowed the account to synch. I don't know why it synched initially though - as the "junk" label existed before I first loaded Zimbra and the initial synch happened without incident.
    -Pierre Bouchard

  7. #7
    Join Date
    May 2008
    Posts
    63
    Rep Power
    7

    Default

    Thanks Pierre,

    I've filed a bug to track this issue: Bug 35514 &ndash; Duplicate IMAP_FOLDER tracker when import GMail folder/label named 'junk'. We'll try to get the fix into the next RC2 release.

  8. #8
    Join Date
    Sep 2010
    Posts
    2
    Rep Power
    5

    Default Different flavor of the same problem

    Hey All,

    I'm using the Zimbra Desktop on OS X 10.6.4 and I'm having a similar issue with my gmail account.

    I've been using Zimbra for about 1 week and then yesterday it suddenly stopped sending and receiving. It's in a perpetual state of synch, just pin-wheeling away. When I click on the set up link, I get an "in progress" status and the last synch occured on 9/8 at 3:10pm.

    any ideas?

  9. #9
    Join Date
    Sep 2010
    Posts
    2
    Rep Power
    5

    Default

    So I re-installed the desktop client and doing that cleared up my problem and it wasn't nearly as annoying as I expected.

Similar Threads

  1. Mobile Phone Field not Synching with Gmail contacts
    By strider871 in forum Error Reports
    Replies: 4
    Last Post: 03-02-2009, 10:56 PM
  2. Zimbra Desktop and Gmail
    By Magritte in forum General Questions
    Replies: 4
    Last Post: 02-11-2009, 07:31 AM
  3. Synching problem
    By danny.sierra@omtech.net in forum Error Reports
    Replies: 0
    Last Post: 05-27-2008, 09:26 PM
  4. [SOLVED] Upgraded to 5.0 OSS - Sendmail Problem
    By Chewie71 in forum Installation
    Replies: 11
    Last Post: 12-28-2007, 07:07 PM
  5. Is it started or not
    By kwelipatton in forum Installation
    Replies: 10
    Last Post: 03-28-2006, 11:11 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
  •