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]
0.53 Broken
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
0.53 Broken
___________________________________
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
0.53 Broken
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'
0.53 Broken
Unfortunately there's no workaround to this right now. Please shutdown zdesktop until this is fixed in a new version. Thanks!
0.53 Broken
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!
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!
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
0.53 Broken
[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
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
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate
0.53 Broken
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.
- L. Mark Stone
- Ambassador
- Posts: 2802
- Joined: Wed Oct 09, 2013 11:35 am
- Location: Portland, Maine, US
- ZCS/ZD Version: 10.0.7 Network Edition
- Contact:
0.53 Broken
[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
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
L. Mark Stone
Mission Critical Email - Zimbra VAR/BSP/Training Partner https://www.missioncriticalemail.com/
AWS Certified Solutions Architect-Associate