Repair Logger Data Corruption

Introduction

Frequent write activity on the zimbra_logger.raw_logs table cause it to be subject index corruption 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.

Impact

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

Solution

$ logmysql zimbra_logger
mysql> REPAIR TABLE raw_logs USE_FRM;

Related Articles

---

Keywords: logger, error, raw_logs, corrupt, index