Graphs Missing Data periodically (Gaps in Graphs)

BadKarma · Post by **BadKarma** » Wed Sep 15, 2004 4:23 pm

Hi,

Im running RedHat 9, net-snmp 5.1.2 and php 4.3.8.

Regards,

BadKarma

ottob · Post by **ottob** » Thu Sep 16, 2004 2:58 am

Hi all,

i got the same problem: i have gaps on some graphs (about 2% of all) and i cannot find any connection between them (it is not a host problem)

When i use cmd.php everything works fine, if i use cactid from the rpm i got these gaps...

My System:

RH9,
net-snmp-5.0.9-2.90.1
php php-4.3.5

Guest · Post by **Guest** » Sun Sep 19, 2004 5:44 am

ottob wrote:Hi all,

i got the same problem: i have gaps on some graphs (about 2% of all) and i cannot find any connection between them (it is not a host problem)

When i use cmd.php everything works fine, if i use cactid from the rpm i got these gaps...

My System:

RH9,
net-snmp-5.0.9-2.90.1
php php-4.3.5

using a similar setup here... i noticed that in the last 30 minutes i've started to receive gaps in my graphs... i also notice that my MYSQL server reached "maximum connections" at the same time.

i believe it must have something to do with MYSQL, because as soon as i increased "max_connections" in my.cnf and restarted MYSQL, the graphs started working again.

obviously i'm using RRD files to store the data, but i'm assuming its doing something with the data in the RRD files with MYSQL...

fyi.

Harry

Post by **TheWitness** » Sun Sep 19, 2004 2:49 pm

Harry,

Are you running the pre-release of 0.8.6a? Also, it would appear that there may be a script hanging your system. You may have multiple zombie processes killing your MySQL database.

If you are running *nix, try the ps -ef | grep "cacti", "php", "perl", etc... and see if I am correct. I worked with a user who was polling weather bug last week with the same problem. His weather bug script was hung and killed his system. Your's is likley not the same issue, but you should check.

TheWitness

BadKarma · Post by **BadKarma** » Mon Sep 20, 2004 5:11 am

Hi,

I just upgraded to the pre release of 0.8.6a at the site where i'm having these gap issues however the pre-release still doesnt seem to fix the problems i'm having with graph gaps.
Here is a little piece of my cacti.log (the total log is to large to post here)

09/20/2004 11:46:07 AM - CACTID: Poller[0] DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (8967,'5min_cpu',NOW(),'7')
09/20/2004 11:46:07 AM - CACTID: Poller[0] Host[205] SNMP: v2: ext-nob-02.net.nob.nl, dsname: 5min_cpu, oid: .1.3.6.1.4.1.9.9.109.1.1.1.1.5.1, value: 7

09/20/2004 11:46:08 AM - POLLER: Poller[0] CACTI2RRD: /usr/local/rrdtool/bin/rrdtool update /usr/local/cacti/rra/extnob02_5min_cpu_8967.rrd --template 5min_cpu 1095673567:7
09/20/2004 11:46:08 AM - CMDPHP: Poller[0] RRD2CACTI:

As far as i understand the logging here tells me that the value '7' is inserted into the rrd. When however i'm viewing this graph, the data in the graph doesnt seem te be updated.
I've attached the graph to my posting to make things a bit clearer.

Regards,

BadKarma

Post by **TheWitness** » Mon Sep 20, 2004 5:47 am

looks like RRDTool is crashing. Could you please state your RRDTool version and OS version. Also, did you make RRDTool or download RPM?

TheWitness

BadKarma · Post by **BadKarma** » Mon Sep 20, 2004 6:08 am

Hi,

Im making use of rrdtool 1.0.45.
I made the rrdtool did not use rpm.
I havn't seen this problem when running the 0.8.5a release and did not touch rrdtool during the upgrade to 0.8.6.

BadKarma

Post by **TheWitness** » Mon Sep 20, 2004 6:09 am

We changed the default behavior of cacti with respect to RRD processing. Could you please update to 1.0.48. Thanks.

TheWitness

Guest · Post by **Guest** » Mon Sep 20, 2004 6:27 am

Hi,

I just updated my rrdtool to 1.0.48 but unfortunatly am still having the same issues.

BadKarma

JoeNetwork · Post by **JoeNetwork** » Mon Sep 20, 2004 9:15 am

hmm, I'm still on RRD v1.0.46 with no issues and I know v1.0.49 is out.

1) Should I upgrade?
2) If so, is there a reason to not go to v1.0.49?

Post by **TheWitness** » Mon Sep 20, 2004 10:32 am

Try 1.0.48 before going to 1.0.49. I have had great success (in Windows) with 1.0.48. Others are having the exact problem you are having.

TheWitness

Post by **TheWitness** » Mon Sep 20, 2004 10:33 am

There may also be a logic problem with the RRD_Execute function. I am going to make some changes this evening (late) to start utilizing the "Select" statement to await output on the pipes prior to reading. This may have something to do with the problem.

TheWitness

Guest · Post by **Guest** » Mon Sep 20, 2004 10:55 am

TheWitness wrote:BadKarma,

What is your OS? Please post a response.

Thanks,

TheWitness

Having the same problem here,

OS is gentoo,

RRDtool 1.0.42
PHP 4.3.8
mysql Ver 12.22 Distrib 4.0.20

Currently updating rrdtool to 1.0.47 but thats going to take a an hour or so (it's updating gcc as well :/ ).

I've also switched logging to debug.

leeg · Post by **leeg** » Mon Sep 20, 2004 2:05 pm

Same issue.
Cacti 0.8.6
RH9
RRDTool 1.0.49
PHP 4.3.8

I've noticed in the debug-level log that the SNMP and script results look ok. In fact, there are two lines for each "rrdtool -update". For a data source which has problems, I can cut & paste the update command line and it works. So, I think that Cacti is retrieving the data but for some reason isn't updating some RRDs.

Post by **TheWitness** » Mon Sep 20, 2004 7:10 pm

leeg,

I have made a change to the CVS tonight to correct this problem. Please download the latest pre-release on Tuesday, September 21st. It should be available in the early AM EDT (GMT -4).

TheWitness

Graphs Missing Data periodically (Gaps in Graphs)

Who is online