Обсуждение: urgent request : PSQLException: FATAL: could not open relation XXX: No such file or directory

On Sunday 01 February 2009 12:38:21 am Preethi Valsalan wrote:
>  Hi
>
> I am working on an application where Postgresql is used as the db. I have a
> trigger and three functions running on that trigger. The data in db is
> updated by a thread each 1 minute continuously.
>
> I kept my application running for 2 days and on runtime Postgres stopped
> running. But when I restarted it and restarted my application I got the
> error "PSQLException: FATAL: could not open relation XXX: No such file or
> directory" . I found that some of the files in the db(data folder) are
> lost(just dissappeared). Can u explain me why it happened and how can I fix
> this problem, since this is blocking my application.
>

You will need to supply more information to start the troubleshooting process:
Postgres version
OS type and version
What is your application doing?
Are there other application running that touch the db or its data directory?

From this particular post what does "on runtime Postgres stopped running" mean?


Thanks,

--
Adrian Klaver
aklaver@comcast.net

I copied back to list as your chances of getting an answer are greater.

On Sunday 01 February 2009 10:15:04 pm you wrote:
> The Postgres version is PostgreSQL version 8.3.4.
> OS type - Windows XP Proffesional Version 2002
> Our application is a client server Java application which collects data
> from the db and send to Platform to be shown to the user.
> Only our application is touching Postgresdb.
>
> The application was running smoothly.. But at some point of time the
> db(postgres service) stopped and Platform stopped receiving data from db.
> While checking on the problem we found this exception in the server logs.
>
>
>
> Warm regards,
> Preethi K Valsalan, Team Lead
> Sphere Networks FZCo. P.O.Box 341010, Dubai UAE
> Tel: (+9714) 501-5863   Fax: (+9714) 501-5872
> preethi.valsalan@sphere.ae
> www.sphere.ae
>
>

Some more questions:
Was does Postgres logging show about the shutdown?
What does the XP logging show?
Files in the data folder map to objects in the database, is it possible some
code in the application deleted objects?
Is there a Anti-Virus program running on this machine?
Do you know which files disappeared?

As to recovery, do you have a backup?



--
Adrian Klaver
aklaver@comcast.net