Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
