Results 1 to 1 of 1

Thread: Database Corruption

  1. #1
    Join Date
    Sep 2006
    Location
    Illinois
    Posts
    374
    Rep Power
    9

    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
    ExceptionId:LmtpServer-7303:1221581109447:f3dac198e6f59625
    Code:mail.ALREADY_EXISTS ArgitemId, IID, "20920")
    at com.zimbra.cs.mailbox.MailServiceException.ALREADY _EXISTS(MailServiceException.java:372)
    at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java :163)
    at com.zimbra.cs.mailbox.Message.createInternal(Messa ge.java:397)
    at com.zimbra.cs.mailbox.Message.create(Message.java: 321)
    at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(M ailbox.java:4760)
    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( ZimbraMailAdapter.java:395)
    at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFi ling(ZimbraMailAdapter.java:389)
    at com.zimbra.cs.filter.ZimbraMailAdapter.executeActi ons(ZimbraMailAdapter.java:268)
    at org.apache.jsieve.SieveFactory.evaluate(SieveFacto ry.java:159)
    at com.zimbra.cs.filter.RuleManager.applyRules(RuleMa nager.java:196)
    at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes(ZimbraLmtpBackend.java:379 )
    at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (ZimbraLmtpBackend.java:137)
    at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(LmtpHandler.java:375)
    at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(TcpLmtpHandler.java:67)
    at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa ndler.java:364)
    at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(LmtpHandler.java:174)
    at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(TcpLmtpHandler.java:61)
    at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:160)
    at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:128)
    at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(Unknown Source)
    at java.lang.Thread.run(Thread.java:595)
    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 r.java:931)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2870)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1160)
    at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:685)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1400)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1314)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1299)
    at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:2 33)
    at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java :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
    ./zmdbintegrityreport
    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
    mboxgroup10.mail_item
    error : Corrupt
    zimbra.jiveID
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveOffline
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveRoster
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveRosterGroups
    warning : 1 client is using or hasn't closed the table properly
    zimbra.jiveUserProp
    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.

    http://www.zimbra.com/forums/adminis...box-crash.html

    Thanks,
    Matt
    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
  •