RE: "ERROR: deadlock detected" when replicating TRUNCATE

Поиск
Список
Период
Сортировка
От tanghy.fnst@fujitsu.com
Тема RE: "ERROR: deadlock detected" when replicating TRUNCATE
Дата
Msg-id OS0PR01MB611354A48D0AE47E708D6BB5FB2D9@OS0PR01MB6113.jpnprd01.prod.outlook.com
обсуждение исходный текст
Ответ на Re: "ERROR: deadlock detected" when replicating TRUNCATE  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Monday, May 17, 2021 5:47 PM, Amit Kapila <amit.kapila16@gmail.com> wrote
> +$node_publisher->safe_psql('postgres',
> + "ALTER SYSTEM SET synchronous_standby_names TO 'any 2(sub5_1,
> sub5_2)'");
> +$node_publisher->safe_psql('postgres', "SELECT pg_reload_conf()");
> 
> Do you really need these steps to reproduce the problem? IIUC, this
> has nothing to do with synchronous replication.

Agreed. 
I tested in asynchronous mode, and could reproduce this problem, too.

The attached patch removed the steps for setting synchronous replication.
And the test passed after applying Peter's patch.
Please take it as your reference.

Regards
Tang


Вложения

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

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: "ERROR: deadlock detected" when replicating TRUNCATE
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Forget close an open relation in ReorderBufferProcessTXN()