Re: Help! Corrupted sysprocbody (7.20.UC2)

David Williams wrote: > > What is the contents of the /tmp/af.... files. > /tmp/af.5db5d4 is empty. /tmp/af.63b72d is as follows. ================= 14:00:14 bfcheck: bad page: pg_addr 18 != bp->bf_pagenum 2000bdbuffer header 0be0235c: 00000000 00000000 00000000 00000000 ........ ........ 0be0236c * 0be0238c: 00000000 00000000 0bd03f78 0bd03f78 ........ ..?x..?x 0be0239c: 0be4ec5c 0be4885c 00020000 00300000 ...\\...\\ .....0.. 0be023ac: 002000bd 0d257000 0eb7cc08 00000000 . ...%p. ........ 0be023bc: 00000080 .... page 0d257000: 00000018 00995199 00000000 00000000 ......Q. ........ 0d257010: 00000000 00000000 607ffff8 00e3fff8 ........ `....... 0d257020: ff5fbfe0 febf7fc0 ffffffff 7bf3fef0 ._...... ....{... 0d257030: ffffffff 7fbf1f8f ffffffff 9fcf7ffb ........ ........ 0d257040: ffffffff fdf7fbff 00001fff 00003e1e ........ ......>. 0d257050: 00000000 00000000 00000000 00000000 ........ ........ 0d257060 * 0d2577f0: 00000000 00000000 00000000 00995199 ........ ......Q. chunk info 0eb764e0: 00020000 00000000 000fffff 000ffc58 ........ .......X 0eb764f0: 00020000 0040000a 2f646576 2f726177 .....@.. /dev/raw 0eb76500: 30320000 0eb76248 0ede0400 0ede1000 02....bH ........ 0eb76510: 0ed47cc8 000638a8 00000000 00473d94 ..|...8. .....G=. 0eb76520: 00000000 0ed75180 00000000 00000000 ......Q. ........ 0eb76530: 00000000 00000000 00000000 10000000 ........ ........ 0eb76540: 00006c00 00001800 00428418 0be011c8 ..l..... .B...... 0eb76550: 0be01290 0ede1000 0047ea2c 10000000 ........ .G.,.... 0eb76560: 00006c00 00001400 00000000 6c6f6762 ..l..... ....logb 0eb76570: 66320000 0eb7a1d8 00050000 00000000 f2...... ........ 0eb76580: 000000ba 00000018 00063000 00012000 ........ ..0... . 0eb76590: 00000000 00000000 00000000 00000000 ........ ........ aio req 0ecb4998: 00000000 0ed9ace0 00000001 00000000 ........ ........ 0ecb49a8: 0000000c 00000002 00000000 00000001 ........ ........ 0ecb49b8: 00000000 00000000 00000000 00000000 ........ ........ 0ecb49c8: 00000000 00000000 0ecb49d8 00000000 ........ ..I..... aio op 0ecb49d8: 00000000 00000800 00000001 00000005 ........ ........ 0ecb49e8: 0d257000 00000800 0005e800 0eb77228 .%p..... ......r( 0ecb49f8: 00000000 00000000 00000000 00000000 ........ ........ 0ecb4a08: 0ecb4998 ..I. page from (primary) disk 0ef39000: 00000018 00995199 00000000 00000000 ......Q. ........ 0ef39010: 00000000 00000000 607ffff8 00e3fff8 ........ `....... 0ef39020: ff5fbfe0 febf7fc0 ffffffff 7bf3fef0 ._...... ....{... 0ef39030: ffffffff 7fbf1f8f ffffffff 9fcf7ffb ........ ........ 0ef39040: ffffffff fdf7fbff 00001fff 00003e1e ........ ......>. 0ef39050: 00000000 00000000 00000000 00000000 ........ ........ 0ef39060 * 0ef397f0: 00000000 00000000 00000000 00995199 ........ ......Q. 14:00:14 14:00:14 Assert Failed: Page Check Error in allocrow:bad bitmap page 14:00:14 Who: Session(72, informix@input2.mmsb.usmc.mil, 7845, 247051424) Thread(99, sqlexec, eb7cc08, 1) 14:00:14 Results: Possible inconsistencies in'input:"informix".sysprocbody' 14:00:14 Action: Run 'oncheck -cD 2097232' 14:00:14 See Also: /tmp/af.63b72d, shmem.63b72d.0 14:00:14 Stack for thread: 99 sqlexec base: 0x0f27c018 len: 33280 pc: 0x00368728 tos: 0x0f282f48 0x003680bc mt_affail (0x63b72d, 0x47444c, 0xeb7cc08, 0xeb9b4a0, 0xeb9b4a0, 0x47434c) 0x00269e44 rsam_affail (0x47414c, 0x47434c, 0x47444c, 0xeb7cc08, 0xeb9b4a0, 0x20) 0x00264b04 bffail (0x4, 0xeec45c8, 0x8, 0xbe0235c, 0x0, 0xef38d18) 0x0025c388 allocrow (0x0, 0x6c00, 0x10000000, 0x2, 0x73c90ac, 0x0) 0x0031378c wrt_home (0x109, 0xeb7cc08, 0x109, 0x1, 0x2, 0x11) 0x00313174 wrtrecord (0x2, 0xf283dcc, 0x0, 0x0, 0x0, 0x0) 0x00312ca0 rswrite (0x2, 0xf283dcc, 0xef10ba0, 0xef10b9c, 0x0, 0x10000) 0x002f3acc iswrite (0x2, 0xf283dcc, 0xef10ba0, 0xef10b9c, 0x0, 0x0) 0x003b5f48 fmwrite (0x0, 0xf283dcc, 0xef10ba0, 0xef10b9c, 0x0, 0xef35f40) 0x00144e18 adddoc (0x2, 0x100, 0x0, 0x0, 0x0, 0xef330e0) 0x00144ab4 creatproc (0xef33520, 0xef37050, 0x2, 0x1072, 0x1000, 0x0) 0x00073c4c aud_creatproc (0xef33520, 0x44, 0xef2e118, 0xf2840e8, 0x0, 0x32b) 0x001765c4 excommand (0x0, 0xef314e0, 0xef33648, 0xef337e0, 0x0, 0xf2840ad) 0x0014fb04 sq_execute (0x0, 0x0, 0x0, 0xf2841b4, 0x47ea20, 0x18) 0x00161468 sqmain (0x47c69c, 0x473b54, 0x7, 0x47c400, 0xa, 0x0) 0x0034e574 startup (0xffffffff, 0x0, 0xed6f900, 0x20, 0xef6fd5ac, 0x47c7ac) 0x0038b384 net_wait_for_io (0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 ***unknown*** 14:05:30 ------------------ End of assertion failure 0 ----------------- ==== end of af..63b72d ==== /tmp/af.69370b is as follows ======== 23:05:48 23:05:48 Assert Failed: Internal Error - Segmentation Violation 23:05:48 Who: Session(78, informix@input2.mmsb.usmc.mil, 8731, 247051132) Thread(105, oncheck, eb7c7d0, 1) 23:05:48 Results: OnLine must abort 23:05:48 Action: Reinitialize shared memory 23:05:48 See Also: /tmp/af.69370b, shmem.69370b.0 23:05:48 Stack for thread: 105 oncheck base: 0x0f264a18 len: 33280 pc: 0x00368728 tos: 0x0f26b0e8 0x003680bc mt_affail (0x69370b, 0xef20808, 0xeb7c7d0, 0xeb9b37c, 0xeb9b37c, 0xef207a8) 0x00269e44 rsam_affail (0xef20760, 0xef207a8, 0xef20808, 0xeb7c7d0, 0xeb9b37c, 0x10000) 0x0007015c afsig_segv (0xb, 0x0, 0xf26b808, 0xf025cd98, 0x0, 0x10000) 0x0026044c getmode (0xeba3938, 0x0, 0x0, 0x0, 0x0, 0x0) 0x002eaf90 Check_Data (0x200050, 0x0, 0x8, 0x0, 0x0, 0xd257000) 0x00296d08 do_message (0xf26c2e0, 0xf26cbb0, 0xf26cbb4, 0xefc0, 0xbf39868, 0x10000) 0x00295438 oncheck (0x0, 0x32153708, 0xed9ad80, 0x7, 0xa, 0x0) 0x0034e574 startup (0xffffffff, 0x0, 0xed6f900, 0x20, 0xef6fd5ac, 0x47c7ac) 0x0038b384 net_wait_for_io (0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 ***unknown*** 23:12:08 ------------------ End of assertion failure 0 ----------------- ==== end of /tmp/af.69370b ==== Do they help? Chao