Bug 1412842 - Applying selected errata fails with ERROR: value too long for type character varying(255)
Summary: Applying selected errata fails with ERROR: value too long for type character ...
Keywords:
Status: CLOSED DUPLICATE of bug 1367606
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Remote Execution
Version: 6.2.6
Hardware: All
OS: All
unspecified
medium
Target Milestone: Unspecified
Assignee: satellite6-bugs
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-01-12 23:26 UTC by Josh Foots
Modified: 2020-02-14 18:27 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-01-12 23:37:31 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Josh Foots 2017-01-12 23:26:24 UTC
Description of problem:

WebUI - Content Host - jost.example.com - Errata 
Selected all secuirty (40 Selected)
Apply Selected -> Via remote execution
Error message:
Oops, we're sorry but something went wrong ERROR: value too long for type character varying(255) 
FullTrace is attached


Version-Release number of selected component (if applicable):


How reproducible:

Very

Steps to Reproduce:
1. Pick a host with a large number of errata to apply
2. Select all
3. Apply via remote execution

Actual results:

Fails with Oops, we're sorry but something went wrong ERROR: value too long for type character varying(255) 

Expected results:

For it to apply the errata or tell the user to select less errata

Additional info:

The problem is the 255 char limit. In the case where this was hit, this was the string being passed:

RHSA-2017:0036,RHSA-2017:0014,RHSA-2016:2974,RHSA-2016:2975,RHSA-2016:2973,RHSA-2016:2972,RHSA-2016:2141,RHSA-2016:1850,RHSA-2016:2766,RHSA-2016:1547,RHSA-2016:1421,RHSA-2016:2006,RHSA-2016:2105,RHSA-2016:2093,RHSA-2016:1487,RHSA-2016:1664,RHSA-2016:1406,RHSA-2016:1809,RHSA-2016:1985,RHSA-2016:2946,RHSA-2016:2850,RHSA-2016:2825,RHSA-2016:1041,RHSA-2016:1392,RHSA-2016:1217,RHSA-2016:1292,RHSA-2016:2779,RHSA-2016:2702,RHSA-2016:2780,RHSA-2016:1912,RHSA-2016:2824,RHSA-2016:2872,RHSA-2016:1551,RHSA-2016:1797,RHSA-2016:1776,RHSA-2016:2674,RHSA-2016:1944,RHSA-2016:1237,RHSA-2016:1141,RHSA-2016:2843,RHSA-2016:1626 

That string was generated by the webUI when creating the job for remote execution and has 615 characters in it. As a workaround just select less errata to apply at a time so the limit isn't hit.

Comment 1 Josh Foots 2017-01-12 23:37:31 UTC
Marking this as a duplicate of https://bugzilla.redhat.com/show_bug.cgi?id=1367606

*** This bug has been marked as a duplicate of bug 1367606 ***


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