[solved] Poller[0] ERROR: SQL Assoc Failed!, Error:'1016'

[simonb_13]

Version 0.8.7c
MySQL 4.1
Windows Server 2003

All's been well with this install for months but now I get -J graphs and the Logfile is full of:

10/22/2009 01:23:01 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1016', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

Preceeded by:

10/22/2009 01:23:00 PM - CACTID: Poller[0] MYSQL: ERROR encountered while attempting to retrieve records from query
10/22/2009 01:23:00 PM - CACTID: Poller[0] MYSQL: ERROR encountered while attempting to retrieve records from query
10/22/2009 01:23:00 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1016', SQL:"SELECT host_id, COUNT(*) AS data_sources FROM poller_item WHERE rrd_next_step<=0 GROUP BY host_id ORDER BY host_id"
10/22/2009 01:23:00 PM - CMDPHP: Poller[0] ERROR: SQL Cell Failed!, Error:'1016', SQL:"SELECT COUNT(*) FROM poller_item WHERE rrd_next_step<=0"

Have tried repairing the Cacti tables and repairing poller_item.MYI file in the MySQL data folder. Neither worked.

Any thoughts?

Many thanks

Simon

[simonb_13]

Further System Details

PHP 5
RRDTOOL 5
NET_SNMP 5
SPINE
Apache 2

[BSOD2600]

Did you google for mysql 1016 error? It's "Can't open file", which would indicate your database is corrupt or worse. Have you ran \cacti\cli\repair_database.php yet ? What was the output?

Run chkdsk C: /f and reboot.

[simonb_13]

C:\jffnms\htdocs\cacti\cli>php repair_database.php
C:/net-snmp/etc/snmp/snmp.conf: line 2: Warning: Unknown token: persistentDir.
C:/net-snmp/etc/snmp/snmp.conf: line 3: Warning: Unknown token: tempFilePattern.

Repairing All Cacti Database Tables
Repairing Table -> 'cdef' Successful
Repairing Table -> 'cdef_items' Successful
Repairing Table -> 'colors' Successful
Repairing Table -> 'data_input' Successful
Repairing Table -> 'data_input_data' Successful
Repairing Table -> 'data_input_fields' Successful
Repairing Table -> 'data_local' Successful
Repairing Table -> 'data_template' Successful
Repairing Table -> 'data_template_data' Successful
Repairing Table -> 'data_template_data_rra' Successful
Repairing Table -> 'data_template_rrd' Successful
Repairing Table -> 'graph_local' Successful
Repairing Table -> 'graph_template_input' Successful
Repairing Table -> 'graph_template_input_defs' Successful
Repairing Table -> 'graph_templates' Successful
Repairing Table -> 'graph_templates_gprint' Successful
Repairing Table -> 'graph_templates_graph' Successful
Repairing Table -> 'graph_templates_item' Successful
Repairing Table -> 'graph_tree' Successful
Repairing Table -> 'graph_tree_items' Successful
Repairing Table -> 'host' Successful
Repairing Table -> 'host_graph' Successful
Repairing Table -> 'host_snmp_cache' Successful
Repairing Table -> 'host_snmp_query' Successful
Repairing Table -> 'host_template' Successful
Repairing Table -> 'host_template_graph' Successful
Repairing Table -> 'host_template_snmp_query' Successful
Repairing Table -> 'plugin_config' Successful
Repairing Table -> 'plugin_db_changes' Successful
Repairing Table -> 'plugin_hooks' Successful
Repairing Table -> 'plugin_realms' Successful
Repairing Table -> 'poller' Successful
Repairing Table -> 'poller_command' Successful
Repairing Table -> 'poller_item' Successful
Repairing Table -> 'poller_output' Successful
Repairing Table -> 'poller_output_rt' Successful
Repairing Table -> 'poller_reindex' Successful
Repairing Table -> 'poller_time' Successful
Repairing Table -> 'reports' Successful
Repairing Table -> 'reports_data' Successful
Repairing Table -> 'rra' Successful
Repairing Table -> 'rra_cf' Successful
Repairing Table -> 'settings' Successful
Repairing Table -> 'settings_graphs' Successful
Repairing Table -> 'settings_tree' Successful
Repairing Table -> 'snmp_query' Successful
Repairing Table -> 'snmp_query_graph' Successful
Repairing Table -> 'snmp_query_graph_rrd' Successful
Repairing Table -> 'snmp_query_graph_rrd_sv' Successful
Repairing Table -> 'snmp_query_graph_sv' Successful
Repairing Table -> 'thold' Successful
Repairing Table -> 'thold_data' Successful
Repairing Table -> 'thold_template' Successful
Repairing Table -> 'tholdset' Successful
Repairing Table -> 'user_auth' Successful
Repairing Table -> 'user_auth_perms' Successful
Repairing Table -> 'user_auth_realm' Successful
Repairing Table -> 'user_log' Successful
Repairing Table -> 'version' Successful
Repairing Table -> 'weathermap_auth' Successful
Repairing Table -> 'weathermap_maps' Successful

[simonb_13]

That fixed it!

Not sure my previous attempts through a MYSQL administration app didn't do the job.

Anyway, thanks for your help.

This is a great forum!

Simon