Bug 854686 - The rhn_command.command_class database column default is wrong when upgrading from Satellite 5.0
Summary: The rhn_command.command_class database column default is wrong when upgrading...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 550
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Martin Minar
URL:
Whiteboard:
Depends On:
Blocks: 819027 856133
TreeView+ depends on / blocked
 
Reported: 2012-09-05 14:43 UTC by Jan Pazdziora
Modified: 2016-07-04 00:57 UTC (History)
4 users (show)

Fixed In Version: satellite-schema-5.5.0.14-1-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 856133 (view as bug list)
Environment:
Last Closed: 2012-10-22 11:24:12 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2012:1394 0 normal SHIPPED_LIVE Red Hat Network Satellite server bug fix update 2013-01-10 14:42:37 UTC

Description Jan Pazdziora 2012-09-05 14:43:57 UTC
Description of problem:

The rhn_command.command_class database column default on Satellite upgraded from version < 5.2 is set to '/var/lib/nocpulse/libexec' rather than to '/var/lib/nocpulse/libexec/plugin' like the freshly installed Satellite 5.5 is.

Version-Release number of selected component (if applicable):

spacewalk-schema-1.7.55-31.el6sat.noarch
satellite-schema-5.5.0.13-1.el6sat.noarch

How reproducible:

Deterministic.

Steps to Reproduce:
1. Have Satellite upgraded from 5.0 to 5.5.
2. Connect to its Oracle database with sqlplus.
3. Run SQL> select data_default from user_tab_columns where table_name = 'RHN_COMMAND' and column_name = 'COMMAND_CLASS' ;

Actual results:

DATA_DEFAULT
--------------------------------------------------------------------------------
('/var/lib/nocpulse/libexec')

Expected results:

DATA_DEFAULT
--------------------------------------------------------------------------------
('/var/lib/nocpulse/libexec/plugin')

Additional info:

This issue should have no ill effect on Satellite operation, it's a sanity issue.

The freshly installed Satellite 5.5 will have the default value set to '/var/lib/nocpulse/libexec/plugin' which should also be worth checking upon QA.

Comment 1 Jan Pazdziora 2012-09-05 14:46:26 UTC
Fixed in Spacewalk master, 46ff247497a6b0a13498c8df6f4c9bb80167ff33.

Comment 2 Jan Pazdziora 2012-09-06 13:39:49 UTC
The problem is also present when upgrading from 5.2 to 5.5. So 5.2 can be used isntead of 5.0.

Comment 7 errata-xmlrpc 2012-10-22 11:24:12 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHBA-2012-1394.html


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