Re: Lock timeouts and unusual spikes in replication lag with logical parallel transaction streaming

Поиск
Список
Период
Сортировка
От Zane Duffield
Тема Re: Lock timeouts and unusual spikes in replication lag with logical parallel transaction streaming
Дата
Msg-id CACMiCkUJ6Pb7P4MdRB8g-YksXAgypZ7ZRYUHQ9u7nU-WiTxsLg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Lock timeouts and unusual spikes in replication lag with logical parallel transaction streaming  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: Lock timeouts and unusual spikes in replication lag with logical parallel transaction streaming
Список pgsql-bugs
Sorry for the late reply.

After some more testing, we are going ahead with `streaming = parallel`, with the change to reset `lock_timeout` to the default.

No, as per my understanding it is because parallel apply worker
exiting due to lock_timeout set in the test. Ideally, the patch
proposed by Kuroda-San should show in LOGs that the parallel worker is
exiting due to lock_timeout. Can you try that once?

I don't think I'll have time to compile a patched version and run the tests again, sorry. Have this information in the log probably would have made it easier to work this whole problem out, though, so I hope someone else can test out the change and get it merged.

Thanks for your help Amit, Hou-san, and Hayato-san.

Zane
 

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