Server error

From: Erik Ronström <kvarken(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Server error
Date: 2003-05-06 21:53:22
Message-ID: 20030506215322.11566.qmail@web13806.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-05-06 21:54:02 Re: Server error
Previous Message scott.marlowe 2003-05-06 20:41:17 Re: Backend memory leakage when inserting