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

Поиск
Список
Период
Сортировка
От Alexandra Nitzschke
Тема could not read block 77 of relation 1663/16385/388818775
Дата
Msg-id 49253A5E.6000602@clickware.de
обсуждение исходный текст
Ответы Re: could not read block 77 of relation 1663/16385/388818775  (Craig Ringer <craig@postnewspapers.com.au>)
Re: could not read block 77 of relation 1663/16385/388818775  (Rafael Martinez <r.m.guerrero@usit.uio.no>)
Список pgsql-bugs
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.

The output of pg_filedump of block 76 is ok.
The output of pg_filedump of block 77 is the following:

*******************************************************************
* PostgreSQL File/Block Formatted Dump Utility - Version 8.3.0
*
* File: /tmp/388818775
* Options used: -i -f -R 77
*
* Dump created on: Thu Nov 20 11:18:26 2008
*******************************************************************
Error: Premature end of file encountered.


If you like we could send the data file to you.


Regards,

   A. Nitzschke

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

Предыдущее
От: Tomasz Ostrowski
Дата:
Сообщение: Re: substring with this pattern works in 8.3.1; does not work in 8.3.4
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: could not read block 77 of relation 1663/16385/388818775