Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Zimbra Message Trace not working

  1. #1
    yusufu's Avatar
    yusufu is offline Active Member
    Join Date
    Apr 2008
    Posts
    34
    Rep Power
    6

    Default Zimbra Message Trace not working

    I tried to trace a message on Zimbra and this is the error I get.

    [zimbra@mx root]$ zmmsgtrace -s test.user
    DB: Can't connect to dbi:mysql:database=zimbra_logger;mysql_read_defaul t_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock: Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)


    What do do to rectify this, as some of my users call for message tracing regularly and it's making me and my team look really bad that we can't do anything for them.
    FYI: I use Zimbra message trace on my test server running Zimbra 5

    ice, ice baby

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

    Default

    can you connect to the mysql database as the zimbra user ? is mysql actually running ?

  3. #3
    yusufu's Avatar
    yusufu is offline Active Member
    Join Date
    Apr 2008
    Posts
    34
    Rep Power
    6

    Default

    Yes, I believe it is.


    zmmysqlstatus status
    MySQL uptime: 440 minutes

    Connections and Threads:
    -----------------------
    Connections = 1145
    Max_used_connections = 50
    Threads_cached = 0
    Threads_connected = 50
    Threads_created = 50
    Threads_running = 1

    Operations by type:
    ------------------
    Com_select = 1
    Com_insert = 0
    Com_insert_select = 0
    Com_update = 0
    Com_delete = 0
    Com_delete_multi = 0

    Temp table activity:
    -------------------
    Created_tmp_disk_tables = 0
    Created_tmp_files = 5

    Row-level statistics:
    --------------------
    Handler_read_key = 0
    Handler_read_first = 0
    Handler_read_rnd = 0
    Handler_read_rnd_next = 0
    Handler_write = 132
    Handler_update = 0
    Handler_delete = 0
    Handler_commit = 0
    Handler_rollback = 0

    Key Buffer:
    ----------
    Key_read_requests = 3910491
    Key_reads = 2329
    Key_write_requests = 6174
    Key_writes = 5528

    Handles:
    -------
    Open_files = 32
    Open_tables = 500

    Table scans:
    -----------
    Select_full_join = 0
    Select_full_range_join = 0
    Select_range_check = 0
    Select_scan = 1

    Sorting:
    -------
    Sort_merge_passes = 0
    Sort_range = 0
    Sort_rows = 0
    Sort_scan = 0

    Locking:
    -------
    Table_locks_immediate = 2585758
    Table_locks_waited = 2

    InnoDB Status:
    BUFFER POOL AND MEMORY
    ----------------------
    Total memory allocated 1757377264; in additional pool allocated 1048576
    Buffer pool size 97344
    Free buffers 0
    Database pages 96490
    Modified db pages 40342
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages read 311083, created 6634, written 354346
    1.36 reads/s, 0.02 creates/s, 10.62 writes/s
    Buffer pool hit rate 1000 / 1000
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    1 read views open inside InnoDB
    Main thread process no. 11048, id 1337682832, state: sleeping
    Number of rows inserted 242536, updated 670334, deleted 180678, read 170679306
    0.31 inserts/s, 7.69 updates/s, 4.64 deletes/s, 6140.64 reads/s

    ice, ice baby

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

    Default

    Code:
    su - zimbra
    logmysql
    does that take you into MySQL ?

  5. #5
    yusufu's Avatar
    yusufu is offline Active Member
    Join Date
    Apr 2008
    Posts
    34
    Rep Power
    6

    Default

    yes it does.

    how do i get the database itself.

    could u give me all the troubleshooting commands

    thanks

    ice, ice baby

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

    Default

    Code:
    ls -l /opt/zimbra/logger/db
    ps -fp `cat /opt/zimbra/logger/db/mysql.pid`

  7. #7
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Post the contents of your /etc/hosts file and are there any errors in the logfile: /opt/zimbra/logger/db/data/your_hostname.err.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  8. #8
    yusufu's Avatar
    yusufu is offline Active Member
    Join Date
    Apr 2008
    Posts
    34
    Rep Power
    6

    Default

    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    080508 16:53:27 [ERROR] /opt/zimbra/logger/mysql/libexec/mysqld: Table './zimbra_logger/mta' is marked as crashed and last (automatic?) repair failed
    Last edited by yusufu; 05-08-2008 at 11:57 AM.

    ice, ice baby

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

    Default

    Code:
    su - zimbra
    logmysql
    use zimbra_logger;
    repair table mta;
    exit
    good catch Bill

  10. #10
    yusufu's Avatar
    yusufu is offline Active Member
    Join Date
    Apr 2008
    Posts
    34
    Rep Power
    6

    Default

    thanks man.

    It worked.
    I just have one question, how much space does the database take. I have about 96G left from 400G.
    Is it advisable to leave it on, is there any logging level I can set?

    ice, ice baby

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. admin consol blank after 5.0.3 upgarde
    By maumar in forum Administrators
    Replies: 6
    Last Post: 03-21-2008, 05:16 AM
  2. Replies: 22
    Last Post: 12-02-2007, 05:05 PM
  3. upgrade woes -made into new thread
    By JustinHarlow in forum Installation
    Replies: 18
    Last Post: 06-08-2007, 12:11 PM
  4. Can't start Zimbra!
    By zibra in forum Administrators
    Replies: 5
    Last Post: 03-22-2007, 11:34 AM
  5. huge log size
    By rmvg in forum Administrators
    Replies: 5
    Last Post: 01-02-2007, 10:39 AM

Posting Permissions

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