ERROR: A DB Exec Failed!, Error:‘145‘, SQL:"INSERT INTO `cacti`.`syslog_hosts` (host) (SELECT DISTINCT host FROM `cacti`.`syslog_incoming`) ON DUPLICATE KEY UPDATE host=VALUES(host), last_updated=NOW()‘ RROR: A DB Exec Failed!, Error:‘145‘, SQL:"DELETE FROM `cacti`.`syslog_statistics` WHERE insert_time< ERROR: A DB Exec Failed!, Error:‘145‘, SQL:"INSERT INTO `cacti`.`syslog` (logtime, priority_id, facility_id, host_id, message) SELECT TIMESTAMP(`date`, `time`), priority_id, facility_id, host_id, message FROM (SELECT date, time, priority_id, facility_id, host_id, message FROM syslog_incoming AS si INNER JOIN syslog_facilities AS sf ON sf.facility=si.facility INNER JOIN syslog_priorities AS sp ON sp.priority=si.priority INNER JOIN syslog_hosts AS sh ON sh.host=si.host WHERE status=5) AS merge‘
mysql>show databases; +--------------------+ | Database | +--------------------+ | information_schema | | cacti | | mysql | +--------------------+ 4 rows in set (0.00 sec)
mysql> use cacti
mysql> show tables； +---------------------------------------+ | Tables_in_cacti | +---------------------------------------+ | cdef | | cdef_items | | colors | | data_input | | data_input_data | | data_input_fields | | data_local | | data_template | | data_template_data | | data_template_data_rra | | data_template_rrd | | graph_local | | graph_template_input | | graph_template_input_defs | | graph_templates | | graph_templates_gprint | | graph_templates_graph | | graph_templates_item | | graph_tree | | graph_tree_items | | host | | host_graph | | host_snmp_cache | | host_snmp_query | | host_template | | host_template_graph | | host_template_snmp_query | | plugin_aggregate_color_template_items | | plugin_aggregate_color_templates | | plugin_config | | plugin_db_changes | | plugin_hooks | | plugin_realms | | plugin_thold_contacts | | plugin_thold_log | | plugin_thold_template_contact | | plugin_thold_threshold_contact | | poller | | poller_command | | poller_item | | poller_output | | poller_output_rt | | poller_reindex | | poller_time | | rra | | rra_cf | | settings | | settings_graphs | | settings_tree | | snmp_query | | snmp_query_graph | | snmp_query_graph_rrd | | snmp_query_graph_rrd_sv | | snmp_query_graph_sv | | syslog | | syslog_alarm_log | | syslog_alert | | syslog_facilities | | syslog_host_facilities | | syslog_hosts | | syslog_incoming | | syslog_logs | | syslog_priorities | | syslog_remove | | syslog_removed | | syslog_reports | | syslog_statistics | | thold_data | | thold_template | | user_auth | | user_auth_perms | | user_auth_realm | | user_log | | version | | weathermap_auth | | weathermap_data | | weathermap_groups | | weathermap_maps | | weathermap_settings | +---------------------------------------+ 79 rows in set (0.00 sec)
mysql> describe syslog_hosts; ERROR 145 (HY000): Table ‘./cacti/syslog_hosts‘ is marked as crashed and should be repaired
#mysqlcheck -A -o -r -p
mysql> describe syslog_hosts; +--------------+------------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+-------------------+-----------------------------+ | host_id | int(10) unsigned | NO | MUL | NULL | auto_increment | | host | varchar(128) | NO | PRI | NULL | | | last_updated | timestamp | NO | MUL | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+------------------+------+-----+-------------------+-----------------------------+ 3 rows in set (0.00 sec)
1、CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:‘1017‘ 2、ERROR 1017 (HY000): Can‘t find file: ‘poller_output‘ (errno: 2) 3、CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:‘1062‘
原文：https://www.cnblogs.com/xuewenlong/p/12808274.html