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 /
[EMAIL PROTECTED]) that might well be related to this.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
