Re: Database Down: Chunk Failed Sanity Check, Bad Pfget

In article <6k438m$kpj$1@nnrp1.dejanews.com>, ishay_friedman@pch.gc.ca writes >Hello, > > >We are running SAP using Informix on Unix. The database was fine. Then, a >level '0' archive failed. The database stopped. > >The first message in the online log indicating failure is: > >I/O error, Primary Chunk 'informix/M01/sapdata/physdev3/data1 offline (sanity) >chunk failed sanity check > > >The SAP utility to start the database failed with the following error: > >Assert Failed: WARNING! pthdrpage:ptalloc: bad bfget >Who: Session(10, informix@SAPMAR,0, -947420584) > Thread(43, xchg_1.6, c785a8b0, 1)>Resuts: Cannot use TBLSpace page for TBLSpace 4194305 >Action: RUn 'oncheck -pt 4194305'. > the table is corrupt. >Then I tried bringing up the database using 'oninit' (No other options). No >error was indicated on the prompt, but, once again, the online log had >indicated the following problems: > >'I/O error, Primary check '/informix/M01/sapdata/physdev3/data1' line(sanity). >chunk failed sanity check. That chunk is corrupt, I/O error implies a bad spot on the disk. >Then, the message '/informix/M01/sapdata/physdev6/data1' line (sanity) >chunk failed sanity check > >The 'Asset Failed' error message previously mentioned then appeared. > >Any ideas or help would be greatly appreciated. Does the 'bad pfget' imply a >problem with an index? > it does implies corruption...and occurs in the xchg_1.6 thread which implies problems during Fast Recovery... Run the oncheck as it tells you to!! > > >Thanks, > >Ishay Friedman >(819) 994-3043 > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/ Now offering spam-free web-based newsreading -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care