Re: CRITICAL SITUATION - who has seen this Page Check Error problem
Barry Leb wrote: > > "Jerry A. Van Zant" <jvanzant@msn.com> wrote: > > >What is the size of your chunks? and their offsets? > > Dbspaces > address num flags fchunk nchunks flags owner name > c50980f0 1 2 1 1 M informix rootdbs > c50c5a98 2 2001 2 1 N T informix tempdbs > c50c5b00 3 2 3 1 M informix physdbs > c50c5b68 4 1 4 2 N informix fsprod_data_01 > c50c5bd0 5 1 5 2 N informix fsprod_data_02 > c50c5c38 6 1 9 1 N informix fsprod_index_01 > c50c5ca0 7 1 10 1 N informix fsprod_index_02 > c50c5d08 8 1 8 1 N informix logdbs > 8 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > c5098158 1 1 0 26000 25293 PO- /dev/informix/rootdbs > c5098230 1 1 0 26000 0 MO dev/informix/rootmirror_dbs > c50c5228 2 2 0 96000 95947 PO- /dev/informix/tempdbs > c50c5300 3 3 0 12000 8547 PO- /dev/informix/physdbs > c50c59c0 3 3 0 12000 0 MO-/dev/informix/mphysdbs > c50c53d8 4 4 0 750000 3 PO /dev/informix/fsprod_data_01 > c50c54b0 5 5 0 750000 4 PO-/dev/informix/fsprod_data_02 > c50c5588 6 5 0 250000 147623PO-/dev/informix/fsprod_index_01 > c50c5660 7 4 0 250000 198817 PO-/dev/informix/fsprod_index_02 > c50c5738 8 8 0 250000 1377 PO- /dev/informix/logdbs > c50c5810 9 6 250001 500000 107200PO-/dev/informix/fsprod_index_01 > c50c58e8 10 7 250000 500000 80274 PO-/dev/informix/fsprod_index_02 > 10 active, 2047 maximum > > >Barry Leb <barryleb@atl.mindspring.com> wrote in article > ><5njskb$fqf@camel12.mindspring.com>... > >> We are in dire straits at this time. We are running informix > >> 7.11.uc.1 on an HP 9000 h70, HP-UX 9.04. We are using the NikeArrays > >> with 6-2gig drives configured as 2 RAID 5 devices(Please don't make > >> fun, it wasn't my doing). We have split the data in two. Half the > >> tables reside on one device, with its indexes detached onto the second > >> RAID 5 device and vice versa. > >> > >> This is the problem. Over the last 2 weeks the engine has crashed 5 > >> times with Page Check Errors usually pointing to bad pages or bad > >> current nodes. Onchecks and dumps of the data pages are showing data > >> pages belonging to Chunk 10 which is dedicated to Indexes showing up > >> in Chunk 6 which is dedicated to tables only. > >> > >> Has anyone seen anything like this. We have had a production system > >> down for 2 days and neither Informix nor HP has been able to diagnose > >> this one yet. > >> > >> As a side note, we are seeing some of the same problems on a separate > >> HP 900 k400 running HPUX 10.01. Also Informix is same at 7.11.uc1. > >> However, using RAID 0 here. > >> > >> One last thing. This problem occurred within 24hrs after an upgrade to > >> 7.11 from 6.00. However, the second system has been running 7.11 for > >> over a year. > >> > >> Barry Leb > >> > >> National Linen Service > >> 1420 Peachtree Street > >> MS #230 > >> Atlanta, GA 30309 > >> e-mail: barryleb@mindspring.com > >> > >> > > Barry Leb > > National Linen Service > 1420 Peachtree Street > MS #230 > Atlanta, GA 30309 > e-mail: barryleb@mindspring.com Barry, I took the liberty of running one my little reports on your output above, and you might find it interesting: Pages Pages Pages DBSpace Name Total Used Free % Full KB Used KB Free Total ================================================================================ physdbs 24000 15453 8547 64.39 31647 17504 49152 logdbs 250000 248623 1377 99.45 509179 2820 512000 rootdbs 52000 26707 25293 51.36 54695 51800 106496 tempdbs 96000 53 95947 0.06 108 196499 196608 fsprod_data_01 1000000 801180 198820 80.12 1640816 407183 2048000 fsprod_data_02 1000000 999996 4 100.00 2047991 8 2048000 fsprod_index_02 500000 419726 80274 83.95 859598 164401 1024000 fsprod_index_01 500000 500000 0 100.00 1024000 0 1024000 ================================================================================ This was generated using a tool called Dspace, available at my site. I modified it slightly to take in your data listed above. Under what conditions does it crash? Your disk space seems kinda tight... Just guessing... Tim -- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) ------------------------oOOo---( )---o00o--------- http://www.inxutil.com