PG periodic Error on W2K

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: PG periodic Error on W2K
Date: 2007-03-01 00:44:19
Message-ID: 45E621E3.9080107@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running PG 8.2.3 on We doze 2000 Server. (Should I apologise for
that up front to appease the masses?)

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.

and

The file or directory D: is corrupt and unreadable. Please run the
Chkdsk utility.

Now, per the errors suggestion I have run the chkdsk utility with a /X
/F switch to do a complete check on reboot before mounting the volume.

This showed no errors.

I can also open the mentioned file - pgstat.stat - using notepad or any
other program without mention of corruption and the data within the file
looks to be uniform suggesting it is fine.

Strangely enough, this error was being presented on the last server I
had it running on, and was in fact one of the reasons I moved it - I
assumed the error was due to dodgy disks but this seems a bit much of a
coincidence.

I know these errors are not coming directly from Postgres, but does
anyone else have problems (or has had previously) of a similar nature or
any suggestions on where it may be?

As a side-note, this server is RAID controlled, the D drive has

3 disks in the array - I would therefore have assumed that if there
was a problem with one of the disks then the server would carry on using
the other disks.

I can find no performance degradation in Postgres, the service and
connections et al. keep on operating as though there was nothing wrong,
but the errors continue to pop up sporadically on the console.

Thoughts? Ideas? Suggestions? Should I bugger off?

--
Paul Lambert
Database Administrator
AutoLedgers

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-03-01 00:47:46 Re: Why does "group by" need to match select fields?
Previous Message Naz Gassiep 2007-03-01 00:38:52 Re: Select retrieval slowdown after db drop/reload. Suggestions?