Bugzilla will be upgraded to version 5.0 on a still to be determined date in the near future. The original upgrade date has been delayed.
Bug 618214 - Upgrade JON2.3.1 to 2.4 lost 'SNMP Server Configuration Properties' data
Upgrade JON2.3.1 to 2.4 lost 'SNMP Server Configuration Properties' data
Product: RHQ Project
Classification: Other
Component: Database (Show other bugs)
All Linux
high Severity medium (vote)
: ---
: ---
Assigned To: Heiko W. Rupp
Rajan Timaniya
Depends On:
Blocks: jon30-bugs
  Show dependency treegraph
Reported: 2010-07-26 08:38 EDT by Rajan Timaniya
Modified: 2013-09-02 03:17 EDT (History)
5 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 648780 (view as bug list)
Last Closed: 2013-09-02 03:17:47 EDT
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
server log (76.36 KB, text/x-log)
2010-07-26 08:38 EDT, Rajan Timaniya
no flags Details
Screenshot (58.36 KB, image/png)
2011-06-23 08:07 EDT, Sunil Kondkar
no flags Details

  None (edit)
Description Rajan Timaniya 2010-07-26 08:38:04 EDT
Created attachment 434408 [details]
server log

Description of problem:
Upgrade JON2.3.1 to 2.4 lost 'SNMP Server Configuration Properties' data ('SNMP protcol version' & 'Trap OID').

Version-Release number of selected component (if applicable):
version: 2.4.0.GA_QA (build #78) build number: 10888:29722f6

How reproducible:

Steps to Reproduce:
1) Install JON 2.3.1 and agent
2) Administration > System Configuration > Settings 
3) Set 'SNMP Server Configuration Properties'
	SNMP Protocol Version: 2c
	Trap OID:
	Community: public
4) Down JON server 2.3.1 (Keep agent running)
5) Upgrade JON 2.3.1 to 2.4 (build #78)
6) Log-in to upgraded JON 2.4 (build #78)
7) Goto Server Settings  >  Installed Plugins  >Server Plugins Configuration > Alert:SNMP
8) Refer Plugin configuration
Actual results:
Upgrade JON2.3.1 to 2.4 lost 'SNMP Server Configuration Properties' data ('SNMP protcol version' & 'Trap OID').

Expected results:
Upgrade JON2.3.1 to 2.4 should not lost 'SNMP Server Configuration Properties' data.

Additional info:
Please refer attached server log.
Comment 1 Heiko W. Rupp 2010-07-26 10:21:34 EDT
Manual upgrade steps for RHQ 3 are documented in https://bugzilla.redhat.com/show_bug.cgi?id=618214

We will re-visit this in master.
Comment 2 Heiko W. Rupp 2010-08-05 07:06:44 EDT
*argh* Comment 1 has the wrong link. This one is the right one: https://bugzilla.redhat.com/show_bug.cgi?id=618265
Comment 3 Heiko W. Rupp 2010-08-06 12:57:03 EDT
Code added in master at version 5b29f99
Comment 4 Rajan Timaniya 2010-08-12 09:31:18 EDT
As discuss with Heiko, the bug will be tested on JON 2.4.1 build, its known issue of JON 2.4
Comment 5 Charles Crouch 2010-11-02 01:08:36 EDT
Needs to be tested as part of JON3
Comment 6 Lukas Krejci 2010-11-23 13:06:13 EST
QA Failed.

The configuration entries with the settings are persisted using the upgrade code but the rhq_plugin table is never updated with an entry for the snmp-alert plugin and thus the plugin is never associated with the configuration.

Another problem that I can see here is that there are no entries for the server-side plugins in the rhq_plugin table before the RHQ 3 server is started for the first time so the upgrade code will have to insert a new entry in that table and somehow fake the plugins MD5 and binary contents...
Comment 7 Lukas Krejci 2010-12-01 08:39:09 EST
commit d19c483830aaed8ab154dcb494334ad1e5baab9e
Author: Lukas Krejci <lkrejci@redhat.com>
Date:   Wed Dec 1 14:37:47 2010 +0100

    BZ 618214 - Create a temporary entry in RHQ_PLUGIN table for the snmp-alert plugin in case we need to add something to its configuration during db-upgrade.
                Once the server starts up, the temporary entry will get overwritten by the "real stuff".
Comment 8 Lukas Krejci 2010-12-01 09:47:58 EST
Note that this needs to be tested on both postgres and oracle.
Comment 9 Corey Welton 2011-01-06 10:08:44 EST
Removing blocker against jon241 version of this bug
Comment 10 Sunil Kondkar 2011-06-23 08:04:00 EDT
Verified this by Upgrading JON2.3.1 to 2.4.1 build (version: 2.4.1.GA build number: 11123:4efbdc8279)

Verified by upgrading on both postgres and oracle.

The details of 'SNMP Server Configuration Properties' data is displayed in Administration->System Configuration->Settings->Configure Server Plugins->Alert Plugin->Alert:SNMP page.

Please refer the attached screenshot.

Marking as verified.
Comment 11 Sunil Kondkar 2011-06-23 08:07:42 EDT
Created attachment 506225 [details]
Comment 12 Heiko W. Rupp 2013-09-02 03:17:47 EDT
Bulk closing of issues that were VERIFIED, had no target release and where the status changed more than a year ago.

Note You need to log in before you can comment on or make changes to this bug.