Service Failure when synching my AOL accounts

[GuitarMonster]

Hi,

I'm having service failures when synchronizing my AOL accounts which are driving me crazy. Any help will be very appreciated.

Here's a copy of the report...

Product name: Zimbra Desktop
Product version: 0.91
Build ID: 1344
Release type: BETA
OS Platform: Mac OS X i386 10.5.5
Time of event: 2008-11-28 17:39:31
Error type: service.FAILURE
Error summary: Synchronization of folder 'Sent' failed. Synchronization has been disabled for this folder

Failure details:
----------------------------------------------------------------------------

com.zimbra.common.service.ServiceException: system failure: Unable to store IMAP message data
ExceptionId:sync-timer-chipigungho@aol.com:1227922771396:51bc958ccda99071
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:317)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:434)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:112)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:176)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:157)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:120)
at com.zimbra.cs.datasource.DataSourceManager.importD ata(DataSourceManager.java:158)
at com.zimbra.cs.mailbox.LocalMailbox.importData(Loca lMailbox.java:354)
at com.zimbra.cs.mailbox.LocalMailbox.syncAllLocalDat aSources(LocalMailbox.java:327)
at com.zimbra.cs.mailbox.LocalMailbox.sync(LocalMailb ox.java:383)
at com.zimbra.cs.mailbox.LocalMailbox.syncOnTimer(Loc alMailbox.java:307)
at com.zimbra.cs.mailbox.DesktopMailbox$1.run(Desktop Mailbox.java:259)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
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 'SQL081128131238240' 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)
... 14 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 'SQL081128131238240' 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)
... 19 more

[jjzhuang]

Please file a bug for this one as well. Thanks!