Project

General

Profile

Actions

Bug #37080

closed

PG::ProgramLimitExceeded error for Update content counts task on a big setup

Added by Ian Ballou 10 months ago. Updated 9 months ago.

Status:
Closed
Priority:
High
Assignee:
Category:
Foreman Proxy Content
Target version:
Difficulty:
Triaged:
Yes
Found in Releases:

Description

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

Description of problem:
After Capsule sync the 'Update Content Counts' task is trigerred. In case of a bigger setup the task fails with error like:
PG::ProgramLimitExceeded: ERROR: index row requires 17440 bytes, maximum size is 8191

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

How reproducible:
always

Steps to Reproduce:
1. Have a Capsule (unassigned LCE right now).
2. Prepare the content to sync
a) Sync several repos, I used these for example:
ansible-2.9-for-rhel-8-x86_64-rpms
rhel-7-server-ansible-2.9-rpms
rhel-7-server-kickstart
rhel-7-server-rpms
rhel-8-for-x86_64-baseos-kickstart
rhel-8-for-x86_64-baseos-rpms
rhel-9-for-x86_64-baseos-kickstart
rhel-9-for-x86_64-baseos-rpms
rhel-6-server-els-satellite-client-6-rpms
rhel-7-server-satellite-client-6-rpms
satellite-client-6-for-rhel-8-x86_64-rpms
satellite-client-6-for-rhel-9-x86_64-rpms
b) Create 10 LCEs.
c) Create 10 CVs, add all the repos, publish and promote to all LCEs from 2b).
3. Assign the Capsule with Library and all the LCEs from 2b).
4. Sync the Capsule.

Actual results:
After sync is done the Update Content Counts task is spawned and it fails with the PG::ProgramLimitExceeded error

Expected results:
The task should succeed without errors.


Related issues 1 (0 open1 closed)

Has duplicate Katello - Bug #37105: Running Smatproxy UpdateContentCounts fails on smartproxies with ActiveRecord::StatementInvalid: PG::ProgramLimitExceeded: ERROR: index row requires 9280 bytes, maximum size is 8191DuplicateActions
Actions #1

Updated by Ian Ballou 10 months ago

  • Subject changed from PG::ProgramLimitExceeded error for Update content counts task on a big setup to PG::ProgramLimitExceeded error for Update content counts task on a big setup
  • Assignee set to Ian Ballou
  • Target version set to Katello 4.11.1
Actions #2

Updated by The Foreman Bot 10 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/10855 added
Actions #3

Updated by The Foreman Bot 10 months ago

  • Fixed in Releases Katello 4.12.0 added
Actions #4

Updated by Anonymous 10 months ago

  • Status changed from Ready For Testing to Closed
Actions #5

Updated by Partha Aji 10 months ago

  • Triaged changed from No to Yes
Actions #6

Updated by Jeremy Lenz 10 months ago

  • Has duplicate Bug #37105: Running Smatproxy UpdateContentCounts fails on smartproxies with ActiveRecord::StatementInvalid: PG::ProgramLimitExceeded: ERROR: index row requires 9280 bytes, maximum size is 8191 added
Actions #7

Updated by Ian Ballou 9 months ago

  • Pull request deleted (https://github.com/Katello/katello/pull/10855)
  • Fixed in Releases Katello 4.11.1 added
Actions #8

Updated by The Foreman Bot 9 months ago

  • Fixed in Releases Katello 4.11.2 added
Actions #9

Updated by The Foreman Bot 9 months ago

  • Pull request https://github.com/Katello/katello/pull/10920 added
Actions

Also available in: Atom PDF