-
1. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 10:04 AM (in response to amit8484)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 -
2. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 10:09 AM (in response to amit8484)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?
-
3. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 10:14 AM (in response to amit8484)What you propose should work. By the way, are you familiar with the /admin/test pages?
-
4. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 10:16 AM (in response to amit8484)no whats that
-
5. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 10:54 AM (in response to amit8484)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.
-
6. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 11:18 AM (in response to amit8484)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 -
7. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 11:20 AM (in response to amit8484)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.
-
8. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 12:49 PM (in response to amit8484)hi joe, when i try goto the test.sql, i get this....
Error
The page requested cannot be displayed due to some error.
Return to the previous page, Dashboard, or Browse Resources page.
/admin/test/sql.jsp -
9. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 12:53 PM (in response to amit8484)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 -
10. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 1:04 PM (in response to amit8484)joe,
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) -
11. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 1:23 PM (in response to amit8484)I'm looking into this now. Will reply back shortly.
-
12. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 1:25 PM (in response to amit8484)Thank you SO much, it means a lot to me that your working on this
-
13. Re: could this be whwy my recovery alerts arent working?
joe.marques Jun 17, 2009 4:07 PM (in response to amit8484)Look at the new SQL I put in RHQ-2150, it should work now.
-
14. Re: could this be whwy my recovery alerts arent working?
amit8484 Jun 17, 2009 4:20 PM (in response to amit8484)ill let you know if it works, thanks!