Zimbra Message Trace not working

[yusufu]

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

[uxbod]

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

[yusufu]

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

[uxbod]

su - zimbra
logmysql

does that take you into MySQL ?

[yusufu]

yes it does.

how do i get the database itself.

could u give me all the troubleshooting commands

thanks

[uxbod]

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

[phoenix]

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

[yusufu]

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

[uxbod]

su - zimbra
logmysql
use zimbra_logger;
repair table mta;
exit

good catch Bill

[yusufu]

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?