Hello All,
I've inherited a fairly complex database that makes heavy use of plpgsql.
Recently, this database has been crashing at random times when it tries to
execute a specific plpgsql function. I have lots of print statements
sprinkled throughout the plpgsq function and the crash seems to happen at
random places for no apparent reason. According to my print statements, the
crash sometimes occurs when the function has succesfully exited! So it may
not be related to the function at all. Because of this apparent randomness,
I can not reliably duplicate the crash.
I'm very new to postgreSQL, and I'm not much of database guru either. Can
anyone suggest further debugging avenues?
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
This is the log output printed when the database does crash:
2002-10-24 14:09:33 [5737] DEBUG: server process (pid 6551) was
terminated by signal 11
2002-10-24 14:09:33 [5737] DEBUG: terminating any other active server
processes
2002-10-24 14:09:33 [5737] DEBUG: all server processes terminated;
reinitializing shared memory and semaphores
2002-10-24 14:09:33 [6552] DEBUG: database system was interrupted at
2002-10-24 14:09:25 EDT
2002-10-24 14:09:33 [6552] DEBUG: checkpoint record is at 2C/68264F00
2002-10-24 14:09:33 [6552] DEBUG: redo record is at 2C/68264F00; undo
record is at 0/0; shutdown TRUE
2002-10-24 14:09:33 [6552] DEBUG: next transaction id: 43454478; next
oid: 411378833
2002-10-24 14:09:33 [6552] DEBUG: database system was not properly shut
down; automatic recovery in progress
2002-10-24 14:09:33 [6552] DEBUG: redo starts at 2C/68264F40
2002-10-24 14:09:33 [6552] DEBUG: ReadRecord: record with zero length at
2C/68268FC8
2002-10-24 14:09:33 [6552] DEBUG: redo done at 2C/68264F40
Thanks very much,
Rich
