zmmsgtrace

[reza225]

hey everyone
i'm trying to use zmmsgtrace on our server but it keeps bombing out. Has anyone seen this error before?

[zimbra@mail ~]$ zmmsgtrace -r user@domain.tld
Tracing messages
to user@domain.tld

/opt/zimbra/bin/zmmsgtrace sql execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed

0 messages found

[alexkelly]

I think this is what you are looking for
Repair Logger Data Corruption - Zimbra :: Wiki

If the repair doesn't work, you'll have to re-initialize your logger database.

[keris]

I did that but no luck.
may be the too many rows?

mysql> REPAIR TABLE raw_logs USE_FRM;

+------------------------+--------+----------+-------------------------------------------+
| Table                  | Op     | Msg_type | Msg_text                                  |
+------------------------+--------+----------+-------------------------------------------+
| zimbra_logger.raw_logs | repair | warning  | Number of rows changed from 0 to 14498675 | 
| zimbra_logger.raw_logs | repair | status   | OK                                        | 
+------------------------+--------+----------+-------------------------------------------+

I guess I've to rebuild the db?

./keris
Release 5.0.4_GA_2101.RHEL5_64_20080321141727 CentOS5_64 NETWORK edition

[TrinityEMS]

I am using v5.0.5 and am having the same problem. I ran the fixes from the Wiki page and am still getting the original error. Did you eventually find a fix to the problem, and if so what was it?