Gaps in graphs

[ghostmonk]

Hokay, I've got several hosts that I'm trying to get some consistent graphs for. I'm running a custom script from here:
http://www.askaboutphp.com/44/cacti-usi ... art-1.html

Most of the time I get good graphs. However, it's not uncommon to get gaps of varying lengths. I've cranked up the logging and received the following:

Code: Select all

01/12/2011 07:45:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (34, 'traffic_in', '2011-01-12 19:45:05', '4019044247')'
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[34] SNMP: v2: 92.52.79.64, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, output: 4019044247
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[34] SNMP: v2: 92.52.79.64, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.8, output: 31518630
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (33, 'traffic_out', '2011-01-12 19:45:05', '237791444')'
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[33] SNMP: v2: 92.52.79.64, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5, output: 237791444
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[34] SNMP: v2: 92.52.79.64, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.8, output: 4019044247
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into poller_output (local_data_id, rrd_name, time, output) values (33, 'traffic_in', '2011-01-12 19:45:05', '2155628320')'
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[33] SNMP: v2: 92.52.79.64, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5, output: 2155628320
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[33] SNMP: v2: 92.52.79.64, dsname: traffic_out, oid: .1.3.6.1.2.1.2.2.1.16.5, output: 237791444
01/12/2011 07:45:08 PM - CMDPHP: Poller[0] Host[4] DS[33] SNMP: v2: 92.52.79.64, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.5, output: 2155628320 

I've then entered the following command into MySQL with a successful result:

Code: Select all

insert into poller_output (local_data_id, rrd_name, time, output) values (33, 'traffic_out', '2011-01-12 19:45:05', '237791444')

I can see error 1062 is a duplicate entry error but I've checked crontab and I'm not double polling. I've run through the debugging guide and I can't find anything. I've got four hosts that I'm polling using this script and they all have gaps at exactly the same times.

Any ideas or help would be greatly appreciated.