mysql_stats templates - replication template wont show graph

[markokobal]

Hi,

I have successfuly set up the mysql_stats templates, the only one problem is with the repliacation template.

See below - via the Cacti web page there is no grap - but if I go to graph debug and execute the rrdtool commad via commad line the graph is generated.

How is this possible???

[markokobal]

Hi,

So, nobody has any clue about this weird problem?

[gandalf]

Please post the whole rrdtool graph statement shown at Graph Management. Please note your current rrdtool version
Reinhard

[markokobal]

RRDTool Command:

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Corvus - MySQL - Replication - 3310" \
--base=1000 \
--height=150 \
--width=600 \
--alt-autoscale-max \
--lower-limit=1 \
--logarithmic \
--vertical-label="" \
--slope-mode \
DEF:a="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":ReadExecLogPosDiff:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":SecondsBehindMaster:AVERAGE \
DEF:c="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":BinlogCacheDiskUse:AVERAGE \
DEF:d="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":BinlogCacheUse:AVERAGE \
CDEF:cdefa=a,1024,/ \
CDEF:cdefd=c,1024,/ \
CDEF:cdefe=d,1024,/ \
AREA:cdefa#EAAF00:"LogPosLag(KB)" \
LINE1:cdefa#837C04:"" \
LINE2:b#F51D30:"Seconds Lag" \
LINE2:cdefd#4444FF:"Binlog Cache Disk(K)" \
LINE1:cdefe#35962B:"Binlog Cache Use(K)"

RRDTool Says:

---------

So RRDTool Says "nothing"

My OS: 6.2-RELEASE-p8
rrdtool: rrdtool-1.2.23
cacti: cacti-0.8.6j.3_2

(as I mentioned, other graphs - about 200 of them - are shown ok), just this one bugs me ...

[gandalf]

Please have a look at /var/log/httpd/error_log when graphing this one.
You're using a distro rpm? Please verify, that all patches have been applied: http://www.cacti.net/download_patches.php
Reinhard

[markokobal]

Hi,

I have looked at the error log and no errors are logged. The last error that was logged was the error of the favicon.ico "File does not exist" but this is irrelevant and I have fixed this days ago.

I'm using the FreeBSD port version of the cacti (http://www.freebsd.org/cgi/ports.cgi?qu ... &stype=all) and I guess it has all paches applied.

It's an really wierd problem ...

[gandalf]

Please select the broken graph. Now you will see 4 broken graphs, each of them accompanied by a wrench. Select the first one and post again the whole rrdtool graph statement
Reinhard

[markokobal]

"wrench" debug of the first of fourg graphs (Daily (5 Minute Average)):

/usr/local/bin/rrdtool graph - \
--imgformat=PNG \
--start=-86400 \
--end=-300 \
--title="Corvus - MySQL - Replication - 3310" \
--base=1000 \
--height=150 \
--width=600 \
--alt-autoscale-max \
--lower-limit=1 \
--logarithmic \
--vertical-label="" \
--slope-mode \
DEF:a="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":ReadExecLogPosDiff:AVERAGE \
DEF:b="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":SecondsBehindMaster:AVERAGE \
DEF:c="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":BinlogCacheDiskUse:AVERAGE \
DEF:d="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":BinlogCacheUse:AVERAGE \
CDEF:cdefa=a,1024,/ \
CDEF:cdefd=c,1024,/ \
CDEF:cdefe=d,1024,/ \
AREA:cdefa#EAAF00:"LogPosLag(KB)" \
LINE1:cdefa#837C04:"" \
LINE2:b#F51D30:"Seconds Lag" \
LINE2:cdefd#4444FF:"Binlog Cache Disk(K)" \
LINE1:cdefe#35962B:"Binlog Cache Use(K)"

[markokobal]

So, looks like this one remains unresolved?

[gandalf]

Will pm Larry. Can't get it myself
Reinhard

[TheWitness]

Login to the server and take that RRDtool syntax and paste it into a shell like this:

Code: Select all

rrdtool my_graph_syntax > myfile.png

Post the result of that command. I am suspecting a segmentation fault.

TheWitness

[markokobal]

#/usr/local/bin/rrdtool graph - \
> --imgformat=PNG \
> --start=-86400 \
> --end=-300 \
> --title="Corvus - MySQL - Replication - 3310" \
> --base=1000 \
> --height=150 \
> --width=600 \
> --alt-autoscale-max \
> --lower-limit=1 \
> --logarithmic \
> --vertical-label="" \
> --slope-mode \
> DEF:a="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":ReadExecLogPosDiff:AVERAGE \
> DEF:b="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":SecondsBehindMaster:AVERAGE \
> DEF:c="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":BinlogCacheDiskUse:AVERAGE \
> DEF:d="/usr/local/share/cacti/rra/corvus_readexeclogposdiff_233.rrd":BinlogCacheUse:AVERAGE \
> CDEF:cdefa=a,1024,/ \
> CDEF:cdefd=c,1024,/ \
> CDEF:cdefe=d,1024,/ \
> AREA:cdefa#EAAF00:"LogPosLag(KB)" \
> LINE1:cdefa#837C04:"" \
> LINE2:b#F51D30:"Seconds Lag" \
> LINE2:cdefd#4444FF:"Binlog Cache Disk(K)" \
> LINE1:cdefe#35962B:"Binlog Cache Use(K)" > /root/test.png
#

... no errors at all via shell command line! And like you can see below the graph is actualy created without problems. And the data in the .rrd files are also stored. Well, this is really wierd. Is there some special wrapper or something when cacti web application executes the commad above so that graph is not generated properly? Wierdy wierd...