Poller, Error:'1062', SQL [Solved]

[slithy]

I upgraded my cacti install from 0.8.7 to 0.8.7b and now everytime the poller cron job runs, the following errors show up in the cacti log file:

Code: Select all

04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (234, 'mem_swap', '2008-04-14 10:25:03', '3911180')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (233, 'mem_buffers', '2008-04-14 10:25:03', '1920616')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (232, '', '2008-04-14 10:25:03', '1min:0.01 5min:0.08 10min:0.09')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (229, 'traffic_out', '2008-04-14 10:25:03', '3702839962')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (229, 'traffic_in', '2008-04-14 10:25:03', '1689494476')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (228, 'traffic_out', '2008-04-14 10:25:03', '4196200639')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (228, 'traffic_in', '2008-04-14 10:25:03', '4133183865')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (227, 'traffic_out', '2008-04-14 10:25:03', '114348829')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (227, 'traffic_in', '2008-04-14 10:25:03', '2615892602')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (226, 'proc', '2008-04-14 10:25:03', '110')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (225, 'mem_free', '2008-04-14 10:25:03', '536040')'
04/14/2008 10:25:03 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (224, 'mem_cache', '2008-04-14 10:25:03', 'U')' 

I can take these SQL statements and manually run them and they execute fine, so I'm not sure where the breakdown is. Anyone have any ideas on where to look to fix this?

[rony]

That is a sign that you have 2 pollers running. Make sure that you don't have to separate crontabs executing the poller.

[slithy]

That is a sign that you have 2 pollers running. Make sure that you don't have to separate crontabs executing the poller.

Yep this was the case. Had an entry in /etc/crontab, as well as a cacti script in /etc/cron.d/

I removed the one in /etc/cron.d and all is well, thanks!