Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby.

Поиск
Список
Период
Сортировка
Искать
От
Simon Riggs
Тема
Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby.
Дата
Msg-id
1224732709.27145.553.camel@ebony.2ndQuadrant
Ответ на
Список
Дерево обсуждения
Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby. Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby. Simon Riggs <simon@2ndQuadrant.com>
Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby. Tom Lane <tgl@sss.pgh.pa.us>
Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby. Simon Riggs <simon@2ndQuadrant.com>
Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby. Alvaro Herrera <alvherre@commandprompt.com>
Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby. Simon Riggs <simon@2ndQuadrant.com>

On Wed, 2008-10-22 at 13:25 -0400, Tom Lane wrote:

> I can't reproduce this 100% reliably, but the case where I saw it came
> from mistakenly inserting
> 	Assert(!IsA(node, AppendRelInfo));
> into flatten_join_alias_vars_mutator and then running the serial
> regression tests.  This case *can* happen, but it doesn't occur
> until late in the regression tests.  The recovery ensuing from the
> assert failure crashes maybe one time in two --- likely has something
> to do with when the last checkpoint happened.

This seems like a useful type of test.

Can we change regression tests so that we avoid checkpoints, then crash
at the end of the test and go through recovery process? That would be a
neat way of including a recovery check in with each make check. 

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support


В списке pgsql-hackers по дате отправления
От: Simon Riggs
Дата:
FAQ