Postgres Lock Up Fun

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Postgres Lock Up Fun
Date: 2002-07-29 02:36:03
Message-ID: GNELIHDDFBOCMGBFGEFOIEGACDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I've just managed to recover from a fun Postgres lock up experience!

Basically Postgres seemed to have hung, with a stack of idle postmaster
processes. There was an idle VACUUM process and an idle CHECKPOINT process
running as well.

I finally managed to get it restarted (after a reboot), then I ran vacuumdb
again to test it, ctrl-c'd it while it was running, and then ps ax was
showing an idle VACUUM process again!

I restarted the computer again and then vacuumdb ran to completion.

Some of my problems were related to the fact that we were using daemontools
to monitor the postgres process. I've taken that off now as I think it was
more trouble than it was worth.

The vacuum analyze that caused the original crash I think was in pg_amop. I
have a copy of the data dir from then if anyone's interested, and I can dig
into the logfiles a bit more to try to give more info...

Chris

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-07-29 02:44:50 Re: Virus Emails
Previous Message Tatsuo Ishii 2002-07-29 02:12:24 JDBC does not compile