Alexandra Nitzschke wrote:
> 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.
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.
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 Momjian||Date: 2008-11-20 14:20:42|
|Subject: Re: BUG #4529: lc_messages in config ignored|
|Previous:||From: Craig Ringer||Date: 2008-11-20 11:33:04|
|Subject: Re: could not read block 77 of relation 1663/16385/388818775|