Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not been created yet -- apparent wraparound - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not been created yet -- apparent wraparound
Date
Msg-id 87imz8stsw.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound  (Phil Hildebrand <phil.hildebrand@moz.com>)
List pgsql-bugs
>>>>> "Phil" == Phil Hildebrand <phil.hildebrand@moz.com> writes:

 Phil> Yeah - There's no sensitive data (it's public domain reviews).
 Phil> I've attached the hexdump

OK. The page is definitely corrupt starting at offset 0x1000 (i.e.
offset 4kB in the 8kB page), but it's harder than usual to spot because
(a) the tear is in the middle of a text field and (b) the data in the
second half of the page is actually from a page of what is presumably a
different partition of the same table (it has the same row structure,
but the data is from 2017 not 2018).

The split being on a 4k boundary points the finger at the hardware or
OS, since pg doesn't care about 4k hardware pages or 4k disk sectors but
rather does everything in 8k blocks.

-- 
Andrew.


pgsql-bugs by date:

Previous
From: Phil Hildebrand
Date:
Subject: Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
Next
From: Phil Hildebrand
Date:
Subject: Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound