public inbox for [email protected]
help / color / mirror / Atom feedFrom: Wasim Devale <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Muhammad Waqas <[email protected]>
Cc: Pgsql-admin <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Dead lock after the migration from CentOS 7 to RHEL 9
Date: Thu, 15 Aug 2024 08:58:11 +0530
Message-ID: <CAB5fag7hsyWJUv=KezM=10RZ8hs=3fDkR4vMmJvn-Fjv3O0oeA@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwbHt_56dOP-Fjtaj2C9KVJN14-L9LrDUf5AeWyW21g7KQ@mail.gmail.com>
References: <CAB5fag444HCM8xONrKbg+rJ5odCdy=0vmianN2Si5K5mWRFKvQ@mail.gmail.com>
<CAB5fag6QPm1OE7H6roywzovDxb9rT9Wx-MdeiuK=mDvx6NTwtw@mail.gmail.com>
<CAKFQuwbHt_56dOP-Fjtaj2C9KVJN14-L9LrDUf5AeWyW21g7KQ@mail.gmail.com>
So it's not a postgresql issue. It's from the application side correct?
On Thu, 15 Aug, 2024, 8:56 am David G. Johnston, <[email protected]>
wrote:
> On Wednesday, August 14, 2024, Wasim Devale <[email protected]> wrote:
>
>> Hi please help me with the below email.
>>
>> ---------- Forwarded message ---------
>> From: Wasim Devale <[email protected]>
>> Date: Wed, 14 Aug, 2024, 11:09 am
>> Subject: Dead lock after the migration from CentOS 7 to RHEL 9
>> To: Pgsql-admin <[email protected]>, pgsql-admin <
>> [email protected]>
>>
>>
>> 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.
>>
>
> How are we supposed to help; you have the indicated log files, and
> application code, not us. It’s a bug in your code. And you haven’t asked
> any question that could be answered.
>
> David J.
>
>
view thread (13+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Dead lock after the migration from CentOS 7 to RHEL 9
In-Reply-To: <CAB5fag7hsyWJUv=KezM=10RZ8hs=3fDkR4vMmJvn-Fjv3O0oeA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox