From: | Wasim Devale <wasimd60(at)gmail(dot)com> |
---|---|
To: | Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Fwd: Dead lock after the migration from CentOS 7 to RHEL 9 |
Date: | 2024-08-15 03:21:10 |
Message-ID: | CAB5fag6QPm1OE7H6roywzovDxb9rT9Wx-MdeiuK=mDvx6NTwtw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi please help me with the below email.
---------- Forwarded message ---------
From: Wasim Devale <wasimd60(at)gmail(dot)com>
Date: Wed, 14 Aug, 2024, 11:09 am
Subject: Dead lock after the migration from CentOS 7 to RHEL 9
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <
pgsql-admin(at)postgresql(dot)org>
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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2024-08-15 03:26:48 | Re: Dead lock after the migration from CentOS 7 to RHEL 9 |
Previous Message | tiamoh m | 2024-08-14 17:00:46 | LIsten Errror |