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.lin@dl.ac.uk) that might well be related to this.

--   Richard Huxton  Archonet Ltd