Re: B-tree crash recovery error in 8.3 beta 2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: Koichi Suzuki <suzuki(dot)koichi(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: B-tree crash recovery error in 8.3 beta 2
Date: 2007-11-16 19:55:22
Message-ID: 1496.1195242922@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Heikki Linnakangas <heikki(at)enterprisedb(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Hussain Jawad-FXRM43 2007-11-17 00:19:37 Start up error
Previous Message Tom Lane 2007-11-16 16:00:14 Re: BUG #3752: query yields "could not find block containing chunk", then server crashes