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
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 |