Help !!! Help !!! Help !!!
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:
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.
:qdwuser@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.