Server stats not working

[furlongm]

Hi,

Server stats are not working on our Zimbra installation. It is the following version: Version 6.0.4_GA_2038.RHEL5_64.NETWORK. I've searched the forums and tried a number of different possible solutions (waiting at least 48 hours after each solution to see if the stats show up), but no joy. I'm attaching the information specified at

Logger (ZCS 6.0.x and later) - Zimbra :: Wiki

in case anyone can give me any pointers? Thanks.


zimbra@mail ~ $ zmloggerctl status; echo $?; ps ax | grep zmlogger
0
1855 pts/0 S+ 0:00 grep --colour=auto zmlogger
16486 ? S 17:42 /usr/bin/perl /opt/zimbra/libexec/zmlogger
16712 ? S 0:00 zmlogger: zmrrdfetch: server

zimbra@mail ~ $ /opt/zimbra/libexec/zmrrdfetch -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.

zimbra@mail ~ $ /opt/zimbra/libexec/zmrrdfetch -c -f zmmtastats
no structure found for zmmtastats at /opt/zimbra/libexec/zmrrdfetch line 225.

zimbra@mail ~ $ grep -w MTA /var/log/zimbra-stats.log

zimbra@mail ~ $ tail /var/log/zimbra-stats.log
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BA322-67C5-11DF-BC6C-E14B7B19F7B7:::, Com_purge_before_date, Com_rename_table, Com_repair, Com_replace, Com_replace_select, Com_reset, Com_restore_table, Com_revoke, Com_revoke_all, Com_rollback, Com_savepoint, Com_select, Com_set_option, Com_show_binlog_events, Com_show_binlogs, Com_show_charsets, Com_show_collations, Com_show_column_types, Com_show_create_db, Com_show_create_table, Com_show_databases, Com_show_errors, Com_show_fields, Com_show_grants, Com_show_innodb_status, Com_show_keys, Com_show_logs, Com_show_master_status, Com_show_ndb_status, Com_show_new_master, Com_show_open_tables, Com_show_privileges, Com_show_processlist, Com_show_slave_hosts, Com_show_slave_status, Com_show_status, Com_show_storage_engines, Com_show_tables, Com_show_triggers, Com_show_variables, Com_show_warnings, Com_slave_start, Com_slave_sto:::689BAE3A-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BAE3A-67C5-11DF-BC6C-E14B7B19F7B7::, Com_stmt_close, Com_stmt_execute, Com_stmt_fetch, Com_stmt_prepare, Com_stmt_reset, Com_stmt_send_long_data, Com_truncate, Com_unlock_tables, Com_update, Com_update_multi, Com_xa_commit, Com_xa_end, Com_xa_prepare, Com_xa_recover, Com_xa_rollback, Com_xa_start, Compression, Connections, Created_tmp_disk_tables, Created_tmp_files, Created_tmp_tables, Delayed_errors, Delayed_insert_threads, Delayed_writes, Flush_commands, Handler_commit, Handler_delete, Handler_discover, Handler_prepare, Handler_read_first, Handler_read_key, Handler_read_next, Handler_read_prev, Handler_read_rnd, Handler_read_rnd_next, Handler_rollback, Handler_savepoint, Handler_savepoint_rollback, Handler_update, Handler_write, Innodb_buffer_pool_pages_data, Innodb_buffer_pool_pages_dirty, Innodb_buffer_pool_pages_flush:::689BB268-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BB268-67C5-11DF-BC6C-E14B7B19F7B7:::ed, Innodb_buffer_pool_pages_free, Innodb_buffer_pool_pages_misc, Innodb_buffer_pool_pages_total, Innodb_buffer_pool_read_ahead_rnd, Innodb_buffer_pool_read_ahead_seq, Innodb_buffer_pool_read_requests, Innodb_buffer_pool_reads, Innodb_buffer_pool_wait_free, Innodb_buffer_pool_write_requests, Innodb_data_fsyncs, Innodb_data_pending_fsyncs, Innodb_data_pending_reads, Innodb_data_pending_writes, Innodb_data_read, Innodb_data_reads, Innodb_data_writes, Innodb_data_written, Innodb_dblwr_pages_written, Innodb_dblwr_writes, Innodb_log_waits, Innodb_log_write_requests, Innodb_log_writes, Innodb_os_log_fsyncs, Innodb_os_log_pending_fsyncs, Innodb_os_log_pending_writes, Innodb_os_log_written, Innodb_page_size, Innodb_pages_created, Innodb_pages_read, Innodb_pages_written, Innodb_row_lock_current_wai:::689BB68C-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BB68C-67C5-11DF-BC6C-E14B7B19F7B7:::ts, Innodb_row_lock_time, Innodb_row_lock_time_avg, Innodb_row_lock_time_max, Innodb_row_lock_waits, Innodb_rows_deleted, Innodb_rows_inserted, Innodb_rows_read, Innodb_rows_updated, Key_blocks_not_flushed, Key_blocks_unused, Key_blocks_used, Key_read_requests, Key_reads, Key_write_requests, Key_writes, Last_query_cost, Max_used_connections, Not_flushed_delayed_rows, Open_files, Open_streams, Open_tables, Opened_tables, Prepared_stmt_count, Qcache_free_blocks, Qcache_free_memory, Qcache_hits, Qcache_inserts, Qcache_lowmem_prunes, Qcache_not_cached, Qcache_queries_in_cache, Qcache_total_blocks, Queries, Questions, Rpl_status, Select_full_join, Select_full_range_join, Select_range, Select_range_check, Select_scan, Slave_open_temp_tables, Slave_retried_transactions, Slave_running, Slow_launch:::689BBABA-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BBABA-67C5-11DF-BC6C-E14B7B19F7B7:::_threads, Slow_queries, Sort_merge_passes, Sort_range, Sort_rows, Sort_scan, Ssl_accept_renegotiates, Ssl_accepts, Ssl_callback_cache_hits, Ssl_cipher, Ssl_cipher_list, Ssl_client_connects, Ssl_connect_renegotiates, Ssl_ctx_verify_depth, Ssl_ctx_verify_mode, Ssl_default_timeout, Ssl_finished_accepts, Ssl_finished_connects, Ssl_session_cache_hits, Ssl_session_cache_misses, Ssl_session_cache_mode, Ssl_session_cache_overflows, Ssl_session_cache_size, Ssl_session_cache_timeouts, Ssl_sessions_reused, Ssl_used_session_cache_entries, Ssl_verify_depth, Ssl_verify_mode, Ssl_version, Table_locks_immediate, Table_locks_waited, Tc_log_max_pages_used, Tc_log_page_size, Tc_log_page_waits, Threads_cached, Threads_connected, Threads_created, Threads_running, Uptime:: 05/25/2010 16:19:00,33,0,0,0,369338102:::689BBECA-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: 9730:info: :::689BBECA-67C5-11DF-BC6C-E14B7B19F7B7:::4,65431578771,39,0,0,0,0,0,0,266,0, 2427,0,2999329,26,0,90,196,0,0,383507,0,0,0,0,0,42 ,0,0,0,0,0,0,0,0,873960,14681,0,0,0,0,0,0,0,0,0,0, 0,0,196553,32,0,0,0,0,4601927,0,5169159,13797655,0 ,0,0,65,0,0,0,3,0,0,0,30122,0,0,0,0,0,0,0,0,0,0,98 348,0,292,0,65,0,0,0,0,0,0,0,0,0,0,0,1689408,12224 7,0,0,0,0,0,0,OFF,98417,126998,213,430855,0,0,0,1, 5833721,134,0,0,122894,74066147,1193512326,7230638 ,9036030,15567730,48595,0,0,6939804,16154186,10983 2,0,2780125,231047,6129,347008,31,419,3872989961,6 9163,0,49837817,954249,0,0,0,1533104128,71857,2837 388,93834289664,2780125,145550,0,6108499,230026,32 1040,0,0,2688510976,16384,16910,93440,2780125,0,0, 0,0,0,923535,663312,1291484019,1748935,0,6680,5439 ,6055773,14,367875,356038,0.000000,7,0,76,0,986,14 62,0,0,0,0,0,0,0,0,0,30040709,30040709,NULL,0,0,76 3731,0,66016,0,:::689BC2E4-67C5-11DF-BC6C-E14B7B19F7B7:::
May 25 16:19:00 mail zimbramon[9730]: :::689BC2E4-67C5-11DF-BC6C-E14B7B19F7B7:::0,OFF,0,5597,124,668801,3827740,125 576,0,0,0,,,0,0,0,0,0,0,0,0,0,NONE,0,0,0,0,0,0,0,, 9763978,0,0,0,0,0,7,7,1,1808444
May 25 16:19:02 mail zimbramon[9716]: 9716:info: zmstat cpu.csv: timestamp, cpu:user, cpu:nice, cpu:sys, cpu:idle, cpu:iowait, cpu:irq, cpu:softirq, cpu0:user, cpu0:nice, cpu0:sys, cpu0:idle, cpu0:iowait, cpu0:irq, cpu0:softirq, cpu1:user, cpu1:nice, cpu1:sys, cpu1:idle, cpu1:iowait, cpu1:irq, cpu1:softirq, cpu2:user, cpu2:nice, cpu2:sys, cpu2:idle, cpu2:iowait, cpu2:irq, cpu2:softirq, cpu3:user, cpu3:nice, cpu3:sys, cpu3:idle, cpu3:iowait, cpu3:irq, cpu3:softirq, cpu4:user, cpu4:nice, cpu4:sys, cpu4:idle, cpu4:iowait, cpu4:irq, cpu4:softirq, cpu5:user, cpu5:nice, cpu5:sys, cpu5:idle, cpu5:iowait, cpu5:irq, cpu5:softirq, cpu6:user, cpu6:nice, cpu6:sys, cpu6:idle, cpu6:iowait, cpu6:irq, cpu6:softirq, cpu7:user, cpu7:nice, cpu7:sys, cpu7:idle, cpu7:iowait, cpu7:irq, cpu7:softirq, cpu8:user, cpu8:nice, cpu8:sys, cpu8:idle, cpu8:iowait, cpu8:::6A006950-67C5-11DF-9B15-D34B7B19F7B7:::
May 25 16:19:02 mail zimbramon[9716]: 9716:info: :::6A006950-67C5-11DF-9B15-D34B7B19F7B7::::irq, cpu8:softirq, cpu9:user, cpu9:nice, cpu9:sys, cpu9:idle, cpu9:iowait, cpu9:irq, cpu9:softirq, cpu10:user, cpu10:nice, cpu10:sys, cpu10:idle, cpu10:iowait, cpu10:irq, cpu10:softirq, cpu11:user, cpu11:nice, cpu11:sys, cpu11:idle, cpu11:iowait, cpu11:irq, cpu11:softirq, cpu12:user, cpu12:nice, cpu12:sys, cpu12:idle, cpu12:iowait, cpu12:irq, cpu12:softirq, cpu13:user, cpu13:nice, cpu13:sys, cpu13:idle, cpu13:iowait, cpu13:irq, cpu13:softirq, cpu14:user, cpu14:nice, cpu14:sys, cpu14:idle, cpu14:iowait, cpu14:irq, cpu14:softirq, cpu15:user, cpu15:nice, cpu15:sys, cpu15:idle, cpu15:iowait, cpu15:irq, cpu15:softirq:: 05/25/2010 16:19:02, 11.8, 0.0, 0.9, 86.4, 0.8, 0.0, 0.1, 15.9, 0.0, 3.1, 72.1, 8.2, 0.0, 0.8, 2.1, 0.0, 0.3, 97.4, 0.3, 0.0, 0.0, 9.8, 0.0, 0.4, 89.8, 0.1, 0.0, 0.0, 7.8, 0.0, :::6A0070A8-67C5-11DF-9B15-D34B7B19F7B7:::
May 25 16:19:02 mail zimbramon[9716]: :::6A0070A8-67C5-11DF-9B15-D34B7B19F7B7:::0.8, 91.4, 0.1, 0.0, 0.0, 12.5, 0.0, 1.6, 85.9, 0.0, 0.0, 0.0, 3.1, 0.0, 0.3, 96.5, 0.0, 0.0, 0.0, 9.3, 0.0, 0.4, 90.2, 0.0, 0.0, 0.0, 8.3, 0.0, 0.5, 91.3, 0.0, 0.0, 0.0, 22.7, 0.0, 1.4, 73.1, 2.9, 0.0, 0.0, 13.4, 0.0, 1.0, 85.4, 0.2, 0.0, 0.0, 7.7, 0.0, 0.7, 91.5, 0.0, 0.0, 0.0, 15.5, 0.0, 0.7, 83.8, 0.0, 0.0, 0.0, 20.1, 0.0, 1.2, 78.5, 0.1, 0.0, 0.0, 12.8, 0.0, 0.9, 85.8, 0.5, 0.0, 0.0, 13.6, 0.0, 0.8, 85.6, 0.0, 0.0, 0.0, 14.8, 0.0, 0.9, 84.3, 0.0, 0.0, 0.0

zimbra@mail ~ $ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats | head -20


zimbra@mail ~ $ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats @limit=1 | head -50