Table failure: sysmaster:informix.arc_file_copy
Posted in 1998
Hi Family,
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.
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'
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]
( 1) 0x002f30f4 mt_affail + 0x314 [/usr/informix/bin/oninit]
( 2) 0x001dd6e0 rsam_affail + 0x18 [/usr/informix/bin/oninit]
( 3) 0x00193798 pthdrget + 0x5b0 [/usr/informix/bin/oninit]
( 4) 0x0018f97c ptaltstat + 0x134 [/usr/informix/bin/oninit]
( 5) 0x00190c40 ptalloc + 0x1d0 [/usr/informix/bin/oninit]
( 6) 0x001ec4dc nxtpartp + 0x134 [/usr/informix/bin/oninit]
( 7) 0x001ec1ac prptnnam + 0x24 [/usr/informix/bin/oninit]
( 8) 0x001e78a8 pstread + 0x468 [/usr/informix/bin/oninit]
( 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]
(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]
(16) 0x00097168 scan_next + 0x150 [/usr/informix/bin/oninit]
(17) 0x0015c7c4 join_next + 0x1b4 [/usr/informix/bin/oninit]
(18) 0x0015e6cc next_row + 0x64 [/usr/informix/bin/oninit]
(19) 0x0015e9a0 get_first_row_from_producer + 0x28
[/usr/informix/bin/oninit]
(20) 0x0015e8e0 process_non_groupby + 0x10
[/usr/informix/bin/oninit]
(21) 0x0015d594 group_open + 0x31c [/usr/informix/bin/oninit]
(22) 0x0013ab54 prepselect + 0x42c [/usr/informix/bin/oninit]
(23) 0x0014ca84 open_cursor + 0x33c [/usr/informix/bin/oninit]
(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 -----------------