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
Ответ на
Re: BUG #8673: Could not open file "pg_multixact/members/xxxx" on slave during hot_standby (Tom Lane)
Список
Дерево обсуждения
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
Дата: