Lists: | pgsql-bugs |
---|
From: | "Evgeniy" <efreet(at)efreet(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #5703: Streaming replication: FATAL: bad buffer id: 0 |
Date: | 2010-10-11 15:50:36 |
Message-ID: | 201010111550.o9BFoa8u045564@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5703
Logged by: Evgeniy
Email address: efreet(at)efreet(dot)ru
PostgreSQL version: 9.0.1
Operating system: linux
Description: Streaming replication: FATAL: bad buffer id: 0
Details:
SR doesn't work for me:
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
2010-10-11 19:12:17.191 MSD [13855/0]: [1-1] user=,db= LOG: startup process
(PID 13864) exited with exit code 1
2010-10-11 19:12:17.192 MSD [13855/0]: [2-1] user=,db= LOG: terminating any
other active server processes
What else logs or configuration files should I attach?
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Evgeniy" <efreet(at)efreet(dot)ru> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5703: Streaming replication: FATAL: bad buffer id: 0 |
Date: | 2010-10-11 16:34:31 |
Message-ID: | 25449.1286814871@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"Evgeniy" <efreet(at)efreet(dot)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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Evgeniy" <efreet(at)efreet(dot)ru> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5703: Streaming replication: FATAL: bad buffer id: 0 |
Date: | 2010-10-11 23:07:19 |
Message-ID: | 7582.1286838439@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
I wrote:
> 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.
Actually, it's been broken since 8.2 :-(. I've applied a patch.
regards, tom lane