Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl
От
Tom Lane
Тема
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl
Дата
Msg-id
15459.1499045039@sss.pgh.pa.us
Ответ на
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl (Michael Paquier)
Список
Дерево обсуждения
[HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Race-like failure in recovery/t/009_twophase.pl Tom Lane <tgl@sss.pgh.pa.us>
Michael Paquier writes: > On Mon, Jul 3, 2017 at 7:02 AM, Tom Lane wrote: >> Anyone have a different view of what to fix here? > No, this sounds like a good plan. What do you think about the attached? Oh, that's a good way. I just finished testing a fix that involved not turning on the second server's sync commit until later (it seems that only the first action on "paris" is really at risk currently). But disabling sync commit for individual transactions is clearly cleaner and more extensible to future test script changes. FWIW, I just got done doing a few check-world cycles with the delay in WalReceiverMain plus speeding up pg_ctl.c to WAITS_PER_SEC = 1000. No other problems seem to be revealed this way. regards, tom lane
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата: