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

2011-08-01 Thread Deniz Atak
e. This just One of > doing it. There might be more the experts here can answer very well. I am > interested to see others answers as well. > > My way is time consuming and if you have a very large table or tables > affected it's a nightmare to fix them. > > Good luck wi

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

2011-08-01 Thread Deniz Atak
ctid='(4707,0)'; but it resulted in: oid | ctid | relname -+--+- (0 rows) Isn't there suppose to be a ctid of '(4707,0)'? Or did I misunderstand what you have written? Regards, Deniz On Mon, Aug 1, 2011 at 1:21 PM, Tomas Vondra wrote: > On 1 Srpen

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

2011-07-31 Thread Deniz Atak
wrote: > Deniz Atak 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 Ser

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

2011-07-30 Thread Deniz Atak
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.DatabaseExcept

[GENERAL] Table dublicates values

2011-07-16 Thread Deniz Atak
Hi all, I am using postgresql on Glassfish server. When I restart the server for some reason, one of my databases' tables duplicates the values. For example aTable is from aDatabase: select * from aTable col1| col2 ---+- text/html |1672 t