Postgres Pro
Downloads
Home   >   mailing lists

could not read block 77 of relation 1663/16385/388818775 - Mailing list pgsql-bugs

From Alexandra Nitzschke
Subject could not read block 77 of relation 1663/16385/388818775
Date
Msg-id 49253A5E.6000602@clickware.de
Whole thread Raw
Responses 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>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: substring with this pattern works in 8.3.1; does not work in 8.3.4
Next
From: Craig Ringer
Date:
Subject: Re: could not read block 77 of relation 1663/16385/388818775