MYSQL error from cacti log

Post support questions that relate to the Windows 2003/2000/XP operating systems.

Moderators: Developers, Moderators

Post Reply
areast
Cacti User
Posts: 105
Joined: Wed Oct 29, 2014 5:08 am

MYSQL error from cacti log

Post by areast »

Log shown below message
CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1146', SQL:"SELECT host.id, host.hostname, host.description, host.snmp_community, host.snmp_version, host.snmp_username, host.snmp_password, host.snmp_port, host.snmp_timeout, manage_host.uptime, manage_host.statut FROM host,manage_host where manage = 'on' and disabled <> 'on' and host.id=manage_host.id"

And seem the database does not contain those item.

mysql> use cacti
Database changed
mysql> show tables;
+------------------------------------------+
| Tables_in_cacti |
+------------------------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_source_stats_daily |
| data_source_stats_hourly |
| data_source_stats_hourly_cache |
| data_source_stats_hourly_last |
| data_source_stats_monthly |
| data_source_stats_weekly |
| data_source_stats_yearly |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| gpsmap_templates |
| 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_quer
y |[/b]
| mac_track_interface_graphs |
| manage_admin_link |
| manage_alerts |
| manage_groups |
| manage_poller_output |
| manage_process |
| manage_services |
| manage_sites |
| manage_tcp |
| manage_templates |
| manage_uptime_method |
| notices |
| plugin_aggregate_color_template_items |
| plugin_aggregate_color_templates |
| plugin_aggregate_graph_templates |
| plugin_aggregate_graph_templates_graph |
| plugin_aggregate_graph_templates_item |
| plugin_aggregate_graphs |
| plugin_aggregate_graphs_graph_item |
| plugin_aggregate_graphs_items |
| plugin_autom8_graph_rule_items |
| plugin_autom8_graph_rules |
| plugin_autom8_match_rule_items |
| plugin_autom8_tree_rule_items |
| plugin_autom8_tree_rules |
| plugin_config |
| plugin_db_changes |
| plugin_fix64bit |
| plugin_hooks |
| plugin_murlin_cache |
| plugin_murlin_index |
| plugin_nectar |
| plugin_nectar_items |
| plugin_nmiddataexport_dataitems |
| plugin_nmidweb2_sort_order |
| plugin_realms |
| plugin_rrdclean |
| plugin_rrdclean_action |
| plugin_spikekill_templates |
| plugin_thold_contacts |
| plugin_thold_log |
| plugin_thold_template_contact |
| plugin_thold_threshold_contact |
| plugin_transporter_poller_output_archive |
| plugin_usersettings |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_output_rt |
| poller_reindex |
| poller_time |
| reports |
| reports_data |
| 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 |
| superlinks_auth |
| superlinks_pages |
| syslog |
| 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 |
| transporter_table |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
| weathermap_auth |
| weathermap_data |
| weathermap_groups |
| weathermap_maps |
| weathermap_settings |
+------------------------------------------+
126 rows in set (0.00 sec)
User avatar
Osiris
Cacti Guru User
Posts: 1424
Joined: Mon Jan 05, 2015 10:10 am

Re: MYSQL error from cacti log

Post by Osiris »

Answer depends on storage engine in MySQL. Have you run the repair_database.php script?
Before history, there was a paradise, now dust.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests