From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Peter Geoghegan <pg@bowt.ie>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: iijima.yun@koumakan.jp
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
Date: Mon, 25 Oct 2021 01:56:36 +0100
Message-ID: <87pmru6i9u.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <CAH2-Wzn4mNEPbQ2Jrs=0tfF=iDHNpi7dSgPy2k1iHMdswR11MA@mail.gmail.com>
References: <17245-ddf06aaf85735f36@postgresql.org>
<CAH2-Wzn4mNEPbQ2Jrs=0tfF=iDHNpi7dSgPy2k1iHMdswR11MA@mail.gmail.com>
>>>>> "Peter" == Peter Geoghegan <pg@bowt.ie> writes:
Peter> PostgreSQL 14 is the first version where the default
Peter> wal_sync_method is fdatasync() on FreeBSD -- though only with
Peter> FreeBSD 13. See commit f900a79e. Perhaps that has something to
Peter> do with the problem seen here.
Nope. The database in question was restored from a pg_dumpall backup
three weeks ago and I'm told there have been no crashes or even unclean
restarts since then.
Peter> I suspect that there was TID recycling by VACUUM involved here.
That also doesn't seem likely from the heap page images I saw, which
suggested a fairly low update rate, HOT updates, and page cleanup rather
than much vacuum activity (in particular there were several LP_REDIRECT
pointers and few free pointers).
--
Andrew (irc:RhodiumToad)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: andrew@tao11.riddles.org.uk, pg@bowt.ie, pgsql-bugs@lists.postgresql.org, thomas.munro@gmail.com, iijima.yun@koumakan.jp
Subject: Re: BUG #17245: Index corruption involving deduplicated entries
In-Reply-To: <87pmru6i9u.fsf@news-spur.riddles.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox