Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group