Re: What is a 'Fail Consistency Check' error ?

Peter Brueton wrote: > > > 13:24:39 --Fail Consistency Check --pthhdr:ptwrite:bad bfget > > --pid=4201 user=103 us=10002158 > > " > > > > Could anybody please tell me what the error means and how to avoid > it > > in future.? > > By the look of it this is an internal Informix error. > > My advice, for what it is worth, would be to upgrade to a more recent > version of the engine. No, no, no. Every version does consistency checks, and any can fail. It is simply checking the data on a page, like the timestamp at the beginning being the same as the timestamp at the end. If they are not then the write operation must have failed and there is potentially corrupted data on that page. That's all... Of course, as we all know, data corruption can be anything from a corrupted index node to corrupted system catalogue data pages. Cheers, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+