new rrd files not created

[drewlander]

I recently created a new data input method. It is a script, that returns data in the right format.
In the logs, I see:

Code: Select all

12/31/2008 03:30:03 PM - SPINE: Poller[0] Host[66] DS[975] SCRIPT: /var/www/html/cacti/scripts/s-master2.test.sh vip.s-master2.s-master.sat.mlsrvr.com, output: getQueryCount=3600:0 getAverageQueryTime=3600:0 getSlowestQueryTime=3600:0
12/31/2008 03:30:03 PM - SPINE: Poller[0] DEBUG: SQL:'INSERT INTO poller_output (local_data_id, rrd_name, time, output) VALUES (975,'','2008-12-31 15:30:02','getQueryCount=3600:0 getAverageQueryTime=3600:0 getSlowestQueryTime=3600:0')'

so i know cacti is getting the data

The Data Source Debug shows:

Code: Select all

/usr/bin/rrdtool create \
/var/www/html/cacti/rra/s-master2_querycount_975.rrd \
--step 300  \
DS:querycount:GAUGE:600:0:1000000000 \
DS:averagequerytime:GAUGE:600:0:1000000000 \
DS:slowestquerytime:GAUGE:600:0:1000000000 \
RRA:AVERAGE:0.5:1:500 \
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:500 \
RRA:MAX:0.5:1:600 \
RRA:MAX:0.5:6:700 \
RRA:MAX:0.5:24:775 \
RRA:MAX:0.5:288:797 \

No errors.
However, I never see any rrd file created.
The ONLY difference I see between this and other data sources is that the poller interval is 5 minutes, while the rest of them are 30 seconds. Could that be causing a problem?

I have attached the technical support output.

What is the best way to start troubleshooting?

[drewlander]

I have narrowed it down more, it seems as though cacti is not creating the new rrd file for this template. Even if I were to create it the way the Data Source Debug says, it does not insert any data into it.
Permissions are correct on /rra
it is able to update the other rrd files just fine.
The device is up
I have searched as much as I can, and nothing seems to have a fix for me.
Any ideas?

[drewlander]

I think I have found the problem:
I get a poller output table not empty, and the data source it says is the problem, is the one that I have been having the problem with.
It never leaves the poller_output.

Code: Select all

+---------------+----------+---------------------+----------------------------------------------------------------------------------+
| local_data_id | rrd_name | time                | output                                                                           |
+---------------+----------+---------------------+----------------------------------------------------------------------------------+
|           978 |          | 2009-01-02 10:34:02 | getQueryCount=3600:2 getAverageQueryTime=3600:1301 getSlowestQueryTime=3600:2524 |
+---------------+----------+---------------------+----------------------------------------------------------------------------------+

Code: Select all

01/02/2009 10:35:02 AM - POLLER: Poller[0] WARNING: Poller Output Table not Empty. Potential Data Source Issues for Data Sources: (DS[978]) 

I have searched and searched and cannot find a fix for me still. It still will not create the rrd file or put any data in when I manually create the rrd file.
Is there a step inbetween I am not seeing?

[gandalf]

The output of the script looks very weird to me. What's the ":" for?
Reinhard

[drewlander]

The : are for the output.
So, this script was written by one of our developers to get stats from one of our java programs.
i did not think having an equals sign would matter, since I did not change the defualt ":".
So basically, when i run the script it will output:

Code: Select all

getQueryCount=3600:2 getAverageQueryTime=3600:2276 getSlowestQueryTime=3600:3195

I should be getting 2,2276 and 3915.
So for my data input methods I am using:
getAverageQueryTime=3600
getQueryCount=3600
getSlowestQueryTime=3600

as far as I can tell, cacti is getting the values correctly

Code: Select all

01/02/2009 12:37:03 PM - SPINE: Poller[0] Host[66] DS[979] SCRIPT: /var/www/html/cacti/scripts/s-master2.test.sh vip.s-master2.s-master.sat.mlsrvr.com, output: getQueryCount=3600:2 getAverageQueryTime=3600:2276 getSlowestQueryTime=3600:3195

I have not tried without the equals since I did not think it would be an issue, would it?

[drewlander]

It does not like the equals sign.
Thanks for your help!
Problem solved