From: Richard Huxton <dev@archonet.com>
To: Craig A. James <cjames@modgraph-usa.com>
Cc: Russell Smith <mr-russ@pws.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres server crash
Date: Thu, 16 Nov 2006 17:29:58 +0000
Message-ID: <455CA016.7030709@archonet.com> (raw)
In-Reply-To: <455C9CCA.7080804@modgraph-usa.com>
References: <ce4072df0610201305u7836dc7bn437ec0aaf1c3e25f@mail.gmail.com>
<b42b73150610201811m84369f7kc7d58b39aed3ad73@mail.gmail.com>
<ce4072df0610230810t5d66bbb8xf1e9c0ed71b6b6c0@mail.gmail.com>
<20061023215913.GW26892@nasby.net>
<ce4072df0610240617s72f35540odd3d4e0903313b63@mail.gmail.com>
<20061025001709.GA26892@nasby.net>
<453EF7C4.2040105@modgraph-usa.com>
<455BCAE8.8010905@modgraph-usa.com>
<455BCCCD.2020701@pws.com.au>
<455C420D.8090209@archonet.com>
<455C9CCA.7080804@modgraph-usa.com>
Craig A. James wrote:
> By the way, in spite of my questions and concerns, I was *very*
> impressed by the recovery process. I know it might seem like old hat to
> you guys to watch the WAL in action, and I know on a theoretical level
> it's supposed to work, but watching it recover 150 separate databases,
> and find and fix a couple of problems was very impressive. It gives me
> great confidence that I made the right choice to use Postgres.
>
> Richard Huxton wrote:
>>>> 2. Why didn't the database recover? Why are there two processes
>>>> that couldn't be killed?
>>
>> I'm guessing it didn't recover *because* there were two processes that
>> couldn't be killed. Responsibility for that falls to the
>> operating-system. I've seen it most often with faulty drivers or
>> hardware that's being communicated with/written to. However, see below.
>
> It can't be a coincidence that these were the only two processes in a
> SELECT operation. Does the server disable signals at critical points?
If a "kill -9" as root doesn't get rid of them, I think I'm right in
saying that it's a kernel-level problem rather than something else.
--
Richard Huxton
Archonet Ltd
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, cjames@modgraph-usa.com, mr-russ@pws.com.au
Subject: Re: Postgres server crash
In-Reply-To: <455CA016.7030709@archonet.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