BUG #7648: Momentary index corruption while in hot standby

Поиск
Список
Период
Сортировка
От daniel@heroku.com
Тема BUG #7648: Momentary index corruption while in hot standby
Дата
Msg-id E1TWxOH-0002Lx-QA@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7648: Momentary index corruption while in hot standby  (Jeff Davis <pgsql@j-davis.com>)
Список 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 по дате отправления:

Предыдущее
От: haribabu.kommi@huawei.com
Дата:
Сообщение: BUG #7643: Issuing a shutdown request while server startup leads to server hang
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: BUG #7648: Momentary index corruption while in hot standby