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

[junglism]

Hi

I'm using cactiez with cacti version 0.8.7c
I'm getting these 1017 errors when i turn on 'high' logging.

The history:

my cacti server ran out of room about a week ago. so i deleted some files from /var/www/backups to free up some room (about 20% of drive space).

i think it was working ok after that,.. but i didnt really check.

yesterday i checked and the graps were all showing "the rrd file does not exist". so i turned on logging to check out what the problem was..

the logs are as follows:

01/20/2010 10:06:05 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', 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) "

01/20/2010 10:07:04 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1017', Message:'Can't find file: 'poller_output' (errno: 2)', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (121,'traffic_out','2010-01-20 10:07:04','2459928830'),(121,'traffic_in','2010-01-20 10:07:04','1878517142'),(120,'cpu','2010-01-20 10:07:04','9')'

i am using spine as my poller.

would appreciate any help

[gandalf]

Please see "System Utilities -> Tech Support" to verify that the table poller output is in place and healthy
R

[junglism]

hi Gandalf
Thanks for getting back to me.. the poller table is in place and healthy.. i might just start again with a new image....

[bobulger]

Hello,

I had a similar situation. I have inherited this Debian Etch server from a previous employee. Didn't know about it and the disk filled up. I have cleared some of the backups and cleared the root mail account to free space. I rebooted the server and was able to login to the site as admin. Here is a snip of the log file.


02/02/2012 08:10:26 AM - SPINE: Poller[0] Host[107] DEBUG: The POPEN returned the following File Descriptor 27
02/02/2012 08:10:26 AM - SPINE: Poller[0] Host[107] DS[431] SCRIPT: /usr/bin/perl /usr/share/cacti/site/scripts/ping.pl 172.26.38.253, output: 46.8
02/02/2012 08:10:26 AM - SPINE: Poller[0] Host[107] DS[430] SNMP: v1: 172.26.38.253, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.10001, value: 1936741200
02/02/2012 08:10:26 AM - SPINE: Poller[0] Host[107] DS[430] SNMP: v1: 172.26.38.253, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.10001, value: 310577340
02/02/2012 08:10:26 AM - SPINE: Poller[0] Host[107] DS[466] SNMP: v1: 172.26.38.253, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.2.1.58.0, value: 7
02/02/2012 08:10:26 AM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1017', Message:'Can't find file: 'poller_output' (errno: 2)', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (430,'traffic_out','2012-02-02 08:10:26','1936741200'),(430,'traffic_in','2012-02-02 08:10:26','310577340'),(431,'ping','2012-02-02 08:10:26','46.8'),(466,'5min_cpu','2012-02-02 08:10:26','7')'

I followed your advice in the previous post and checked "System Utilities -> Tech Support to verify that the table poller output is in place." It is not in the database.

How do I restore this table?

Bo

[gandalf]

Find definitions as part of cacti.sql file
R.

[Johnny Lingo]

Worth mentioning that even though the table doesn't show up in System Utilities -> Technical Support, the table does still exist. However, when I went to drop it, I was told the table doesn't exist. But for all intensive purposes that was a cosmetic error.

Code: Select all

mysql> CREATE TABLE poller_output (
    ->   local_data_id mediumint(8) unsigned NOT NULL default '0',
    ->   rrd_name varchar(19) NOT NULL default '',
    ->   time datetime NOT NULL default '0000-00-00 00:00:00',
    ->   output text NOT NULL,
    ->   PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
    -> ) ENGINE=MyISAM;
ERROR 1050 (42S01): Table 'poller_output' already exists

mysql> drop table poller_output;
ERROR 1051 (42S02): Unknown table 'poller_output'

mysql> CREATE TABLE poller_output (
    ->   local_data_id mediumint(8) unsigned NOT NULL default '0',
    ->   rrd_name varchar(19) NOT NULL default '',
    ->   time datetime NOT NULL default '0000-00-00 00:00:00',
    ->   output text NOT NULL,
    ->   PRIMARY KEY (local_data_id,rrd_name,time) /*!50060 USING BTREE */
    -> ) ENGINE=MyISAM;
Query OK, 0 rows affected (0.07 sec)