On Mon, Mar 18, 2019 at 12:53 PM Alexander Korotkov <[email protected]> wrote: > I've discovered bug, when vacuum full fails with error, because it > couldn't find toast chunks deleted by itself. That happens because > cluster_rel() sets OldestXmin, but toast accesses gets snapshot later > and independently. That causes heap_page_prune_opt() to clean chunks, > which rebuild_relation() expects to exist. This bug very rarely > happens on busy systems which actively update toast values. But I > found way to reliably reproduce it using debugger.
Boy, I really feel like we've talked about this before. These are somewhat-related discussions, but none of them are exactly the same thing: http://postgr.es/m/[email protected] http://postgr.es/m/[email protected] http://postgr.es/m/[email protected] I don't know whether we've actually talked about this precise problem before and I just can't find the thread, or whether I'm confusing what you've found here with some closely-related issue. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
