Re: Questions regarding notify processing.

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Geoffrey <esoteric(at)3times25(dot)net>
Subject: Re: Questions regarding notify processing.
Date: 2005-02-25 20:13:04
Message-ID: 200502251513.04928.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry, I didn't know what you needed. Here is the trace:
(gdb) bt
#0 0x2b04eef2 in select () from /lib/i686/libc.so.6
#1 0x2adeb06c in ?? () from /usr/X11R6/lib/libXt.so.6
#2 0x00000001 in ?? ()
#3 0x08136b88 in ?? ()
#4 0x2adc0c47 in XtChangeManagedSet () from /usr/X11R6/lib/libXt.so.6
#5 0x2adc13b0 in _XtWaitForSomething () from /usr/X11R6/lib/libXt.so.6
#6 0x2adc23f6 in XtAppNextEvent () from /usr/X11R6/lib/libXt.so.6
#7 0x2adb6a7c in XtAppMainLoop () from /usr/X11R6/lib/libXt.so.6
#8 0x080b136a in main (argc=2, argv=0xbffff794) at main/main.c:252

Thanks for your help...

On Friday 25 February 2005 03:06 pm, Tom Lane saith:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Berényi Gábor 2005-02-25 20:19:34 hosting - asking for advice
Previous Message Tom Lane 2005-02-25 20:06:58 Re: Questions regarding notify processing.