[LOG] Erreur - A DB Exec Failed!, Error:'1062'

[GarsDuCalvados]

Hello,

I'm sorry my english is very bad.

I've a Cacti Server in 0.87i version. I've install this version with "YUM COMMAND".
In my log /var/www/cacti/log/cacti.log, i've these lines :

Code: Select all

03/27/2012 05:30:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (171, 'traffic_out', '2012-03-27 17:30:09', '2739587528')'
03/27/2012 05:30:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (170, 'traffic_out', '2012-03-27 17:30:09', '300821017')'
03/27/2012 05:30:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (186, 'traffic_out', '2012-03-27 17:30:09', '3270860396')'
03/27/2012 05:30:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (185, 'traffic_out', '2012-03-27 17:30:09', '9629778')'
03/27/2012 05:30:09 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (162, 'traffic_out', '2012-03-27 17:30:09', '3538240961')'

How i can resolv this error.

Thanks for your help.

Cordially,
.Matt

[GarsDuCalvados]

Hello,

Someone ca help me?

Thanks,

.Matt

[gandalf]

Please see 2nd link of my sig, escpecially the double poller issue
R.

[GarsDuCalvados]

Hello,

I don't understand what i do?

Can you explain to me please?

Thanks you,

.Matt

[gandalf]

Log into the forums
find the 2nd link of my sig underneath each of my posts, select that
read the document carefully
find the chapter that talks about two pollers running in parallel; see, if that applies to your case
apply the required changes, then.
If that does not help, please come back
R.

[GarsDuCalvados]

Hello

Thanks you, I have two poller in CRONTAB

.Matt

[quicky2g]

Bumping this topic again. I don't have double poller entries but still getting the same error.

Code: Select all

quicky2g@linux:/etc$ sudo grep -R cacti cron*
cron.d/cacti:* * * * * www-data php --define suhosin.memory_limit=512M /usr/share/cacti/site/poller.php 2>&1 >/dev/null | if [ -f /usr/bin/ts ] ; then ts ; else tee ; fi
>> /var/log/cacti/poller-error.log

Tried the database fix from here but didn't work:

https://www.experts-exchange.com/questi ... phing.html

Any ideas?

[Osiris]

The previous post is accurate. Check your con log.