Results 1 to 3 of 3

Thread: zmlogprocess Error / mysql crash

  1. #1
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    9

    Question zmlogprocess Error / mysql crash

    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.

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    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
    Last edited by jholder; 04-06-2007 at 05:02 PM.

  3. #3
    Join Date
    Oct 2006
    Posts
    100
    Rep Power
    9

    Red face hmm

    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.

Similar Threads

  1. zmlogprocess error on aggregates
    By hlandgar in forum Installation
    Replies: 4
    Last Post: 04-19-2007, 10:22 AM
  2. Open Source on Fedora 6 Random Server Crash
    By bmj in forum Administrators
    Replies: 2
    Last Post: 04-05-2007, 05:43 AM
  3. zimbra is not starting after a wacky upgrade/downgrade
    By keanne in forum Administrators
    Replies: 4
    Last Post: 09-03-2006, 11:49 PM
  4. Outlok crash with Zimbra Connector
    By chcbearsfan in forum Zimbra Connector for Outlook
    Replies: 3
    Last Post: 06-12-2006, 06:12 AM
  5. 64bit, convertd, verity causing java thread to crash
    By jnetman1 in forum Installation
    Replies: 3
    Last Post: 04-25-2006, 02:38 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
  •