If you create your recovery rules at the resource-level (alert definition) they should work in Jopr 2.2
There was a recently discovered bug if you were creating recovery rules at the resource type-level (alert templates). That was documented, with a workaround, here -- http://jira.rhq-project.org/browse/RHQ-2150
I only have access to jopr right now. So the only way i can get the recovery alerts working is if I create them at the alert definition level? what if I create an alert template for availability going down but then create seperate alert defintions under each jboss application server, will that work?
What you propose should work. By the way, are you familiar with the /admin/test pages?
no whats that
If you have administrator access to Jopr, then log in as the administrator and go to /admin/test/sql.jsp - it gives you full SQL access to the backing data store, which will allow you to run the query mentioned in RHQ-2150 if you want to use the workaround for alert templates.
okay, so if i created 4 alert TEMPLATES (Jboss As Server Level) listed below..
1) jboss as server down alert
2) recover alert for jboss as server
3)jvm free memory < X MB
4) recover alert for jvm free memory
if I this access and run that query, will everything work like I would want it to so i wont have to manually add a bunch of recovery alerts to all my as servers.
Thanks a lot by the way
That's correct. The SQL should "fix" the broken recovery alerts, which in your case are the resource-level alert definition that would get created when #2 and #4 are applied to all JBAS instances in your inventory.
hi joe, when i try goto the test.sql, i get this....
The page requested cannot be displayed due to some error.
Return to the previous page, Dashboard, or Browse Resources page.
In older version of Jopr that page used to be located at /admin/sql.jsp
In later versions, it was moved to /admin/test/sql.jsp
Statement failed... here is the output of the query...
Command (statement 1 of 1) Had an error:
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row (error code=1427)
update rhq_alert_definition recovery set recovery_id = (select toBeRecovered.id from rhq_alert_definition toBeRecovered where toBeRecovered.resource_id = recovery.resource_id and toBeRecovered.name = (select template.name from rhq_alert_definition template where template.id = recovery.recovery_id)) where recovery_id != 0 and parent_id != 0 and recovery_id = (select parent.recovery_id from rhq_alert_definition parent where parent.id = recovery.parent_id)
I'm looking into this now. Will reply back shortly.
Thank you SO much, it means a lot to me that your working on this
Look at the new SQL I put in RHQ-2150, it should work now.
ill let you know if it works, thanks!