Re: Dead lock after the migration from CentOS 7 to RHEL 9

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, <ronljohnsonjr(at)gmail(dot)com> wrote:

> On Wed, Aug 14, 2024 at 11:50 PM David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Wednesday, August 14, 2024, Wasim Devale <wasimd60(at)gmail(dot)com> 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!
>