Bug 720143 - Cannot create alertdefs with certain mysql plugin metrics or use the monitor template for certain mysql server metrics
Summary: Cannot create alertdefs with certain mysql plugin metrics or use the monitor ...
Keywords:
Status: NEW
Alias: None
Product: RHQ Project
Classification: Other
Component: Core UI
Version: 4.0.1
Hardware: All
OS: Linux
medium
unspecified
Target Milestone: ---
: ---
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-07-10 08:09 UTC by Robert Keng
Modified: 2022-03-31 04:27 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed:
Embargoed:


Attachments (Terms of Use)

Description Robert Keng 2011-07-10 08:09:42 UTC
Description of problem: Can't find certain metrics when trying to create alertdefs for the mysql server plugin. Possibly related problem, but you can't enable or set collection time for certain metrics of the mysql server plugin from administration/templates because it only returns 200 metrics (400+ for mysql). Oracle server plugin has the same problem (300+ for oracle). However if you use the "scheduling" submenu under monitoring tab from the mysql server resource itself, you can enable/set collection interval for ALL of the metrics.


Version-Release number of selected component (if applicable): 4.0.1


How reproducible:


Steps to Reproduce:
1. From the scheduling submenu under monitoring tab of any mysql server resource, find and enable Innodb_os_log_written per minute metric. You cannot do this from the administration/templates as it only returns 200 rows and there are no paginate ability
2. create an alertdef via the mysql server resource or from administration/templates
3. when setting condition, select measurement absolute value threshold as type
4. try and find the Innodb_os_log_written per minute metric from the comparator drop down list. Don't mistakenly pick Innodb_log_writes per minute metrics. Notice how everything is unsorted...yeah makes it very painful.
  
Actual results: can't find innodb_os_log_written per minute metric, and cannot enable/set collection interval from administration/templates for a good percentage of metrics because it doesn't return more than 200 results and there are no paginate options


Expected results: ability to define alerts for all metrics, and enable/set collection intervals for all metrics


Additional info:

Comment 1 Robert Keng 2011-07-10 08:13:10 UTC
Is it possible to define alertdefs for metrics I need or set monitor template by using rhq-cli (hehe example would be nice, or some pointers would also do)? Or is there any other workaround, or is this fixed in head? This severely impairs the use of plugins with high number of metrics.


Note You need to log in before you can comment on or make changes to this bug.