Deepak, Tom thanks for answering. Tom, we have psql 8.1.18. So you are right, this weird message is because of the old version. I will check with my colleague about the possible reasons. What can I do if there is a messed up table?
Regards, Deniz On Sat, Jul 30, 2011 at 11:45 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Deniz Atak <deniza...@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 >
