Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby
Дата
Msg-id
20140606171656.GF10482@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby petr@petrovich.kiev.ua
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Andres Freund <andres@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Jeff Janes <jeff.janes@gmail.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Alvaro Herrera <alvherre@2ndquadrant.com>
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby Serge Negodyuck <petr@petrovich.kiev.ua>
On 2014-06-06 13:04:29 -0400, Tom Lane wrote:
> Alvaro Herrera  writes:
> > After some simplification I think it should be clearer.  Thanks Andres
> > for commenting offlist.
> 
> I find this not only unreadable but a bit scary:
> 
> ! 		if (offset + MAX_MEMBERS_IN_LAST_MEMBERS_PAGE < offset)
> 
> I'm worried whether some compilers might not decide that that's a
> can't-happen situation, and optimize the test away entirely.

offset is a (via typedefs) uint32 and unsigned overflow is defined in
the C standard, so that shouldn't be a allowed optimization. Don't we
already have a fair amount of similar tests around? Around TransactionId
wraparound for exzmple:
	xidWrapLimit = oldest_datfrozenxid + (MaxTransactionId >> 1);
	if (xidWrapLimit < FirstNormalTransactionId)
		xidWrapLimit += FirstNormalTransactionId;
and similar things.

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: Alvaro Herrera
Дата:
FAQ