Re: Corruption during WAL replay

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Corruption during WAL replay
Дата
Msg-id
3170060.1648171358@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Corruption during WAL replay Teja Mupparti <tejeswarm@hotmail.com>
Re: Corruption during WAL replay Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Corruption during WAL replay Andres Freund <andres@anarazel.de>
Re: Corruption during WAL replay Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Corruption during WAL replay Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Corruption during WAL replay Andres Freund <andres@anarazel.de>
Re: Corruption during WAL replay Teja Mupparti <tejeswarm@hotmail.com>
Re: Corruption during WAL replay Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Corruption during WAL replay Andres Freund <andres@anarazel.de>
Re: Corruption during WAL replay Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Re: Corruption during WAL replay Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Corruption during WAL replay Teja Mupparti <tejeswarm@hotmail.com>
Wait profiling Daniel Wood <hexexpert@comcast.net>
Re: Wait profiling Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Wait profiling Julien Rouhaud <rjuju123@gmail.com>
Re: Corruption during WAL replay Heikki Linnakangas <hlinnaka@iki.fi>
Re: Corruption during WAL replay Andres Freund <andres@anarazel.de>
Re: Corruption during WAL replay Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Corruption during WAL replay Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Corruption during WAL replay Masahiko Sawada <sawada.mshk@gmail.com>
Re: Corruption during WAL replay Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Corruption during WAL replay Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Robert Haas  writes:
> I hate to say "no" because the evidence suggests that the answer might
> be "yes" -- but it definitely isn't intending to change anything about
> the shutdown sequence. It just introduces a mechanism to backends to
> force the checkpointer to delay writing the checkpoint record.

Wait a minute, I think we may be barking up the wrong tree.

The three commits that serinus saw as new in its first failure were

ce95c54376 Thu Mar 24 20:33:13 2022 UTC  Fix pg_statio_all_tables view for multiple TOAST indexes. 
7dac61402e Thu Mar 24 19:51:40 2022 UTC  Remove unused module imports from TAP tests 
412ad7a556 Thu Mar 24 18:52:28 2022 UTC  Fix possible recovery trouble if TRUNCATE overlaps a checkpoint.

I failed to look closely at dragonet, but I now see that its
first failure saw

ce95c54376 Thu Mar 24 20:33:13 2022 UTC  Fix pg_statio_all_tables view for multiple TOAST indexes. 
7dac61402e Thu Mar 24 19:51:40 2022 UTC  Remove unused module imports from TAP tests

serinus is 0-for-3 since then, and dragonet 0-for-4, so we can be pretty
confident that the failure is repeatable for them.  That means that the
culprit must be ce95c54376 or 7dac61402e, not anything nearby such as
412ad7a556.

It's *really* hard to see how the pg_statio_all_tables change could
have affected this.  So that leaves 7dac61402e, which did this to
the test script that's failing:
 
 use strict;
 use warnings;
-use Config;
 use PostgreSQL::Test::Cluster;
 use PostgreSQL::Test::Utils;

Discuss.

			regards, tom lane


В списке pgsql-hackers по дате отправления
От: Yugo NAGATA
Дата:
От: Andres Freund
Дата:
FAQ