Hi,

I have just loaded Zimbra desktop and setup my 2 gmail imap accounts but neither of them are syncing. Initially I thought it was an install issue but since then have setup another imap account on a 3rd party server and its working perfectly.

Here are the 2 error reports I am getting:

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

Exception:

com.zimbra.common.service.ServiceException: system failure: Synchronization of folder '[Gmail]/Sent Mail' failed
ExceptionId:mid=3:1248258559125:9f9972cc5ca904d3
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:298)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:221)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:193)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:152)
at com.zimbra.cs.offline.OfflineImport.importData(Off lineImport.java:88)
at com.zimbra.cs.offline.GMailImport.importData(GMail Import.java:52)
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:437)
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=3:1248258559109:9f9972cc5ca904d3
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.ImapSync.createFolderTrac ker(ImapSync.java:85)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:521)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:125)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:216)
... 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 'SQL090722153417350' 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)
... 17 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 'SQL090722153417350' 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)
... 22 more

If issue persists please post description and debug information here.



And the second error:

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

Exception:

com.zimbra.common.service.ServiceException: system failure: Synchronization of folder '[Gmail]/Sent Mail' failed
ExceptionId:mid=3:1248259783296:9f9972cc5ca904d3
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.datasource.ImapSync.syncFailed(ImapS ync.java:298)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:221)
at com.zimbra.cs.datasource.ImapSync.syncFolders(Imap Sync.java:193)
at com.zimbra.cs.datasource.ImapSync.importData(ImapS ync.java:152)
at com.zimbra.cs.offline.OfflineImport.importData(Off lineImport.java:88)
at com.zimbra.cs.offline.GMailImport.importData(GMail Import.java:52)
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:437)
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=3:1248259783296:9f9972cc5ca904d3
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.ImapSync.createFolderTrac ker(ImapSync.java:85)
at com.zimbra.cs.datasource.ImapFolderSync.createLoca lFolder(ImapFolderSync.java:521)
at com.zimbra.cs.datasource.ImapFolderSync.syncFolder (ImapFolderSync.java:125)
at com.zimbra.cs.datasource.ImapSync.syncRemoteFolder s(ImapSync.java:216)
... 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 'SQL090722153417350' 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)
... 17 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 'SQL090722153417350' 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)
... 22 more

If issue persists please post description and debug information here.



Any help would be greatful.

Thanks.