Re: PG periodic Error on W2K - Mailing list pgsql-general

From Magnus Hagander
Subject Re: PG periodic Error on W2K
Date
Msg-id 20070301155133.GC4202@svr2.hagander.net
Whole thread Raw
In response to Re: PG periodic Error on W2K  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PG periodic Error on W2K  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-general
On Thu, Mar 01, 2007 at 10:45:16AM -0500, Tom Lane wrote:
> Magnus Hagander <magnus@hagander.net> writes:
> > On Thu, Mar 01, 2007 at 09:44:19AM +0900, Paul Lambert wrote:
> >> I am periodically getting errors pop up on the server console of the
> >> following nature:
> >> The File or directory D:\PostgresQL\Data\global\pgstat.stat is corrupt
> >> and unreadable. Please run the Chkdsk utility.
>
> > They can *not* be caused by a bug in PostgreSQL - no more than a kernel
> > oops in linux is the fault of PostgreSQL. Now, we do push the filesystem
> > and disk layer in an unusual way with the pgstats writes, gievn that we
> > rewrite the same file over and over and over and over again at very
> > short intervals. But nothing says we're not allowed to do that :-)
>
> I'm wondering whether the message is coming from the kernel, or some
> sort of file-scanning utility that gets confused when a file is deleted
> while it's looking at it.

That specific message comes from the kernel.

//Magnus

pgsql-general by date:

Previous
From: hanak@asellus.cz (Ing. Pavel Hanák)
Date:
Subject: Bug in row locking?
Next
From: "Merlin Moncure"
Date:
Subject: Re: General Ledger db design