Assert Failed: Memory block header corruption detected in add_to_list 1
Hello to all,
I've looked through the IIUG comp.databases.informix archive for some
help but I can't really find anything.
I get "Assert Failed: Memory block header corruption detected in
add_to_list 1".
The platform is AIX OS-Version: 4 Release: 2
Informix 7.23 UC1
The error only occurs randomly under a certain load in terms of hit
frequency,
with the various sql-statement or procedure.
Thank you very much
Regards
Raymond
onstat -g:
INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 3 days 10:38:00 --1415464 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
31281 magicadm - 110574 ux01.ste 1 1286144 1256684
tid name rstcb flags curstk status
90634 sqlexec 915f9d14 ---P--- 6716 915f9d14 running
Memory pools count 2
name class addr totalsize freesize #allocfrag #freefrag
31281 V 7f322014 1253376 13508 963 28
31281_SORT_ V 7fbf8014 32768 15952 7 2
name free used name free used
overhead 0 216 scb 0 80
opentable 0 37444 filetable 0 2744
ru 0 220 log 0 4180
temprec 0 2364 ralloc 0
1130644
gentcb 0 7632 ostcb 0 2200
sort 0 16868 sqscb 0 15252
srtmembuf 0 64 rdahead 0 124
hashfiletab 0 276 osenv 0 1432
buft_buffer 0 25876 sqtcb 0 6000
fragman 0 2760 shmblklist 0 204
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
31281 - bop DR Not Wait 0 0 7.20
Last parsed SQL statement :
insert into T_tourselect
( id_tour
,datum_abgang
,string_betr
,string_gvs
)
select distinct
t1.id_tour
,t1.datum_abgang
,st_pr_mg_betr_tour(t1.id_tour)
,st_pr_mg_tour_gvs(t1.id_tour)
from
mg_tour t1
,mg_trans_tour t2
,mg_trans_kopf t3
where
t1.datum_abgang >= "11/12/1999"
and t3.lkz_betrieb = "MKD"
and
t3.id_trans_kopf = t2.id_trans_kopf
and t2.id_tour = t1.id_tour
User-created Temp tables :
partnum tabname rowsize
600239 t_tourselect 310
600229 t5830907 132
AF-logfile:
08:59:14 Found during add_to_list 1
08:59:14 Pool '31281' (0x7f322014)
08:59:14 Bad block header 0x9087bdb0
blk-64
9087bd70: 00000000 00000000 00000000 00000000 ........ ........9087bd80 *
9087bd90: ffffffff 00000000 00000000 00000000 ........ ........
9087bda0: 00000000 00000000 00000000 00000000 ........ ........
blk+64
9087bdb0: 00000016 9087be18 9087b9b0 00000068 ........ .......h
9087bdc0: 210f7800 30300000 00000000 00000000 !.x.00.. ........
9087bdd0: 00000000 00000000 00000000 00000000 ........ ........
9087bde0 *
08:59:14 Bad block removed from pool
08:59:14
08:59:14 Assert Failed: Memory block header corruption detected in
add_to_list 1
08:59:14 Who: Session(31281, magicadm@ux01.steilnet.de, 110574, 0)
Thread(90634, sqlexec, 0, 3)
08:59:14 Results: Pool repaired
08:59:14 Action: Please notify Informix Technical Support.
08:59:14 See Also: /UX02_WORK/af.620a6ed1, shmem.620a6ed1.0
08:59:14 Stack for thread: 90634 sqlexecbase: 0x76210014
base: 0x76210014
len: 135168
pc: 0x10030a28
tos: 0x7622f5d8
0x10030b54 afstack (0x7622f78c, 0x20002ee4, 0x620a6ed1, 0x0,
0x7622f8ac, 0x1, 0x1, 0x8080)
0x10031a98 mt_affail (0x7622fb08, 0x20002dd4, 0x2000226c, 0x2,
0x0, 0x60000000, 0x6000b340, 0x0)
0x1002b76c recover_pool_bad_block(0x1002e6e4, 0x12000, 0x400,
0x100002,0x20012050, 0x2007bee4, 0x20012058, 0x7f322060)
0x1002c3c0 add_to_list (0x645f70a0, 0x1, 0x7622fd08, 0x220c5021,
0x100ab700, 0x2007bee4, 0x20012058, 0x2007beec)
0x1002b9e0 morecore (0x90909f70, 0x2007df98, 0x0, 0xb4,
0x2007bee4, 0x2007cefc, 0x0, 0x706d6e58)
0x1002e704 mt_shm_malloc_segid(0x0, 0x90909fd4, 0x7622fe18,
0x20078178,0x1008d140, 0x2007df98, 0x0, 0xb4)
0x1002eb44 mt_shm_malloc (0x54, 0x2007df98, 0x0, 0x7623016c,
0x76230168, 0x0, 0x762301ec, 0x90381b50)
0x102662d8 do_rualloc (0x7622ff78, 0x0, 0x3ec, 0x15, 0x908eeff4,
0x8, 0x90381c44, 0x0)
0x1007bc0c chkralloc (0x1007bc0c, 0x76230088, 0x7622ffb8, 0x2,
0x102662d8, 0x2, 0x7622ffb8, 0x20078178)
0x10081300 sqmktab (0x0, 0x900b95e8, 0x76230018, 0x0, 0x1,
0x2007df98, 0x76230008, 0x0)
0x10081604 sqmkcb (0x7f322014, 0x0, 0x30, 0x2007df98,
0x908eef98, 0x900e4c28, 0x76230078, 0x24044884)
0x10217c08 mksdb (0x908eef98, 0x2, 0x76230078, 0x2007df90,
0x10267b6c, 0x900b9444, 0x76230088, 0x0)
0x102dd530 initcrd (0x43300000, 0x2007df98, 0x762300d8,
0x20078178, 0x43300000, 0x908eef98, 0x900e4c28, 0x2)
0x102dd894 qd_initenv (0x908d1cc8, 0x900b93e8, 0x20003850,
0x2007df90, 0x900b95e8, 0x2007df98, 0x0, 0x0)
0x102d6078 ip_evalexpr (0x102d86e8, 0x7fc12828, 0x0, 0x90380c1c,
0x0, 0x749b9028, 0x20076144, 0x30)
0x102d975c runproc (0x0, 0x7f322014, 0x0, 0x0, 0x0, 0x0, 0x0,
0x0)
0x1027524c evalproc (0x1002eb44, 0x1, 0x762303d8, 0x0,
0x70006014, 0x0, 0x762303f8, 0x70081030)
0x10275d7c geval (0x1034b7a0, 0x0, 0x762305b8, 0x20078178,
0x101de8ac, 0x9067801c, 0x76230598, 0x222242a0)
0x103387e0 evalcols (0x10354114, 0x0, 0x762306b8, 0x7ba0a6f8,
0x7ba0a900, 0x707f73ac, 0x0, 0x0)@
0x10337574 getrow (0x1007bc0c, 0x707f73ac, 0x0, 0x2007df98,
0x2007df90, 0x7fc12828, 0x76230768, 0x42024481)
0x10338a08 fetchrow (0x0, 0x7fc12828, 0x0, 0x1, 0x102dd394,
0x90854e84, 0x0, 0x2007df98)
0x102d2a84 ip_scurnext (0x6, 0x90854e84, 0x2007df90, 0x908de1cc,
0x0, 0x7c, 0x908550d0, 0x707f73ac)
0x102d2fc8 ip_evalcurnext (0x102d86e8, 0x908de1d8, 0x0, 0x90853884,
0x0, 0x7b2ed028, 0x20076144, 0x30)
0x102d9704 runproc (0x1013d828, 0x100, 0x90863734, 0x90853eec,
0x908d181c, 0x90899ea8, 0x76230988, 0x0)
0x1027524c evalproc (0x102a6ba0, 0x0, 0x76230a08, 0x20078178,
0x1013d5a4, 0x908de308, 0x1f760, 0x0)
0x10275d7c geval (0x101db030, 0x908a704c, 0x43300000,
0x80001806, 0x101e99ac, 0x908df760, 0x0, 0x2007d758)
0x10346b70 sort_open (0x908df838, 0x908df760, 0x76230c68,
0x41082280, 0x10337db8, 0x7dfb91fc, 0x76230c88, 0x908d1028)
0x1033fce0 insert_open (0x102a0000, 0x908de308, 0x76230cd8,
0xffffffff, 0x908de1d8, 0x908d1028, 0x908d1cc8, 0x908df5cc)
0x10339108 prepselect (0x100844ec, 0x0, 0x0, 0x2007df98,
0x90852914, 0x90853658, 0x76230dc8, 0x0)
0x1033e2c4 doinsert (0x43300000, 0x0, 0x2, 0x0, 0x908de1d8,
0x0,0x6, 0x2007df98)@
0x1021fe8c aud_doinsert (0x10153108, 0x7bbb1f54, 0x76230e78,
0x20078178, 0x0, 0