Thank you for helpful explanation, after I removed FNPATTERN and replaced @RRDFN@ with mysql.rrd - the graph appeared for the second machine too.
And no, I neither have other mysql*.rrd file in the /var/lib/hobbit/rrd/HOSTNAME/ directory, nor any of the existing ones had keys starting with "mysql" string.
-- Arie
On Mon, Nov 29, 2010 at 23:54, Henrik Størner <henrik at hswn.dk> wrote:
On Sun, 28 Nov 2010 16:30:39 +0200, Arie Skliarouk wrote:
On Thu, Nov 25, 2010 at 17:59, Henrik Størner <henrik at hswn.dk> wrote:
On Wed, 24 Nov 2010 16:12:07 +0200, Arie Skliarouk wrote:
I created a custom mysql parameters check that shows graphs on one server, but not on the other. hobbitgraph.sh (hobbitgraph.cgi?) kept sending following error instead of the actual image: <html><head><title>Invalid request</title></head> <body>Attempting to reuse 'mysqlht'</body></html>
This is an error from the rrdtool library. So I would suspect something dodgy with the graph-definition in hobbit-graphs.cfg, or the RRD file data is not as you would expect.
Could you show us the graph definition you use ?
See attached.
OK, the interesting part of your graph definition looks like this:
[mysql] FNPATTERN mysql.rrd TITLE MySQL YAXIS Number DEF:mysqlht=@RRDFN@:mysqlht:AVERAGE DEF:mysqlhs=@RRDFN@:mysqlhs:AVERAGE DEF:mysqlhq=@RRDFN@:mysqlhq:AVERAGE LINE2:mysqlht#00CCCC:MySQL threads LINE2:mysqlhs#ff0000:Slow queries LINE2:mysqlhq#ff00ff:Queries per sec
The problem occurs because you're using an FNPATTERN definition, but you only expect one file to match. I'll bet that the problem host has another RRD file present which matches "mysql.rrd" - there is no anchor in the pattern, so a file "blablamysql.rrd" will also match this pattern. Or even "mysql.rrd.old".
When you have multiple files that match FNPATTERN, the rest of the definition is repeated for each file when Xymon tells RRDtool how to generate the graph. So you'll end up with two DEF lines that define a "mysqlht" variable - one for each file that matches FNPATTERN. That is not allowed, and causes RRDtool to complain with the error you see.
If you only want to use one specific RRD file, don't use FNPATTERN. Instead, put the filename where you have "@RRDFN@" now:
[mysql] TITLE MySQL YAXIS Number DEF:mysqlht=mysql.rrd:mysqlht:AVERAGE DEF:mysqlhs=mysql.rrd:mysqlhs:AVERAGE DEF:mysqlhq=mysql.rrd:mysqlhq:AVERAGE LINE2:mysqlht#00CCCC:MySQL threads LINE2:mysqlhs#ff0000:Slow queries LINE2:mysqlhq#ff00ff:Queries per sec
Just for the record, if you DO want to match multiple files, then you must include the index-number in the DEF and GPRINT definition. E.g.
[mysql] FNPATTERN mysql.rrd TITLE MySQL YAXIS Number DEF:mysqlht at RRDIDX@=@RRDFN@:mysqlht:AVERAGE DEF:mysqlhs at RRDIDX@=@RRDFN@:mysqlhs:AVERAGE DEF:mysqlhq at RRDIDX@=@RRDFN@:mysqlhq:AVERAGE LINE2:mysqlht at RRDIDX@#@COLOR@:@RRDPARAM@ MySQL threads
See e.g. the [la] and [disk] definitions in the standard graphs.cfg / hobbitgraph.cfg file.
Regards, Henrik
To unsubscribe from the xymon list, send an e-mail to xymon-unsubscribe at xymon.com