Re: Postgres gets stuck

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres gets stuck
Date: 2006-05-11 15:26:12
Message-ID: e3vl2r$k7$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


""Craig A. James"" <cjames(at)modgraph-usa(dot)com> wrote
> I'm having a rare but deadly problem. On our web servers, a process
> occasionally gets stuck, and can't be unstuck. Once it's stuck, all
> Postgres activities cease. "kill -9" is required to kill it --
> signals 2 and 15 don't work, and "/etc/init.d/postgresql stop" fails.
>
> Details:
>
> Postgres 8.0.3
>

[Scanning 8.0.4 ~ 8.0.7 ...] Didn't find related bug fix in the upgrade
release. Can you attach to the problematic process and "bt" it (so we
could see where it stucks)?

Regards,
Qingqing

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2006-05-11 15:35:34 Re: [HACKERS] Big IN() clauses etc : feature proposal
Previous Message Christian Paul Cosinas 2006-05-11 14:45:33 Speed Up Offset and Limit Clause