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

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

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: Alexandra Nitzschke <an(at)clickware(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: could not read block 77 of relation 1663/16385/388818775
Date: 2008-11-20 11:36:50
Message-ID: 49254BD2.6010205@usit.uio.no (view raw or flat)
Thread:
Lists: 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(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
 Center for Information Technology Services
 University of Oslo, Norway

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

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2008-11-20 14:20:42
Subject: Re: BUG #4529: lc_messages in config ignored
Previous:From: Craig RingerDate: 2008-11-20 11:33:04
Subject: Re: could not read block 77 of relation 1663/16385/388818775

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