INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Memory block header corruption followed by SEGV with SQL
statement that has a select with "where ... in(...)" clause with
a large number of values inside the "in" group. For example:

select * from tab1 where col1 in ("1","2",...,"65000")

The following is an example of the memory block header
corruption af:

14:40:30  Found during mt_shm_malloc_segid 5
14:40:30  Pool '42*O0' (0x486eb040)
14:40:30  Bad free block 0x4b2a6098
blk-64
000000004b2a6058: 00000000 00000000 01000000 00000000   ........
........
000000004b2a6068: b8152a4b 00000000 cdcccc3d 00000000   ..*K....
...=....
000000004b2a6078: ffff0000 00000000 a8b06e48 00000000   ........
..nH....
000000004b2a6088: 01000000 00000000 d8152a4b 00000000   ........
..*K....
blk+64
000000004b2a6098: cdcccc3d 00000000 e8b06e48 00000000   ...=....
..nH....
000000004b2a60a8: d161dd90 00000000 01000000 00000000   .a......
........
000000004b2a60b8: f8152a4b 00000000 cdcccc3d 00000000   ..*K....
...=....
000000004b2a60c8: 0bd67800 00000000 00000000 00000000   ..x.....
........
14:40:30  Bad free block removed from free list
14:40:30  Attempting to clean up all block list...
14:40:30  Pool '42*O0' (0x486eb040)
14:40:30  Bad block header 0x4b2a6070
blk-64
000000004b2a6030: 00000000 00000000 01000000 00000000   ........
........
000000004b2a6040: 98152a4b 00000000 cdcccc3d 00000000   ..*K....
...=....
000000004b2a6050: 00000000 00000000 00000000 00000000   ........
........
000000004b2a6060: 01000000 00000000 b8152a4b 00000000   ........
..*K....
14:40:30  Bad block removed from pool
...

With the following stack trace:

mt_shm_malloc_segid
mt_malloc
old_do_rualloc
old_rualloc
mc_toplevel
oridxclausecost
oridxclausecost
oridxclausecost
...
oporindex
opidxp
opscanp
op_opinit
sqoptim
bldstructs
sqcmd
sq_cmnd
sq_prepare
sqmain
spawn_thread
th_init_initgls
startup

Note: there are a large number of oridxclausecost() calls on the
stack - possibly thousands, and possibly many stack segments.

Some other possible stacks:

afstack
afhandler
affail_interface
mt_ex_throw_sig
afsig_handler
signal frame>
old_do_rualloc
old_rualloc
mc_toplevel
oridxclausecost
oridxclausecost
...
oporindex
opidxp
opscanp
op_opinit
sqoptim
bldstructs
sqcmd
sq_cmnd
sq_prepare
sqmain
spawn_thread
th_init_initgls
startup

afstack
afhandler
affail_interface
mt_free
old_do_rhpfree
opt_free_pool
sqoptim
bldstructs
sqcmd
sq_cmnd
sq_prepare
sqmain
spawn_thread
th_init_initgls
startup

****************************************************************
* USERS AFFECTED:                                              *
* Users of 12.10.xC3 through 12.10.xC8.                        *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* A query may trigger assertion failure under the following    *
* conditions:                                                  *
*   - query involves a table defined as VTI (virtual table     *
* interface), e.g., a timeseries table                         *
*   - there is an IN-list predicate on the timeseries column   *
*   - there are a large number of elements in the IN-list,     *
* e.g. > 32767 elements                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC9                      *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.03.2017
10.07.2017
10.07.2017

12.10.xC9