I've upgraded to 8.2rc1. I still receive fsync errors all the time, but I haven't had it freeze yet. With 8.1.5 I was able to reproduce the freeze very quickly, so this is a good sign! Only time will tell if it's truly resolved - but I'll post updates to this list either way.
I'm still open to testing the fsync fix that Tom proposed if I can get a patched exe. On Thu, 30 Nov 2006 10:15:50 -0600, "Bradley Russell" <[EMAIL PROTECTED]> said: > In our case the hanging transactions was killing our in house merge > process that merges the data from our stores to the warehouse. > > When we rolled back sp1 no hanging transactions. When we applied sp1 > the hanging started again. We took sp1 off and on a couple times and it > happened every time. > > -----Original Message----- > From: Thomas H. [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 30, 2006 10:04 AM > To: Bradley Russell > Cc: pgsql-bugs@postgresql.org > Subject: Re: [BUGS] fsync and semctl errors with 8.1.5/win32 > > > > We were also running it on Windows Server 2003. We ended up rolling > > back service pack 1 and it seems to have taken care of the hanging > > transactions and we haven't seen a semctl error in awhile. > > interesting. we're using sp1 & pgsql since day 1 and the problem only > started when testing 8.2b1. but on the other hand, it might be that a > hotfix > is the cause for this error, as i haven't seen it before aug/sept 06. i > sure > would have noticed... > > - thomas > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend