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
Ответ на
Re: archive status ".ready" files may be created too early (alvherre@alvh.no-ip.org)
Список
Дерево обсуждения
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
Дата: