Repair Logger Data Corruption

Repair Logger Data Corruption

   KB 2278        Last updated on 2015-07-11  




0.00
(0 votes)

Introduction

Frequent write activity on the zimbra_logger.raw_logs table cause it to be subject to index corruption under certain conditions. Those conditions include but may not be limited to 100% disk utilization, abrupt end to the MySQL logger process, or other system failure. If the logger database is experiencing corruption, the raw_logs table is the likely culprit, however other tables can be affected as well. Trouble with the logger database is reported in /opt/zimbra/logger/db/data/hostname.err.

This error is especially common in Zimbra releases prior to 4.5.7, in which an error in a maintenance script could cause the zmlogswatch script to show itself as down when in fact it was still running. An administrator would see the logger as failed and would restart it, which would result in two or more instances of the zmlogswatch script running. Both of these instances would write to the same table in the logger database, causing this error. If this error is happening frequently, an upgrade to the current release is recommended.

Impact

Any data or index corruption on the logger DB will result in inaccurate or missing statistics.

Solution

Diagnose problematic table in hostname.err

070927 14:30:01 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/raw_logs' is marked as crashed and last (automatic?) repair failed

Attempt table repair

$ logmysql zimbra_logger
mysql> REPAIR TABLE raw_logs;

If this repair step succeeds, you do not need to perform the next step.

Repair table by writing a new index file

This repair method creates a new .MYI index file using the .frm file for the table. Use this option only as a last resort.

mysql> REPAIR TABLE raw_logs USE_FRM;

Related Articles

Mysql Crash Recovery

References

MySQL 5.0 Reference Manual http://dev.mysql.com/doc/refman/5.0/en/repair-table.html



Keywords: logger, database, mysql, error, raw_logs, corrupt, index

Verified Against: Zimbra Collaboration Suite 5.0 Date Created: 11/25/2007
Article ID: https://wiki.zimbra.com/index.php?title=Repair_Logger_Data_Corruption Date Modified: 2015-07-11



Try Zimbra

Try Zimbra Collaboration with a 60-day free trial.
Get it now »

Want to get involved?

You can contribute in the Community, Wiki, Code, or development of Zimlets.
Find out more. »

Looking for a Video?

Visit our YouTube channel to get the latest webinars, technology news, product overviews, and so much more.
Go to the YouTube channel »

Jump to: navigation, search