Re: 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: Re: How to debug a locked backend ?
Date: 2005-11-18 15:36:32
Message-ID: 1132328192.10890.432.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hmm, sometimes I get my emails immediately on the list, so it's not
always that bad - I had to try.

I have absolutely no experience using gdb... lots of experience
debugging Java, but that's a different animal.
I also don't have too much time right now learning and experimenting
with gdb, so I would appreciate some hints of specific manual pages to
check out on how to do the connecting/stack trace.

Thanks,
Csaba.

BTW, Tom, my mails are always bounced by your system because some
reverse DNS mixup on my side. I brought this to our admins attention but
it seems they won't fix it...

On Fri, 2005-11-18 at 16:10, Tom Lane wrote:
> Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> > 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
> > ...
>
> This post was pretty much a complete waste of bandwidth then, seeing
> that pggeneral never has a turnaround time as short as 15 min (it seems
> to be more like 2 hours today :-().
>
> However, if it happens again, please see what you can learn by attaching
> to the stuck backend with gdb and getting a stack trace.
>
> regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2005-11-18 15:53:05 Re: Moving from MySQL to PostgreSQL with Ruby on Rails.
Previous Message Richard Huxton 2005-11-18 15:29:59 Re: How to debug a locked backend ?