Re: 2-phase commit

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 2-phase commit
Дата
Msg-id 1703.1064642378@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 2-phase commit  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: 2-phase commit  (Richard Huxton <dev@archonet.com>)
Re: 2-phase commit  ("Marc G. Fournier" <scrappy@postgresql.org>)
Список pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> ... You can make this work, but the resource costs
>> are steep.

> So, after 'n' seconds of waiting, we abandon the slave and the slave
> abandons the master.

[itch...]  But you surely cannot guarantee that the slave and the master
time out at exactly the same femtosecond.  What happens when the comm
link comes back online just when one has timed out and the other not?
(Hint: in either order, it ain't good.  Double plus ungood if, say, the
comm link manages to deliver the master's "commit confirm" message a
little bit after the master has timed out and decided to abort after all.)

In my book, timeout-based solutions to this kind of problem are certain
disasters.
        regards, tom lane


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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: invalid tid errors in latest 7.3.4 stable.