Production environment:
Database: MySQL 5.5.49-cll-lve
Problem: In many cacti monitoring objects, because of the addition of the monitoring object nginx, resulting in cacti in the monitoring of all objects only 1 objects out of the graph data.
Analysis:
1.systemutilities–>rebuild poller Cache #需要重建cache吗?
2. System time is not accurate, reset time #需要更新服务器时间吗?
3. Image not generated, run
#/usr/bin/php/var/www/html/cacti/poller.php--force #出现数据了吗?
4. Permissions issues, modify permissions #chmod 777-r/var/www/html/cacti/rra #没有权限吗?
5.crontab-e #定时任务的问题吗?
6. The database table is corrupt. #需要修复数据库吗?
After the problem occurs, we want to check the error log to analyze the problem, please check the attachment.
by viewing the cacti log file, it was found that no valid data was loaded and the problem of figure out data was resolved by repairing the cacti database.
[Email protected] sky]# Mysqlcheck--auto-repair--databases cacti-p
Enter Password:
Cacti.cdef OK
Cacti.cdef_items OK
Cacti.colors OK
Cacti.data_input OK
Cacti.data_input_data
Warning:2 clients is using or haven ' t closed the table properly
Status:ok
Cacti.data_input_fields OK
Cacti.data_local
Warning:3 clients is using or haven ' t closed the table properly
Status:ok
Cacti.data_template OK
Cacti.data_template_data
Warning:3 clients is using or haven ' t closed the table properly
Status:ok
Cacti.data_template_data_rra
Warning:2 clients is using or haven ' t closed the table properly
Status:ok
Cacti.data_template_rrd
Warning:2 clients is using or haven ' t closed the table properly
Status:ok
Cacti.graph_local
Warning:3 clients is using or haven ' t closed the table properly
Status:ok
Cacti.graph_template_input OK
Cacti.graph_template_input_defs OK
Cacti.graph_templates OK
Cacti.graph_templates_gprint OK
Cacti.graph_templates_graph
Warning:3 clients is using or haven ' t closed the table properly
Status:ok
Cacti.graph_templates_item
Warning:2 clients is using or haven ' t closed the table properly
Status:ok
Cacti.graph_tree
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.graph_tree_items
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.host
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.host_graph OK
Cacti.host_snmp_cache
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.host_snmp_query OK
Cacti.host_template OK
Cacti.host_template_graph OK
Cacti.host_template_snmp_query OK
Cacti.plugin_config
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.plugin_db_changes
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.plugin_discover_hosts
Warning:5 clients is using or haven ' t closed the table properly
Status:ok
Cacti.plugin_discover_template OK
Cacti.plugin_hooks
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.plugin_notification_lists OK
Cacti.plugin_realms
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.plugin_thold_contacts OK
Cacti.plugin_thold_host_failed OK
Cacti.plugin_thold_log
Warning:7 clients is using or haven ' t closed the table properly
Status:ok
Cacti.plugin_thold_template_contact OK
Cacti.plugin_thold_threshold_contact OK
Cacti.poller OK
Cacti.poller_command
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.poller_item
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.poller_output OK
Cacti.poller_output_rt
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.poller_reindex
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.poller_time OK
Cacti.rra OK
CACTI.RRA_CF OK
Cacti.settings
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.settings_graphs OK
Cacti.settings_tree OK
Cacti.snmp_query OK
Cacti.snmp_query_graph OK
CACTI.SNMP_QUERY_GRAPH_RRD OK
CACTI.SNMP_QUERY_GRAPH_RRD_SV OK
CACTI.SNMP_QUERY_GRAPH_SV OK
Cacti.syslog OK
Cacti.syslog_alert OK
Cacti.syslog_facilities OK
Cacti.syslog_host_facilities OK
Cacti.syslog_hosts OK
Cacti.syslog_incoming OK
Cacti.syslog_logs OK
Cacti.syslog_priorities OK
Cacti.syslog_remove OK
Cacti.syslog_removed OK
Cacti.syslog_reports OK
Cacti.syslog_statistics OK
Cacti.thold_data
Warning:9 clients is using or haven ' t closed the table properly
Status:ok
Cacti.thold_template OK
Cacti.user_auth OK
Cacti.user_auth_perms OK
Cacti.user_auth_realm
Warning:1 client is using or hasn ' t closed the table properly
Status:ok
Cacti.user_log
Warning:8 clients is using or haven ' t closed the table properly
Status:ok
Cacti.version OK
Utilities Utilities
This article is from the "sky9890" blog, make sure to keep this source http://sky9896.blog.51cto.com/2330653/1794426
Database problems caused by increased cacti monitoring objects