.53 syncing

adobrin · Post by **adobrin** » Fri Aug 03, 2007 7:22 pm

Hi!
.53 seems to be syncing -- i'm getting *alot* of these errors in mailbox.log, though:
[quote]

2007-08-04 00:19:44.831 GMT Thread[Timer-Offline-Main,5,main] (XID = 1551), (SESSIONID = 1), (DATABASE = /home/adam/zimbra/zdesktop/derby), (DRDAID = null), Failed Statement is: INSERT INTO mboxgroup1.open_conversation(mailbox_id, hash, conv_id) VALUES (?, ?, ?)

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 'PK_OPEN_CONVERSATION' defined on 'OPEN_CONVERSATION'.

at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:316)

at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(IndexChanger.java:489)

at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java:406)

at org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java:613)

at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(IndexSetChanger.java:268)

at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java:453)

at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1010)

at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:523)

at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:358)

at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1182)

at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1635)

at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:299)

at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:233)

at com.zimbra.cs.db.DbMailItem.openConversation(DbMailItem.java:792)

at com.zimbra.cs.mailbox.VirtualConversation.open(VirtualConversation.java:106)

at com.zimbra.cs.mailbox.Mailbox.openConversation(Mailbox.java:3891)

at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:3774)

at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3599)

at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3542)

at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:873)

at com.zimbra.cs.mailbox.InitialSync.syncMessage(InitialSync.java:829)

at com.zimbra.cs.mailbox.InitialSync.syncMessagelikeItems(InitialSync.java:317)

at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:233)

at com.zimbra.cs.mailbox.InitialSync.prioritySync(InitialSync.java:283)

at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:261)

at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:272)

at com.zimbra.cs.mailbox.InitialSync.sync(InitialSync.java:155)

at com.zimbra.cs.mailbox.InitialSync.sync(InitialSync.java:142)

at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.sync(OfflineMailboxManager.java:126)

at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.run(OfflineMailboxManager.java:98)

at java.util.TimerThread.mainLoop(Unknown Source)

at java.util.TimerThread.run(Unknown Source)

Cleanup action completed

[/quote]

jjzhuang · Post by **jjzhuang** » Sat Aug 04, 2007 11:08 pm

This shouldn't be in mailbox.log. You are probably seeing this in derby.log. This is benign. It's how we detect whether there's already a conversation open with the same subject. We let derby throw the exception and catch it to detect existing conversations. Because derby debug logging was turned on therefore you see the exception being logged. We'll turn off derby debug log once the product becomes stable. Thanks!

adobrin · Post by **adobrin** » Mon Aug 06, 2007 4:17 pm

from mailbox.log on a vista machine.
seems to stop syncing after the first few hundred mb:
[quote]

2007-08-06 16:51:49,751 ERROR [Timer-Offline-Main] [] offline - failed to sync account email@address.com
com.zimbra.common.service.ServiceException: system failure: storing message 113243
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:878)
at com.zimbra.cs.mailbox.InitialSync.syncMessage(InitialSync.java:829)
at com.zimbra.cs.mailbox.InitialSync.syncMessagelikeItems(InitialSync.java:317)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:233)
at com.zimbra.cs.mailbox.InitialSync.prioritySync(InitialSync.java:283)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:261)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:272)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:175)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:163)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.sync(OfflineMailboxManager.java:128)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.run(OfflineMailboxManager.java:98)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: java.io.IOException: Unable to rename C:zimbrazdesktopstoreincoming1186427799516-904.msg to C:zimbrazdesktopstore1msg27113243-327844.msg
at com.zimbra.cs.store.FileBlobStore.renameTo(FileBlobStore.java:239)
at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:3817)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3599)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3542)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:873)
... 12 more
2007-08-06 16:52:53,006 DEBUG [Timer-Offline-Main] [] offline - resuming initial sync
2007-08-06 16:52:53,190 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (11): ROOT
2007-08-06 16:52:53,335 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (1): USER_ROOT
2007-08-06 16:52:53,490 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (2): Inbox
2007-08-06 16:52:56,014 ERROR [Timer-Offline-Main] [] offline - failed to sync account email@address.com
com.zimbra.common.service.ServiceException: system failure: storing message 113243
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:878)
at com.zimbra.cs.mailbox.InitialSync.syncMessage(InitialSync.java:829)
at com.zimbra.cs.mailbox.InitialSync.syncMessagelikeItems(InitialSync.java:317)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:233)
at com.zimbra.cs.mailbox.InitialSync.prioritySync(InitialSync.java:283)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:261)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:272)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:175)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:163)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.sync(OfflineMailboxManager.java:128)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.run(OfflineMailboxManager.java:98)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: java.io.IOException: Unable to rename C:zimbrazdesktopstoreincoming1186427799516-905.msg to C:zimbrazdesktopstore1msg27113243-327844.msg
at com.zimbra.cs.store.FileBlobStore.renameTo(FileBlobStore.java:239)
at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:3817)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3599)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3542)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:873)
... 12 more
2007-08-06 16:53:58,365 DEBUG [Timer-Offline-Main] [] offline - resuming initial sync
2007-08-06 16:53:58,528 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (11): ROOT
2007-08-06 16:53:58,684 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (1): USER_ROOT
2007-08-06 16:53:58,846 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (2): Inbox
2007-08-06 16:53:59,192 ERROR [Timer-Offline-Main] [] offline - failed to sync account email@address.com
com.zimbra.common.service.ServiceException: system failure: storing message 113243
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:878)
at com.zimbra.cs.mailbox.InitialSync.syncMessage(InitialSync.java:829)
at com.zimbra.cs.mailbox.InitialSync.syncMessagelikeItems(InitialSync.java:317)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:233)
at com.zimbra.cs.mailbox.InitialSync.prioritySync(InitialSync.java:283)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:261)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:272)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:175)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:163)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.sync(OfflineMailboxManager.java:128)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.run(OfflineMailboxManager.java:98)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: java.io.IOException: Unable to rename C:zimbrazdesktopstoreincoming1186427799516-906.msg to C:zimbrazdesktopstore1msg27113243-327844.msg
at com.zimbra.cs.store.FileBlobStore.renameTo(FileBlobStore.java:239)
at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:3817)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3599)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3542)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:873)
... 12 more
2007-08-06 16:55:01,501 DEBUG [Timer-Offline-Main] [] offline - resuming initial sync
2007-08-06 16:55:01,657 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (11): ROOT
2007-08-06 16:55:01,977 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (1): USER_ROOT
2007-08-06 16:55:02,204 DEBUG [Timer-Offline-Main] [] offline - delta: updated folder (2): Inbox
2007-08-06 16:55:02,969 ERROR [Timer-Offline-Main] [] offline - failed to sync account email@address.com
com.zimbra.common.service.ServiceException: system failure: storing message 113243
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:878)
at com.zimbra.cs.mailbox.InitialSync.syncMessage(InitialSync.java:829)
at com.zimbra.cs.mailbox.InitialSync.syncMessagelikeItems(InitialSync.java:317)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:233)
at com.zimbra.cs.mailbox.InitialSync.prioritySync(InitialSync.java:283)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:261)
at com.zimbra.cs.mailbox.InitialSync.initialFolderSync(InitialSync.java:272)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:175)
at com.zimbra.cs.mailbox.InitialSync.resume(InitialSync.java:163)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.sync(OfflineMailboxManager.java:128)
at com.zimbra.cs.mailbox.OfflineMailboxManager$SyncTask.run(OfflineMailboxManager.java:98)
at java.util.TimerThread.mainLoop(Unknown Source)
at java.util.TimerThread.run(Unknown Source)
Caused by: java.io.IOException: Unable to rename C:zimbrazdesktopstoreincoming1186427799516-907.msg to C:zimbrazdesktopstore1msg27113243-327844.msg
at com.zimbra.cs.store.FileBlobStore.renameTo(FileBlobStore.java:239)
at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:3817)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3599)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:3542)
at com.zimbra.cs.mailbox.InitialSync.saveMessage(InitialSync.java:873)
... 12 more
[/quote]

dkarp · Post by **dkarp** » Mon Aug 06, 2007 9:38 pm

Did those files somehow get marked read-only?