public inbox for [email protected]  

help / color / mirror / Atom feed
From: Wasim Devale <[email protected]>
To: Ron Johnson <[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 20:10:01 +0530
Message-ID: <CAB5fag7qvvgqMMtDJQfg5LZqsHvQeQVJzEwrCxbjM3A=N1bqPg@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaBsA60vJEG2fGKRiGAuo_soLVwFcGVsZrD3iHPA_Js1+A@mail.gmail.com>
References: <CAB5fag444HCM8xONrKbg+rJ5odCdy=0vmianN2Si5K5mWRFKvQ@mail.gmail.com>
	<CAB5fag6QPm1OE7H6roywzovDxb9rT9Wx-MdeiuK=mDvx6NTwtw@mail.gmail.com>
	<CAKFQuwbHt_56dOP-Fjtaj2C9KVJN14-L9LrDUf5AeWyW21g7KQ@mail.gmail.com>
	<CAB5fag7hsyWJUv=KezM=10RZ8hs=3fDkR4vMmJvn-Fjv3O0oeA@mail.gmail.com>
	<CAKFQuwYyFBgKKtJwFAOOsd2NahG6g8ymFKy_KpqhcoHdb_Nd3g@mail.gmail.com>
	<CAB5fag47NNn4T1e-t7YkLkqQbdammAvgDeb423ThaY=VjkSTOQ@mail.gmail.com>
	<CAKFQuwYB3Af7e62rAFQQMi0G_he81ypqf5WtHvg9vHc-8276-Q@mail.gmail.com>
	<CANzqJaBsA60vJEG2fGKRiGAuo_soLVwFcGVsZrD3iHPA_Js1+A@mail.gmail.com>

I am not much aware that the application code is embedded in Java and the
groovy language.

The issue is resolved I did indexing concurrently on each primary key index
individually via a Linux command written in a file and executed it and
other indexes that has the btree indexing. This resolved it.

Thanks everyone.

On Thu, 15 Aug, 2024, 7:41 pm Ron Johnson, <[email protected]> wrote:

> On Wed, Aug 14, 2024 at 11:50 PM David G. Johnston <
> [email protected]> wrote:
>
>> On Wednesday, August 14, 2024, Wasim Devale <[email protected]> wrote:
>>
>>> Ok thanks for the insights.
>>>
>>> Do we need to do any config changes in the config file?
>>>
>>> We have also configured Datadog agent at operating system level that
>>> checks postgresql activity it's has the pgpouncer.d config file that is
>>> unchanged after the migration. This might be the possible reason that it is
>>> throughing dead lock error.
>>>
>>> Please through some insights on the above.
>>>
>>
>> Sounds like you need to read up on what a deadlock is, and then go figure
>> out what combination of SQL commands in your environment is causing it.
>> Only then does it make sense to reason through possible solutions.  Until
>> you can show some SQL commands I’m not of much help.  I’m not inclined to
>> teach what a deadlock is - such knowledge is available on the internet.
>>
>
> TBF, this is apparently the same application that was running "fine"
> before upgrading.
>
> OP has still done a non-existant job at telling us what version he
> upgraded from and to, how he upgraded and what he did afterwards.
>
> --
> Death to America, and butter sauce.
> Iraq lobster!
>


view thread (13+ messages)

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]
  Subject: Re: Dead lock after the migration from CentOS 7 to RHEL 9
  In-Reply-To: <CAB5fag7qvvgqMMtDJQfg5LZqsHvQeQVJzEwrCxbjM3A=N1bqPg@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