Quick Links

How to debug a locked backend ?

From:	Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To:	Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject:	How to debug a locked backend ?
Date:	2005-11-18 11:13:00
Message-ID:	1132312380.10890.337.camel@coppola.muc.ecircle.de
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi all,

I have right now a locked backend, similar to what I had a few days ago.
It won't answer to pg_cancel_backend.
Is there a way to diagnoze what it is actually doing ?

If you answer, please do it quickly as in max 15 minutes I'll kill -9
...

Thanks,
Csaba.

Responses

Re: How to debug a locked backend ? at 2005-11-18 13:18:43 from Martijn van Oosterhout
Re: How to debug a locked backend ? at 2005-11-18 13:20:17 from A.j. Langereis
Re: How to debug a locked backend ? at 2005-11-18 13:23:35 from Richard Huxton
Re: How to debug a locked backend ? at 2005-11-18 15:10:22 from Tom Lane

Browse pgsql-general by date

	From	Date	Subject
Next Message	Aftab Alam	2005-11-18 11:18:08	trigger
Previous Message	Andreas Pflug	2005-11-18 11:11:09	Re: Numeric 508 datatype