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