Re: rogue process maxing cpu and unresponsive to signals - Mailing list pgsql-novice

From Tom Lane
Subject Re: rogue process maxing cpu and unresponsive to signals
Date
Msg-id 3167.1187274499@sss.pgh.pa.us
Whole thread Raw
In response to Re: rogue process maxing cpu and unresponsive to signals  (Jon Jensen <jon@jenseng.com>)
Responses Re: rogue process maxing cpu and unresponsive to signals  (Jon Jensen <jon@jenseng.com>)
List pgsql-novice
Jon Jensen <jon@jenseng.com> writes:
> Yeah, if there's any information I can furnish that would help determine
> where it's getting stuck, let me know. I'm not really sure how to gain
> any visibility into what the process is doing at this point.

If my theory is right that it's stuck in a kernel call, then *maybe*
"strace -p pid" would show the suspended call.  Or maybe not.  Probably
worth trying if you haven't rebooted yet.

            regards, tom lane

pgsql-novice by date:

Previous
From: Jon Jensen
Date:
Subject: Re: rogue process maxing cpu and unresponsive to signals
Next
From: "s anwar"
Date:
Subject: How to create a spatial index on point data.