PostgreSQL terminated abnormally

Поиск
Список
Период
Сортировка
От Oskars Ozols
Тема PostgreSQL terminated abnormally
Дата
Msg-id 434BB736.60305@di.lv
обсуждение исходный текст
Ответы Re: PostgreSQL terminated abnormally  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PostgreSQL terminated abnormally  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: PostgreSQL's bug tracker
Следующее
От: Robert Treat
Дата:
Сообщение: Re: PostgreSQL's bug tracker