Re: Table failure: sysmaster:informix.arc_file_copy

In article <34F434F2.83C2C2AD@garpac.com>, Jacob Salomon <jake@garpac.com> writes >Hi Family, > Hiya! >The past week my mailbox has been getting cluttered with messages like >the above. It originates from the alarm program. Since we do not use >OnArchive here, this seems rather pointless. This morning I got 7 >identical messages, except for the time stamp, all identifying the same >af file. That file had 7 dumps, which I can't even start interpreting. >I will include one mail and its corresponding dump after my signature, >on the off chance that someone can quickly recognize this. I have >edited it slightly in for appearance's sake in a 72-character client >window. > What verison of the engine? >BTW, the partition number for the table arc_file_copy is 1048718. > >Any idea what causes this? > >Thanks. >-- > -- Jake (Never really wanted to be a fireman) >+------------------------------------------------------------+ >| The expedient performance of a task with excessive concern | >| regarding its duration-to-completion engenders a virtual | >| certainty of diminished benefit therefrom. | >| -- Benjamin Franklin (but he said it in 3 words) | >+------------------------------------------------------------+ >============================================================== >Date: 02/24/98-01:39 > >Message: Table failure: 'sysmaster:informix.arc_file_copy'. > >Severity: 4 > >Class: 1 > >Additional: pthdrpage:ptaltstat2:bad alter slot > >Reference: /var/scratch/af.1b1c6b15 >============================================================== >TBLSpace header >c981ab20: c80bbd80 c80bbde0 00010001 0010008e ........ ........ >c981ab30: 0010008e 00100261 00000000 00000000 .......a ........ >c981ab40: 00000000 00000000 00000000 00000000 ........ ........ >c981ab50 * >c981ab80: 00000000 00000000 0010008e 0801000a ........ ........ >c981ab90: 00870000 00020001 34e91334 00000001 ........ 4..4.... >c981aba0: 00000008 00000008 00000008 00000003 ........ ........ >c981abb0: 00000000 ffffffff 0010008e 00000000 ........ ........ >c981abc0: c83d2ac0 00000000 00000000 0bb31811 .=*..... ........ >c981abd0: 00010000 00000000 00000000 00000000 ........ ........ >c981abe0: c8eff080 c7e32208 00000000 00000000 ......". ........ >c981abf0: 00000000 00000000 00000000 00000000 ........ ........ >c981ac00 * >c981ac30: 00000000 .... >TBLSpace page >c4195800: 00104065 0000a060 00060022 002c07b8 ..@e...` ...".,.. >c4195810: 00000000 00000000 00000001 00000000 ........ ........ >c4195820: 00000043 0000000f 00000087 00000000 ...C.... ........ >c4195830: 00000000 00000000 00000000 00000000 ........ ........ >c4195840 * >c4195fe0: 00000000 00180014 00000000 00000000 ........ ........ >c4195ff0: 00000000 00000000 00000000 0000a060 ........ .......` >01:39:18 >01:39:18 Assert Failed: pthdrpage:ptaltstat2:bad alter slot >01:39:18 Who: Session(3052, rga@bacchus, 24453, -941524136) > Thread(6940, sqlexec, c7df4a58, 1) >01:39:18 Results: Cannot use TBLSpace page for TBLSpace 1048718 >01:39:18 Action: Run 'oncheck -pt 1048718' Try running this oncheck and see what happens... Looks like a corrupt page. >01:39:18 See Also: /var/scratch/af.1b1c6b15 >01:39:18 Stack for thread: 6940 sqlexec> > base: 0xc8d5a3e8 > len: 36864 > pc: 0x00000000 > tos: 0xc8d5bb30 > >( 0) 0x002f3954 afstack + 0x104 [/usr/informix/bin/oninit] AfStack (dumnp the stack?). >( 1) 0x002f30f4 mt_affail + 0x314 [/usr/informix/bin/oninit] Mutli thread af fail >( 2) 0x001dd6e0 rsam_affail + 0x18 [/usr/informix/bin/oninit] Oops! RSAM AF fail i.e. asserted failed somewhere in the code. >( 3) 0x00193798 pthdrget + 0x5b0 [/usr/informix/bin/oninit] Partition header get? >( 4) 0x0018f97c ptaltstat + 0x134 [/usr/informix/bin/oninit] >( 5) 0x00190c40 ptalloc + 0x1d0 [/usr/informix/bin/oninit] >( 6) 0x001ec4dc nxtpartp + 0x134 [/usr/informix/bin/oninit] Next partnum page? >( 7) 0x001ec1ac prptnnam + 0x24 [/usr/informix/bin/oninit] >( 8) 0x001e78a8 pstread + 0x468 [/usr/informix/bin/oninit] Partition read? >( 9) 0x0025e784 pst_rsread + 0x9c [/usr/informix/bin/oninit] >(10) 0x0025edb8 rsread + 0x140 [/usr/informix/bin/oninit] >(11) 0x0024d4a0 isread + 0x28 [/usr/informix/bin/oninit] ISAM read? >(12) 0x0034bb48 fmread + 0x180 [/usr/informix/bin/oninit] >(13) 0x00095110 sqisread + 0x28 [/usr/informix/bin/oninit] >(14) 0x00098d60 readseq + 0x250 [/usr/informix/bin/oninit] >(15) 0x00098908 gettupl + 0xc8 [/usr/informix/bin/oninit] get tuple ?? >(16) 0x00097168 scan_next + 0x150 [/usr/informix/bin/oninit] >(17) 0x0015c7c4 join_next + 0x1b4 [/usr/informix/bin/oninit] Ok I stand corrected, scan threads feeding a join thread feeding a group by thread. >(18) 0x0015e6cc next_row + 0x64 [/usr/informix/bin/oninit] >(19) 0x0015e9a0 get_first_row_from_producer + 0x28 > [/usr/informix/bin/oninit] I assume this cursor has multiple threads i.e. something like scans threads (producers) fedding a group by thread. Hence the group by thread is 'getting the first row from the producer'. >(20) 0x0015e8e0 process_non_groupby + 0x10 > [/usr/informix/bin/oninit] >(21) 0x0015d594 group_open + 0x31c [/usr/informix/bin/oninit] Doing a group by ? >(22) 0x0013ab54 prepselect + 0x42c [/usr/informix/bin/oninit] Prepare select? >(23) 0x0014ca84 open_cursor + 0x33c [/usr/informix/bin/oninit] Openign a cursor >(24) 0x0014c650 sq_open + 0x48 [/usr/informix/bin/oninit] >(25) 0x0010de40 sqmain + 0x98 [/usr/informix/bin/oninit] >(26) 0x002f4340 startup + 0xa0 [/usr/informix/bin/oninit] >(27) 0x002ed198 mt_swap_threads + 0xdc [/usr/informix/bin/oninit] > > >01:39:18 >------------------ End of assertion failure 0 ----------------- Looks like corruption on the page listed, I'd run the oncheck. -- 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