View Single Post
  #1 (permalink)  
Old 06-21-2007, 08:23 AM
kyle kyle is offline
Junior Member
 
Posts: 9
Default tomcat crash: mailbox - Unable to commit database transaction. Forcing server to abo

Hi All,

Sorry if this has been posted before, I've spent the better part of 3 hours searching for anything relating to this problem in the wiki and the forum.

At about 5:00 cst last night my server went down under a very quick power outage. When it came back up, everything seemed fine, but I get the following error message in /opt/zimbra/log/mailbox.log when trying to restart 'mailbox' with zmmailboxctl start:
Code:
2007-06-21 09:07:08,933 INFO  [NOTIFY-7035-Server] [] misc - starting server loop
2007-06-21 09:07:09,069 INFO  [LmtpServer] [] TcpServer/7025 - starting accept loop
2007-06-21 09:07:09,110 INFO  [PostStartupCrashRecovery] [] cache - Initializing folder and tag caches for mailbox 5
2007-06-21 09:07:09,374 INFO  [Pop3Server] [] TcpServer/995 - starting accept loop
2007-06-21 09:07:09,467 FATAL [PostStartupCrashRecovery] [] mailbox - Unable to commit database transaction.  Forcing server to abort.
com.zimbra.common.service.ServiceException: system failure: committing database transaction
        at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
        at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.java:162)
        at com.zimbra.cs.mailbox.Mailbox.endTransaction(Mailbox.java:5024)
        at com.zimbra.cs.mailbox.Mailbox.getConfig(Mailbox.java:941)
        at com.zimbra.cs.mailbox.Mailbox.(Mailbox.java:386)
        at com.zimbra.cs.mailbox.MailboxManager.instantiateMailbox(MailboxManager.java:355)
        at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:306)
        at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:239)
        at com.zimbra.cs.redolog.op.IndexItem.redo(IndexItem.java:99)
        at com.zimbra.cs.redolog.RedoLogManager$PostStartupCrashRecoveryThread.run(RedoLogManager.java:291)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
        at com.mysql.jdbc.Connection.commit(Connection.java:2246)
        at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:248)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:244)
        at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.java:160)
        ... 8 more
2007-06-21 09:07:09,484 INFO  [ImapServer] [] TcpServer/143 - starting accept loop
2007-06-21 09:07:09,492 INFO  [ImapSSLServer] [] TcpServer/993 - starting accept loop
I'm at my witt's end. I'd appreciate any help I can get.

TIA

Kyle Hall
Reply With Quote