Re: could not read block 77 of relation 1663/16385/388818775

Поиск
Список
Период
Сортировка
От Rafael Martinez
Тема Re: could not read block 77 of relation 1663/16385/388818775
Дата
Msg-id 49254BD2.6010205@usit.uio.no
обсуждение исходный текст
Ответ на could not read block 77 of relation 1663/16385/388818775  (Alexandra Nitzschke <an@clickware.de>)
Список pgsql-bugs
Alexandra Nitzschke wrote:
> Hi,
>
> we encountered the following error while inserting a record into a table:
>
> org.postgresql.util.PSQLException: ERROR: could not read block 77 of
> relation 1663/16385/388818775: read only 0 of 8192 bytes
>
> Using postgres 8.3.5
>
> The reported object is an index.
> The size of its data file is 630784 bytes.
>

Hello

You have probably a harware issue and data in your disk is corrupted.

Probably a reindex of this index will fix this problem. But I would take
a backup of this system right away just in case your disk is dying.

regards
--
 Rafael Martinez, <r.m.guerrero@usit.uio.no>
 Center for Information Technology Services
 University of Oslo, Norway

 PGP Public Key: http://folk.uio.no/rafael/

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: could not read block 77 of relation 1663/16385/388818775
Следующее
От: Sushil
Дата:
Сообщение: executing SELECT xmlelement(name foo); causes "server closed the connection unexpectedly" Error