Postgres Pro
Downloads
Home   >   mailing lists

Dead lock after the migration from CentOS 7 to RHEL 9 - Mailing list pgsql-admin

From Wasim Devale
Subject Dead lock after the migration from CentOS 7 to RHEL 9
Date
Msg-id CAB5fag444HCM8xONrKbg+rJ5odCdy=0vmianN2Si5K5mWRFKvQ@mail.gmail.com
Whole thread Raw
Responses Fwd: Dead lock after the migration from CentOS 7 to RHEL 9
Re: Dead lock after the migration from CentOS 7 to RHEL 9
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Assistance Required for Index Corruption Issue Post OS Upgrade to RHEL 8.x
Next
From: Mohammed Afsar
Date:
Subject: Reindex doesn’t not working replica nodes