Hi all
Any help appreciated here.
I was trying to create a custom graph of database tablespace utilization. I was getting some input from the clients, which my external script was eventually reducing to this. ---snip--- DS:siebprod.XDB:GAUGE:600:0:100 DS:siebprod.WHS_INDEX:GAUGE:600:0:100 DS:siebprod.WHS_DATA:GAUGE:600:0:100 DS:siebprod.USERS:GAUGE:600:0:100 DS:siebprod.UNDOTBS1:GAUGE:600:0:100 DS:siebprod.TOOLS:GAUGE:600:0:100 DS:siebprod.SYSTEM:GAUGE:600:0:100 DS:siebprod.SIEB_INDEX:GAUGE:600:0:100 DS:siebprod.SIEB_DATA:GAUGE:600:0:100 DS:siebprod.LOADER_DATA:GAUGE:600:0:100 tablespace.rrd 0:71:78:1:26:66:69:81:84:0 ---snip---
No worries so far, except no .rrd file was created. I checked the logs, and found ---snip--- 2005-05-06 11:36:30 RRD error creating /var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument 'DS:siebprod.XDB:GAUGE:600:0:100' ---snip--- It was getting stuck on the first row.
On a hunch, I changed the output from database.tablename to database_tablename, so my output looked like this. ---snip--- DS:siebprod_XDB:GAUGE:600:0:100 DS:siebprod_WHS_INDEX:GAUGE:600:0:100 DS:siebprod_WHS_DATA:GAUGE:600:0:100 DS:siebprod_USERS:GAUGE:600:0:100 DS:siebprod_UNDOTBS1:GAUGE:600:0:100 DS:siebprod_TOOLS:GAUGE:600:0:100 DS:siebprod_SYSTEM:GAUGE:600:0:100 DS:siebprod_SIEB_INDEX:GAUGE:600:0:100 DS:siebprod_SIEB_DATA:GAUGE:600:0:100 DS:siebprod_LOADER_DATA:GAUGE:600:0:100 tablespace.rrd 0:71:78:1:26:66:69:81:84:0 ---snip---
Still nothing in the .rrd file, but the logs now showed this.
---snip--- 2005-05-06 12:01:30 RRD error creating /var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument 'DS:siebprod_LOADER_DATA:GAUGE:600:0:100' ---snip---
The last line! I thought stuff-it, I can do without the last line, and took it out with a grep -v All of a sudden, I had my tablespace.rrd Woohoo!
I left it for an hour, and came back from lunch hoping to find a lovely graph. No dice.
All I get is a link to a graph, and the link gives me 4 (empty) links to the history graphs. No graphs appeared.
My hobbitgraph.cfg entry for this looks like this.
---snip--- [ora9-sga] FNPATTERN tablespace(.*).rrd TITLE TableSpace Utilization YAXIS % Full DEF:p at RRDIDX@=@RRDFN@:pct:AVERAGE LINE2:p at RRDIDX@#@COLOR@:@RRDPARAM@ -u 100 -l 0 GPRINT:p at RRDIDX@:LAST: \: %5.1lf (cur) GPRINT:p at RRDIDX@:MAX: \: %5.1lf (max) GPRINT:p at RRDIDX@:MIN: \: %5.1lf (min) GPRINT:p at RRDIDX@:AVERAGE: \: %5.1lf (avg)\n
---snip---
and the hobbitserver.cfg looks like this
---snip--- LARRDS="cpu=la,disk,inode,qtree,memory,ora9-sga,vmio,$PINGCOLUMN=tcp,htt p=tcp,dns=tcp,dig=tcp,time=ntpstat,vmstat,iostat,netstat,temperature,apa che,bind,sendmail,nmailq,socks,bea,iishealth,citrix,bbgen,bbtest,bbproxy ,hobbitd"
GRAPHS="la,disk,inode,qtree,memory,users,vmstat,iostat,tcp.http,tcp,nets tat,mrtg::1,temperature,ntpstat,apache,bind,sendmail,nmailq,socks,bea,ii shealth,citrix,bbgen,bbtest,bbproxy,hobbitd,ora9-sga,vmio" ---snip---
What am I missing?
Right now I will settle for any advice that will get the graphs to display. However I am curious about the "couldn't parse" logs. Any ideas?
Cheers Vernon
NOTICE: This message and any attachments are confidential and may contain copyright material of Australian Finance Group Limited or a third party. It is intended solely for the purpose of the addressee and any other named recipient. If you are not the intended recipient, any use, distribution, disclosure or copying of this message is strictly prohibited. The confidentiality attached to this message is not waived or lost by reason of the mistaken transmission or delivery to any unintended party. If you have received this message in error, please notify the author immediately or contact Australian Finance Group on +61 8 9420 7888.
On Fri, May 06, 2005 at 02:45:29PM +0800, Vernon Everett wrote:
/var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument 'DS:siebprod.XDB:GAUGE:600:0:100' [snip] /var/lib/hobbit/rrd/aufin2/tablespace.rrd: can't parse argument 'DS:siebprod_LOADER_DATA:GAUGE:600:0:100'
I'd advise anyone trying to do custom graphs to read the "rrdcreate" man-page from RRDtool. Here you'll find this:
A ds-name must be 1 to 19 characters long in the
characters [a-zA-Z0-9_].[no graphs show up]
My hobbitgraph.cfg entry for this looks like this.
---snip--- [ora9-sga] FNPATTERN tablespace(.*).rrd TITLE TableSpace Utilization YAXIS % Full DEF:p at RRDIDX@=@RRDFN@:pct:AVERAGE
The DEF: line here is wrong. The "pct" here is the name of the dataset you want to graph - the same string that you use in the "DS:" definition of the RRD file. So to get a graph of the siebprod_XDB data, you should have DEF:p at RRDIDX@=@RRDFN@:siebprod_XDB:AVERAGE LINE2:p at RRDIDX@#@COLOR@:@RRDPARAM@
If you want to graph more than one dataset in a single image, you just add more DEF and LINE entries - but make sure you keep a unique name for each of the DEF's you define. E.g.
DEF:whsidx at RRDIDX@=@RRDFN@:siebprod_WHS_INDEX:AVERAGE
DEF:whsdata at RRDIDX@=@RRDFN@:siebprod_WHS_DATA:AVERAGE
LINE2:whsidx at RRDIDX@#@COLOR@:@RRDPARAM@
LINE2:whsdata at RRDIDX@#@COLOR@:@RRDPARAM@But that is usually not a good idea when you are also combining multiple RRD files into one graph.
Regards, Henrik
participants (2)
-
henrik＠hswn.dk
-
v.everett＠afgonline.com.au