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"
<bradley.russell@npcinternational.com> 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:me@alternize.com]
> 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