Informix - Problem description
Problem IT40469 | Status: Closed |
STACK OVERFLOW POSSIBLE ADDING INDEX TO A TEMP TABLE DURING SUBQUERY OF QUERY WITH MANY UNIONS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC8. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC8. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC8. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.03.2022 05.05.2023 05.05.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |