Re: Adding a TAP test checking data consistency on standby withminRecoveryPoint

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Adding a TAP test checking data consistency on standby withminRecoveryPoint
Дата
Msg-id 20181108052548.GF1222@paquier.xyz
обсуждение исходный текст
Ответ на Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-hackers
On Thu, Nov 08, 2018 at 05:04:35AM +0000, Andrew Gierth wrote:
> How? It's OK (and normal) for in-core pages to have newer LSNs than
> minRecoveryPoint, it's only on-disk pages that must not be more recent
> than that. And pageinspect will show the in-core page...

If the standby is stopped cleanly once, what's in shared buffers gets
flushed to disk by the checkpointer once at shutdown, forcing
minRecoveryPoint to be updated by the checkpointer, and that update was
not happening beforethe fix.  And once the standby is started again,
what's on disk gets reloaded, showing the inconsistency.
--
Michael

Вложения

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [HACKERS] [PATCH] Generic type subscripting
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query