{"id":113,"date":"2017-10-11T08:43:00","date_gmt":"2017-10-11T08:43:00","guid":{"rendered":"https:\/\/linuxadmin.melberi.com\/uncategorized\/poller0-error-sql-assoc-failed"},"modified":"2017-10-11T09:48:25","modified_gmt":"2017-10-11T09:48:25","slug":"poller0-error-sql-assoc-failed","status":"publish","type":"post","link":"https:\/\/www.melberi.com\/linuxadmin\/cacti\/poller0-error-sql-assoc-failed","title":{"rendered":"Poller[0] ERROR: SQL Assoc Failed!, Error:’1017′ – Cacti"},"content":{"rendered":"

Cacti ERROR: SQL Assoc Failed!<\/p>\n

Cacti Poller[0] ERROR:<\/u><\/b><\/h3>\n

Cacti Graphs were not generated.
\nWhile checking the Cacti Log, it shows the following error.<\/p>\n

#tail -f \/var\/www\/html\/log\/cacti.log<\/strong><\/p>\n

Error Log:<\/u><\/b><\/p>\n

Poller[0] ERROR: SQL Assoc Failed!, Error:’1017′, SQL:”select\u00a0 poller_output.output,\u00a0 poller_output.time,\u00a0 poller_output.local_data_id,\u00a0 poller_item.rrd_path,\u00a0 poller_item.rrd_name,\u00a0 poller_item.rrd_num\u00a0 from (poller_output,poller_item)\u00a0 where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)\u00a0 LIMIT 10000″
\n
\n<\/b>
\nCheck your cacti database. This may be because of any table corruption.<\/p>\n

While checking we found\u00a0 poller_output<\/strong> table was corruption.
\n
\n<\/b><\/p>\n

 <\/p>\n

\"\"<\/b><\/div>\n


\n<\/b>
\nSolution:<\/u><\/b><\/h3>\n

Try repairing the corrupted table, if it was not successfully.<\/p>\n

Then try Truncated that particular table through phpmyadmin and rebuild the poller cache through Cache Admin->System Utilities.<\/strong>
\n<\/b>
\n TRUNCATE `poller_output` ;<\/strong>
\nYour SQL query has been executed successfully<\/p>\n

Due to low disk space in the database server, the table poller_output was corrupted in our case.<\/p>\n","protected":false},"excerpt":{"rendered":"

Cacti ERROR: SQL Assoc Failed! Cacti Poller[0] ERROR: Cacti Graphs were not generated. While checking the Cacti Log, it shows the following error. #tail -f \/var\/www\/html\/log\/cacti.log Error Log: Poller[0] ERROR:… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":288,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[135],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/113"}],"collection":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/comments?post=113"}],"version-history":[{"count":4,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":704,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/113\/revisions\/704"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media\/288"}],"wp:attachment":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media?parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/categories?post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/tags?post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}