Bug 1175534 - upgrading 5.6.0 with external Oracle @ RHEL6: Enabling Monitoring: DBD::Pg::st execute failed: ERROR: relation "rhn_config_macro" does not exist
Summary: upgrading 5.6.0 with external Oracle @ RHEL6: Enabling Monitoring: DBD::Pg::s...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 570
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ---
Assignee: Tomáš Kašpárek
QA Contact: Pavel Studeník
URL:
Whiteboard:
Depends On:
Blocks: sat570-upgrades 1231357
TreeView+ depends on / blocked
 
Reported: 2014-12-18 00:35 UTC by Jan Hutař
Modified: 2015-06-12 19:28 UTC (History)
1 user (show)

Fixed In Version: spacewalk-setup-2.3.0-14-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 1231357 (view as bug list)
Environment:
Last Closed: 2015-01-13 10:25:54 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Jan Hutař 2014-12-18 00:35:52 UTC
Description of problem:
When doing in-place upgrade of 5.6.0 with external Oracle @ RHEL6 to 5.7.0 with embedded PostgreSQL, `./install.pl --upgrade` step fails.


Version-Release number of selected component (if applicable):
rhn-upgrade-5.7.0.18-1.el6sat.noarch
Satellite-5.7.0-RHEL6-re20141212.0-x86_64


How reproducible:
1 of 1


Steps to Reproduce:
1. Prepare 5.6.0 with external Oracle @ RHEL6
2. Do not enable Monitoring (not sure if this is important part of
   the reproducer, but that is how I did it)
3. Follow upgrade procedure (preparations.txt and then satellite-upgrade-postgresql.txt) to `./install.pl --upgrade` step


Actual results:
# /mnt/tmp/install.pl --upgrade --run-updater
* Starting Red Hat Satellite installer.
* Performing pre-install checks.
* Pre-install checks complete.  Beginning installation.
* RHN Registration.
** Registration: System is already registered with RHN.  Not re-registering.
* Upgrade flag passed.  Stopping necessary services.
* Purging conflicting packages.
* Checking for uninstalled prerequisites.
There are some packages from Red Hat Enterprise Linux that are not part
of the @base group that Satellite will require to be installed on this
system. The installer will try resolve the dependencies automatically.
* Installing RHN packages.
* Now running spacewalk-setup.
* Setting up SELinux..
** Database: Setting up database connection for PostgreSQL backend.
** Database: Installing the database:
** Database: This is a long process that is logged in:
** Database:   /var/log/rhn/install_db.log
*** Progress: #
** Database: Installation complete.
** Database: Populating database.
** Database: Skipping database population.
* Setting up users and groups.
** GPG: Initializing GPG and importing key.
* Performing initial configuration.
* Activating Red Hat Satellite.
** Certificate not activated.
** Upgrade process requires the certificate to be activated after the schema is upgraded.
* Enabling Monitoring.
DBD::Pg::st execute failed: ERROR:  relation "rhn_config_macro" does not exist
LINE 1:     UPDATE rhn_config_macro
                   ^ at /usr/bin/spacewalk-setup line 1107.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=rhnschema at /usr/bin/spacewalk-setup line 1107.


Expected results:
Should work.


Additional info:
# tail /var/log/rhn/rhn_installation.log
web.version
/var/lib/rhn/rhn-satellite-prep/etc/rhn/rhn.conf.orig
/var/lib/rhn/rhn-satellite-prep/etc/rhn/rhn.conf
/var/lib/rhn/rhn-satellite-prep/etc/rhn/cluster.ini
/var/lib/rhn/rhn-satellite-prep/etc -> /etc
/var/lib/rhn/rhn-satellite-prep/etc/rhn -> /etc/rhn
/var/lib/rhn/rhn-satellite-prep/etc/rhn/rhn.conf -> /etc/rhn/rhn.conf
 * Making backup of /etc/rhn/rhn.conf to /etc/sysconfig/rhn/backup-2014-12-17-18:58/etc/rhn/rhn.conf
/var/lib/rhn/rhn-satellite-prep/etc/rhn/cluster.ini -> /etc/rhn/cluster.ini
 * Making backup of /etc/rhn/cluster.ini to /etc/sysconfig/rhn/backup-2014-12-17-18:58/etc/rhn/cluster.ini

Comment 6 Clifford Perry 2015-01-13 10:25:54 UTC
With the release of Red Hat Satellite 5.7 on January 12th 2015 this bug is
being moved to a Closed Current Release state. 

The Satellite 5.7 GA Errata:
 - https://rhn.redhat.com/errata/RHSA-2015-0033.html 

Satellite 5.7 Release Notes:
 -
https://access.redhat.com/documentation/en-US/Red_Hat_Satellite/5.7/html-single/Release_Notes/index.html

Satellite Customer Portal Blog announcement for release:
 - https://access.redhat.com/blogs/1169563/posts/1315743 

Cliff

NOTE: This bug has not been re-verified (moved to RELEASE_PENDING) prior to release. We assume that the bug has indeed been fixed and not regressed since we initially verified it. Please re-open in the future if needed.


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