[SOLVED]:SQL Assoc Failed! Error:1017

[dhrabarchuk]

UPDATE: Solved. (Version: cacti-0.8.8a-1.el5.rf)

I had the same issue. The MySQL table poller_output gives the error file not found, when you try to run a select on it in the mysql client.

Running truncate poller_output; in mysql recreates the missing file and solves this issue.

This took some thought because no error about the missing mysql file appeared in either cacti.log or mysqld.log. I had to search to make sure that truncating the table would not create more issues. This led me to here, where I figured I freshen up this stale post.

The red lines in cacti.log were:

06/24/2013 12:55:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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) "
06/24/2013 12:55:09 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_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"

I also ran rebuild_poller_cache.php and repair_database.php. Neither command repaired the issue or reported it. Running the SQL from the cacti error messages in mysql showed me the low level error.