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

From: Alexandra Nitzschke <an(at)clickware(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: could not read block 77 of relation 1663/16385/388818775
Date: 2008-11-20 10:22:22
Message-ID: 49253A5E.6000602@clickware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2008-11-20 11:33:04 Re: could not read block 77 of relation 1663/16385/388818775
Previous Message Tomasz Ostrowski 2008-11-20 09:30:57 Re: substring with this pattern works in 8.3.1; does not work in 8.3.4