strange disappearence of postgres file
От | Harald Armin Massa |
---|---|
Тема | strange disappearence of postgres file |
Дата | |
Msg-id | 7be3f35d0511210640j690b3666i@mail.gmail.com обсуждение исходный текст |
Список | 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 (=3D 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_084= 022.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=E4ische 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=DFe 202b 70197 Stuttgart 0173/9409607
В списке pgsql-bugs по дате отправления: