I have 3 zimbra 4.5 servers, one running mailbox services and two running mta.
Regularly, whenever I run this command:
zmcontrol -s <username>
I get the follwing error:
/opt/zimbra/bin/zmmsgtrace sql execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
I usually have to run:
repair table mta
This resolves it.
My issue is, must be a recurring issue? Is there a way of purging old entire in the mta table to prevent it from crashing so often, or can I specify from that it deletes rows older than a particular age?