Some issues with Poller[0] ERROR: SQL Exec Failed

[jtsa]

Hello ppl

I've got my cacti 0.8.6j up and running under Suse 10


Everything is perfect but I keep getting errors on cacti.log

04/12/2007 10:30:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (416, '5min_cpu', '2007-04-12 10:30:19', '26')"
04/12/2007 10:30:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (417, 'traffic_in', '2007-04-12 10:30:19', '3690438662')"
04/12/2007 10:30:19 AM - CMDPHP: Poller[0] ERROR: SQL Exec Failed "insert into poller_output (local_data_id, rrd_name, time, output) values (417, 'traffic_out', '2007-04-12 10:30:19', '1187029562')"
nagios1-rj:/local/cacti/cacti-0.8.6h/log # mysql -u root -p cacti
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30180 to server version: 5.0.18-Max

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

mysql> insert into poller_output (local_data_id, rrd_name, time, output) values (417, 'traffic_out', '2007-04-12 10:30:19', '1187029562');
ERROR 1062 (23000): Duplicate entry '417-traffic_out-2007-04-12 10:30:19' for key 1
mysql> insert into poller_output (local_data_id, rrd_name, time, output) values (413, 'traffic_out', '2007-04-12 10:30:19', '1799875353');
ERROR 1062 (23000): Duplicate entry '413-traffic_out-2007-04-12 10:30:19' for key 1
mysql> insert into poller_output (local_data_id, rrd_name, time, output) values (665, 'traffic_in', '2007-04-12 10:15:41', '1921447265');
Query OK, 1 row affected (0.00 sec)

mysql> exit



I mean, I got an error, ok, some of the entries ARE duplicate, but some of them are not, because I can MANUALLY insert them on the cacti database

I've checked crontab and there is only one poller entry, over all the box's crontabs

Can someone give me a light?? I'm afraid it might just stop graphing one of these days....

Thanx!

[BSOD2600]

Do you have two cron jobs running cacti per chance? Typically duplicate entries are caused by either manually running the poller or multiple crontabs for cacti.

[jtsa]

no, just 1

this is the only line on my cacti user crontab
*/5 * * * * /usr/bin/php5 /local/cacti/cacti-0.8.6h/poller.php > /local/cacti/cacti-0.8.6h/log/poller.log 2>&1

the other crontab , root's has only one line to backup my box nagios's and cacti

[jtsa]

I think I got it there was a crontab file under /etc/ that was as follows

nagios1-rj:/etc # cat crontab
SHELL=/bin/sh
PATH=/usr/bin:/usr/sbin:/sbin:/bin:/usr/lib/news/bin
MAILTO=root
#
# check scripts in cron.hourly, cron.daily, cron.weekly, and cron.monthly
#
-*/15 * * * * root test -x /usr/lib/cron/run-crons && /usr/lib/cron/run-crons >/dev/null 2>&1
*/5 * * * * cacti php5 /local/cacti/cacti-0.8.6h/poller.php > /dev/null 2>&1



took out that last line, and I think the errors disappeared!