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

From: Deniz Atak <denizatak(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: could not read block 4707 of relation 1663/16384/16564: Success
Date: 2011-07-30 09:01:24
Message-ID: CAL30GtH8jVN4LY9n1OWKWk1U-Q1w9RthVZgmsaM5caDLi=nhHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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
Error Code: 0
Call: select src_ip from table where date > '2011.07.29' AND date <
'2011.07.30' AND ( (src_ip = 'anIP' ) OR ( src_ip = 'anotherIP' ) )
group by src_ip;
bind => [2011-07-29 00:00:00.0, 2011-07-30 00:00:00.0, 195.122.20.236,
195.122.20.88, 500, 0]
Query: ResultSetMappingQuery(sql="select src_ip from table where date >
'2011.07.29' AND date < '2011.07.30' AND ( (src_ip = 'anIP' ) OR (
src_ip = 'anotherIP' ) ) group by src_ip; ")

It is kind of weird to have an error that ends with success :)

Do you have any opinion about this problem? Thanks in advance.

Deniz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavin Flower 2011-07-30 10:17:05 Re: Finding referecing and referenced tables, adaptation from David Fetter's solution
Previous Message Simon Riggs 2011-07-30 08:48:24 Re: List Functions and Code