Bug 1171675

Summary:	The migration from PostgreSQL to Oracle fails, if the package rhn-upgrade is installed
Product:	Red Hat Satellite 5	Reporter:	Martin Korbel <mkorbel>
Component:	Upgrades	Assignee:	Jan Dobes <jdobes>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Martin Korbel <mkorbel>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	570	CC:	cperry, jdobes, tkasparek, tlestach
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	spacewalk-utils-2.3.2-11	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2015-01-13 10:25:58 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 Martin Korbel 2014-12-08 11:12:17 UTC

Description of problem:
The migration process from Sat5.7 embPG -> Sat5.7 extOracle fails, if the package rhn-upgrade is installed. In my specific case, I have a Sat5.7 embPG, what was upgraded from Sat5.6 embPG.


Version-Release number of selected component (if applicable):
Satellite-5.7.0-RHEL6-re20141203.0
rhn-upgrade-5.7.0.12-1.el6sat
spacewalk-utils-2.3.2-10.el6sat

How reproducible:
100%

Steps to Reproduce:
1. We have got Sat5.7 embPG
2. Install the latest version of rhn-upgrade
> yum install rhn-upgrade
3. Make a dump
> spacewalk-dump-schema --to=oracle  > /tmp/spacewalk-postgresql.dump

Actual results:
DBD::Pg::st execute failed: ERROR:  column b.rowid does not exist
LINE 1: ...ArchCompat a  where a.rowid > any (        select b.rowid   ...
                                                             ^ at /usr/bin/spacewalk-dump-schema line 411.
DBD::Pg::st execute failed: ERROR:  column b.rowid does not exist
LINE 1: ...ArchCompat a  where a.rowid > any (        select b.rowid   ...
                                                             ^ at /usr/bin/spacewalk-dump-schema line 411.
DBD::Pg::db selectall_hashref failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block at /usr/bin/spacewalk-dump-schema line 295.
DBD::Pg::db selectall_hashref failed: ERROR:  current transaction is aborted, commands ignored until end of transaction block at /usr/bin/spacewalk-dump-schema line 295.
END failed--call queue aborted at /usr/bin/spacewalk-dump-schema line 411.
Issuing rollback() due to DESTROY without explicit disconnect() of DBD::Pg::db handle dbname=rhnschema at /usr/bin/spacewalk-dump-schema line 411.


Expected results:
No errors

Additional info:
The core of problem is that, the utility "spacewalk-dump-schema" tries to execute the upgrade scripts from /etc/sysconfig/rhn/schema-dump/, but some of these scripts are write only for Oracle DB. The PostgreSQL doesn't know about rowid, it has oid. 

pre/rhnpackageupgradearchcompat

Comment 3 Jan Dobes 2014-12-12 16:30:27 UTC

fixed in spacewalk master:

438a9e7a7cf6d2dc53103dba6935f92c96543072

Comment 6 Martin Korbel 2015-01-06 12:46:35 UTC

VERIFIED on Satellite-5.7.0-RHEL6-re20150105.1 (spacewalk-utils-2.3.2-13.el6sat)

Reproducer in comment 0.

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