dying backend processes

From: postgres admin <postgres(at)taifun(dot)interface-business(dot)de>
To: pgsql-general(at)hub(dot)org
Cc: joerg(at)interface-business(dot)de
Subject: dying backend processes
Date: 1999-05-05 20:01:59
Message-ID: Pine.GSO.3.96.990505220012.27392C-100000@taifun.interface-business.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

we are using Postgresql 6.4.2 on FreeBSD 2.2.8 and have a lot of
problems with suddenly dying backend processes. We have already
changed kernel parameters to get more shared memory and start the
postmaster with -B 1024. The postmaster's virtual memory limit is
currently 300MByte and our largest tables contain about 12000
records. vacuum runs nightly and reports no errors. The problem
arises mostly after a couple of INSERT or SELECT INTO statements,
but also a 'COPY mytable FROM stdin' fails when I try to load
a file with 13000 datasets. It works when I split it up into
several files of not more than 5000 datasets each and load them
separately.

Turning on debugging for the postmaster as well as the backends
is not very helpful for us because the server seems to behave
differently. For Example, with debugging turned on we can't
create a certain view, which works without the debugging options.
Anyway, debug level 3 produced the following message:

postmaster: reaping dead processes...
postmaster: CleanupProc: pid 15608 exited with status 139
postmaster: CleanupProc: reinitializing shared memory and semaphores
shmem_exit(0) [#0]
binding ShmemCreate(key=52e389, size=8852184)

Does anyone know what 'status 139' means or where we can find
a hint in the source?

Any further ideas how we can track down the cause of our dying
backends?

Thanks in advance

Mirko

Browse pgsql-general by date

  From Date Subject
Next Message Anand Surelia 1999-05-05 22:14:44 How to increase shared memory buffers?
Previous Message Michael J Davis 1999-05-05 19:52:25 RE: [GENERAL] which guru know this ??