Results 1 to 4 of 4

Thread: zmmsgtrace

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

    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
    10

    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
    8

    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
  •