Re: B-tree crash recovery error in 8.3 beta 2 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: B-tree crash recovery error in 8.3 beta 2
Date
Msg-id 1496.1195242922@sss.pgh.pa.us
Whole thread Raw
In response to Re: B-tree crash recovery error in 8.3 beta 2  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-bugs
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> There seems to be a bug in the B-tree split WAL reduction patch from
> Februrary. On split, we copy the HIKEY of the left page from the
> leftmost item on the right page, but that doesn't work because the
> leftmost key is not stored on intermediate levels.
> Patch attached that stores the high key explicitly in the WAL record on
> intermediate levels.

Applied with revisions --- mostly, being safe about alignment issues.
You wouldn't notice that on an Intel CPU, but some machines are
pickier ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #3752: query yields "could not find block containing chunk", then server crashes
Next
From: "Hussain Jawad-FXRM43"
Date:
Subject: Start up error