Hi!

I have a process that deadlocks on itself. It also locks some important tables, so other normal processes are blocked when reading these tables.

But I don't know how to "undeadlock" that process, since killing it just leaves it in limbo state and doesn't actually kill it.

So far we had to re-start server to resolve it, so i wonder if it's possible to kill this process somehow without restart. Of course it's not a solution for the long run, but it's good to know (if possible at all :))