From: | Harald Armin Massa <haraldarminmassa(at)gmail(dot)com> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | strange disappearence of postgres file |
Date: | 2005-11-21 14:40:37 |
Message-ID: | 7be3f35d0511210640j690b3666i@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I ran into a very strange disappearance of a postgresql data file.
The environment:
Windows XP professional
select version();
PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2(mingw-special)
All datafiles are within c:\ghum\data
that part of the harddrive is only accessable to user account postgres (=
the one running the service) and Administrator.
the logentries:
postgresql-2005-11-21_080758.log
2005-11-21 08:08:05 LOG: startup process (PID 1220) exited with unexpected
status 128
2005-11-21 08:08:05 LOG: aborting startup due to startup process failure
2005-11-21 08:08:06 LOG: logger shutting down
<file://///Svs00004/K__Anw_Allg/massa/haase/pglog/postgresql-2005-11-21_084022.log>
postgresql-2005-11-21_084022.log
2005-11-21 08:40:24 LOG: database system was shut down at 2005-11-20
16:46:29 Westeuropäische Normalzeit
2005-11-21 08:40:24 LOG: checkpoint record is at 4/2C880BC0
2005-11-21 08:40:24 LOG: redo record is at 4/2C880BC0; undo record is at
0/0; shutdown TRUE
2005-11-21 08:40:24 LOG: next transaction ID: 421189; next OID: 381050
2005-11-21 08:40:24 LOG: database system is ready
2005-11-21 09:45:50 ERROR: could not open relation 1663/17253/43471: No such
file or directory
2005-11-21 09:45:52 ERROR: could not open relation 1663/17253/43471: No such
file or directory
2005-11-21 09:45:59 ERROR: could not open relation 1663/17253/43471: No such
file or directory
2005-11-21 09:46:09 ERROR: could not open relation 1663/17253/43471: No such
file or directory
2005-11-21 09:46:30 ERROR: could not open relation 1663/17253/43471: No such
file or directory
... and on and on and on...
My checking showed that... within directory data/base/17253 there is indeed
no file named 43471; but ones named 43470,43472,43473 .....
Additional Information: that is a laptop-computer, and it is quite possible
that it was restarted between 8:08 and 8:40 this morning.
But ... I see no line mentioning a "killing of a file". Can I do something
more to find out WHY this file disappeared? (and esp. make sure that no more
files disappear :( )
Harald
--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-11-21 15:08:32 | Re: BUG #2059: PGConnect fails when used in a thread |
Previous Message | Florian Steinel | 2005-11-21 09:57:41 | BUG #2061: pg_dumpall -f not supported |