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

From: Mayank Mittal <mayank(dot)mittal(dot)1982(at)outlook(dot)com>
To: "mayank(dot)mittal(dot)1982(at)hotmail(dot)com" <mayank(dot)mittal(dot)1982(at)hotmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes
Date: 2012-09-20 16:44:42
Message-ID: COL002-W116226DCA4E62088445BF8CC69A0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Here is a snapshot of installed postgresql packages:
mayank(at)server:~$ dpkg -l | grep postgres

ii
postgresql-9.1
9.1.5-1~bpo60+1
object-relational SQL database, version 9.1 server

ii
postgresql-client-9.1
9.1.5-1~bpo60+1
front-end programs for PostgreSQL 9.1

ii
postgresql-client-common
130~bpo60+1
manager for multiple PostgreSQL client versions

ii postgresql-common
130~bpo60+1
PostgreSQL database-cluster manager

ii
postgresql-contrib
9.1+130~bpo60+2
additional facilities for PostgreSQL (supported
version)

ii
postgresql-contrib-9.1
9.1.5-1~bpo60+1
additional facilities for PostgreSQL
Regards,
Mayank Mittal

> Date: Thu, 20 Sep 2012 16:15:11 +0000
> Subject: [BUGS] BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes
> To: pgsql-bugs(at)postgresql(dot)org
> From: mayank(dot)mittal(dot)1982(at)hotmail(dot)com
>
> The following bug has been logged on the website:
>
> Bug reference: 7562
> Logged by: Mayank Mittal
> Email address: mayank(dot)mittal(dot)1982(at)hotmail(dot)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.
> I'm not sure why this is happening. I was referring release notes of 9.1.3
> and found similar issue is already fixed in it, but we are facing the same.
>
>
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-09-20 17:15:17 Re: BUG #7562: could not read block 0 in file "base/16385/16585": read only 0 of 8192 bytes
Previous Message Tom Lane 2012-09-20 16:23:07 Re: BUG #7559: syslogger doesn't close stdout and stderr