How to deal with crashes?
От | Andrey Mishchenko |
---|---|
Тема | How to deal with crashes? |
Дата | |
Msg-id | ILEFJFKHJCFCOKNEAMAEKEPMCBAA.am@netactor.net обсуждение исходный текст |
Ответы |
Re: How to deal with crashes?
Re: How to deal with crashes? |
Список | pgsql-general |
Hello, I'm posting to pgsql-general since I'm not sure that this should be a bug report. Please correct me if I'm wrong. I have PostgreSQL 7.2, compiled by GCC egcs-2.91.66, Linux version 2.2.20, i686 Periodically, Postgres crashes. The following lines are added to the log file: 2002-04-17 13:55:18 [17524] DEBUG: server process (pid 23600) was terminated by signal 11 2002-04-17 13:55:18 [17524] DEBUG: terminating any other active server processes 2002-04-17 13:55:18 [17524] DEBUG: all server processes terminated; reinitializing shared memory and semaphores 2002-04-17 13:55:18 [17524] DEBUG: startup process (pid 23605) was terminated by signal 11 2002-04-17 13:55:18 [17524] DEBUG: aborting startup due to startup process failure When I do pg_ctl start, the following is logged: 2002-04-17 14:00:04 [26188] DEBUG: database system was interrupted at 2002-04-17 13:48:34 MSD 2002-04-17 14:00:04 [26188] DEBUG: checkpoint record is at 0/7F9D0C4 2002-04-17 14:00:04 [26188] DEBUG: redo record is at 0/7F9D0C4; undo record is at 0/0; shutdown FALSE 2002-04-17 14:00:04 [26188] DEBUG: next transaction id: 551189; next oid: 210621 2002-04-17 14:00:04 [26188] DEBUG: database system was not properly shut down; automatic recovery in progress 2002-04-17 14:00:04 [26188] DEBUG: ReadRecord: record with zero length at 0/7F9D104 2002-04-17 14:00:04 [26188] DEBUG: redo is not required 2002-04-17 14:00:08 [26258] FATAL 1: The database system is starting up 2002-04-17 14:00:08 [26262] FATAL 1: The database system is starting up 2002-04-17 14:00:13 [26365] FATAL 1: The database system is starting up 2002-04-17 14:00:13 [26375] FATAL 1: The database system is starting up 2002-04-17 14:00:24 [26188] DEBUG: database system is ready I do not run debug version, so core dump is not available (I'm not sure that it's a good idea to run debug version on the real web site, and this problem occures only on that particular server). Please tell me, what should I do solve my problem? Is it safe to run debug version on the public web server? What will be the penalties of doing that? (server runs ~10000 queries daily)? Thank you in advance, Andrey
В списке pgsql-general по дате отправления: