Project

General

Profile

Bug #26547

on big katello-agent update: PG::StringDataRightTruncation: ERROR: value too long for type character varying(255)

Added by Marek Hulán 8 months ago. Updated 7 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1694715

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

Associated revisions

Revision ef0083b8 (diff)
Added by Marek Hulán 7 months ago

Fixes #26547 - truncate package list in audit

History

#1 Updated by The Foreman Bot 8 months ago

  • Assignee set to Marek Hulán
  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/8067 added

#2 Updated by Marek Hulán 7 months ago

  • Status changed from Ready For Testing to Closed

#3 Updated by Chris Roberts 7 months ago

  • Triaged changed from No to Yes
  • Target version set to Katello 3.12.0
  • Subject changed from on big katello-agent update: PG::StringDataRightTruncation: ERROR: value too long for type character varying(255) to on big katello-agent update: PG::StringDataRightTruncation: ERROR: value too long for type character varying(255)
  • Fixed in Releases Katello 3.12.0 added

#4 Updated by Jonathon Turel 7 months ago

  • Target version changed from Katello 3.12.0 to Katello 3.11.1

Also available in: Atom PDF