RRD files not updated in certain situations

[Aspirax]

But I'm not sure what the situations are yet. So let me lay this out and see if anyone can help.

Seems like just one of the data sources is not getting populated. This is working correctly with 0.8.6a.

I'm using 0.8.6d with cactid 0.8.6e.rc7 (also fails with 0.8.6d)

I have an RRD with 3 data sources. I use it for sent, received, and rejected email.

The following is debug output from cactid:

Code: Select all

CACTID: Host[94] SCRIPT: /var/www/cacti/scripts/getmail 192.168.70.10, output: ds0:49 ds1:39 ds2:58
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (333,'','2005-05-31 10:54:36','ds0:49 ds1:39 ds2:58')
CACTID: Host[94] DEBUG: The POPEN returned the following File Descriptor 11

Here are the graphs and how they are drawn:
/opt/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Postfix Mail" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
DEF:a="/var/www/cacti/rra/spam_filter_ds0_333.rrd":ds0:AVERAGE \
DEF:b="/var/www/cacti/rra/spam_filter_ds0_333.rrd":ds1:AVERAGE \
AREA:a#00CF00:"Sent\:" \
GPRINTLAST:" Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Max\:%8.0lf\n" \
LINE1:b#4444FF:"Received\:" \
GPRINTLAST:"Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Max\:%8.0lf\n"




/opt/rrdtool/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Rejected Messages" \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="" \
DEF:a="/var/www/cacti/rra/spam_filter_ds0_333.rrd":ds2:AVERAGE \
DEF:b="/var/www/cacti/rra/spam_filter_ds0_333.rrd":ds2:AVERAGE \
AREA:b#00CF00:"Rejected\:" \
GPRINTLAST:" Current\:%8.0lf" \
GPRINTAVERAGE:"Average\:%8.0lf" \
GPRINTMAX:"Maximum%8.0lf" \
LINE1:b#0000FF:""




As you can see, it's not anything fancy. Just two graphs from one RRD.
I have two instances of this happening. The other is one graph/one RRD. I'm happy to post the details of that one if it's deemed to be helpful.

[TheWitness]

You need to use the rrdtool dump command to evaluate what is actually being stored in the RRD. Alternately, you could use the RRDTool fetch or xport.

make sure that DS1 is being populated correctly. You may also be exceeding a MAX value for DS1. You really need to look at what is making it into the RRD file.

You can fetch error messages by manually running poller.php from a command line as well. Good luck!

TheWitness

[Aspirax]

Sorry for the late response. High priority work issues have kept me from this.

What's making it into the RRD file is 'NaN'. So, something (poller.php?) is not supplying it with the correct data.

And here's apparentely why:

06/06/2005 10:00:37 AM - POLLER: Poller[0] CACTI2RRD: /opt/rrdtool/bin/rrdtool update /var/www/cacti/rra/spam_filter_ds0_333.rrd --template ds1:ds2 1118066401:31:37
OK u:0.01 s:0.01 r:0.24


It's never trying to update ds0 here.
It's queried. but not updated.

What else can I supply to find out why? (or find a fix)

Thanks,

[BSOD2600]

The CACTI2RRD is the process which updates the rrd files. Please post the output from when cacti queried the ds0 source (or did that not happen at all?).

[Aspirax]

It's in my original post

[BSOD2600]

whoops, you're right.

hmm, for testing if you created another data source, using a new rrd file. Does it get properly updated?

[Aspirax]

Let me try. I'll get back.

[Aspirax]

The answer is:

CACTID: Host[94] SCRIPT: /var/www/cacti/scripts/getmail 192.168.70.10, output: ds0:35 ds1:35 ds2:55
CACTID: DEBUG: SQLCMD: insert into poller_output (local_data_id,rrd_name,time,output) values (366,'','2005-06-06 14:29:08','ds0:35 ds1:35 ds2:55')


06/06/2005 02:29:51 PM - POLLER: Poller[0] CACTI2RRD: /opt/rrdtool/bin/rrdtool update /var/www/cacti/rra/spam_filter_ds0_366.rrd --template ds1:ds2 1118082572:35:55

Cactid is polling, poller is not updating the right stuff.

[BSOD2600]

The data template does have the ds0 source, right?

Guess it's time for a dev to step in...

[Aspirax]

yep, sure does!

[TheWitness]

Thanks BSOD. Please edit the "Data Source" in question. From the Data Source, in the upper right hand corner, you will find "Data Source Debug". Press that button and post the resulting rrdtool create syntax. For some reason it appears as if the ds0 is being dropped off.

TheWitness

[Aspirax]

The ds0 is in the file. Here's the debug output:


/opt/rrdtool/bin/rrdtool create \
/var/www/cacti/rra/spam_filter_ds0_366.rrd \
--step 300 \
DS:ds0:GAUGE:600:0:3000 \
DS:ds1:GAUGE:600:0:3000 \
DS:ds2:GAUGE:600:0:3000 \
RRA:AVERAGE:0.5:1:600 \
RRA:AVERAGE:0.5:6:700 \
RRA:AVERAGE:0.5:24:775 \
RRA:AVERAGE:0.5:288:797 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

[TheWitness]

Would you be averse to an online conference to discuss this via AIM/MSM?

TheWitness

[Aspirax]

Not at all. I'll PM you Tuesday AM (EDT), and I'm regularly available.

[TheWitness]

That's going to be tough. I have a staff meeting at that time. I am typically available after hours only.

Larry