Bug 1694715
| Summary: | on big katello-agent update: PG::StringDataRightTruncation: ERROR: value too long for type character varying(255) | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Jan Hutař <jhutar> | ||||
| Component: | Audit Log | Assignee: | Marek Hulan <mhulan> | ||||
| Status: | CLOSED ERRATA | QA Contact: | Roman Plevka <rplevka> | ||||
| Severity: | high | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.5.0 | CC: | inecas, kgaikwad, mmccune, rplevka, zhunting | ||||
| Target Milestone: | 6.5.0 | Keywords: | Triaged | ||||
| Target Release: | Unused | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | tfm-rubygem-katello-3.10.0.44-1 | Doc Type: | If docs needed, set a value | ||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2019-05-14 12:40: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: | |||||||
| Attachments: |
|
||||||
Created attachment 1550560 [details]
Satellite side traceback
Same for errata upgrade action where I have selected 100 applicable errata - it was called "Install erratum RHBA-2019:40621, RHSA-2019:40408, RHBA-2019:40252, RHBA-2019:40194, RHBA-2019:40003, RHBA-2019:39731, RHBA-2019:39532, RHSA-2019:39433, RHSA-2019:39408, RHSA-2019:39393, RHBA-2019:39357, RHBA-2019:39356, RHEA-2019:39294, RHBA-2019:39259, RHBA-2019:0192, RHSA-2019:39170, RHBA-2019:39066, RHBA-2019:39054, RHBA-2019:0037, RHSA-2019:0049, RHSA-2018:3651, RHSA-2018:3665, RHBA-2018:3670, RHBA-2018:3664, RHBA-2018:3635, RHBA-2018:3543, RHBA-2018:3508, RHBA-2018:3454, RHBA-2018:3442, RHBA-2018:3098, RHBA-2018:3016, RHBA-2018:3286, RHBA-2018:3166, RHBA-2018:3072, RHBA-2018:3167, RHBA-2018:3106, RHBA-2018:3156, RHBA-2018:3013, RHBA-2018:3207, RHBA-2018:3172, RHBA-2018:3300, RHEA-2018:3097, RHBA-2018:3077, RHBA-2018:3245, RHBA-2018:3084, RHBA-2018:3340, RHBA-2018:3318, RHSA-2018:3041, RHBA-2018:3202, RHEA-2018:3149, RHBA-2018:3215, RHEA-2018:3135, RHBA-2018:3117, RHBA-2018:3045, RHBA-2018:3299, RHBA-2018:3141, RHSA-2018:3092, RHSA-2018:3107, RHBA-2018:3085, RHBA-2018:3088, RHBA-2018:3193, RHBA-2018:3184, RHBA-2018:3111, RHBA-2018:3192, RHSA-2018:3140, RHBA-2018:3119, RHBA-2018:3153, RHSA-2018:3221, RHBA-2018:3014, RHBA-2018:3074, RHBA-2018:3063, RHBA-2018:3240, RHBA-2018:3255, RHEA-2018:3114, RHBA-2018:3267, RHBA-2018:3093, RHEA-2018:3199, RHBA-2018:3120, RHBA-2018:3024, RHBA-2018:3264, RHBA-2018:3279, RHSA-2018:3059, RHBA-2018:3405, RHBA-2018:3297, RHBA-2018:3274, RHBA-2018:3131, RHBA-2018:3076, RHEA-2018:3130, RHBA-2018:3288, RHSA-2018:3157, RHBA-2018:3276, RHBA-2018:3230, RHBA-2018:3219, RHEA-2018:3250, RHBA-2018:3344, RHBA-2018:3203, RHBA-2018:3232, RHBA-2018:3252, RHBA-2018:3079, RHBA-2018:3314" Created redmine issue https://projects.theforeman.org/issues/26547 from this bug Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/26547 has been resolved. VERIFIED on sat6.5.0-22 the task finishes successfully with the packages being updated: Install erratum User admin Started At 4/17/19 1:40 PM Finished At 4/17/19 1:41 PM Parameters RHSA-2019:0194, RHBA-2018:3136, RHSA-2018:2570, RHBA-2018:0742, RHSA-2018:0102, RHBA-2017:3312 State stopped Result success: Output: 32:bind-libs-lite-9.9.4-73.el7_6.x86_64 32:bind-license-9.9.4-73.el7_6.noarch 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. https://access.redhat.com/errata/RHSA-2019:1222 |
Description of problem: On big katello-agent update task fails with "PG::StringDataRightTruncation: ERROR: value too long for type character varying(255)" Version-Release number of selected component (if applicable): satellite-6.5.0-10.el7sat.noarch (snap #22) How reproducible: always Steps to Reproduce: 1. Install RHEL 7.4 host (now when 7.6 is out) and register to Satellite 2. Install katello-agent to the host 3. Hosts -> Content Hosts -> <host> -> Packages -> Applicable -> filter for "bind" -> select all -> Upgrade Selected Actual results: Tasks: Update package bind-libs-lite-9.9.4-50.el7_3.1.x86_64, bind-libs-lite-9.9.4-51.el7.x86_64, bind-libs-lite-9.9.4-51.el7_4.1.x86_64, bind-libs-lite-9.9.4-51.el7_4.2.x86_64, bind-libs-lite-9.9.4-61.el7.x86_64, bind-libs-lite-9.9.4-61.el7_5.1.x86_64, bind-libs-lite-9.9.4-72.el7.x86_64, bind-license-9.9.4-50.el7_3.1.noarch, bind-license-9.9.4-51.el7.noarch, bind-license-9.9.4-51.el7_4.1.noarch, bind-license-9.9.4-51.el7_4.2.noarch, bind-license-9.9.4-61.el7.noarch, bind-license-9.9.4-61.el7_5.1.noarch, bind-license-9.9.4-72.el7.noarch Output: 32:bind-libs-lite-9.9.4-72.el7.x86_64 32:bind-license-9.9.4-72.el7.noarch Errors: PG::StringDataRightTruncation: ERROR: value too long for type character varying(255) : INSERT INTO "audits" ("auditable_id", "auditable_type", "user_id", "username", "action", "audited_changes", "version", "comment", "request_uuid", "created_at", "auditable_name") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) RETURNING "id" Expected results: Task should pass