PostgreSQL terminated abnormally - Mailing list pgsql-general
From | Oskars Ozols |
---|---|
Subject | PostgreSQL terminated abnormally |
Date | |
Msg-id | 434BB736.60305@di.lv Whole thread Raw |
Responses |
Re: PostgreSQL terminated abnormally
Re: PostgreSQL terminated abnormally |
List | pgsql-general |
We were successfully running PostgreSQL 8.0 on Win2003 for several months without downtime. Then suddenly PostgreSQL crashed and there were following info in log file 2005-10-09 03:51:10 WARNING: there is no transaction in progress 2005-10-09 03:51:10 WARNING: there is no transaction in progress 2005-10-09 03:51:24 PANIC: could not rename file "C:/Program Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000CD" to "C:/Program Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000D2" (initialization of log file 0, segment 210): No such file or directory This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. 2005-10-09 03:51:24 LOG: background writer process (PID 3448) was terminated by signal 3 2005-10-09 03:51:24 LOG: terminating any other active server processes 2005-10-09 03:51:24 WARNING: terminating connection because of crash of another server process 2005-10-09 03:51:24 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. 2005-10-09 03:51:24 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2005-10-09 03:51:24 WARNING: terminating connection because of crash of another server process 2005-10-09 03:51:24 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. 2005-10-09 03:51:24 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2005-10-09 03:51:24 WARNING: terminating connection because of crash of another server process 2005-10-09 03:51:24 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. 2005-10-09 03:51:24 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2005-10-09 03:51:24 WARNING: terminating connection because of crash of another server process 2005-10-09 03:51:24 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. 2005-10-09 03:51:24 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2005-10-09 03:51:24 WARNING: terminating connection because of crash of another server process 2005-10-09 03:51:24 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. 2005-10-09 03:51:24 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2005-10-09 03:51:24 LOG: all server processes terminated; reinitializing 2005-10-09 03:51:24 LOG: database system was interrupted at 2005-10-09 03:51:24 FLE Daylight Time 2005-10-09 03:51:24 LOG: checkpoint record is at 0/CE030078 2005-10-09 03:51:24 LOG: redo record is at 0/CE030078; undo record is at 0/0; shutdown FALSE 2005-10-09 03:51:24 LOG: next transaction ID: 140670456; next OID: 3537664 2005-10-09 03:51:24 LOG: database system was not properly shut down; automatic recovery in progress 2005-10-09 03:51:24 LOG: record with zero length at 0/CE0300B8 2005-10-09 03:51:24 LOG: redo is not required 2005-10-09 03:51:24 PANIC: could not rename file "C:/Program Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000CD" to "C:/Program Files/PostgreSQL/8.0/data/pg_xlog/0000000100000000000000D2" (initialization of log file 0, segment 210): No such file or directory This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. 2005-10-09 03:51:24 LOG: startup process (PID 4184) was terminated by signal 3 2005-10-09 03:51:24 LOG: aborting startup due to startup process failure 2005-10-09 03:51:24 LOG: logger shutting down ------------------------------------------------------- What are the reasons for this error?
pgsql-general by date: