BUG #7648: Momentary index corruption while in hot standby - Mailing list pgsql-bugs

From daniel@heroku.com
Subject BUG #7648: Momentary index corruption while in hot standby
Date
Msg-id E1TWxOH-0002Lx-QA@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7648: Momentary index corruption while in hot standby  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7648
Logged by:          Daniel Farina
Email address:      daniel@heroku.com
PostgreSQL version: 9.0.9
Operating system:   Ubuntu 10.04
Description:        =


At more or less one point in time exactly (the same second, at minimum), a
couple of errors were raised on a hot standby while performing query access
that would nominally suggest corruption were raised:

PGError: ERROR: could not read block 556642 in file "base/16385/2904143.4":
read only 0 of 8192 =


Immediately thereafter, no occurrences of the error resurfaced and any
attempts to reproduce the issue with an identical query were met with
failure.

On investigation, this relfile is a fairly common beast: an integer btree
index being used for row identification (e.g. serial).

This is reading from a 9.0.8 Postgres.

pgsql-bugs by date:

Previous
From: haribabu.kommi@huawei.com
Date:
Subject: BUG #7643: Issuing a shutdown request while server startup leads to server hang
Next
From: Jeff Davis
Date:
Subject: Re: BUG #7648: Momentary index corruption while in hot standby