Обсуждение: PG periodic Error on W2K
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
Paul Lambert wrote: > I'm running PG 8.2.3 on We doze 2000 Server. (Should I apologise for > that up front to appease the masses?) Probably ;) > > I am periodically getting errors pop up on the server console of the > following nature: > 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. Try turning off stats. However you will need to run vacuum using some other method. Joshua D. Drake > > Thoughts? Ideas? Suggestions? Should I bugger off? > The Windows port is still young, we are here to help. Try the above and see if the problem goes away :) Sincerely, Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote: > Paul Lambert wrote: >> I'm running PG 8.2.3 on We doze 2000 Server. (Should I apologise for >> that up front to appease the masses?) > > Probably ;) I propound to all my sincerest of apologies for installing what I believe to be a marvel of human creation in Postgres on what most believe to be the ultimate travesty of what some claim to be an operating system in Macrohard Webloze. I would be delighted to offer my assurance that such a farce would never again take place, but I have about forty such installations to do when my development is complete :( > >> I am periodically getting errors pop up on the server console of the >> following nature: >> 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. > > Try turning off stats. However you will need to run vacuum using some > other method. > > Joshua D. Drake > >> Thoughts? Ideas? Suggestions? Should I bugger off? >> > > The Windows port is still young, we are here to help. Try the above and > see if the problem goes away :) > > Sincerely, > > Joshua D. Drake > > I should mention that this particular database is my development server so at this point it doesn't have any data because I'm still trying to get the program prepared that populates is. (All tables have zero rows) I don't think vacuuming will do much for me anyway so I have no problems if I can't run it :) I'll turn off stats and see what happens. Thanks. -- Paul Lambert Technical Support Team Leader and Database Administrator AutoLedgers Level 3, 823 Wellington Street, West Perth, W.A. 6005 Postal: P.O. Box 106, West Perth, W.A. 6872 Ph: 08 9217 5086 Fax: 08 9217 5055 AutoLedgers Technical Support Desk: 1800 649 987 (Free call) 08 9217 5050 (Perth local and mobile) Email: paul.lambert@autoledgers.com.au <http://www.reynolds.com.au> ------------------------------------------------------------------------------------ For AutoLedgers technical support, please send an email to helpdesk@autoledgers.com.au.
On Thu, Mar 01, 2007 at 09:44:19AM +0900, Paul Lambert wrote: > 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? They are, as you say, generated by Windows, and not PostgreSQL. They're a clear indication of either hardware problem, driver problem or windows bug (which we all know don't exist, so it must be one of the first). 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 :-) The reason you acn open it with notepad is most likely that it's a different file - the file is deleted and recreated at a rate of at least twice per second, when there is activity happening in the database. The error is more a "filesystem is broken" message than "this file is broken". > 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. You would hope so. But the problem could be in the actual RAID controller. There are a lot of el-cheapo RAID-boards out there that really do more harm than good. Then there are of course a lot of very nice controllers as well :-) Which one do you have? Also, it could very well be a driver problem - have you verified that you're on the latest version? > 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? Thoughts: scary (for you). Ideas: see above. Suggestions: get it fixed. Next time it might be your datafile or WAL. Bugger off: Nah, find out what it was and let us know instead :-) On Wed, Feb 28, 2007 at 04:52:15PM -0800, Joshua D. Drake wrote: > Try turning off stats. However you will need to run vacuum using some > other method. While this will get rid of the message (most likely) you're only curing the symptoms and not the problem. As I said above, next time it might be a file that contains important data. //Magnus
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
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
> Date: Thu, 01 Mar 2007 10:06:44 +0900
> From: Paul Lambert <paul.lambert@autoledgers.com.au>
> To: "Joshua D. Drake" <jd@commandprompt.com>
> Cc: pgsql-general@postgresql.org
> Subject: Re: PG periodic Error on W2K
> Message-ID: <45E62724.6000200@autoledgers.com.au>
>
>
> I propound to all my sincerest of apologies for installing what I
> believe to be a marvel of human creation in Postgres on what most
> believe to be the ultimate travesty of what some claim to be an
> operating system in Macrohard Webloze.
>
>> [text excluded here]
>
> I would be delighted to offer my assurance that such a farce would never
> again take place, but I have about forty such installations to do when
> my development is complete :(
>
> Paul Lambert
Hi Paul,
Have you thought of running the Postgresql on a Linux box and then developing your application to use the Postgresql server via ODBC?
I am in a Windows environment on a Windows / Novell network. We still use Novell for log-on and security management. I develop in Visual FoxPro because the IT head wants to keep us on Windows clients but he agreed to let me try developing with a Linux server. I have been working with Postgresql on a Redhat 9 server for a couple years now and it is much more stable (and more secure) than our SQLServer databases on a Windows 2000 server.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
MargaretGillon@chromalloy.com wrote: > > > Date: Thu, 01 Mar 2007 10:06:44 +0900 > > From: Paul Lambert <paul.lambert@autoledgers.com.au> > > To: "Joshua D. Drake" <jd@commandprompt.com> > > Cc: pgsql-general@postgresql.org > > Subject: Re: PG periodic Error on W2K > > Message-ID: <45E62724.6000200@autoledgers.com.au> > > > > > > I propound to all my sincerest of apologies for installing what I > > believe to be a marvel of human creation in Postgres on what most > > believe to be the ultimate travesty of what some claim to be an > > operating system in Macrohard Webloze. > > > >> [text excluded here] > > > > I would be delighted to offer my assurance that such a farce would never > > again take place, but I have about forty such installations to do when > > my development is complete :( > > > > Paul Lambert > > Hi Paul, > > Have you thought of running the Postgresql on a Linux box and then > developing your application to use the Postgresql server via ODBC? > > I am in a Windows environment on a Windows / Novell network. We still > use Novell for log-on and security management. I develop in Visual > FoxPro because the IT head wants to keep us on Windows clients but he > agreed to let me try developing with a Linux server. I have been working > with Postgresql on a Redhat 9 server for a couple years now and it is > much more stable (and more secure) than our SQLServer databases on a > Windows 2000 server. > > *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** > *** *** > Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 I've put thought of running it on Linux... a lot of thought... but I haven't for 2 reasons. 1.) I've had very limited exposure to Linux, most of my work is done in an OpenVMS environment with some in Weendoze, I wouldn't feel comfortable configuring a Linux environment let alone configuring it properly. 2.) All of our customers run Weenblows servers and also don't have the expertise to maintain a linux server, it's a lot easier for us to sell our product to them if we can just install it on their existing server and have them not worry about upgrading or adding anything to their server room. Can I put in another plug for an OpenVMS port? Or would I have to do the work myself? ;) -- Paul Lambert Database Administrator AutoLedgers
Magnus Hagander wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > > Still getting the errors, but I managed to convince the powers that be to order me a fancy new server so we'll see how that goes when it arrives. Thanks again to all for the info though. -- Paul Lambert Database Administrator AutoLedgers