bug : reload of hobbitlaunch.cfg on trunk 🔗 link

Hello,

I defined several jobs in hobbitlaunch.cfg, all DISABLED.
I fired up hobbit, and then started enabling those jobs one by one.

I do see in hobbitlaunch.log a "Loading tasklist configuration from ..." 
a couple seconds after saving the new version of hobbitlaunch.cfg

But the job never starts.

And even stranger : enabling/disabling an ENABLED job does  work normaly.

Right now, i working arround this, by doing a stop/start of hobbit.


Olivier Beau

Hi all,

  I have set up a 'mysql' status check as an external script:
~hobbit/client/ext/bb-mysqlstatus.sh

It sends up several informational lines (see below), only some of which
I want to graph.  

I only want to graph "Threads", "Slow queries", and "Open Tables". 

If I only send up the 3 lines I want to graph, everything works as
desired.  However, if I add more lines, the graph stops working.  I'm
guessing that I need to add something somewhere to tell RRD to ignore
the lines I don't want to graph... but where/how?

mysqlstatus.sh sends the following (and shows on the 'mysql' column
page):

	Uptime             : 2 
	Threads            : 4 
	Questions          : 6 
	Slow queries       : 9 
	Opens              : 2 
	Flush tables       : 6 
	Open tables        : 9 
	Queries/second avg : 8


I modified hobbitserver.cfg and 

added "mySQL=ncv" to the end of the 
TEST2RRD="cpu=la,...,lines,mysql=ncv"

added the line:
NCV_mysql="Threads:GAUGE,Slowqueries:GAUGE,Opentables:GAUGE"


I also added the following to hobbitgraph.cfg

[mysql]
   TITLE MySQL Statistics
   YAXIS Number of
   DEF:threads=mysql.rrd:Threads:AVERAGE
   DEF:slow=mysql.rrd:Slowqueries:AVERAGE
   DEF:opentables=mysql.rrd:Opentables:AVERAGE
   LINE2:threads#FF0000:Threads
   LINE2:slow#00CCCC:Slow Queries
   LINE2:opentables#FF00FF:Opentables
   COMMENT:\n
   GPRINT:threads:LAST:Threads     \: %5.1lf (cur)
   GPRINT:threads:MAX: \: %5.1lf (max)
   GPRINT:threads:MIN: \: %5.1lf (min)
   GPRINT:threads:AVERAGE: \: %5.1lf (avg)\n
   GPRINT:slow:LAST:SlowQueries \: %5.1lf (cur)
   GPRINT:slow:MAX: \: %5.1lf (max)
   GPRINT:slow:MIN: \: %5.1lf (min)
   GPRINT:slow:AVERAGE: \: %5.1lf (avg)\n
   GPRINT:opentables:LAST:OpenTables  \: %5.1lf (cur)
   GPRINT:opentables:MAX: \: %5.1lf (max)
   GPRINT:opentables:MIN: \: %5.1lf (min)
   GPRINT:opentables:AVERAGE: \: %5.1lf (avg)\n


Googling around didn't produce any useful results; can someone shed some
light? 

Thanks
Tom


Tom Brand
CVS/pharmacy
IS Rx SysAdmin Store Support

STATEMENT OF CONFIDENTIALITY Information contained in this electronic
message and any attachments to this message are intended for the
exclusive use of the addressee(s) and may contain confidential or
privileged information.  If you are not the intended recipient, please
destroy all copies of this message and any attachments and advise sender
(user-10a840458972@xymon.invalid)

On Friday 12 December 2008, Brand, Thomas R. wrote:

If an rrd is created, the number of counters is fixed.  So, if you initally used 3 counters, the rrd is for these 3 counters.  If you later send on a status message with 5 counters, the rrd will not be updated because it does not match.
I have a script to add a DS to an existing rrd.  An other option is throw away the existing rrd.

So, never change the number of counters in a rrd.  Or the name of the counters.


Stef

Thanks for the info Stef.  I've figured out a few more things too....

Turns out a lot of my problems were caused by three reasons:

1) as you state, I had to remove the existing mysql.rrd file

2) one of the NCV records contained a '%' in the name... 
eg: 'Buffer Pool %' which caused nothing to be graphed; the values in
the rrd file (as shown by rrdtool dump mySQL.rrd were 'NAN'

3) I also found out that one must mention ALL the named values being
sent up by the client, in hobbitserver.cfg.  If the value is not to be
graphed, one can use the flag "NONE"

example:
NCV_mysql="Threads:GAUGE,SlowQueries:GAUGE,OpenTables:GAUGE,FlushTables:
NONE,Questions:NONE,Opens:NONE,AvgQuerysPerSecond:NONE"

I now have three values graphed and the rest are only displayed in the
text area -- not graphed.

Which is what I was looking for :)


Thanks for the help,
Tom