cacti graph gap

[jumpax_2005]

Hi,

i'm encountering a 20 minutes gap on our graphs daily on the snmp based devices. need assistance whether some of you encounter this and found any workaround.

below is the current version of our cacti.

Version: 0.8.7e
Plugin Architecture
Version: 2.6

thanks

[gandalf]

When running a tcpdump, does the snmp request exist? And the response is received?
R.

[jumpax_2005]

hi gandalf,

sorry to ask, but can you lead me on how to do it? quite new to this thing.

thanks

[gandalf]

Oh, that's beyond my capabilities; this is not done in 5 minutes.
Then, please see the log around the times, were the gaps occur and tell us your findings
R.

[jumpax_2005]

Hi Gandalf,

as i notice on the logs, gaps happens around 3:00-3:20AM and 12:00-12:20PM and the error i think might be related are the following:

10/27/2010 3:00 SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine thread)
10/27/2010 3:25 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 3:30 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 3:35 SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine thread)
10/27/2010 3:45 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 3:50 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:05 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:10 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:15 SPINE: Poller[0] FATAL: Spine Encountered a Segmentation Fault (Spine thread)
10/27/2010 12:20 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:25 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:30 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:45 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:50 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010
10/27/2010 12:55 SPINE: Poller[0] ERROR: A database insert failed! Error:'1062', SQL Fragment:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (7489,'hdd_used','2010

thanks

[gandalf]

This will happen, when the poller runs twice. In that case, updates with identical keys will occur. So please check all crontabs ...
R.