SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-07-2008, 10:17 AM
| ||||
| ||||
 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 ? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general      |
|
05-07-2008, 10:17 AM
| |||
| |||
| Re: ERROR: could not open relation 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general |
|
05-07-2008, 10:17 AM
| |||
| |||
| Re: ERROR: could not open relation On Wed, May 7, 2008 at 1:50 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote: > 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 ? > > > > > 2) get table name (connect to affected database) > > 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 |
|
05-07-2008, 10:17 AM
| ||||
| ||||
| Re: ERROR: could not open relation Gurjeet Singh napsal(a): > > The query should be > > select * from pg_class where relfienode = 58374 Yeah, of course. Thanks Zdenek -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general |
Linear Mode
