Re: Help !!! Help !!! Help !!!
In article <01bc65ac$fa2a7cc0$4ac893cf@bat-computer>, benedict de guzman
<bdguz@worldnet.att.net> writes
>Could anyone decipher these error mesages. Our data warehouse is
>running on a HP-UX 10.10 using the Informix On-line DB Server
>version 7.20.
>
>1. An assert failure on an invalid row-id generated this message, I
>followed it
>with displaying other related info:
>
I've just read the latest list of bugs fixed in Online,
this "invalid rowid in decompress" bug is fixed in 7.22.
>04:01:36 Checkpoint Completed: duration was 42 seconds.
>04:58:28 Assert Failed: read_record: decompress_row, source = c901ed48,>target
>= c9042654
>04:58:28 Who: Session(108, dwuser@AAUX1, 7787, -926662648)
> Thread(5294, scan_1.0, c8c2b9b8, 3)
>04:58:28 Results: Record not read
>04:58:28 Action: Please notify Informix Technical Support.
>04:58:28 See Also: /tmp/af.14ae91e4
>04:58:28 read_record: invalid rowid = 0, partnum = 900024
>04:58:50 Checkpoint Completed: duration was 3 seconds.
>05:01:23 Checkpoint Completed: duration was 5 seconds.
>05:02:40 Checkpoint Completed: duration was 8 seconds.
>:q>dwuser@AAUX1>dbsql 'select * from systables where partnum=9437220'
>
>Database selected.
>
>tabname srcd
>owner dwuser
>partnum 9437220
>tabid 716
>rowsize 149
>ncols 11
>nindexes 2
>nrows 155097
>created 19961008
>version 47054884
>tabtype T
>locklevel P
>npused 4250
>fextsize 16
>nextsize 16
>flags 0
>site
>dbname
>
>1 row(s) retrieved.
>
>
>
>Database closed.
>
>dwuser@AAUX1>cat /tmp/af.14ae91e4
>04:58:28
>04:58:28 Assert Failed: read_record: decompress_row, source = c901ed48,>target
>= c9042654
>04:58:28 Who: Session(108, dwuser@AAUX1, 7787, -926662648)
> Thread(5294, scan_1.0, c8c2b9b8, 3)
>04:58:28 Results: Record not read
>04:58:28 Action: Please notify Informix Technical Support.
>04:58:28 See Also: /tmp/af.14ae91e4
>04:58:28 Stack for thread: 5294 scan_1.0>
> base: 0xc9296018
> len: 36864
> pc: 0x00000000
> tos: 0xc92970b0
>
>( 0) 0x002e0290 afstack + 0xf0 [/dw/aa/home/informix/bin/oninit]
>( 1) 0x002dfae0 mt_affail + 0x318 [/dw/aa/home/informix/bin/oninit]
>( 2) 0x001d1180 rsam_affail + 0x18 [/dw/aa/home/informix/bin/oninit]
>( 3) 0x002528f0 read_record + 0x1010 [/dw/aa/home/informix/bin/oninit]
>( 4) 0x0025140c gather_records + 0x7cc
>[/dw/aa/home/informix/bin/oninit]
>( 5) 0x0025011c rsread + 0x81c [/dw/aa/home/informix/bin/oninit]
>( 6) 0x0023b090 isread + 0x28 [/dw/aa/home/informix/bin/oninit]
>( 7) 0x00332bf0 fmread + 0x3b8 [/dw/aa/home/informix/bin/oninit]
>( 8) 0x0008a3e8 sqisread + 0x28 [/dw/aa/home/informix/bin/oninit]
>( 9) 0x0008df14 readseq + 0x204 [/dw/aa/home/informix/bin/oninit]
>(10) 0x0008db94 gettupl + 0x164 [/dw/aa/home/informix/bin/oninit]
>(11) 0x0008c324 scan_next + 0x14c [/dw/aa/home/informix/bin/oninit]
>(12) 0x002ebb64 producer_thread + 0x82c
>[/dw/aa/home/informix/bin/oninit]
>
>(13) 0x002e0c44 startup + 0x9c [/dw/aa/home/informix/bin/oninit]
>(14) 0x002d9c44 resume + 0xd4 [/dw/aa/home/informix/bin/oninit]
>
>
>04:58:28
>------------------ End of assertion failure 0 -----------------
>
>dwuser@AAUX1>
>
>
>
>
>2. This second one as you can see bought the On-line server down. According
>to Informix,
>an upgrade to version 7.22 would fix the problem:
>
>01:39:34 Checkpoint Completed: duration was 0 seconds.
>02:04:54 Checkpoint Completed: duration was 2 seconds.
>02:16:31 Checkpoint Completed: duration was 1 seconds.
>03:58:32 Checkpoint Completed: duration was 1 seconds.
>04:55:36 Checkpoint Completed: duration was 1 seconds.
>05:57:42 Checkpoint Completed: duration was 1 seconds.
>06:55:49 Checkpoint Completed: duration was 1 seconds.
>08:42:46 nsfpipe.c, line 2028, thread 15, spipe error.
>08:42:46 PANIC: Attempting to bring system down>
>
>
>=====>>>> I would appreciate any help. Thnx.
>
--
David Williams