APAR status
Closed as program error.
Error 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)
Local fix
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. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC16 and 14.10.xC8.
Temporary fix
Comments
APAR Information
APAR number
IT40469
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-03-31
Closed date
2023-05-05
Last modified date
2023-05-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 May 2023