could this be whwy my recovery alerts arent working?

[amit8484]

I am running jopr 1.1.0, if I upgrade to 2.2.0, will this fix my recovery alerts problem. No one seems to reply on my original post.

[joe.marques]

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

[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?

[joe.marques]

What you propose should work. By the way, are you familiar with the /admin/test pages?

[amit8484]

no whats that

[joe.marques]

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.

[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

[joe.marques]

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.

[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

[joe.marques]

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

[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)

[joe.marques]

I'm looking into this now. Will reply back shortly.

[amit8484]

Thank you SO much, it means a lot to me that your working on this

[joe.marques]

Look at the new SQL I put in RHQ-2150, it should work now.

[amit8484]

ill let you know if it works, thanks!