Why does listLatestUpgradablePackages take long time to list packages ?

Solution Verified - Updated -

Environment

  • Red Hat Satellite 5.6

Issue

  • For few clients listLatestUpgradablePackages is taking long time to fetch package list from database.
  • API call is taking 30 min to 1 hr for few systems.

Resolution

This issue is fixed with release of Satellite 5.7. Please upgarde your satellite to 5.7 to fix this issue.

Diagnostic Steps

  • Verify output of query.
SELECT procpid,current_query FROM pg_stat_activity;

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.