From: Mathijs Brands <mathijs@ilse.nl>
To: pgsql-sql@postgresql.org
Subject: PostgreSQL crashes on me :(
Date: Sun, 17 Dec 2000 21:51:18 +0100
Message-ID: <20001217215118.D64770@ilse.nl> (raw)
Hi all,
I've been running pgsql database since 6.3 with sizes ranging from a few
megabytes to a few hundred megabytes. And ever since 6.5 came out I've
had almost no crashes. Until now.
We recently installed a small server for an external party to develop
websites on. This machine, a K6-233 with 256 MB, is running FreeBSD 3.3
and PostgreSQL 7.0.2 (maybe I'll upgrade to 7.0.3 tonight). The database
it's running is about 2 MB in size and gets to process an estimated 10000
to 25000 queries per day. Nothing special, I'd say.
However, pgsql keeps crashing. It can take days, but pgsql will crash.
It spits out the following error:
ServerLoop: select failed: No child processes
I've done some searching with Google and I've searched the mailinglist
archives on the PostgreSQL site, but I couldn't turn up anything useful.
I did find a post from someone with the same problem, but appearently
nobody ever replyed to that post.
Does anyone have any idea what might be going on here? Should I be
asking this question on another list? If so, which one?
Any information would be very welcome,
Mathijs
--
"A book is a fragile creature. It suffers the wear of time,
it fears rodents, the elements, clumsy hands."
Umberto Eco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mathijs@ilse.nl
Subject: Re: PostgreSQL crashes on me :(
In-Reply-To: <20001217215118.D64770@ilse.nl>
References: <20001217215118.D64770@ilse.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox