Publishing a Content View with many similar contents throws the following database deadlock error - ActiveRecord::Deadlocked (PG::TRDeadlockDetected: ERROR: deadlock detected)

Solution Verified - Updated -

Issue

  • The following deadlock error is thrown when indexing contents of multiple repositories with many similar contents:

    ActiveRecord::Deadlocked (PG::TRDeadlockDetected: ERROR:  deadlock detected)
DETAIL:  Process 361390 waits for ShareLock on transaction 85433497; blocked by process 361035.
Process 361035 waits for ShareLock on transaction 85433498; blocked by process 361390.
HINT:  See server log for query details.
CONTEXT:  while inserting index tuple (1530,1) in relation "katello_errata"

Environment

  • Red Hat Satellite 6.14

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content