no new graph

[Fandz]

Hello all,

i have a problem.
i create a new graph, and cacti don't generate pics graph.

when i go to Graph Management / mygraph and i launch debug i have a error message

Code: Select all

 RRDTool Command:

/usr/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="F-6500-NATIVE-A2BIS - Traffic - Fa8/9" \
--rigid \
--base=1000 \
--height=120 \
--width=500 \
--alt-autoscale-max \
--lower-limit=0 \
--vertical-label="bits per second" \
--slope-mode \
DEF:a="/fscacti/product/cacti/rra/f6500nativea2bis_traffic_in_2293.rrd":traffic_in:AVERAGE \
DEF:b="/fscacti/product/cacti/rra/f6500nativea2bis_traffic_in_2293.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" 

RRDTool Says:

ERROR: opening '/fscacti/product/cacti/rra/f6500nativea2bis_traffic_in_2293.rrd': No such file or directory

i have permission to write in rra directory (i create a empty file who name f6500nativea2bis_traffic_in_2293.rrd but it don't resolve my problem)

have you got an idea for my problem

thks

[gandalf]

Cacti first tries to test availabiility of that device. If this test fails, rrd files will enver be generated. So please see second link of my sig for debugging
Reinhard

[Fandz]

my device is ok because i have another graph in the same device. And the another graph work

[Fandz]

when i tape the command

Code: Select all

./cactid --verbosity=5 7 7

i see snmp request and return correct value

CACTID: Host[7] DS[2293] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.43, value: 3733858550
CACTID: Host[7] DS[2294] SNMP: v2: x.x.x.x, dsname: traffic_in, oid: .1.3.6.1.2.1.2.2.1.10.44, value: 1132977388

[Fandz]

when i launch manualy poller.php i have this log

Code: Select all

04/04/2008 02:38:41 PM - POLLER: Poller[0] Maximum runtime of 292 seconds exceeded. Exiting.
04/04/2008 02:38:41 PM - SYSTEM STATS: Time:292.3210 Method:cactid Processes:2 Threads:1 Hosts:154 HostsPerProcess:77 DataSources:2554 RRDsProcessed:217
PHP Warning:  pclose(): 59 is not a valid stream resource in /fscacti/product/cacti/lib/rrd.php on line 47

Warning: pclose(): 59 is not a valid stream resource in /fscacti/product/cacti/lib/rrd.php on line 47

[gandalf]

This is which version of cacti/cactid? At best 086k! What about upgrading?
Reinhard

[Fandz]

i think i found the reason.

poller.php execute this request

Code: Select all

select          poller_output.output,
                poller_output.time,
                poller_output.local_data_id,
                poller_item.rrd_path,
                poller_item.rrd_name,
                poller_item.rrd_num
                from (poller_output,poller_item)
                where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name)

and this request contains 6.671.458 rows in set (9 min 33.84 sec)

do you know if it's normal that this table is so big and how can i solve my problem (what's use this table?)

[gandalf]

This is a known problem. Plese see second link of my sig. Solved with 087b. Workarounds available (see: sig)
Reinhard