The query in the reproduction had nearly 500 unions.
The following stack is an example of what you might see in the
assert and note the ~430 merge_open
recursive calls that grow the stack substantially:
15:38:10 Assert Failed: yield_processor: Stack overflow in
thread 233
15:38:10 Who: Session(39, informix@hostname, 28104,
10c8544e8)
Thread(233, sqlexec, 10c8131a8, 1)
File: mt_fn.c Line: 2589
15:38:10 SHM Globals and Master Pool/Master Block Adresses:
15:38:10 Stack for thread: 233 sqlexec
base: 0x000000010f101000
len: 135168
pc: 0x00000001012ef13c
tos: 0x000000010f100d31
state: sleeping
vp: 1
0x1012ef13c oninit :: mt_system + 0x114
sp=0x10f101530(0x101ba6000, 0x101800, 0x101bb1308, 0x10c3e8028,
0x101303704, 0x101303000)
0x10131500c oninit :: afhandler + 0x11a0 sp=0x10f1015e0
delta_sp=176(0x10c8131a8, 0x10c3e4028, 0x689, 0x0, 0x0, 0x0)
0x101313e48 oninit :: afcrash_interface + 0xb0 sp=0x10f101df0
delta_sp=2064(0x10f101f70, 0x0, 0x0, 0xa1d, 0x10177e010,
0x101ba1098)
0x1012d97b0 oninit :: stack_overflow_crash + 0xc8 sp=0x10f101ec0
delta_sp=208(0x101bb1000, 0x101bb1, 0x101800, 0x1018b7000,
0x1018b7, 0x10d1b1938)
0x1012f3674 oninit :: yield_processor_mvp + 0x204 sp=0x10f101ff0
delta_sp=304(0x10f100ff0, 0x0, 0x1620, 0x10c3e3d40, 0xffffffff,
0x101bb1000)
0x100abd4f8 oninit :: bf_bfwait + 0x2f4 sp=0x10f102120
delta_sp=304(0x10c8131a8, 0x120ddae98, 0x100000, 0x10,
0xfffffffffffffffe, 0x0)
0x100abfaa4 oninit :: buffget + 0xd28 sp=0x10f1021f0
delta_sp=208(0x120ddaf10, 0x0, 0x800, 0x120ddae98, 0x1,
0x120001000)
0x100b1eee8 oninit :: allocpage + 0x678 sp=0x10f1024e0
delta_sp=752(0x10f1026c0, 0x116cfd028, 0x101ba1000, 0x1f80,
0x101ba1bb0, 0x0)
0x100a99da8 oninit :: kyadd + 0x118 sp=0x10f1025e0
delta_sp=256(0x10f104440, 0x0, 0xffffffffffffffff, 0x19,
0x101800, 0x10000000)
0x1009d7bf4 oninit :: rsaddindex + 0x208 sp=0x10f1026f0
delta_sp=272(0x1018b7000, 0x10f104440, 0x101ba7550, 0x0, 0x0,
0x10eef1658)
0x1013f8810 oninit :: fmamaddindex + 0x8768 sp=0x10f1027f0
delta_sp=256(0x10eef1028, 0x10f104440, 0x0, 0x10f0469f0, 0x925,
0x0)
0x1013f0054 oninit :: fmaddindex + 0x80 sp=0x10f103d90
delta_sp=5536(0x4d6, 0x0, 0x0, 0x0, 0x0, 0x0)
0x10021d738 oninit :: bldpartn + 0xdd0 sp=0x10f103ec0
delta_sp=304(0x800, 0x4d6, 0x0, 0x1, 0x10f104440, 0x1112cbd40)
0x10021e11c oninit :: bldtmpfile + 0x2e8 sp=0x10f104180
delta_sp=704(0x1112cbab8, 0x101800, 0x10f104440, 0x10168b000,
0x4, 0x10f10424c)
0x100487d18 oninit :: maketab + 0x80 sp=0x10f1042d0
delta_sp=336(0x6f, 0x1112cbab8, 0x10f104440, 0x0, 0x101bb1, 0x4)
0x100482f84 oninit :: prepselect + 0xbb4 sp=0x10f104380
delta_sp=176(0x1112cb1d0, 0x1112cb1d0, 0x10eef1028, 0x10f303028,
0x0, 0x101ba1bd8)
0x10051ba48 oninit :: subqprep + 0x138 sp=0x10f1047e0
delta_sp=1120(0x1112cb1d0, 0x10400, 0x2000, 0x84003, 0x10022001,
0x10022001)
0x100467f44 oninit :: startsubq + 0x20c sp=0x10f104890
delta_sp=176(0x116cf4038, 0x22001, 0x1112c8c38, 0x1112cbab8,
0x20000, 0x101ba1bd8)
0x100464ca4 oninit :: scan_next + 0x3ec sp=0x10f104950
delta_sp=192(0x116cf4038, 0x1112c90a8, 0x101800, 0x100464000,
0x101ba1bd8, 0x80000)
0x10085a980 oninit :: next_row + 0xfc sp=0x10f104a00
delta_sp=176(0x114776578, 0x101ba1000, 0x1, 0x10eef1028,
0x1004648b8, 0x4000)
0x10085b1e4 oninit :: get_first_row_from_producer + 0x34
sp=0x10f104ac0 delta_sp=192(0x114776578, 0x0, 0x40000000, 0x0,
0x1000000, 0x0)
0x10085b094 oninit :: process_non_groupby + 0x4 sp=0x10f104b70
delta_sp=176(0x114776578, 0x0, 0x116cf4038, 0x0, 0x101ba1bd8,
0x0)
0x100857cd0 oninit :: group_open + 0x180 sp=0x10f104c20
delta_sp=176(0x114776578, 0x114776578, 0x0, 0x101800, 0x0,
0xffff7fff)
0x100483154 oninit :: prepselect + 0xd84 sp=0x10f104cd0
delta_sp=176(0x100857b50, 0x1112c8c38, 0x10eef1028, 0x101800,
0x101ba1, 0x101ba1000)
0x10051ba48 oninit :: subqprep + 0x138 sp=0x10f105130
delta_sp=1120(0x1112c8c38, 0x10f1052b8, 0x10ec1b028,
0x101ba1000, 0x20008, 0x20008)
0x10051a9c4 oninit :: check_subquery_remake + 0x604
sp=0x10f1051e0 delta_sp=176(0x1112c8c38, 0x0, 0x0, 0x0,
0x110c7a800, 0x0)
0x10051af20 oninit :: exsubq + 0x180 sp=0x10f1052d0
delta_sp=240(0x1112c8c38, 0x10f105000, 0x10ec0a650, 0x10ec079e8,
0x101bb1000, 0x101bb1)
0x1005114c0 oninit :: geval + 0x1524 sp=0x10f1053c0
delta_sp=240(0x1112d35b0, 0x10f105c10, 0x1161c9548, 0x1112d35c8,
0x0, 0x1112d35c8)
0x100476e6c oninit :: loadkey + 0x5c8 sp=0x10f105860
delta_sp=1184(0x1161c9340, 0x1112d35b0, 0x1112d3608,
0x10f10672c, 0x10f106730, 0x10f106744)
0x100476a2c oninit :: loadkey + 0x188 sp=0x10f105e10
delta_sp=1456(0x1161c9340, 0x115c4a0b8, 0x0, 0x10f10672c,
0x10f106730, 0x10f106744)
0x100476578 oninit :: loadidxkey + 0x134 sp=0x10f1063c0
delta_sp=1456(0x1161c9340, 0x0, 0x1, 0x10f10672c, 0x10f106730,
0x10f106744)
0x100472a70 oninit :: readidx_old + 0x548 sp=0x10f1064e0
delta_sp=288(0x1161c9340, 0x10f106740, 0x30098, 0x113af5318,
0x0, 0x115c4a0b8)
0x10046a600 oninit :: gettupl + 0x460 sp=0x10f106b00
delta_sp=1568(0x1161c9340, 0x80000, 0x1112bc458, 0x40000000,
0x8fbe8, 0x800000)
0x100464cdc oninit :: scan_next + 0x424 sp=0x10f106d10
delta_sp=528(0x1161c9340, 0x1112bc458, 0x101800, 0x100464000,
0x101ba1bd8, 0x80000)
0x10085a980 oninit :: next_row + 0xfc sp=0x10f106dc0
delta_sp=176(0x1161c8ae0, 0x101ba1000, 0x1, 0x10eef1028,
0x1004648b8, 0x4000)
0x10085b1e4 oninit :: get_first_row_from_producer + 0x34
sp=0x10f106e80 delta_sp=192(0x1161c8ae0, 0x0, 0x40000000, 0x0,
0x1000000, 0x0)
0x10085b094 oninit :: process_non_groupby + 0x4 sp=0x10f106f30
delta_sp=176(0x1161c8ae0, 0x0, 0x1161c9340, 0x0, 0x101ba1bd8,
0x0)
0x100857cd0 oninit :: group_open + 0x180 sp=0x10f106fe0
delta_sp=176(0x1161c8ae0, 0x1161c8ae0, 0x0, 0x10ec079e8, 0x0,
0xffff7fff)
0x1004b1350 oninit :: merge_open + 0x1f0 sp=0x10f107090
delta_sp=176(0x1162a19f8, 0x10f105000, 0x10ec0a650, 0x10ec079e8,
0x101bb1000, 0x101bb1)
< 434 total recursive merge_open calls >
0x1004b1318 oninit :: merge_open + 0x1b8 sp=0x10f120680
delta_sp=240(0x115d26f88, 0x10f105000, 0x10ec0a650, 0x10ec079e8,
0x101bb1000, 0x101bb1)
0x1004ab13c oninit :: sort_open + 0x204 sp=0x10f120770
delta_sp=240(0x115d26da0, 0x0, 0x115d26f28, 0xffffffff,
0x115015f88, 0x101ba1bd8)
0x100483154 oninit :: prepselect + 0xd84 sp=0x10f1209d0
delta_sp=608(0x1004aaf38, 0x10f0469f0, 0x10eef1028, 0x101800,
0x101ba1, 0x101ba1000)
0x1006eb748 oninit :: open_cursor + 0xd34 sp=0x10f120e30
delta_sp=1120(0x0, 0x101ba1bd0, 0x10f0469f0, 0x101ba1bd8, 0x1,
0x10f303028)
0x1006ea9dc oninit :: sql_open + 0x230 sp=0x10f120f20
delta_sp=240(0x10f1210ec, 0x10f303028, 0x10eef1028, 0x101ba1bd8,
0x101ba1bd0, 0x0)
0x1006ea758 oninit :: sq_open + 0x8 sp=0x10f121030
delta_sp=272(0x1006ea750, 0x101ba1000, 0x1, 0x0, 0x10d2091c0,
0x60000000)
0x1007bee1c oninit :: sqmain + 0xa6c sp=0x10f1210f0
delta_sp=192(0x30, 0x6, 0x1, 0x20000, 0x0, 0x200000)
0x101449ce8 oninit :: listen_verify + 0x490 sp=0x10f1211c0
delta_sp=208(0x10d20be68, 0x101800, 0x1019e9000, 0x10d2091c0,
0x10d1cdfc0, 0x0)
0x1014494b4 oninit :: spawn_thread + 0x16d4 sp=0x10f121660
delta_sp=1184(0xc8, 0x10d20bf40, 0x101ba6, 0x880d88, 0x101800,
0x880c00)
0x1012d7068 oninit :: th_init_initgls + 0x170 sp=0x10f121d10
delta_sp=1712(0x1018b7, 0x101800, 0x101447de0, 0x101bb1000,
0x10ec079e8, 0x10ec90bc8)
0x1013036f0 oninit :: startup + 0x1d0 sp=0x10f121e50
delta_sp=320(0xa, 0x101ba7550, 0x101bb15b8, 0x0, 0x101ba1090,
0x101bb15b8) |
