Dead lock after the migration from CentOS 7 to RHEL 9

Поиск
Список
Период
Сортировка
От Wasim Devale
Тема Dead lock after the migration from CentOS 7 to RHEL 9
Дата
Msg-id CAB5fag444HCM8xONrKbg+rJ5odCdy=0vmianN2Si5K5mWRFKvQ@mail.gmail.com
обсуждение исходный текст
Ответы Fwd: 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
Дерево обсуждения
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

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