Created attachment 433177 [details] server log Description of problem: Upgrade JON2.3.1 to JON2.4GA_QA with oracle is missing alert notification configurations. Version-Release number of selected component (if applicable): version: 2.4.0.GA_QA (build #70) build number: 10856:52c274a How reproducible: Steps to Reproduce: 1) Install JON 2.3.1 and agent with Oracle 10g 2) Perform operations on JON 2.3.1 (i) Create alerts: (a) Name: Platform_alert_test [Type: Linux (Platform)] If Condition: Free Memory > 0.1B Dampening Rule: Each time condition set is true Action Filters: Disable alert until re-enabled manually or by recovery alert: false Notify Roles (All Resources Role, Super User Role) Notify Other Recipients: Eamil - rtimaniy Operation- Control Type: View Process List (b)Name: JBOSSAS_JVM_ALERT [Type: JBoss AS JVM (Server)] If Condition: Availability goes DOWN Dampening Rule: Each time condition set is true Action Filters: Disable alert until re-enabled manually or byrecovery alert : false Notify Roles (All Resources Role, Super User Role) Notify Other Recipients: Eamil - rtimaniy (c)Name:RHQ_Agent_JVM_Active_Threads_Alert [Type: RHQ Agent(Server)] If Condition: JVM Active Threads > -1.0 Dampening Rule: Each time condition set is true Action Filters: Disable alert until re-enabled manually or byrecovery alert: false Notify Other Recipients: Eamil - rtimaniy Notify Roles (All Resources Role, Super User Role) Notify JON Users (username - rhqadmin) (d) Name: RHQ_Agent_alert_test [Type: RHQ Agent (Server)] If Condition: Total Memory > 0.1B Dampening Rule: Each time condition set is true Action Filters: Disable alert until re-enabled manually or by recovery alert: false Notify Roles (All Resources Role, Super User Role) Notify Other Recipients: Eamil - rtimaniy 5) Stop/Down all JON2.3.1 servers 6) Keep all agents running 7) Upgrade one server from JON2.3.1 to JON 2.4 (build #70) (with same database-Oracle 10g) 8) Verify all alert definitions and its configuration values (alert created in JON2.3.1 - step:2) Actual results: After JON upgrade some alerts are missing their notification configuration values. Upgraded JON was missing alert notification configuration for 'Roles', 'JON Users' and 'Email'. Expected results: JON upgrade should not miss any alert notification configuration value. Additional info: Please refer attached server log.
(9:32:50 AM) pilhuhn: rajan: is this after the failed update of ..395 or ..400 ? especially the latter failed to port over some definitions (9:35:10 AM) rajan: pilhuhn, yes its all in same time of ..395 and ...400 (9:37:15 AM) ccrouch: rajan: ok well that means these last couple bugs may be bogus then? (9:37:27 AM) ccrouch: since the upgrade clearly failed (9:37:54 AM) ccrouch: is that what you were getting at pilhuhn ? (9:41:31 AM) pilhuhn: ccrouch: yes, that is my idea (9:41:48 AM) pilhuhn: perhaps not all, but the 459 one could be caused by the 400 one
This could be related to https://bugzilla.redhat.com/show_bug.cgi?id=615952 Joseph was not able to reproduce when testing on Postgres, Heiko will try to reproduce on Oracle
This could also be related to https://bugzilla.redhat.com/show_bug.cgi?id=616400
We were not able to reproduce on Oracle either. Pushing back to QA for retest. Note: in at least one instance of our testing, our alert notification audit trail got an additional entry added to it. Prior to the upgrade one alert had: subjects: <foobar> email: <blah> And after the upgrade it had: subjects: <foobar> email: <blah> roles: (none) So their was this "ghost" row for the roles, but Charles considers that OK for the release.
After upgrade : - alert a. is missing notification configuration - alert c. contains two Direct Emails: ",fdrabek," and "fdrabek" (in original version there was only one "fdrabek")
Filip, yes, QA saw that too and captured the details of that in BZ-616661
Verified on JON2.4 (build #71) version: 2.4.0.GA_QA build number: 10860:2ca5643 JON upgrade (with build #71) didn't miss any alert notification configuration value. Found upgrade JON2.3.1 to JON2.4GA_QA with oracle is adding two entries for alert notification, so file separate bug #616837
Mass-closure of verified bugs against JON.