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:
Running the query manually works nicely: # su - oracle $ sqlplus `spacewalk-cfg-get default_db` SQL> select * from rhnpackageevr; [...] 1011 rows selected.