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

I forgot to mention - this problem is occurring on multiple Windows
machines.  One of them is running Windows XP Professional.  The other is
running Windows Server 2003.  I have disabled indexing, virus scanning,
and all non-essential services on both of them.  The problem continues
to show up even when no queries are being run (although it might always
start while queries are running)




On Tue, 28 Nov 2006 16:18:56 -0500, "Jeremy Haile" <jhaile@fastmail.fm>
said:
> 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