Re: [BUG] non archived WAL removed during production crash recovery
От
Michael Paquier
Тема
Re: [BUG] non archived WAL removed during production crash recovery
Дата
Msg-id
20200424070510.GM33034@paquier.xyz
Ответ на
Список
Дерево обсуждения
[BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Andres Freund <andres@anarazel.de>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Tom Lane <tgl@sss.pgh.pa.us>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Michael Paquier <michael@paquier.xyz>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
Re: [BUG] non archived WAL removed during production crash recovery Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
Re: [BUG] non archived WAL removed during production crash recovery Fujii Masao <masao.fujii@oss.nttdata.com>
On Thu, Apr 23, 2020 at 06:48:56PM -0700, Andres Freund wrote: > But don't we pretty much know this already from the state of the system? > During crash recovery there's nothing running RemoveOldXLogFiles() but > the startup process. Right? And in DB_IN_ARCHIVE_RECOVERY it should only > happen as part of restartpoints (i.e. the checkpointer). > > Did you add the new shared state to avoid deducing things from the > "environment"? If so, it should really be mentioned in the commit > message & code. Because: Hmm. Sorry, I see your point. The key of the logic here is from XLogArchiveCheckDone() which could be called from other processes than the startup process. There is one code path at the end of a base backup for backup history files where not using a shared state would be a problem. -- Michael
В списке pgsql-bugs по дате отправления
От: David Rowley
Дата:
От: PG Bug reporting form
Дата: