Uploaded image for project: 'Satellite'
  1. Satellite
  2. SAT-22577 PG::ProgramLimitExceeded error for Update content counts task on a big setup
  3. SAT-22611

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

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Undefined Undefined
    • None
    • None
    • Capsule - Content
    • Sprint 127

      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.

      DEV Tracker for https://issues.redhat.com/browse/SAT-22577
      Bugzilla: https://bugzilla.redhat.com/show_bug.cgi?id=2259163

              iballou@redhat.com Ian Ballou
              satellite-focaccia-bot Focaccia Bot
              Partha Aji Partha Aji
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: