Poller[0] ERROR: SQL Exec Failed "insert into poller_ou

hipster · Post by **hipster** » Sat Mar 18, 2006 8:41 am

Why is my cacti.log full of SQL exec fails? Most of my graphs are ok but few fails.

03/18/2006 03:35:14 PM - SYSTEM STATS: Time:7.6596 Method:cmd.php Processes:2 Threads:N/A Hosts:10 HostsPerProcess:5 DataSources:314 RRDsProcessed:133  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (140,'traffic_in','2006-03-18 15:35:09','2957171874')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (138,'traffic_out','2006-03-18 15:35:09','307792')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (138,'traffic_in','2006-03-18 15:35:09','42126')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (137,'traffic_out','2006-03-18 15:35:09','44549062')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (137,'traffic_in','2006-03-18 15:35:09','3398888649')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (136,'traffic_out','2006-03-18 15:35:09','0')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (136,'traffic_in','2006-03-18 15:35:09','0')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (135,'traffic_out','2006-03-18 15:35:09','0')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (135,'traffic_in','2006-03-18 15:35:09','0')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (134,'traffic_out','2006-03-18 15:35:09','868297883')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (134,'traffic_in','2006-03-18 15:35:09','69422608')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (133,'traffic_out','2006-03-18 15:35:09','48968461')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (133,'traffic_in','2006-03-18 15:35:09','0')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (132,'traffic_out','2006-03-18 15:35:09','3119628319')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (132,'traffic_in','2006-03-18 15:35:09','2638798837')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (131,'traffic_out','2006-03-18 15:35:09','49036339')"  
03/18/2006 03:35:13 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (131,'traffic_in','2006-03-18 15:35:09','495')"

acornu · Post by **acornu** » Sat Mar 18, 2006 7:01 pm

Funny thing, I've just subscribe to the forum to ask the exact same question!!

My cacti.log file was over 1.3Gig in size...

Strange thing too, I am unable to view or clear the log file using the system utilities, when trying to clear it, I get: - "Error: Unable to clear log, file does not exist." (?!?)

So I've just manually deleted the file.

Anyway, I am not really expert in SQL, is there a way to find what cause all these messages?

03/18/2006 06:45:07 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (1581,'traffic_out','2006-03-18 18:45:01','1179215716')"

tomhutch · Post by **tomhutch** » Thu Mar 23, 2006 9:31 pm

Anyone out there have the answer? I know my mysql parameters are correct. I can login to mysql as cactiuser with the configured password, use the cacti database and even manually "insert" using the same syntax as show below.

??

Tom

Here is my output:

03/23/2006 06:25:03 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (17,'traffic_out','20
06-03-23 18:25:02','2302319152')"
03/23/2006 06:25:03 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (18,'traffic_out','20
06-03-23 18:25:02','1031278808')"
03/23/2006 06:25:03 PM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id,rrd_name,time,output) values (19,'traffic_out','20
06-03-23 18:25:02','2280408014')"

tomhutch · Post by **tomhutch** » Thu Mar 23, 2006 9:35 pm

I also can't clear the log file. I get "Error: Unable to clear log, no write permissions."

The log file has the following UNIX permissions:
-rw-r--r-- 1 cactiuser cactiuser 21488 Mar 23 18:30 cacti.log

I also tried changing the group to rw and added apache to the cactiuser group without any joy.

Help,
Tom

Post by **TheWitness** » Thu Mar 23, 2006 11:14 pm

The apache account new's rw permissions to the log directory.

The other issue may be to a duplicated graph element. The reason that the poll fails is due to a primary key violation, which means duplicate poller items. Try clearing the poller cache. System Utilities -> Clear Poller Cache. (actually, it rebuilds it)

TheWitness

acornu · Post by **acornu** » Mon Apr 17, 2006 10:29 am

Thanks for the info..

Unfortunately, I was still having problem..

I changed the poller type from php to Cactid, it's a lot better but now I get a lot of "duplicate entry" error msgs in the log. I know there's a few treads that discuss about it, so I'll go trough them see what I can find.

For the logs, seems like cacti can't find the file, when I delete it, cacti automatically recreate it.
drwxrw-rw- 2 cactiuser cactiuser 4096 Apr 8 22:46 log

Using the web page, I try to view the log, nothing shows up, blank... and if I try to clear the log file gives me the error "Unable to clear log, file does not exist."... Even if Cacti created the file by itself.
Path is fine: /var/www/html/cacti/log/cacti.log

Post by **TheWitness** » Mon Apr 17, 2006 8:09 pm

The SVN version corrects the duplicate issue. It is caused by the verify all indexes reindex method. If you use the SVN version, this message will go away.

TheWitness

fittdog8848 · Post by **fittdog8848** » Tue Apr 18, 2006 3:16 pm

This is what helped me from another post

The first few messages are often seen in installation that run 2 different crontabs with a cronjob for cacti in each of them. RPM installation often installs /etc/cron.d/cacti and if you put the poller in /etc/crontab or into crontab of user root or cactiuser you'll have two of them. This will not work well. So please search for this issue.
Reinhard

Post by **gandalf** » Wed Apr 19, 2006 4:31 am

fittdog8848 wrote:This is what helped me from another post

The first few messages are often seen in installation that run 2 different crontabs with a cronjob for cacti in each of them. RPM installation often installs /etc/cron.d/cacti and if you put the poller in /etc/crontab or into crontab of user root or cactiuser you'll have two of them. This will not work well. So please search for this issue.
Reinhard

Wow, I followed this post all the time. I had no idea, whatsoever, that THIS would help.
Reinhard

fittdog8848 · Post by **fittdog8848** » Wed Apr 19, 2006 9:50 am

LOL...it was you that suggested it.

JJX · Post by **JJX** » Fri May 19, 2006 11:47 am

I face the same problem
What is the SVN version?

Post by **gandalf** » Fri May 19, 2006 12:27 pm

See http://cacti.net/svn.php for anonymous access to SVN and http://svn.cacti.net/cgi-bin/viewcvs.cgi/ for online access
Reinhard

JJX · Post by **JJX** » Fri May 19, 2006 2:39 pm

Axx , cvs version....
ok - thx
This should be fixed in 0.8.6h version? (i cant find when it was released to compare the dates)

Cacti

Poller[0] ERROR: SQL Exec Failed "insert into poller_ou

Poller[0] ERROR: SQL Exec Failed "insert into poller_ou

Me too :(

Addenum:

Who is online