Results 1 to 1 of 1

Thread: Database Corruption

  1. #1
    Join Date
    Sep 2006
    Rep Power

    Default Database Corruption

    We had some server problems yesterday and crashed a couple mailbox servers. They wouldn't restart and mount the volumes until we did an 'fsck'. This morning we discovered some users who can't move messages, some can't reply to messages, and some can't even receive messages. Looks like we might have database corruption?

    2008-09-16 11:05:09,447 INFO [LmtpServer-7303] [name=USER@DOMAIN.COM;mid=2578;] lmtp - rejecting message USER@DOMAIN.COM: exception occurred
    com.zimbra.cs.mailbox.MailServiceException: object with that id already exists: 20920
    Code:mail.ALREADY_EXISTS ArgitemId, IID, "20920")
    at com.zimbra.cs.mailbox.MailServiceException.ALREADY _EXISTS(
    at com.zimbra.cs.db.DbMailItem.create( :163)
    at com.zimbra.cs.mailbox.Message.createInternal(Messa
    at com.zimbra.cs.mailbox.Message.create( 321)
    at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(M
    at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4626)
    at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4582)
    at com.zimbra.cs.filter.ZimbraMailAdapter.addMessage(
    at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFi ling(
    at com.zimbra.cs.filter.ZimbraMailAdapter.executeActi ons(
    at org.apache.jsieve.SieveFactory.evaluate(SieveFacto
    at com.zimbra.cs.filter.RuleManager.applyRules(RuleMa
    at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes( )
    at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (
    at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(
    at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(
    at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa
    at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(
    at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(
    at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(
    at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo Source)
    Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraint ViolationException: Duplicate entry '2578-20920' for key 1

    Query being executed when exception was thrown:

    com.mysql.jdbc.ServerPreparedStatement[31852] - INSERT INTO mboxgroup78.mail_item(mailbox_id, id, type, parent_id, folder_id, index_id, imap_id, date, size, volume_id, blob_digest, unread, flags, tags, sender, subject, name, metadata, mod_metadata, change_date, mod_content) VALUES (2578, 20920, 5, null, 2, 20920, 20920, 1221581109, 1379, 1, 'cyZW54,KIpmv6sTO+ANW,z7j+v4=', 1, 0, 0, 'Tammy K', 'Key', null, 'd1:f152:The extra office key requested for you is ready to pick up at Public Safety at your convenience. Thanks! Tammy K...1:s34:Tammy K <TK-@DOMAIN>COM>1:vi10ee', 73900, 1221581109, 73900)
    at com.mysql.jdbc.SQLError.createSQLException(SQLErro
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
    at com.mysql.jdbc.MysqlIO.sendCommand( 73)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(
    at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate( 33)
    at com.zimbra.cs.db.DbMailItem.create( :147)
    ... 21 more
    2008-09-16 11:05:09,448 INFO [LmtpServer-7303] [] lmtp - 554 5.0.0 Permanent message delivery failure (DATA)
    2008-09-16 11:05:09,448 INFO [LmtpServer-7303] [] ProtocolHandler - Handler exiting normally
    We've run the zmdbintegrityreport tool and got this back
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=ROOT_PWD
    error : Corrupt
    warning : 1 client is using or hasn't closed the table properly
    warning : 1 client is using or hasn't closed the table properly
    warning : 1 client is using or hasn't closed the table properly
    warning : 1 client is using or hasn't closed the table properly
    warning : 2 clients are using or haven't closed the table properly
    I found this other post....but I'm not sure if the steps there would help us or are the right thing to do. I've opened a ticket with Zimbra....thought I'd also post here in case someone else had ever seen this issue.

    Last edited by Chewie71; 09-18-2008 at 09:03 AM.

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 02:44 PM
  2. change ldap database
    By Grejao in forum Administrators
    Replies: 1
    Last Post: 12-07-2007, 07:39 AM
  3. Bad 5.0b2 upgrade
    By JoshuaPrismon in forum Installation
    Replies: 1
    Last Post: 07-26-2007, 07:34 PM
  4. Database corruption after restore
    By NightTwix in forum Administrators
    Replies: 1
    Last Post: 07-06-2007, 04:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts