Results 1 to 9 of 9

Thread: [SOLVED] Month '-1' out of range

  1. #1
    useopenid is offline Senior Member
    Join Date
    Jul 2008
    Location
    Corvallis, OR
    Posts
    54
    Rep Power
    7

    Default [SOLVED] Month '-1' out of range

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

  2. #2
    rkerr is offline Active Member
    Join Date
    Jan 2007
    Posts
    42
    Rep Power
    8

    Default

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

  3. #3
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Code:
    su - zimbra
    zmlocalconfig -s zimbra_logger_mysql_password
    Once you have the MySQL password you can run the following to check the logger tables
    Code:
    su - zimbra
    mysqlcheck --defaults-file=/opt/zimbra/conf/my.logger.cnf --socket=/opt/zimbra/logger/db/mysql.sock -u zimbra -p zimbra_logger

  4. #4
    rkerr is offline Active Member
    Join Date
    Jan 2007
    Posts
    42
    Rep Power
    8

    Default

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

  5. #5
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

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

  6. #6
    rkerr is offline Active Member
    Join Date
    Jan 2007
    Posts
    42
    Rep Power
    8

    Default

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

  7. #7
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Code:
    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
    Code:
    su - zimbra
    /opt/zimbra/mysql/bin/myisamchk -r -q /opt/zimbra/logger/db/data/zimbra_logger amavis

  8. #8
    rkerr is offline Active Member
    Join Date
    Jan 2007
    Posts
    42
    Rep Power
    8

    Default

    That works!

    Thank you very much for the help

  9. #9
    staufj22 Guest

    Default

    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.
    Last edited by staufj22; 09-22-2009 at 10:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Zimbra community hang after working ok 3 month
    By bart in forum Administrators
    Replies: 5
    Last Post: 06-23-2008, 07:16 AM
  2. Day to Day.. Month to Month maintenance...
    By timothyalangorman in forum Administrators
    Replies: 0
    Last Post: 10-24-2007, 12:40 PM
  3. Calendar Month View
    By pfefferc in forum Administrators
    Replies: 1
    Last Post: 02-20-2007, 11:54 AM
  4. Printing Date Range in month view
    By Joshefson in forum Developers
    Replies: 1
    Last Post: 06-16-2006, 05:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •