Dead lock after the migration from CentOS 7 to RHEL 9

From: Wasim Devale <wasimd60(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Dead lock after the migration from CentOS 7 to RHEL 9
Date: 2024-08-14 05:39:22
Message-ID: CAB5fag444HCM8xONrKbg+rJ5odCdy=0vmianN2Si5K5mWRFKvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All

I am facing this issue while reindexing after migration. I analysed the
application holding the particular table. I stopped the application and
reindexed it. It went well then again I am facing this issue below.

ERROR: deadlock detected

DETAIL: Process 2197043 waits for AccessExclusiveLock on relation 10384355
of database 10163711; blocked by process 1889236.

Process 1889236 waits for RowExclusiveLock on relation 10168609 of database
10163711; blocked by process 2197043.

HINT: See server log for query details.

Thanks,
Wasim

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mohammed Afsar 2024-08-14 12:58:01 Reindex doesn’t not working replica nodes
Previous Message Ron Johnson 2024-08-13 14:54:19 Re: Assistance Required for Index Corruption Issue Post OS Upgrade to RHEL 8.x