Bug 1170611

Summary:	upgrading Sat5.4.1@RHEL5-s390x embDB to Sat5.7 x86_64 extPG fails on spacewalk-dump-schema with: ORA-24334
Product:	Red Hat Satellite 5	Reporter:	Martin Korbel <mkorbel>
Component:	Upgrades	Assignee:	Tomáš Kašpárek <tkasparek>
Status:	CLOSED WONTFIX	QA Contact:	Martin Korbel <mkorbel>
Severity:	medium	Docs Contact:
Priority:	high
Version:	570	CC:	jhutar, mmraka, tlestach
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-03-22 08:29:35 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:	1162131

Description Martin Korbel 2014-12-04 12:55:59 UTC

Description of problem:
Upgrading Sat5.4.1@RHEL5 s390x embDB -> Sat5.7 x86_64 extPG fails with this message:
"DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from rhnpackageevr"] at ./spacewalk-dump-schema line 369."

Version-Release number of selected component (if applicable):
(Satellite-5.4.1-RHEL5-re20110615.0)  rhn-upgrade-5.7.0.10-1.el5sat

How reproducible:
100%

Steps to Reproduce:
1. We have got Sat5.4.1 s390x
2. Synchronize RHEL6 channels without packages and rpms. I'm not sure, if this is important.
> ARCH=$(uname -i); satellite-sync -c -c rhel-${ARCH}-server-6 -c rhn-tools-rhel-${ARCH}-server-6 --no-packages --no-rpms
3. Make dump
> ./spacewalk-dump-schema | bzip2 -7c - | split -d -b 2147483648 - /tmp/backup5.7a/schema-dump-


Actual results:

DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position (DBD ERROR: OCIParamGet) [for Statement "select * from rhnpackageevr"] at ./spacewalk-dump-schema line 369.

Expected results:

No errors

Additional info:

Comment 2 Jan Hutař 2014-12-04 13:35:01 UTC

Running the query manually works nicely:

# su - oracle
$ sqlplus `spacewalk-cfg-get default_db`
SQL> select * from rhnpackageevr;
[...]
1011 rows selected.