From: Nigel Bishop <nigel.bishop@gmail.com>
To: pgsql-admin@postgresql.org
Subject: DB Cluster hanging
Date: Thu, 13 Oct 2005 16:22:28 +0100
Message-ID: <7e974e490510130822q3a853039n4c96991179deae5a@mail.gmail.com> (raw)
Hi,
I'm hoping that someone will be able to answer this query:
Last night at 3am our Postgresql DB cluster hung. At the time data
was being loaded. The parameter log_statement_stats in the
postgresql.conf file was set to true. This was churning out data into
the logfile which was switching every 10Mb. Eventually the partition
where the logfiles are written to filled up – fair enough – this had
been going on since about 5.30pm the previous evening and the logfiles
were being generated at the rate of 4/5 a minute. The partition was
cleared of old logs and I expected the DB to spring in to life, but no
it just sat there. I could not connect with psql or pg_ctl to
shutdown the cluster.
Eventually I had to issue a kill -9 on the postmaster, set
log_statement_stats to false and restarted the cluster, It recovered
itself and the data load carried on.
My question is, is this normal behaviour when the logfile destination
fills up? There was nothing in the logfile being used at the time of
the hang, just stats data.
PG version 8.0.3 with archived WAL logs enabled
O/S version RH ES4 with 2 CPUs & 2Gb RAM
Thanks very much for any input.
Regards,
Nigel Bishop
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-admin@postgresql.org
Cc: nigel.bishop@gmail.com
Subject: Re: DB Cluster hanging
In-Reply-To: <7e974e490510130822q3a853039n4c96991179deae5a@mail.gmail.com>
References: <7e974e490510130822q3a853039n4c96991179deae5a@mail.gmail.com>
* 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