Re: Server error

On Tue, 6 May 2003, Erik Ronström wrote:

> 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.

Sig 11 means you have bad memory or CPU, about 99.9% of the time.

www.memtest86.com