Thread: ERROR: could not open relation
I get this strange error Caused by: org.postgresql.util.PSQLException: ERROR: could not open relation 1663/53544/58374: No such file or directory How do I recover from it ? Version 8.2 on windows. I think I had an hardware issue in the past where my box rebooted few times I assume this is due to that thing. I tried to re index them but is not working. Any ideas ? Thanks Q Ps. I tried to start the server in stand alone and reindex all (used the -P command to disable the indexed but it didn't work) any ideas ?
Q Master napsal(a): > I get this strange error > > Caused by: org.postgresql.util.PSQLException: ERROR: could not open > relation 1663/53544/58374: No such file or directory > > How do I recover from it ? Version 8.2 on windows. > > I think I had an hardware issue in the past where my box rebooted few > times I assume this is due to that thing. > > I tried to re index them but is not working. Any ideas ? > You lost file related to table 58374 and database 53544. Check presence file with name 58374 in directory base/53544. You can determine which table is it: 1) get database name select * from pg_database where oid=53544 2) get table name (connect to affected database) select * from pg_class where oid=58374 Probably there is no much what you can do. Only restore from backup. Zdenek
On Wed, May 7, 2008 at 1:50 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
The query should be
select * from pg_class where relfienode = 58374
Best regards
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
Q Master napsal(a):2) get table name (connect to affected database)I get this strange error
Caused by: org.postgresql.util.PSQLException: ERROR: could not open relation 1663/53544/58374: No such file or directory
How do I recover from it ? Version 8.2 on windows.
I think I had an hardware issue in the past where my box rebooted few times I assume this is due to that thing.
I tried to re index them but is not working. Any ideas ?
select * from pg_class where oid=58374
The query should be
select * from pg_class where relfienode = 58374
Best regards
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device
Gurjeet Singh napsal(a): > > The query should be > > select * from pg_class where relfienode = 58374 Yeah, of course. Thanks Zdenek