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