Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes
Date
Msg-id 25722.1348161317@sss.pgh.pa.us
Whole thread Raw
In response to BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes  (mayank.mittal.1982@hotmail.com)
Responses Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes  (Mayank Mittal <mayank.mittal.1982@hotmail.com>)
Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
mayank.mittal.1982@hotmail.com writes:
> The following bug has been logged on the website:
> Bug reference:      7562
> Logged by:          Mayank Mittal
> Email address:      mayank.mittal.1982@hotmail.com
> PostgreSQL version: 9.1.5
> Operating system:   Debian Linux 6.0
> Description:

> We are using 2 node set-up of PostgreSQL 9.1.5 in which one is master and
> other is slave which is in sync of master with streaming replication.
> The design is in such a way that in case of master node failure the slave
> node has to take master role. I'm controlling this behaviour using Corosync
> and Heartbeat.
> My application is requirement needs heavy database updates. Upon fail-over
> I've noticed that database indexes got corrupted.

Hmm.  There is a fix for a slave-side-index-corruption problem in 9.1.6,
which is due to be announced Monday.  I am not certain whether this is
the same thing though; that bug is low-probability as far as we can
tell (it would only happen if the master had been in the middle of an
index page split or page deletion at the instant of failover).  Anyway
the first thing to find out is whether 9.1.6 fixes it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7559: syslogger doesn't close stdout and stderr
Next
From: Mayank Mittal
Date:
Subject: Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes