[Satellite 6] Host registration fails with: Runtime Error could not obtain pessimistic lock at org.postgresql.core

Environment

• Satellite 6

Issue

• Bulk host registration sometimes fails with the following error:

Runtime Error could not obtain pessimistic lock at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse:2,675 (HTTP error code 500: Internal Server Error)

Resolution

• Apply tuning to your Satellite server. Specifically have a look at PostgreSQL tuning:
• Tuning Performance of Red Hat Satellite 6.12
• Satellite 6.11 Performance Tuning Guide
• Satellite 6.10 Performance Tuning Guide
• Satellite 6.9 Performance Tuning Guide

For more KB articles/solutions related to Red Hat Satellite 6.x Client Subscription Issues, please refer to the Red Hat Satellite Consolidated Troubleshooting Article for Red Hat Satellite 6.x Client Subscription Issues

Root Cause

• This has been reported in: This content is not included.Bug 1758115 - when satellite is under load, delete on host can fail
• It can affect various host operations (not just registrations/delete).

Diagnostic Steps

• Here the registration fails during provisioning process:

Starting the subscription-manager registration process
Updating Subscription Management repositories.
Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Error: There are no enabled repositories in "/etc/yum.repos.d", "/etc/yum/repos.d", "/etc/distro.repos.d".
Retrieving http://satellite.example.com/pub/katello-ca-consumer-latest.noarch.rpm
Verifying...                          ########################################
Preparing...                          ########################################
Updating / installing...
katello-ca-consumer-satellite.example.com-1.0########################################
Runtime Error could not obtain pessimistic lock at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse:2,675 (HTTP error code 500: Internal Server Error)
Updating Subscription Management repositories.
Unable to read consumer identity

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.