Re: ERROR: could not read block 4707 of relation 1663/16384/16564: Success
| От | D M |
|---|---|
| Тема | Re: ERROR: could not read block 4707 of relation 1663/16384/16564: Success |
| Дата | |
| Msg-id | 67F26198-44CB-453C-AF13-B831119A07BB@gmail.com обсуждение исходный текст |
| Ответ на | ERROR: could not read block 4707 of relation 1663/16384/16564: Success (Deniz Atak <denizatak@gmail.com>) |
| Список | pgsql-general |
My guess is some one moved the data folder or the directory got deleted (/var/lib/pgsql/9.0/data/.../...1663/16384/16564). Without server restart. I am sure some experts gonna answer this very well.
Thanks
Deepak
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
В списке pgsql-general по дате отправления: