Re: archive status ".ready" files may be created too early

Поиск
Список
Период
Сортировка
Искать
От
alvherre@alvh.no-ip.org
Тема
Re: archive status ".ready" files may be created too early
Дата
Msg-id
202108231730.qrifplqfm27i@alvherre.pgsql
Ответ на
Список
Дерево обсуждения
archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@2ndquadrant.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Fujii Masao <masao.fujii@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
RE: archive status ".ready" files may be created too early "matsumura.ryo@fujitsu.com" <matsumura.ryo@fujitsu.com>
Re: archive status ".ready" files may be created too early Michael Paquier <michael@paquier.xyz>
Re: archive status ".ready" files may be created too early Heikki Linnakangas <hlinnaka@iki.fi>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Andrey Borodin <x4mmm@yandex-team.ru>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andres Freund <andres@anarazel.de>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Michael Paquier <michael@paquier.xyz>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "alvherre@alvh.no-ip.org" <alvherre@alvh.no-ip.org>
Re: archive status ".ready" files may be created too early Fujii Masao <masao.fujii@oss.nttdata.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Robert Haas <robertmhaas@gmail.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Andrey Borodin <x4mmm@yandex-team.ru>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early "Bossart, Nathan" <bossartn@amazon.com>
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi <horikyota.ntt@gmail.com>
On 2021-Aug-23, alvherre@alvh.no-ip.org wrote:

> The only way .ready files are created is that XLogNotifyWrite() is
> called.  For regular WAL files during regular operation, that only
> happens in XLogNotifyWriteSeg().  That, in turn, only happens in
> NotifySegmentsReadyForArchive().  But if the system runs and never
> writes WAL records that cross WAL boundaries, that function will see
> that both earliestSegBoundary and latestSegBoundary are MaxXLogSegno,
> and return without doing anything.  So no segments will be notified.

Nevermind -- I realized that all segments get registered, not just those
for which we generate continuation records.

-- 
Álvaro Herrera           39°49'30"S 73°17'W  —  https://www.EnterpriseDB.com/
"Use it up, wear it out, make it do, or do without"


В списке pgsql-hackers по дате отправления
От: alvherre@alvh.no-ip.org
Дата:
От: Mark Dilger
Дата:
FAQ