Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group