Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem?
Дата
Msg-id 20140226220342.GJ4759@eldon.alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem?  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: Another possible corruption bug in 9.3.2 or possibly a known MultiXact problem?  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
I forgot to mention that the bug can be reproduced in a hot-standby
setup with the attached isolation spec.  Note that full_page_writes must
be turned off (otherwise, the updates use full-page writes and then the
bogus code is not run).  Once the spec is executed, in the replica run

SET enable_seqscan TO off;
SELECT * FROM f WHERE a=1;

and you get no rows back.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Вложения

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: jsonb and nested hstore
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: extension_control_path