Bug 849018

Summary: rhnPackageCapability.version is too small for some packages
Product: Red Hat Satellite 5 Reporter: Nigel Jones <nigjones>
Component: ServerAssignee: Jan Pazdziora <jpazdziora>
Status: CLOSED ERRATA QA Contact: Martin Minar <mminar>
Severity: medium Docs Contact:
Priority: medium    
Version: 541CC: cperry, jmoran, jpazdziora, mkoci, mminar, xdmoon
Target Milestone: ---Keywords: Patch
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: satellite-schema-5.5.0.15-1-sat Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 856128 (view as bug list) Environment:
Last Closed: 2012-10-22 11:24:08 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: 465198, 819027, 856128    
Attachments:
Description Flags
Patch to change rhnPackageCapability.version to 512 bytes wide none

Description Nigel Jones 2012-08-17 05:20:01 UTC 
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.

How reproducible:
Always

Steps to Reproduce:
1. Attempt to 'rhnpush' attached mpm file to RHN Satellite
2. Watch /var/log/httpd/error_log
3.
  
Actual results:
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)'))

Expected results:
RHN Push to succeed and package to appear in Solaris channel.

Additional info:
Comment 4 Jan Pazdziora 2012-09-05 14:48:05 UTC 
When doing 5.4 and/or 5.5 errata, we should consider also doing fix for bug 854686.
Comment 6 Jan Pazdziora 2012-09-05 14:59:31 UTC 
Fixed in Spacewalk master, commits f89a70e86fa7344c1b0cc323a8f8173c99051800 and af4a153419204be2fcde71bbbed0d7289d723403 (the schema upgrade scripts).
Comment 9 Jan Pazdziora 2012-09-10 16:50:38 UTC 
Fixed schema upgrade script in Spacewalk master, 2ed9809ff0914a0f409d680f75f700634f7a4d59.
Comment 13 errata-xmlrpc 2012-10-22 11:24:08 UTC 
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.

http://rhn.redhat.com/errata/RHBA-2012-1394.html