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

Deniz Atak <denizatak@gmail.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