Bug #46899 Slow Query Log Not Enabled rule missing value tag in thresholdList

Submitted: 24 Aug 2009 17:54 Modified: 21 Sep 2009 10:27
Reporter: Andy Bang Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Advisors/Rules Severity:S3 (Non-critical)
Version:2.1.0.1093 OS:Any
Assigned to: Andy Bang CPU Architecture:Any

[24 Aug 2009 17:54] Andy Bang
Description:
The "Slow Query Log Not Enabled" rule is missing a <value> tag in the <thresholdList>.  This is causing a stack trace for some people when the Service Manager is started.

How to repeat:
1) Start the Service Manager
2) Look for stack trace in the tomcat console
[24 Aug 2009 18:45] Enterprise Tools JIRA Robot
Andy Bang writes: 
Pushed up to revision 304.
[24 Aug 2009 22:45] Enterprise Tools JIRA Robot
Keith Russell writes: 
Patch installed in versions => 2.1.0.1096.
[26 Aug 2009 9:01] Enterprise Tools JIRA Robot
Eric Herman writes: 
the stack-trace was an ArrayIndexOutOfBoundsException and can be seen at the following secure-pastebin:

https://intranet.mysql.com/secure/paste/displaypaste.php?codeid=8717

With the change from "category" to "tags", our sanity-check code was not previously allowing for the possiblilty that a "bad" rule could mean a rule not only with no tag[0] being an empty string, but potentially with no tags defined at all.

A test and a fix has been pushed to trunk for this situation, which results in a slightly more clear exception here:

https://intranet.mysql.com/secure/paste/displaypaste.php?codeid=8754

The root cause seems to be a 2.2 server getting a 2.1 advisors.
[21 Sep 2009 10:27] Tony Bedford
An entry was added to the 2.1.0 changelog:

The “Slow Query Log Not Enabled” rule was missing a <value> tag in the <thresholdList> block. This caused a stack trace to be generated when the Service Manager started.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.