Red Hat Bugzilla – Bug 849018
rhnPackageCapability.version is too small for some packages
Last modified: 2016-07-03 20:57:18 EDT
Created attachment 605078 [details]
Patch to change rhnPackageCapability.version to 512 bytes wide
Description of problem:
This arises from the same case as the Solaris bug 849011 however from a different source package.
It appears that some Solaris packages come with version strings exceeding 64 characters in length, and will fail in an 'rhnpush'.
rhnPackageEVR specifies version as 512 bytes, so I'm chosen to match that in this patch for consistancy.
Steps to Reproduce:
1. Attempt to 'rhnpush' attached mpm file to RHN Satellite
2. Watch /var/log/httpd/error_log
Failure (SQLError: (12899, 'ORA-12899: value too large for column "RHNSAT"."RHNPACKAGECAPABILITY"."VERSION" (actual: 73, maximum: 64)\\n', 'insert into rhnPackageCapability (id, name, version) values (:id, :name, :version)'))
RHN Push to succeed and package to appear in Solaris channel.
When doing 5.4 and/or 5.5 errata, we should consider also doing fix for bug 854686.
Fixed in Spacewalk master, commits f89a70e86fa7344c1b0cc323a8f8173c99051800 and af4a153419204be2fcde71bbbed0d7289d723403 (the schema upgrade scripts).
Fixed schema upgrade script in Spacewalk master, 2ed9809ff0914a0f409d680f75f700634f7a4d59.
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.