Re: [PERFORM] Hanging queries on dual CPU windows

Magnus Hagander wrote:
>> On Monday 13 March 2006 12:27, Magnus Hagander wrote:
>>> Great. That'll certainly help - now you don't have to wait for
>>> binaries from me.
>>>
>>> What I'd be interested in seeing is new stackdumps from a version
>>> where
>>> you:
>>> 1) Do *not* have the patch for mutexes applied
>>> 2) Have removed "static" from all the function devlarations in
>>> signal.c and socket.c, bnoth in src/backend/port/win32.
>> I did that, and the interesting thing is that:
>> 1. It takes much longer to hang.
>
> ?! That shouldn't be related :-)
>
>> 2. Once it hangs, the stacktraces are the same.
>
> Hmm. That's weird :-(
> Did you do a make clean? Sometimes needed to get the port stuff in,
> mingw messes up sometimes.
>
>> 3 (and this is the kicker). The thing starts working again
>> after a couple (+/-
>> 5) minutes ?????????
>
> Interesting. And you get nothing in the logs? (pg_log / eventlog)

There's a report on -bugs ([BUGS] Random hang during commit /
b(dot)lin(at)dl(dot)ac(dot)uk) that might well be related to this.

--
Richard Huxton
Archonet Ltd