Red Hat Bugzilla – Bug 1006305
Data migration to PostgreSQL fails for very large lobs
Last modified: 2016-07-03 20:58:00 EDT
Description of problem:
Data migration from an older Oracle schema to Satellite 5.6 @ PostgreSQL
will fail for large LOBs (currently larger than 10M).
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Satellite 5.5 or older with a registered client
2. Have the client remotely run a script which will create >= 10MB output
3. Migrate to Satellite 5.6 @ PostgreSQL
spacewalk-dump-schema fails with the following error:
DBD::Oracle::st fetchrow_arrayref failed: ERROR fetching field 3 of 8. LOB
value truncated from 14465734 to 10000000. DBI attribute LongReadLen too small
and/or LongTruncOk not set [for Statement "select * from
rhnserveractionscriptresult"] at ./spacewalk-dump-schema line 437.
Schema migration succeeds.
spacewalk.git master: 8e8cc44ec35bbc839c110b1ad9d80366bf75933f
Satellite 5.6 has been released. This bug tracked under Upgrades.
This bug either was VERIFIED or RELEASE_PENDING (re-verified prior shortly before release).
Moving to CLOSED CURRENT_RELEASE.
Text from Upgrade Erratum follows:
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.