How to deal with crashes?

From: "Andrey Mishchenko" <am(at)netactor(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to deal with crashes?
Date: 2002-04-24 13:30:33
Message-ID: ILEFJFKHJCFCOKNEAMAEKEPMCBAA.am@netactor.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jani Averbach 2002-04-24 13:40:35 Re: Errors during dump/restore
Previous Message Doug McNaught 2002-04-24 13:22:01 Re: Connections per second?