Hi I am running Postgres 8.2 on Windows 2003 server SP2.
Every now and then (2-3 times a year) our Postgres service is down and we need to manually start it. This is what we find: In log when going down: 2008-06-02 13:40:02 PANIC: could not open file "pg_xlog/000000010000001C00000081" (log file 28, segment 129): Invalid argument This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. 2008-06-02 13:40:02 LOG: server process (PID 5792) exited with exit code 3 2008-06-02 13:40:02 LOG: terminating any other active server processes 2008-06-02 13:40:02 WARNING: terminating connection because of crash of another server process 2008-06-02 13:40:02 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2008-06-02 13:40:02 HINT: In a moment you should be able to reconnect to the database and repeat your command. (WARNING, DETAIL and HINT is repeated a few times...) 2008-06-02 13:40:02 LOG: all server processes terminated; reinitializing 2008-06-02 13:40:02 LOG: database system was interrupted at 2008-06-02 13:39:39 W. Europe Daylight Time 2008-06-02 13:40:02 LOG: checkpoint record is at 1C/80F646B0 2008-06-02 13:40:02 LOG: redo record is at 1C/80F646B0; undo record is at 0/0; shutdown FALSE 2008-06-02 13:40:02 LOG: next transaction ID: 0/316291661; next OID: 44447343 2008-06-02 13:40:02 LOG: next MultiXactId: 1929; next MultiXactOffset: 4093 2008-06-02 13:40:02 LOG: database system was not properly shut down; automatic recovery in progress 2008-06-02 13:40:02 LOG: redo starts at 1C/80F64700 2008-06-02 13:40:02 LOG: unexpected pageaddr 1C/79000000 in log file 28, segment 129, offset 0 2008-06-02 13:40:02 LOG: redo done at 1C/80FFD6E0 2008-06-02 13:40:02 FATAL: the database system is starting up 2008-06-02 13:40:03 FATAL: the database system is starting up 2008-06-02 13:40:03 FATAL: the database system is starting up 2008-06-02 13:40:03 FATAL: the database system is starting up 2008-06-02 13:40:03 FATAL: could not open file "pg_xlog/000000010000001C00000081" (log file 28, segment 129): Invalid argument 2008-06-02 13:40:03 FATAL: the database system is starting up 2008-06-02 13:40:03 LOG: startup process (PID 4420) exited with exit code 1 2008-06-02 13:40:03 LOG: aborting startup due to startup process failure 2008-06-02 13:40:05 LOG: archived transaction log file "000000010000001C00000080" 2008-06-02 13:40:05 LOG: logger shutting down In log when manually started: 2008-06-02 13:50:34 LOG: database system was shut down at 2008-06-02 13:40:03 W. Europe Daylight Time 2008-06-02 13:50:34 LOG: checkpoint record is at 1C/80FFE990 2008-06-02 13:50:34 LOG: redo record is at 1C/80FFE990; undo record is at 0/0; shutdown TRUE 2008-06-02 13:50:34 LOG: next transaction ID: 0/316292191; next OID: 44447343 2008-06-02 13:50:34 LOG: next MultiXactId: 1929; next MultiXactOffset: 4093 2008-06-02 13:50:34 LOG: database system is ready 2008-06-02 13:50:35 LOG: archived transaction log file "000000010000001C00000080" 2008-06-02 13:50:54 LOG: archived transaction log file "000000010000001C00000080" We are archiving WAL-segments at a remote machine, and we are copying non-filled WAL-segments every 10 minutes to be able to rebuild the DB with a maximum of 10 minutes of missing data. (I don't know if that has anything to do with it). Does anyone have a clue on what the problem could be? Vennlig hilsen Per Lauvås Systemutvikler Fax: +47 22 41 60 61 Direct: +47 24 15 55 51 Mintra as Storgata 1 P.O. Box 8945 Youngstorget N-0028 Oslo Tel: +47 24 15 55 00 Fax: +47 22 41 60 61 http://www.mintra.no Faglig forum: Helhetlig læring og kompetanse Motta Mintras faglige e-postmagasin Helhetlig LÆRING & KOMPETANSE - gratis hver måned. Svar på denne e-posten med "HLK" i emnefeltet eller se www.mintra.no for å melde din interesse. Hyllevare e-læringskurs på Trainingportal.no Få tilgang til Mintras hyllevarer av e-læringskurs innen HMS, applikasjonsopplæring, prosjektledelse, teknisk opplæring med mer på www.trainingportal.no
