PG periodic Error on W2K
От | Paul Lambert |
---|---|
Тема | PG periodic Error on W2K |
Дата | |
Msg-id | 45E621E3.9080107@autoledgers.com.au обсуждение исходный текст |
Ответы |
Re: PG periodic Error on W2K
Re: PG periodic Error on W2K |
Список | 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
В списке pgsql-general по дате отправления: