rrd's not getting created, not graphing if manually created.

[pwohlers]

I've got a new interface for which I need to graph the traffic.

Creating the graph seems to be fine:
"Created graph: router: sf-edge1 - Traffic - circID#.....'

but when I look at the Graph Managemt/<host>/interface with debug on, I see the following:

RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="router: sf-edge1 - Traffic - CircID#...." \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
DEF:a="/usr/share/cacti/rra/router_sfedge1_traffic_in_6298.rrd":traffic_in:AVERAGE \
DEF:b="/usr/share/cacti/rra/router_sfedge1_traffic_in_6298.rrd":traffic_out:AVERAGE \
CDEF:cdefa=a,8,* \
CDEF:cdefe=b,8,* \
AREA:cdefa#00CF00:"Inbound" \
GPRINT:cdefa:LAST:" Current\:%8.2lf %s" \
GPRINT:cdefa:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefa:MAX:"Maximum\:%8.2lf %s\n" \
LINE1:cdefe#002A97:"Outbound" \
GPRINT:cdefe:LAST:"Current\:%8.2lf %s" \
GPRINT:cdefe:AVERAGE:"Average\:%8.2lf %s" \
GPRINT:cdefe:MAX:"Maximum\:%8.2lf %s\n" \
COMMENT:"\n" \
HRULE:0#FF0000:"95th Percentile" \
COMMENT:"(0 mbit in+out)"

RRDTool Says:

ERROR: opening '/usr/share/cacti/rra/router_sfedge1_traffic_in_6298.rrd': No such file or directory

I've looked at the following thread:

Traffic RRD's Not Created: Duplicate Data Source Issue
http://forums.cacti.net/viewtopic.php?t=6773

but this doesn't seem to apply, as there aren't any duplicate data sources.

If I go to the data sources section and look at the interface in debug mode, I see:

Data Source Debug

/usr/bin/rrdtool create \
/usr/share/cacti/rra/router_sfedge1_traffic_in_6298.rrd \
--step 300 \
DS:traffic_out:COUNTER:600:0:1000000000 \
DS:traffic_in:COUNTER:600:0:1000000000 \
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:MIN:0.5:1:600 \
RRA:MIN:0.5:6:700 \
RRA:MIN:0.5:24:775 \
RRA:MIN: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 \
RRA:LAST:0.5:1:600 \
RRA:LAST:0.5:6:700 \
RRA:LAST:0.5:24:775 \
RRA:LAST:0.5:288:797 \

However the rrd file doesn't exist.
/usr/share/cacti/rra/router_sfedge1_traffic_in_6298.rrd

If I log in as the cacti user and run the above command, it will indeed create the rrd file, and I can the graph comes up, but with no data.

There are other interfaces that use the same template, that are graphing properly, so I'm pretty sure that's not the template, but I could be wrong.

deleting/re-creating these graphs/datasouces doesn't seem to change the behavior.

Any thoughts on how I can continue to troubleshoot this?

bones thrown are greatly appreciated

Thanks,
Peter

[gandalf]

It's surely not the duplicate ds issue.
I suppose, it's due to downed host detection. To verify, please post the device status found at the Device List
Reinhard

[pwohlers]

Description Status Hostname Current (ms) Average (ms) Availability
router: sf-edge1 Up 204.9.x.y 2.77 2.63 99.71%

Other interfaces on this same router have been graphing fine :-/

[gandalf]

Ok, missed.
Please see second link of my signature for more help
Reinhard

[pwohlers]

cool. Thanks.

So, manually creating the RRD is OK? and then just troubleshoot the Nan issue?

Or does manually creating the rrd file short-cut any other operations that the cacti-app has to do?

[gandalf]

If you make sure, that the rrd files have to correct ownership and permissions, all is fine
Reinhard

[pwohlers]

cool
thanks for the clarification.


/me delves back into docs and troubleshooting.

[pwohlers]

btw, it seems that the links in your signature are only visible when logged in...in fact, your .sig only appears in the body when logged in...

So, for those that aren't logged in/registered yet, this is the link in question:

http://docs.cacti.net/node/283

[pwohlers]

OK. finally some cycles to troubleshoot more.

I followed the doc and it's still not working. Maybe I'm missing something...

the results:

1) snmp is OK
2) Check basic Data Gathering:
results: This is OK. i.e. other identical graphs on same host, different interfaces work fine.

3) Cacti Poller, using cmd.php
The poller fires off for all the datasources for this host, except for the ds in question. i.e. no record of the poller firing for this rrd file.

I had manually created the rrd file and verified ownership/perms.

4) Since poller didn't fire...i dont' see the sql query to test.

5) rrd file manually created, yet no updates found.

6) rrd file ownership:

/* Files looked like this:
-rw-rw-r-- 1 cacti cacti 189016 Jun 4 09:36 router_sfedge1_traffic_in_6297.rrd
-rw-rw-r-- 1 cacti cacti 189016 Jun 13 09:40 router_sfedge1_traffic_in_6298.rrd

changed to:

-rw-r--r-- 1 cacti cacti 189016 Jun 4 09:36 router_sfedge1_traffic_in_6297.rrd
-rw-r--r-- 1 cacti cacti 189016 Jun 13 09:40 router_sfedge1_traffic_in_6298.rrd
*/


7) Check rrd file numbers

These all looked fine.

Graph statements
these were OK. (other interfaces on same device using same graph statements. It's mostly that the rrd file has null data.

9) php.ini's memory setting:
memory_limit = 2024M

10) poller logging only yielded this, where I've got the weathermap set up to report data from this rrd file.:

06/13/2007 02:17:00 PM - WEATHERMAP: Poller[0] ReadData: Link sf-edge1-att, target: /usr/share/cacti/rra/router_sfedge1_traffic_in_6
298.rrd on config line 315 had no valid data


Hopefully, there's a glaring pilot-error here that I'm not seeing, or have misinterpereted.

It seems like the source of the problem is how the poller doesn't seem to query the router, but I'm not quite sure how to remedy that.

Thanks,
Peter

[gandalf]

OK. finally some cycles to troubleshoot more.

I followed the doc and it's still not working. Maybe I'm missing something...

the results:

1) snmp is OK
2) Check basic Data Gathering:
results: This is OK. i.e. other identical graphs on same host, different interfaces work fine.

3) Cacti Poller, using cmd.php
The poller fires off for all the datasources for this host, except for the ds in question. i.e. no record of the poller firing for this rrd file.

I had manually created the rrd file and verified ownership/perms.

Ar ALL ds of this host corrupted or only THIS one?
Reinhard

[pwohlers]

Just this one :-/

I have cacti graphing interfaces on four of it's five interfaces.

This interface graphs/generates data for the errors/discards, but not bandwidth.

Thanks!

--Peter

[SQLParrot]

Greetings!

I had the same problem. In my case there was nothing wrong with cacti or rrdtool. What I discovered by fooling around was that the rra and log folders had to be chmod 770 for the directory and 660 for the files.

These folders are owned (as suggested in the documentation) by user cacti and cacti is also a member of the apache group -and apache of the cacti group. So this seemed a bit odd to me.

I just had a login open in ssh and was changing things while running the graph generator in debug mode. It kept coming up with that the file was permission denied.

What is strange to me, is that this worked fine about a week ago when I installed it -then, for some reason -stopped making graphs! It also would not create the rrd files either.

Suse Linux Enterprise 10
Apache 2.2.3
PhP 5.current
Pear.current
Mysql 5.x.current

etc.

[pwohlers]

hmmm...interesting.

Although none of my other graphs have problems...

Was that the situation in your case?

--Peter

[pc]

We are having what looks to be the same problem as 'pwohlers'. Traffic does not graph but other data from this device graphs fine. Interface-Traffic just doesn't create an rrd file but other data does create rrd's and graphs without any troubles.

There are at least a dozen separate threads dancing around this problem. It looks to be a fairly common problem but it is not getting solved. What is it that novice to intermediate Cacti users are doing wrong but the experts trying to help through this forum just don't see?!! The standard expert answer of "follow instructions after my sig" is not working. At least 6 different people in 6 different threads have tried....just as we have and as 'pwohlers' has.

The common issue is the following error:

Code: Select all

RRDTool Says:

ERROR: opening '/usr/share/cacti/rra/xxxxxx_yyyyyy_traffic_in_zzzz.rrd': No such file or directory 

Poller is polling (other graphs are updating)
Permissions (rra and log are 777 -- and other rra's are getting created)
Not duplicate DS / NaN issue
Not downed host detection (other graphs on this host are updating)
and YES we have ALL waited 5 minutes for next pole (5 hours and 5 days in many cases!)

And lastly, this Traffic template works and rrd files for it do exist for other hosts. We just can't create any NEW traffic graphs.

Can someone PLEASE take a NEW look at this problem and not just reply with the same solutions?

Great tool for the hosts and data types that work but something has broken and it is not getting fixed.

Thanks.

[pc]

Bump?

Can anyone suggest where we should go from here?

Thanks.

PC