Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock
От
Andres Freund
Тема
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock
Дата
Msg-id
20220817184534.333uwbebj3rp4gph@awork3.anarazel.de
Ответ на
Список
Дерево обсуждения
hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Mark Dilger <mark.dilger@enterprisedb.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Thomas Munro <thomas.munro@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Thomas Munro <thomas.munro@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Tom Lane <tgl@sss.pgh.pa.us>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock vignesh C <vignesh21@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock vignesh C <vignesh21@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Peter Geoghegan <pg@bowt.ie>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Peter Geoghegan <pg@bowt.ie>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Tom Lane <tgl@sss.pgh.pa.us>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Amit Kapila <amit.kapila16@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Andres Freund <andres@anarazel.de>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock vignesh C <vignesh21@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Thomas Munro <thomas.munro@gmail.com>
Re: hash_xlog_split_allocate_page: failed to acquire cleanup lock Robert Haas <robertmhaas@gmail.com>
Hi, On 2022-08-17 08:25:06 -0400, Robert Haas wrote: > Regarding the question of whether we need a cleanup lock on the new > bucket I am not really seeing the advantage of going down that path. > Simply fixing this code to take a cleanup lock instead of hoping that > it always gets one by accident is low risk and should fix the observed > problem. Getting rid of the cleanup lock will be more invasive and I'd > like to see some evidence that it's a necessary step before we take > the risk of breaking things. Given that the cleanup locks in question are "taken" *after* re-initializing the page, I'm doubtful that's a sane path forward. It seems quite likely to mislead somebody to rely on it working as a cleanup lock in the future. Greetings, Andres Freund
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата: