Bug 849018 - rhnPackageCapability.version is too small for some packages
Summary: rhnPackageCapability.version is too small for some packages
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Server
Version: 541
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Martin Minar
URL:
Whiteboard:
Depends On:
Blocks: 465198 819027 856128
TreeView+ depends on / blocked
 
Reported: 2012-08-17 05:20 UTC by Nigel Jones
Modified: 2018-11-30 21:35 UTC (History)
6 users (show)

Fixed In Version: satellite-schema-5.5.0.15-1-sat
Doc Type: Bug Fix
Doc Text:
Clone Of:
: 856128 (view as bug list)
Environment:
Last Closed: 2012-10-22 11:24:08 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
Patch to change rhnPackageCapability.version to 512 bytes wide (1.08 KB, patch)
2012-08-17 05:20 UTC, Nigel Jones
no flags Details | Diff


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2012:1394 0 normal SHIPPED_LIVE Red Hat Network Satellite server bug fix update 2013-01-10 14:42:37 UTC

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


Note You need to log in before you can comment on or make changes to this bug.