Postgres Pro
Downloads
Home   >   mailing lists

Re: How to debug a locked backend ? - Mailing list pgsql-general

From Richard Huxton
Subject Re: How to debug a locked backend ?
Date
Msg-id 437DD5D7.2000702@archonet.com
Whole thread Raw
In response to How to debug a locked backend ?  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: How to debug a locked backend ?  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-general
Tree view 
Csaba Nagy wrote:
> 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

Have you tried "strace -p <pid>" to see what calls it's making?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "A.j. Langereis"
Date:
Subject: Re: How to debug a locked backend ?
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Rebranding PostgreSQL