ERROR: SQL Exec Failed

[stuartar]

Hi All,

Running (patched) Cacti0.8.6g on FC4 against MySQL 4.1.11 and I'm getting the error "ERROR: SQL Exec Failed" from the poller. Checking the poller_output table though, you can see that the data IS going in, and the graphs reflect that. Odd thing is that this error isnt there when running poller.php from the command line, so I guess its environment related. Ive tried running poller through a shell wrapper to set a few things but no joy.
Anyone have any ideas whats causing this? Its not a show stopper but I can do without a load of these errors inthe logs for every single server at every single poller run....

01/15/2006 10:40:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (112,'','2006-01-15 10:40:04','LastHourIn:2 LastHourOut:2 Queue:21 ConnectionIn:0 ConnectionOut:10')"
01/15/2006 10:40:08 AM - CMDPHP: Poller[0] Time: 3.9003 s, Theads: N/A, Hosts: 1
01/15/2006 10:40:08 AM - CMDPHP: Poller[0] DEBUG: SQL Exec: "insert into poller_time (poller_id, start_time, end_time) values (0, NOW(), NOW())"

cactihost:/var/www/html/cacti/lib# mysql cacti
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22445 to server version: 4.1.11

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from poller_output;
+---------------+----------+---------------------+---------------------------------------------------------------------+
| local_data_id | rrd_name | time | output |
+---------------+----------+---------------------+---------------------------------------------------------------------+
| 110 | | 2006-01-15 10:40:04 | LastHourIn:2 LastHourOut:2 Queue:21 ConnectionIn:0 ConnectionOut:10 |
| 111 | | 2006-01-15 10:40:04 | LastHourIn:2 LastHourOut:2 Queue:21 ConnectionIn:0 ConnectionOut:10 |
| 112 | | 2006-01-15 10:40:04 | LastHourIn:2 LastHourOut:2 Queue:21 ConnectionIn:0 ConnectionOut:10 |
+---------------+----------+---------------------+---------------------------------------------------------------------+
3 rows in set (0.00 sec)

mysql> Bye

[TheWitness]

This problem could be indicative of having 2 Data Sources of the same type pointed at the same host.

TheWitness

[stuartar]

Hmm. Not two datasources as such, but I have one script that runs and collects 5 values. This is in one data template. Then I have 3 graph templates graphing various combinations of those 5 values. This creates 3 different data sources, but all referring back to the one data input method.

I've just run it with two of the three disabled and get the same error.

[gandalf]

Am I wrong?

Code: Select all

01/15/2006 10:40:08 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (112,'','2006-01-15 10:40:04','LastHourIn:2 LastHourOut:2 Queue:21 ConnectionIn:0 ConnectionOut:10')"

indicates an empty rrd_name (2nd parameter) which is weird. Perhaps this helps coming closer?
Reinhard

[TheWitness]

That is normal for MULTI OUTPUT scripts. It will get an error if you have 2 datasources of the same thing though.

TheWitness

[stuartar]

Ok. Since the prospect of two pollers kept coming being mentioned I diabled the cron entry for it, and guess what. problem solved.

So now I'm just trying to figure out whats running the other poller...

[stuartar]

/etc/cron.d/cacti

Thanks for everyones help.