Hello,
I have a plpgsql function which dies strangely very often, with the
message "server closed the connection unexpectedly". The log file says
[...]
postgres[3315]: [391-8] :extprm () :locprm () :initplan <> :nprm 0
:scanrelid 1 }
postgres[30748]: [182] DEBUG: reaping dead processes
postgres[30748]: [183] DEBUG: child process (pid 3315) was terminated
by signal 11
postgres[30748]: [184] DEBUG: server process (pid 3315) was terminated
by signal 11
postgres[30748]: [185] DEBUG: terminating any other active server
processes
postgres[30748]: [186] DEBUG: all server processes terminated;
reinitializing shared memory and semaphores
postgres[30748]: [187] DEBUG: shmem_exit(0)
[...]
What is signal 11 (and where is it documented anyway?), and what could
be the cause? I tracked the error to a line in the function which
consists of a simple EXECUTE call.
Erik
__________________________________________________
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer