Results 1 to 4 of 4

Thread: zmmsgtrace

  1. #1
    Join Date
    Aug 2006
    Location
    San Diego
    Posts
    193
    Rep Power
    9

    Default zmmsgtrace

    hey everyone
    i'm trying to use zmmsgtrace on our server but it keeps bombing out. Has anyone seen this error before?

    [zimbra@mail ~]$ zmmsgtrace -r user@domain.tld
    Tracing messages
    to user@domain.tld

    /opt/zimbra/bin/zmmsgtrace sql execute failed: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed

    0 messages found

  2. #2
    Join Date
    Oct 2007
    Location
    Columbus, OH
    Posts
    70
    Rep Power
    8

    Default

    I think this is what you are looking for
    Repair Logger Data Corruption - Zimbra :: Wiki

    If the repair doesn't work, you'll have to re-initialize your logger database.

  3. #3
    Join Date
    May 2006
    Location
    Malaysia
    Posts
    9
    Rep Power
    9

    Default

    I did that but no luck.
    may be the too many rows?
    Code:
    mysql> REPAIR TABLE raw_logs USE_FRM;
    
    +------------------------+--------+----------+-------------------------------------------+
    | Table                  | Op     | Msg_type | Msg_text                                  |
    +------------------------+--------+----------+-------------------------------------------+
    | zimbra_logger.raw_logs | repair | warning  | Number of rows changed from 0 to 14498675 | 
    | zimbra_logger.raw_logs | repair | status   | OK                                        | 
    +------------------------+--------+----------+-------------------------------------------+
    I guess I've to rebuild the db?

    ./keris
    Release 5.0.4_GA_2101.RHEL5_64_20080321141727 CentOS5_64 NETWORK edition

  4. #4
    Join Date
    Jul 2008
    Posts
    11
    Rep Power
    7

    Default

    I am using v5.0.5 and am having the same problem. I ran the fixes from the Wiki page and am still getting the original error. Did you eventually find a fix to the problem, and if so what was it?

Similar Threads

  1. Zmmsgtrace - sql execute failed - error in SQL syntax
    By Edmund in forum Administrators
    Replies: 2
    Last Post: 03-19-2008, 01:04 PM
  2. server statistic & zmmsgtrace
    By zmmm in forum Administrators
    Replies: 3
    Last Post: 01-27-2008, 02:10 AM
  3. Zmmsgtrace
    By claros in forum Administrators
    Replies: 2
    Last Post: 11-09-2006, 05:44 AM
  4. where is zmmsgtrace in zcs-4.0.2_GA?
    By alessio in forum Administrators
    Replies: 2
    Last Post: 10-26-2006, 06:02 AM
  5. zmmsgtrace not working
    By Alfspace in forum Administrators
    Replies: 11
    Last Post: 03-02-2006, 01:51 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
  •