Bug 1174743

Summary:	`./install.pl --managed-db --upgrade` (managed PostgreSQL DB system upgrade) fails with "There was a problem during embedded database upgrade. Exit value: 127."
Product:	Red Hat Satellite 5	Reporter:	Jan Hutař <jhutar>
Component:	Upgrades	Assignee:	Tomáš Kašpárek <tkasparek>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Pavel Studeník <pstudeni>
Severity:	high	Docs Contact:
Priority:	unspecified
Version:	570	CC:	pstudeni, tlestach
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	spacewalk-setup-postgresql-2.3.0-14-sat	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-01-13 10:25:30 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1128174

Description Jan Hutař 2014-12-16 12:12:48 UTC

Description of problem:
`./install.pl --managed-db --upgrade` fails with "There was a problem during embedded database upgrade. Exit value: 127."


Version-Release number of selected component (if applicable):
Satellite-5.7.0-RHEL6-re20141212.0-x86_64


How reproducible:
1 of 1


Steps to Reproduce:
1. Install 5.6.0 with external managed PostgreSQL DB backend
2. Mount 5.7.0 ISO and upgrade it
   # /mnt/tmp/install.pl --managed-db --upgrade


Actual results:
# /mnt/tmp/install.pl --managed-db --upgrade
* 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.
* Upgrading managed DB packages.
*** Upgrading embedded database.
There was a problem during embedded database upgrade.
  Exit value: 127.
Please examine /var/log/rhn/rhn_installation.log for more information.


Expected results:
Should work


Additional info:
# tail /var/log/rhn/rhn_installation.log
Running Transaction
  Installing : postgresql92-postgresql-upgrade-9.2.8-2.el6.x86_64           1/1 
  Verifying  : postgresql92-postgresql-upgrade-9.2.8-2.el6.x86_64           1/1 

Installed:
  postgresql92-postgresql-upgrade.x86_64 0:9.2.8-2.el6                          

Complete!
Starting postgresql service: [  OK  ]
/usr/bin/spacewalk-upgrade-postgresql: line 22: spacewalk-sql: command not found
# rpm -qf /usr/bin/spacewalk-upgrade-postgresql
spacewalk-setup-postgresql-2.3.0-13.el6sat.noarch
# rpm -q --requires spacewalk-setup-postgresql | grep -v ^rpmlib
/bin/bash
lsof
postgresql92-postgresql-contrib
postgresql92-postgresql-pltcl
postgresql92-postgresql-server

Comment 1 Jan Hutař 2014-12-16 12:23:59 UTC

When I have copied these files from Satellite system to managed PostgreSQL system (so `spacewalk-sql -i` worked), upgrade worked.

Comment 5 Clifford Perry 2015-01-13 10:25:30 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.