Re: ERROR: could not read block 4707 of relation 1663/16384/16564: Success

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Deniz Atak <denizatak(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: could not read block 4707 of relation 1663/16384/16564: Success
Date: 2011-07-30 20:45:32
Message-ID: 26711.1312058732@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Deniz Atak <denizatak(at)gmail(dot)com> writes:
> I am using postgresql on Glassfish server and I have EJB 3.0 for ORM. I am
> trying to run a query in PSQL but receiving following error:

> Local Exception Stack:
> Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.0.0.v20091031-r5713): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: could not read
> block 4707 of relation 1663/16384/16564: Success

What Postgres server version is that?

If it's 8.2 or older, this probably indicates a partial block at the end
of the file. Newer versions produce a more sensible error message for
the case, but that's just cosmetic --- the real problem is a messed-up
table. Have you had a filesystem corruption or an out-of-disk-space
condition on this machine?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2011-07-30 20:46:46 Re: [GENERAL] Dropping extensions
Previous Message D M 2011-07-30 20:25:41 Re: ERROR: could not read block 4707 of relation 1663/16384/16564: Success