Re: BUG #5703: Streaming replication: FATAL: bad buffer id: 0 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5703: Streaming replication: FATAL: bad buffer id: 0
Date
Msg-id 25449.1286814871@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5703: Streaming replication: FATAL: bad buffer id: 0  ("Evgeniy" <efreet@efreet.ru>)
Responses Re: BUG #5703: Streaming replication: FATAL: bad buffer id: 0  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
"Evgeniy" <efreet@efreet.ru> writes:
> Standby server dies after some minutes with FATAL message:

> 2010-10-11 19:12:17.129 MSD [13864/0]: [5-1] user=,db= LOG:  consistent
> recovery state reached at E/A5DCD3A8
> 2010-10-11 19:12:17.139 MSD [13864/0]: [6-1] user=,db= FATAL:  bad buffer
> id: 0
> 2010-10-11 19:12:17.139 MSD [13864/0]: [7-1] user=,db= CONTEXT:  xlog redo
> Delete list pages (16), node: 1663/18241/93940 blkno: 21207

Hmm ... that seems to be a GIN index message ... and a bit of looking at
the GIN code says that its xlog replay logic is many bricks shy of a
load.  I think SR is exposing a pre-existing problem here.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Evgeniy"
Date:
Subject: BUG #5703: Streaming replication: FATAL: bad buffer id: 0
Next
From: Dave Page
Date:
Subject: Re: BUG #5699: Postgres runs only under default user.