Server Crash Help!

[ricocho]

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:

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:

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.

[adeelarifbhatti]

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

[uxbod]

http://www.zimbra.com/forums/install...-properly.html Instead of the Jive table repair the mboxgroup tables. You may also wish to run

su - zimbra
zmblobchk -u {user}

dependent on which version of ZCS you are running

su - zimbra
zmcontrol -v

[ricocho]

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:

[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)

[ricocho]

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

[ricocho]

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

[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"

[ricocho]

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.

[iway]

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