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

Поиск
Список
Период
Сортировка
От Wasim Devale
Тема Re: Dead lock after the migration from CentOS 7 to RHEL 9
Дата
Msg-id CAB5fag47NNn4T1e-t7YkLkqQbdammAvgDeb423ThaY=VjkSTOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dead lock after the migration from CentOS 7 to RHEL 9  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Dead lock after the migration from CentOS 7 to RHEL 9
Re: Dead lock after the migration from CentOS 7 to RHEL 9
Список pgsql-admin

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.

Thanks for the immediate help.

Regards,
Wasim

On Thu, 15 Aug, 2024, 9:01 am David G. Johnston, <david.g.johnston@gmail.com> wrote:
On Wednesday, August 14, 2024, Wasim Devale <wasimd60@gmail.com> wrote:

So it's not a postgresql issue. It's from the application side correct?


That’s the assumption.  The vast majority of locks happen because the “application” executed SQL commands.

David J.

В списке pgsql-admin по дате отправления: