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
fixed in spacewalk master: 438a9e7a7cf6d2dc53103dba6935f92c96543072
VERIFIED on Satellite-5.7.0-RHEL6-re20150105.1 (spacewalk-utils-2.3.2-13.el6sat) Reproducer in comment 0.
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.