zmlogprocess Error / mysql crash

[3RiversTechAdmin]

Hey Everyone,

Preface:
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.

Error:
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:

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.

Every few weeks my graphs will stop updating, and to fix the problem I have to:
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.

[jholder]

Let's try to reinit the logger.
Obviously, make a backup before you do this.

su - zimbra
logger.server stop
mkdir /opt/zimbra/logger.backup
cp -R /opt/zimbra/logger/db/data /opt/zimbra/logger.backup
rm -rf /opt/zimbra/logger/db/data
/opt/zimbra/libexec/zmloggerinit

Let's see what that does.

john

[3RiversTechAdmin]

That looks reasonable... If I run that I see i'll have a backup of my old data, but it will no longer be represented in the graphs? If possible I would just like to fix the crashed tables.
Thanks.