sysprocplan index corrupt/inconsistent

Hi all, OS: SUNOS xxxx 5.8 Generic_117350-31 IDS : 9.30FC6X1 Hi all, Snip from the af file: 12:04:20 bfcheck: bad page: pg_flags 0x90 != type 0x1 buffer header 0000000115998888: 00000000 00000000 00000000 00000000 ........ ........ 0000000115998898: 00000001 0d6fc0d0 00000001 0d6fc0d0 .....o.. .....o.. 00000001159988a8: 00000001 15932b30 00000001 159ba778 ......+0 .......x 00000001159988b8: 00000802 0000001c 0000026e 00000000 ........ ...n.... 00000001159988c8: 00000000 00000000 00000000 00000000 ........ ........ 00000001159988d8: 00010000 00000010 00000000 0020002b ........ ..... .+ 00000001159988e8: 000115fa 00000001 00000000 db6d59a6 ........ .....mY. 00000001159988f8: 00000000 ffffffff 0223d102 00000001 ........ .#...... 0000000115998908: 00000001 85635000 .....cP. page 0000000185635000: 0223d102 b9132726 002e0090 04c103f0 .#....'& ........ 0000000185635010: 00016732 0001668d 8005c6c3 80000480 ..g2..f. ........ 0000000185635020: 51800000 0100bbd0 040001d6 c4060180 Q....... ........ 0000000185635030: 05c6c380 00048c44 80000001 00bbd601 .......D ........ 0000000185635040: 0001d6c4 07018005 c6c38000 048c4480 ........ ......D. 0000000185635050: 00000200 bbd60200 01d6c501 018005c6 ........ ........ 0000000185635060: c3800004 8c518000 000100bb d6030001 .....Q.. ........ 0000000185635070: d6c50201 8005c6c3 8000048c 51800000 ........ ....Q... 0000000185635080: 0200bbd6 040001d6 c5050180 05c6c380 ........ ........ 0000000185635090: 00048c51 80000003 00bc6f07 0001d6c5 ...Q.... ..o..... 00000001856350a0: 06018005 c6c38000 048c5180 00000400 ........ ..Q..... 00000001856350b0: bc710100 01d6c507 018005c6 c3800004 .q...... ........ 00000001856350c0: 8c518000 000500bc 71020001 d6c70301 .Q...... q....... 00000001856350d0: 8005c6c3 800004c8 44800000 0100bc71 ........ D......q 00000001856350e0: 030001d6 c7040180 05c6c380 0004c844 ........ .......D 00000001856350f0: 80000002 00bc7104 0001d6c7 05018005 ......q. ........ 0000000185635100: c6c38000 04c84480 00000300 bc730600 ......D. .....s.. It appear that page is expected to be a data page, but the page read from disk is an index page. Page flag 0x1 means data page. 0x90 means its an index page. When i run the command $ oncheck -cID xxxxx.sysprocplan Validating indexes for xxxxx:informix.sysprocplan... Index procplan ERROR: No btree item exisits for data row. Rowid 0x41804 contains key value: Key: 157702:100:"D":1: Questions: 1. If i know that store procedure name that caused the crash above, can i a. delete the entry in the sysprocplan based on the procid b. Run update statistics for procedure abc ? where abc is the name of the store procedure. 2. Any other ways of solving the problem above? (Beside call for IBM support) Any input is appreciated.

You can try letting oncheck repair the index after taking a level 0 archive and possibly running a dbexport for safety. Otherwise it's going to take: dbexport the database, drop, and dbimport to fix this. Causes: Is this an unlogged or buffered log database and was there a recent hardware crash? Is the storage (SAN, etc) using write-back caching that might have crashed and didn't properly flush after restarting (check the system and SAN logs)? Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 11, 2009 at 5:49 AM, LEY PATRICK <patrickley@gmail.com> wrote: > Hi all, > > OS: SUNOS xxxx 5.8 Generic_117350-31 > IDS : 9.30FC6X1 > > Hi all, > > Snip from the af file: > > 12:04:20 bfcheck: bad page: pg_flags 0x90 != type 0x1 > buffer header > 0000000115998888: 00000000 00000000 00000000 00000000 ........ ........ > 0000000115998898: 00000001 0d6fc0d0 00000001 0d6fc0d0 .....o.. .....o.. > 00000001159988a8: 00000001 15932b30 00000001 159ba778 ......+0 .......x > 00000001159988b8: 00000802 0000001c 0000026e 00000000 ........ ...n.... > 00000001159988c8: 00000000 00000000 00000000 00000000 ........ ........ > 00000001159988d8: 00010000 00000010 00000000 0020002b ........ ..... .+ > 00000001159988e8: 000115fa 00000001 00000000 db6d59a6 ........ .....mY. > 00000001159988f8: 00000000 ffffffff 0223d102 00000001 ........ .#...... > 0000000115998908: 00000001 85635000 .....cP. > page > 0000000185635000: 0223d102 b9132726 002e0090 04c103f0 .#....'& ........ > 0000000185635010: 00016732 0001668d 8005c6c3 80000480 ..g2..f. ........ > 0000000185635020: 51800000 0100bbd0 040001d6 c4060180 Q....... ........ > 0000000185635030: 05c6c380 00048c44 80000001 00bbd601 .......D ........ > 0000000185635040: 0001d6c4 07018005 c6c38000 048c4480 ........ ......D. > 0000000185635050: 00000200 bbd60200 01d6c501 018005c6 ........ ........ > 0000000185635060: c3800004 8c518000 000100bb d6030001 .....Q.. ........ > 0000000185635070: d6c50201 8005c6c3 8000048c 51800000 ........ ....Q... > 0000000185635080: 0200bbd6 040001d6 c5050180 05c6c380 ........ ........ > 0000000185635090: 00048c51 80000003 00bc6f07 0001d6c5 ...Q.... ..o..... > 00000001856350a0: 06018005 c6c38000 048c5180 00000400 ........ ..Q..... > 00000001856350b0: bc710100 01d6c507 018005c6 c3800004 .q...... ........ > 00000001856350c0: 8c518000 000500bc 71020001 d6c70301 .Q...... q....... > 00000001856350d0: 8005c6c3 800004c8 44800000 0100bc71 ........ D......q > 00000001856350e0: 030001d6 c7040180 05c6c380 0004c844 ........ .......D > 00000001856350f0: 80000002 00bc7104 0001d6c7 05018005 ......q. ........ > 0000000185635100: c6c38000 04c84480 00000300 bc730600 ......D. .....s.. > > It appear that page is expected to be a data page, but the page read from > disk > is an index page. Page flag 0x1 means data page. 0x90 means its an index > page. > > When i run the command > $ oncheck -cID xxxxx.sysprocplan> > Validating indexes for xxxxx:informix.sysprocplan... > > Index procplan > ERROR: No btree item exisits for data row. > Rowid 0x41804 contains key value: > Key: 157702:100:"D":1: > > Questions: > 1. If i know that store procedure name that caused the crash above, can i > > a. delete the entry in the sysprocplan based on the procid > > b. Run update statistics for procedure abc ? > > where abc is the name of the store procedure. > > 2. Any other ways of solving the problem above? (Beside call for IBM > support) > > Any input is appreciated. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00235407f006fb298c047a721257