[srinivas.v]

zdesktop error report (2009-09-16 11:37:06): service.FAILURE

Product name: Zimbra Desktop
Product version: 1.0.2
Build ID: 1652
Release type: R
OS Platform: Windows XP x86 5.1
Time of event: 2009-09-16 11:37:06
Error type: service.FAILURE
Item ID: 5659
Error summary: message sync failed

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

com.zimbra.common.service.ServiceException: system failure: deleting contents for conversation 1073743487
ExceptionId:mid=2:1253081226835:e685aea747363809
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbMailItem.deleteContents(DbMailI tem.java:1408)
at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java :1345)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2448)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2372)
at com.zimbra.cs.mailbox.MailItem.delete(MailItem.jav a:2352)
at com.zimbra.cs.mailbox.Conversation.removeChild(Con versation.java:681)
at com.zimbra.cs.mailbox.OfflineMailbox.setConversati onId(OfflineMailbox.java:294)
at com.zimbra.cs.mailbox.DeltaSync.syncMessage(DeltaS ync.java:823)
at com.zimbra.cs.mailbox.DeltaSync.deltaSync(DeltaSyn c.java:231)
at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.jav a:92)
at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.jav a:76)
at com.zimbra.cs.mailbox.MailboxSync.sync(MailboxSync .java:190)
at com.zimbra.cs.mailbox.OfflineMailbox.sync(OfflineM ailbox.java:140)
at com.zimbra.cs.mailbox.OfflineMailbox.syncOnTimer(O fflineMailbox.java:121)
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: java.sql.SQLException: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (2,5659). The statement has been rolled back.
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.DbMailItem.deleteContents(DbMailI tem.java:1406)
... 16 more
Caused by: ERROR 23503: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (2,5659). The statement has been rolled back.
at org.apache.derby.iapi.error.StandardException.newE xception(Unknown Source)
at org.apache.derby.impl.sql.execute.ReferencedKeyRIC hecker.doCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.RISetChecker.doP KCheck(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteResultSet. runFkChecker(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeRes ultSet.runFkChecker(Unknown Source)
at org.apache.derby.impl.sql.execute.DeleteCascadeRes ultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement .execute(Unknown Source)
... 21 more

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