I am running zimbra version 4.5.1_GA_660.UBUNTU6. I'm running on a P4 Prescott 3.8 GHz, 1.5 GB DDR2 RAM, and two SATA drives in Linux Software RAID0 with about 40 users and no performance issues.
I am getting an error with zmlogproccess that I do not know how to fix due to my limited mysql experience. I'm hoping someone can tell me how to handle it or point me in the direction of a relevant resource. Here is the error:
Every few weeks my graphs will stop updating, and to fix the problem I have to:Aggregating day mta from 2007-04-05 00:00:00 to 2007-04-06 00:00:00
Aggregating hour amavis from 2007-04-06 15:00:00 to 2007-04-06 16:00:00
Aggregating day amavis from 2007-04-05 00:00:00 to 2007-04-06 00:00:00
DBD::mysql::st execute failed: Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired at ./zmlogprocess line 1022.
Error executing select period_start from disk_aggregate where period='hour' order by period_start desc limit 1 with
Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired
Table './zimbra_logger/disk_aggregate' is marked as crashed and should be repaired at ./zmlogprocess line 1023.
Can't call method "fetchall_arrayref" on an undefined value at ./zmlogprocess line 650.
1. remove /zimbra/log/zmlogprocess.pid (which is empty)
2. run /zimbra/libexec/zmlogprocess
3. run /zimbra/libexec/zmgengraphs
After this, everything will be ok for a while. I'm guessing this may be related to the above message in some way.
Any help with this issue would be much appreciated! Thanks.