Re: Questions regarding notify processing.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Terry Lee Tucker <terry(at)esc1(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Questions regarding notify processing.
Date: 2005-02-25 20:06:58
Message-ID: 7700.1109362018@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Terry Lee Tucker <terry(at)esc1(dot)com> writes:
>> Is this a bug? Did anybody look at the stack trace is sent? I don't have
>> the expertise to analyze it.

I haven't seen any stack trace. strace is not a stack trace --- I'm
talking about attaching to the stuck process with gdb and getting the
result of "bt".

If it is hanging up in PQnotifies then that's certainly a bug, but you
haven't proven that. The debug printouts you showed could equally well
be interpreted as PQnotifies returned NULL and control went back to the
idle loop. PQnotifies is not supposed to block, ever.

At the moment I suspect the problem is somewhere upstream, probably in
your interaction with the X toolkit. I think the program is blocking
when in fact there are still bytes ready to be read by libpq.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2005-02-25 20:13:04 Re: Questions regarding notify processing.
Previous Message Terry Lee Tucker 2005-02-25 19:26:31 Re: Questions regarding notify processing.