Bug #37080
closedPG::ProgramLimitExceeded error for Update content counts task on a big setup
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.
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
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
Updated by Anonymous 10 months ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|acbe320a17c16bf4239fbdd3ee78bb576f1b9fb4.
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
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
Updated by The Foreman Bot 9 months ago
- Pull request https://github.com/Katello/katello/pull/10920 added