Re: I/O error in message log

O/S: Solaris 8, Disks: StorEdge Hitachi 9910 The sys admins checked for error messages in the system logs and found none. Informix Support was called and oncheck -pe would not work (IIRC unknown error 0). (oncheck -cr was not run by oversight). The database was bounced and then oncheck worked. Later that night the box was bounced and the messges have not come back. Good! The Informix engineer explained that as chunk 0 is not a real chunk it could be either a bad page on disk or in memory. As the error messages stopped after the bounce and there was no error in the sys logs it must have been something wrong with the memory. He also mentioned that there is a bug with nrows (or pages) not being updated in the sys catalog tables even with an update stats, so if you have a table that is being deleted from and the config paramaters RA_PAGES is anything but 0 (and of course it is for performance) then this problem can occur. The fix in that case would be to set RA_PAGES to 0. Regards, Zev Berezin From: Jonathan Leffler <jleffler@earthlink.net> Organization: Randomly Disorganized Subject: Re: I/O error in message log Date sent: Tue, 07 Feb 2006 05:06:48 GMT To: informix-list@iiug.org > Zev Berezin wrote: > > This is coming up in the message log like every couple of seconds > > I/O bad request chunk 0, pagenum 85003, pagecnt 1 > > david@smooth1.co.uk wrote: > > Which Informix version? Sounds like a bug...raise a support call with > > IBM. > > Which version and platform is a valid question. Raising a support call > with IBM may also be valid advice. I'm not sure it necessarily sounds > like a bug - it sounds more like a failing disk drive to me. I'd take a > good look at the system message logs (platform would help!), to see > whether all your disk drives are working OK. If they are, then have > you run any onchecks on your root dbspace? > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >