[SOLVED] Sudden problem synching with gmail

[bouchardpie]

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

[dac]

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.

[bouchardpie]

Originally Posted by dac

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

[dac]

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

[bouchardpie]

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

[bouchardpie]

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

[dac]

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.

[cal47]

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?

[cal47]

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