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.