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

OK - after uninstalling the virus scanner (McAfee), I still get the same
disk access errors.

Here's a few seconds of the log output (this has been going on for 10
mins as of this e-mail being sent):
2006-11-28 16:16:10 LOG:  could not fsync segment 0 of relation
1663/16404/30267: Permission denied
2006-11-28 16:16:10 ERROR:  storage sync failed on magnetic disk:
Permission denied
2006-11-28 16:16:11 LOG:  could not fsync segment 0 of relation
1663/16404/30267: Permission denied
2006-11-28 16:16:11 ERROR:  storage sync failed on magnetic disk:
Permission denied
2006-11-28 16:16:12 LOG:  could not fsync segment 0 of relation
1663/16404/30267: Permission denied
2006-11-28 16:16:12 ERROR:  storage sync failed on magnetic disk:
Permission denied
2006-11-28 16:16:13 LOG:  could not fsync segment 0 of relation
1663/16404/30267: Permission denied
2006-11-28 16:16:13 ERROR:  storage sync failed on magnetic disk:
Permission denied


Here's the FileMon output from the same seconds:
4:16:10 PM      postgres.exe:3168       OPEN    C:\Program
Files\PostgreSQL\8.1\data\base\16404\30267   DELETE PEND     Options:
Open  Access: 0012019F
4:16:11 PM      postgres.exe:3168       OPEN    C:\Program
Files\PostgreSQL\8.1\data\base\16404\30267   DELETE PEND     Options:
Open  Access: 0012019F
4:16:12 PM      postgres.exe:3168       OPEN    C:\Program
Files\PostgreSQL\8.1\data\base\16404\30267   DELETE PEND     Options:
Open  Access: 0012019F
4:16:13 PM      postgres.exe:3168       OPEN    C:\Program
Files\PostgreSQL\8.1\data\base\16404\30267   DELETE PEND     Options:
Open  Access: 0012019F


This is an incredibly bad problem for me.  I'd really appreciate any
help!

Jeremy


On Mon, 27 Nov 2006 12:14:00 -0500, "Jeremy Haile" <jhaile@fastmail.fm>
said:
> Thanks for the feedback.  If you don't mind, what version of PostgreSQL
> are you running?
>
> I'm trying to bring PostgreSQL into this company - they are primarily a
> Windows/SQL Server shop (although Java software development)  I've
> already gotten comments similar to "Why don't you just switch to SQL
> Server?" -  so I'm hoping to find a workaround before I get forced to
> switch DB platforms.  As it is, my application seems unreliable because
> I haven't been able to resolve the PostgreSQL hanging problems in
> Windows.  If I had my way, I'd switch the server to Linux - but alas,
> that hasn't been an option so far.
>
> I know this may be the wrong list to ask this question on - but as I'm
> an outspoken PostgreSQL advocate, I'd like your opinions.  If I am
> unable to resolve these PostgreSQL issues given my constraints, will I
> likely have less problems running MySQL/InnoDB on Windows? (since it has
> had a native Windows build for much longer)
>
>
> On Mon, 27 Nov 2006 16:40:57 +0000, "Dave Page" <dpage@postgresql.org>
> said:
> > Jeremy Haile wrote:
> > > I've gotten pushback from my organization on removing antivirus from the
> > > servers completely.  Are there any antiviruses that are known to be
> > > compatible with PostgreSQL/win32?
> >
> > All my boxes (2 build farm members, 1 production server, and the laptop
> > on which the official releases are built and tested) run Sophos Anti
> > Virus (http://www.sophos.com/products/es/endpoint/sav.html), with no
> > problems.
> >
> > Regards, Dave
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings