0.53 Broken

General discussion about Zimbra Desktop.
Post Reply
User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

0.53 Broken

Post by L. Mark Stone »

Uh oh...
CPU usage is pegged at 100% due to a java process.
ZD Manage Accounts web page is up, but clicking the "Launch" button gets a perpetual wait with no screen repaint.
Here's the log; any ideas?
Thanks,

Mark
2007-09-09 10:54:01,354 ERROR [Timer-Offline-Main] [] offline - failed to sync account mark.stone@reliablenetworks.com

com.zimbra.common.service.ServiceException: system failure: deleting contents for virtual conversation -415202

at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)

at com.zimbra.cs.db.DbMailItem.deleteContents(DbMailItem.java:1343)

at com.zimbra.cs.db.DbMailItem.delete(DbMailItem.java:1280)

at com.zimbra.cs.mailbox.MailItem.delete(MailItem.java:2192)

at com.zimbra.cs.mailbox.MailItem.delete(MailItem.java:2153)

at com.zimbra.cs.mailbox.Message.delete(Message.java:630)

at com.zimbra.cs.mailbox.Mailbox.delete(Mailbox.java:4470)

at com.zimbra.cs.mailbox.OfflineMailbox.delete(OfflineMailbox.java:353)

at com.zimbra.cs.mailbox.DeltaSync.processLeafDeletes(DeltaSync.java:258)

at com.zimbra.cs.mailbox.DeltaSync.deltaSync(DeltaSync.java:110)

at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.java:97)

at com.zimbra.cs.mailbox.DeltaSync.sync(DeltaSync.java:80)

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

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.sql.SQLException: DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' for key (1,415202). The statement has been rolled back.

at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)

at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:203)

at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:380)

at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:345)

at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1378)

at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)

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

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.deleteContents(DbMailItem.java:1341)

... 14 more

2007-09-09 10:55:03,279 DEBUG [Timer-Offline-Main] [] offline - starting delta sync [token 483750]
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
jjzhuang
Elite member
Elite member
Posts: 1687
Joined: Fri Sep 12, 2014 10:24 pm

0.53 Broken

Post by jjzhuang »

Yup. Known issue, but not yet fixed: Bug 18026 - DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID'
jjzhuang
Elite member
Elite member
Posts: 1687
Joined: Fri Sep 12, 2014 10:24 pm

0.53 Broken

Post by jjzhuang »

Unfortunately there's no workaround to this right now. Please shutdown zdesktop until this is fixed in a new version. Thanks!
jjzhuang
Elite member
Elite member
Posts: 1687
Joined: Fri Sep 12, 2014 10:24 pm

0.53 Broken

Post by jjzhuang »

Actually it will help us a lot if you could send us your database. If you could please follow these steps:
1. shutdown zdesktop. Make sure the process is gone.

2. go into and find a directory called "derby".

3. zip up the entire "derby" directory.

4. attach the zip file to the bug Bug 18026 - DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' using "Create a New attachment" link.
The derby directory only contains metadata so nobody can read your real mails:) If you don't want to post it to a public bug, you can also send the zip file by email to me at "jjzhuang@zimbra.com". Thanks!
User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

0.53 Broken

Post by L. Mark Stone »

[quote user="jjzhuang"]Actually it will help us a lot if you could send us your database. If you could please follow these steps:
1. shutdown zdesktop. Make sure the process is gone.

2. go into and find a directory called "derby".

3. zip up the entire "derby" directory.

4. attach the zip file to the bug Bug 18026 - DELETE on table 'MAIL_ITEM' caused a violation of foreign key constraint 'FK_MAIL_ITEM_PARENT_ID' using "Create a New attachment" link.
The derby directory only contains metadata so nobody can read your real mails:) If you don't want to post it to a public bug, you can also send the zip file by email to me at "jjzhuang@zimbra.com". Thanks![/QUOTE]
Just sent the file to you via email; it's too large to attach to the bug report.
Hope it helps, and be nice to Andy! ;-)
All the best,

Mark
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
jjzhuang
Elite member
Elite member
Posts: 1687
Joined: Fri Sep 12, 2014 10:24 pm

0.53 Broken

Post by jjzhuang »

Hi Mark, for some reason I don't see any email from you. Maybe the attachment is too large and got dropped either by your mail server or our mail server? How big is the zip file? If it's too big for email I can arrange an ftp drop off on our ftp server. Thanks! --J.J.
User avatar
L. Mark Stone
Ambassador
Ambassador
Posts: 2796
Joined: Wed Oct 09, 2013 11:35 am
Location: Portland, Maine, US
ZCS/ZD Version: 10.0.6 Network Edition
Contact:

0.53 Broken

Post by L. Mark Stone »

[quote user="jjzhuang"]Hi Mark, for some reason I don't see any email from you. Maybe the attachment is too large and got dropped either by your mail server or our mail server? How big is the zip file? If it's too big for email I can arrange an ftp drop off on our ftp server. Thanks! --J.J.[/QUOTE]
Hi J.J.,
The file is over 20MB in size. Our Zimbra system allows emails up to 100MB in size. :-)
Happy to ftp it to a location of your choice. Just let me know!
All the best,

Mark
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
Post Reply