Re: PG periodic Error on W2K

On Thu, Mar 01, 2007 at 10:45:16AM -0500, Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)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