Bug 2259163
| Summary: | PG::ProgramLimitExceeded error for Update content counts task on a big setup | ||
|---|---|---|---|
| Product: | Red Hat Satellite | Reporter: | Vladimír Sedmík <vsedmik> |
| Component: | Capsule - Content | Assignee: | Ian Ballou <iballou> |
| Status: | CLOSED ERRATA | QA Contact: | Vladimír Sedmík <vsedmik> |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 6.15.0 | CC: | ahumbe, iballou, rlavi, zhunting |
| Target Milestone: | 6.15.0 | Keywords: | Performance, Triaged, UserExperience |
| Target Release: | Unused | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | rubygem-katello-4.11.0.4-1 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2024-04-23 17:17:18 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: | |||
Created redmine issue https://projects.theforeman.org/issues/37080 from this bug Verified in 6.15.0 snap 8.0 - the Update Content Counts task succeeded without errors, content counts on the Capsule side match the CV counts 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 (Important: Satellite 6.15.0 release), 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-2024:2010 |
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): 6.15.0 snap 6.0 How reproducible: always Steps to Reproduce: 1. Have a Satellite with registered 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.