[SOLVED] Month '-1' out of range

[useopenid]

I've started getting this daily message:

Month '-1' out of range 0..11 at /opt/zimbra/libexec/zmdailyreport line 591

In looking at the code, it looks like something has gotten corrupted in the db, but not sure where to look...

[rkerr]

I just upgraded to 5.0.18 and am getting this same error. Any pointers to bug reports or workarounds would be welcome.

[uxbod]

su - zimbra
zmlocalconfig -s zimbra_logger_mysql_password

Once you have the MySQL password you can run the following to check the logger tables

su - zimbra
mysqlcheck --defaults-file=/opt/zimbra/conf/my.logger.cnf --socket=/opt/zimbra/logger/db/mysql.sock -u zimbra -p zimbra_logger

[rkerr]

zimbra_logger.amavis
warning : Table is marked as crashed and last repair failed
error : Size of indexfile is: 1024 Should be: 59010048
error : Corrupt

[uxbod]

su - zimbra
mysqlcheck --defaults-file=/opt/zimbra/conf/my.logger.cnf --socket=/opt/zimbra/logger/db/mysql.sock --auto-repair -u zimbra -p zimbra_logger

[rkerr]

Table shows a correct, but running /opt/zimbra/libexec/zmdailyreport as zimbra user still returns the same error.

[uxbod]

su - zimbra
/opt/zimbra/mysql/bin/myisamchk /opt/zimbra/logger/db/data/zimbra_logger./amavis

if that returns errors about the index then you can try

su - zimbra
/opt/zimbra/mysql/bin/myisamchk -r -q /opt/zimbra/logger/db/data/zimbra_logger amavis

[rkerr]

That works!

Thank you very much for the help

[staufj22]

So I followed the directions, and fixed both , but my zmdailreport is still returning "Month '-1' out of range 0..11 at ./zmdailyreport line 591"

Any other ideas?

Actually, I went and ran /opt/zimbra/mysql/bin/myisamchk a few more times, fixed raw_logs and service_status

and reran the mysqlcheck... the report is generating now.