Sync error messages

[Jan L]

Sync from my Yahoo mailbox is not functioning. Several error reports are popping up. See below. My browser is Firefox 3.0.6; Windows XP platform and Zimbra ver. 1.0_build1482. Seems to be Java related somehow, but my Java is updated to latest version 6.12. Would appreciate some advice from this forum. Since I'm not an expert please keep it simple (if possible!)
Thanks a lot - Jan L

Error report here:
Debug message: Connection is closed

Exception:

com.zimbra.common.service.ServiceException: system failure: Synchronization of folder '/Yahoo' failed
ExceptionId:mid=2:1234707899414:bf9d7b98912d8414
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.syncMessages(Ima pSync.java:239)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:174)
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.YMailImport.importData(YMail Import.java:90)
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: java.io.IOException: Connection is closed
at com.zimbra.cs.mailclient.imap.ImapConnection.sendR equest(ImapConnection.java:467)
at com.zimbra.cs.mailclient.imap.ImapRequest.send(Ima pRequest.java:76)
at com.zimbra.cs.mailclient.imap.ImapRequest.sendChec kStatus(ImapRequest.java:80)
at com.zimbra.cs.mailclient.imap.ImapConnection.doSel ectOrExamine(ImapConnection.java:195)
at com.zimbra.cs.mailclient.imap.ImapConnection.selec t(ImapConnection.java:182)
at com.zimbra.cs.datasource.RemoteFolder.select(Remot eFolder.java:202)
at com.zimbra.cs.datasource.ImapFolderSync.checkUidVa lidity(ImapFolderSync.java:715)
at com.zimbra.cs.datasource.ImapFolderSync.syncMessag es(ImapFolderSync.java:208)
at com.zimbra.cs.datasource.ImapSync.syncMessages(Ima pSync.java:236)
... 12 more

[jjzhuang]

where exactly do you see this? can you provide a screenshot? are you seeing this in a UI popup or in the log?

[Jan L]

The error reports appeared in my 'Error Reports' folder. I deleted after having pasted into my first report to this forum, but now I received 2 new error reports - in the same 'Error Reports' folder.
Latest report here (is this format OK?):
Regards Jan

Product name: Zimbra Desktop
Product version: 1.0
Build ID: 1482
Release type: RC1
OS Platform: Windows XP x86 5.1
Time of event: 2009-02-15 16:24:18
Error type: service.FAILURE
Item ID: -1
Error summary: Fetch failed for uid 14817

Failure details - PLEASE REMOVE ANY SENSITIVE INFORMATION
----------------------------------------------------------------------------

com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:mid=2:1234711458336:bf9d7b98912d8414
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapMessage.storeImapMessage(Db ImapMessage.java:69)
at com.zimbra.cs.datasource.ImapFolderSync.storeImapM essage(ImapFolderSync.java:701)
at com.zimbra.cs.datasource.ImapFolderSync.handleFetc h(ImapFolderSync.java:992)
at com.zimbra.cs.datasource.ImapFolderSync.access$500 (ImapFolderSync.java:63)
at com.zimbra.cs.datasource.ImapFolderSync$2.handleFe tchResponse(ImapFolderSync.java:907)
at com.zimbra.cs.mailclient.imap.FetchResponseHandler .handleResponse(FetchResponseHandler.java:34)
at com.zimbra.cs.mailclient.imap.ImapConnection.proce ssUntagged(ImapConnection.java:678)
at com.zimbra.cs.mailclient.imap.ImapConnection.proce ssResponse(ImapConnection.java:650)
at com.zimbra.cs.mailclient.imap.ImapConnection.nextR esponse(ImapConnection.java:627)
at com.zimbra.cs.mailclient.imap.ImapConnection.waitF orResponse(ImapConnection.java:548)
at com.zimbra.cs.mailclient.imap.ImapConnection.sendR equest(ImapConnection.java:483)
at com.zimbra.cs.mailclient.imap.ImapRequest.send(Ima pRequest.java:76)
at com.zimbra.cs.mailclient.imap.ImapRequest.sendChec kStatus(ImapRequest.java:80)
at com.zimbra.cs.mailclient.imap.ImapConnection.uidFe tch(ImapConnection.java:305)
at com.zimbra.cs.datasource.ImapFolderSync.fetchMessa ges(ImapFolderSync.java:919)
at com.zimbra.cs.datasource.ImapFolderSync.fetchMessa ges(ImapFolderSync.java:854)
at com.zimbra.cs.datasource.ImapFolderSync.fetchMessa ges(ImapFolderSync.java:843)
at com.zimbra.cs.datasource.ImapFolderSync.syncMessag es(ImapFolderSync.java:241)
at com.zimbra.cs.datasource.ImapSync.syncMessages(Ima pSync.java:236)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:174)
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.YMailImport.importData(YMail Import.java:90)
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: 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 'I_UID_IMAP_ID' defined on 'IMAP_MESSAGE'.
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.DbImapMessage.storeImapMessage(Db ImapMessage.java:66)
... 30 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 'I_UID_IMAP_ID' defined on 'IMAP_MESSAGE'.
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)
... 35 more

----------------------------------------------------------------------------

[dac]

Did you happen to move messages between local folders, or delete a message with sync enabled on the Trash folder? If so then this should be fixed in Bug 34871 – offline : Deleted mail shows unread in trash folder which will be in the next RC release.

[Jan L]

Yes, these functions seems to work fine. Jan L

[jmckinl]

I am seeing this error as well by using Zimbra to manage mail in my IMAP account and move them from the Inbox to the appropriate folder.

----------------------------------------------------------------------------
Product name: Zimbra Desktop
Product version: 1.0
Build ID: 1482
Release type: RC1
OS Platform: Windows Vista x86 6.0
Time of event: 2009-02-25 20:26:16
Error type: service.FAILURE
Item ID: -1
Error summary: Fetch failed for uid 1054

Failure details - PLEASE REMOVE ANY SENSITIVE INFORMATION
----------------------------------------------------------------------------

com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:mid=8:1235611576701:38d0bfefd2bc7129
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbImapMessage.storeImapMessage(Db ImapMessage.java:69)
at com.zimbra.cs.datasource.ImapFolderSync.storeImapM essage(ImapFolderSync.java:701)
at com.zimbra.cs.datasource.ImapFolderSync.handleFetc h(ImapFolderSync.java:992)
at com.zimbra.cs.datasource.ImapFolderSync.access$500 (ImapFolderSync.java:63)
at com.zimbra.cs.datasource.ImapFolderSync$2.handleFe tchResponse(ImapFolderSync.java:907)
at com.zimbra.cs.mailclient.imap.FetchResponseHandler .handleResponse(FetchResponseHandler.java:34)
at com.zimbra.cs.mailclient.imap.ImapConnection.proce ssUntagged(ImapConnection.java:678)
at com.zimbra.cs.mailclient.imap.ImapConnection.proce ssResponse(ImapConnection.java:650)
at com.zimbra.cs.mailclient.imap.ImapConnection.nextR esponse(ImapConnection.java:627)
at com.zimbra.cs.mailclient.imap.ImapConnection.waitF orResponse(ImapConnection.java:548)
at com.zimbra.cs.mailclient.imap.ImapConnection.sendR equest(ImapConnection.java:483)
at com.zimbra.cs.mailclient.imap.ImapRequest.send(Ima pRequest.java:76)
at com.zimbra.cs.mailclient.imap.ImapRequest.sendChec kStatus(ImapRequest.java:80)
at com.zimbra.cs.mailclient.imap.ImapConnection.uidFe tch(ImapConnection.java:305)
at com.zimbra.cs.datasource.ImapFolderSync.fetchMessa ges(ImapFolderSync.java:919)
at com.zimbra.cs.datasource.ImapFolderSync.fetchMessa ges(ImapFolderSync.java:854)
at com.zimbra.cs.datasource.ImapFolderSync.fetchMessa ges(ImapFolderSync.java:843)
at com.zimbra.cs.datasource.ImapFolderSync.syncMessag es(ImapFolderSync.java:241)
at com.zimbra.cs.datasource.ImapSync.syncMessages(Ima pSync.java:236)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:174)
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.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: 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 'I_UID_IMAP_ID' defined on 'IMAP_MESSAGE'.
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.DbImapMessage.storeImapMessage(Db ImapMessage.java:66)
... 29 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 'I_UID_IMAP_ID' defined on 'IMAP_MESSAGE'.
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)
... 34 more

----------------------------------------------------------------------------