Re: R: R: BUG #6342: libpq blocks forever in "poll" function - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: R: R: BUG #6342: libpq blocks forever in "poll" function
Date
Msg-id 4EF12177.2050404@ringerc.id.au
Whole thread Raw
In response to R: R: BUG #6342: libpq blocks forever in "poll" function  ("Andrea Grassi" <andreagrassi@sogeasoft.com>)
List pgsql-bugs
On 19/12/2011 11:14 PM, Andrea Grassi wrote:
> Hi, Craig
> Now my process is blocked and I have the case in my hands.
> Do you have something to ask me in order to have more details ?
>
As I tend to agree with Tom re this being a kernel issue, try (as root):

# Enable stack dumps etc via sysrq
echo 8 > /proc/sys/kernel/sysrq
# Trigger kernel stack dump of all processes via sysrq mechanism
echo t > /proc/sysrq-trigger

... then search the kernel log files to find the kernel stack dump
associated with your test program.

If you're not on the latest kernel for your OS, you should update it.

--
Craig Ringer

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: R: R: R: R: BUG #6342: libpq blocks forever in "poll" function
Next
From: Tom Lane
Date:
Subject: Re: [PATCH v2] Use CC atomic builtins as a fallback