Results 1 to 8 of 8

Thread: Server Crash Help!

  1. #1
    ricocho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    7

    Default Server Crash Help!

    I was running zimbra open source edition for about 2 years on RHEL 4. One my hardrives failed and the last backup I have is about 6 mounths old.

    I have been able rsync the /opt/zimbra directory on the corrupt disk and install the same version of zimbra on a centos 4.7 server and replace the /opt/zimbra as described in a few wiki pages. Most of my users can log in so the ldap data seem to be intact.

    Once logged in users can click on emails about 50% of them. Emails that fail, fail with missing BLOB errors.

    First Issue I think I should tackle, getting everyone to be able to view there mailbox:

    I am having DB issues, when I run zmdbintegrityreport I get the following errors:
    Code:
    mboxgroup14.pop3_message
     Error    : Table 'mboxgroup14.pop3_message' doesn't exist
     error    : Corrupt
     mboxgroup28.revision
     Error    : Table 'mboxgroup28.revision' doesn't exist
     error    : Corrupt
     mboxgroup35.revision
     Error    : Table 'mboxgroup35.revision' doesn't exist
     error    : Corrupt
    I have 2 users that are having the following errors when I try to query the mysql db:
    Code:
    mysql> describe mail_item;
    ERROR 1146 (42S02): Table 'mboxgroup21.mail_item' doesn't exist
    How can I address these issues. Any suggestions would be appreciated.

  2. #2
    adeelarifbhatti is offline Advanced Member
    Join Date
    Feb 2009
    Posts
    188
    Rep Power
    6

    Post

    why you have restored the zimbra on centos.
    I guess, you were running on RHEL 4. So try it on RHEL 4 again , may be that is cousing the problem.


    Regards
    Adeel
    Last edited by adeelarifbhatti; 08-04-2009 at 02:38 AM.

  3. #3
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,016
    Rep Power
    24

    Default

    http://www.zimbra.com/forums/install...-properly.html Instead of the Jive table repair the mboxgroup tables. You may also wish to run
    Code:
    su - zimbra
    zmblobchk -u {user}
    dependent on which version of ZCS you are running
    Code:
    su - zimbra
    zmcontrol -v

  4. #4
    ricocho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    7

    Default

    I am using version 5.08. I'll try running the zmblobchk per user. When I run the check with out the -u it fails because the table does not exsist:
    Code:
    [zimbra@mail bin]$ zmblobchk
    Retrieving volume information
    Retrieving mboxgroup list
    Spooling item list to /tmp/mailitems47711.lst
    Retrieving items from mboxgroup1
    Retrieving items from mboxgroup2
    Retrieving items from mboxgroup3
    Retrieving items from mboxgroup4
    Retrieving items from mboxgroup5
    Retrieving items from mboxgroup6
    Retrieving items from mboxgroup7
    Retrieving items from mboxgroup8
    Retrieving items from mboxgroup9
    Retrieving items from mboxgroup10
    Retrieving items from mboxgroup11
    Retrieving items from mboxgroup12
    Retrieving items from mboxgroup13
    Retrieving items from mboxgroup14
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'mboxgroup14.mail_item' doesn't exist
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatem                                                                   ent.java:1149)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement                                                                   .java:1262)
            at com.zimbra.cs.store.consistency.StatementExecutor.query(Stateme                                                                   ntExecutor.java:74)
            at com.zimbra.cs.store.consistency.StatementExecutor.query(Stateme                                                                   ntExecutor.java:64)
            at com.zimbra.cs.store.consistency.ReportGenerator.getMailItems(Re                                                                   portGenerator.java:382)
            at com.zimbra.cs.store.consistency.ReportGenerator.run(ReportGener                                                                   ator.java:108)
            at com.zimbra.cs.store.consistency.BlobConsistencyCheck.main(BlobC                                                                   onsistencyCheck.java:112)

  5. #5
    ricocho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    7

    Default

    I get the same error as above just checking the user.

  6. #6
    ricocho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    7

    Default

    Cannot run zmblobchk because the it fails on the corrupt or missing database:

    Code:
    [zimbra@mail bin]$ zmblobchk -u pkurtz@digitalaircontrol.com
    Retrieving volume information
    Retrieving mboxgroup list
    Spooling item list to /tmp/mailitems31921.lst
    Retrieving items from mboxgroup1
    Retrieving items from mboxgroup2
    Retrieving items from mboxgroup3
    Retrieving items from mboxgroup4
    Retrieving items from mboxgroup5
    Retrieving items from mboxgroup6
    Retrieving items from mboxgroup7
    Retrieving items from mboxgroup8
    Retrieving items from mboxgroup9
    Retrieving items from mboxgroup10
    Retrieving items from mboxgroup11
    Retrieving items from mboxgroup12
    Retrieving items from mboxgroup13
    Retrieving items from mboxgroup14
    com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'mboxgroup14.mail_item' doesn't exist
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
            at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
            at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
            at com.zimbra.cs.store.consistency.StatementExecutor.query(StatementExecutor.java:74)
            at com.zimbra.cs.store.consistency.StatementExecutor.query(StatementExecutor.java:64)
            at com.zimbra.cs.store.consistency.ReportGenerator.getMailItems(ReportGenerator.java:382)
            at com.zimbra.cs.store.consistency.ReportGenerator.run(ReportGenerator.java:108)
            at com.zimbra.cs.store.consistency.BlobConsistencyCheck.main(BlobConsistencyCheck.java:112)
    I will give the link: "[SOLVED] Database errors - table didn't close properly"

  7. #7
    ricocho is offline Junior Member
    Join Date
    Jul 2007
    Posts
    5
    Rep Power
    7

    Default

    I was able to restore the mysql tables from and old backup, replacing lost tables due to disk corruption. Before this zmblobchk tool would fail due to table errors. Now zmblobchk tool starts makes it past checking the mailgroups but fails while trying to delete refrences to missing blobs.

    I think my only recourse for these users is to try to reinject email msg from the store back into there account using zmlmtpinject.

  8. #8
    iway is offline Partner (VAR/HSP)
    Join Date
    May 2008
    Posts
    432
    Rep Power
    6

    Default

    Have you tried repairing the MySQL tables as per the Wiki?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. zmmailboxdctl is not running !!!!!!
    By olibite in forum Administrators
    Replies: 14
    Last Post: 04-28-2011, 05:50 AM
  2. Keeping a backup server synced with live server
    By Q-Mike in forum Administrators
    Replies: 5
    Last Post: 04-11-2008, 01:40 PM
  3. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  4. Installation Problem - Possibly LDAP
    By geroshea in forum Installation
    Replies: 5
    Last Post: 03-16-2007, 04:47 AM
  5. Getting problems in FC4 while instalation
    By kitty_bhoo in forum Installation
    Replies: 13
    Last Post: 09-12-2006, 10:34 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
  •