Bug 1412842

Summary: Applying selected errata fails with ERROR: value too long for type character varying(255)
Product: Red Hat Satellite Reporter: Josh Foots <jfoots>
Component: Remote ExecutionAssignee: satellite6-bugs <satellite6-bugs>
Status: CLOSED DUPLICATE QA Contact:
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.2.6CC: inecas
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-01-12 23:37:31 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:

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 ***