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

From Tom Lane
Subject Re: PG periodic Error on W2K
Date
Msg-id 24513.1172763916@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG periodic Error on W2K  (Magnus Hagander <magnus@hagander.net>)
Responses Re: PG periodic Error on W2K  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Brian A. Seklecki"
Date:
Subject: Re: why can't I increase shared buffers to higher value?
Next
From: Robert Partyka
Date:
Subject: strange behaviour with sub-select and pl/pgSQL