Re: fsync and semctl errors with 8.1.5/win32 - Mailing list pgsql-bugs

From Jeremy Haile
Subject Re: fsync and semctl errors with 8.1.5/win32
Date
Msg-id 1164921330.31514.278273257@webmail.messagingengine.com
Whole thread Raw
In response to Re: fsync and semctl errors with 8.1.5/win32  ("Bradley Russell" <bradley.russell@npcinternational.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Jeremy Haile"
Date:
Subject: Re: BUG #2795: can't start service postgre
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #2794: corrupted table pk index