Bug 720143

Summary: Cannot create alertdefs with certain mysql plugin metrics or use the monitor template for certain mysql server metrics
Product: [Other] RHQ Project Reporter: Robert Keng <robert>
Component: Core UIAssignee: RHQ Project Maintainer <rhq-maint>
Status: NEW --- QA Contact: Mike Foley <mfoley>
Severity: unspecified Docs Contact:
Priority: medium    
Version: 4.0.1CC: hrupp
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Description Robert Keng 2011-07-10 04:09:42 EDT
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 04:13:10 EDT
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.