APAR status
Closed as program error.
Error description
When running set explain on avoid_execute for following query on a view. SELECT * FROM vw_ts_tables Stack looks like: 12:10:51 Context ptr = 0x00000000914cab00 12:10:51 Siginfo ptr = 0x00000000914cac30 12:10:51 Reg 0(R8) 0x0000000001d81fc0 Reg 1(R9) 0x0000000000000000 12:10:51 Reg 2(R10) 0x0000000000000000 Reg 3(R11) 0x0000000000000001 12:10:51 Reg 4(R12) 0x0000000000000048 Reg 5(R13) 0x0000000188215c88 12:10:51 Reg 6(R14) 0x0000000000000000 Reg 7(R15) 0x0000000000000001 12:10:51 Reg 8(RDI) 0x0000000090ccbc28 Reg 9(RSI) 0x0000000090ccbc28 12:10:51 Reg 10(RBP) 0x000000013bdf0878 Reg 11(RBX) 0x0000000000000048 12:10:51 Reg 12(RDX) 0x000000000000000f Reg 13(RAX) 0x0000000000000049 12:10:51 Reg 14(RCX) 0x0000000000000000 Reg 15(RSP) 0x00000001c3ecb090 12:10:51 Reg 16(RIP) 0x000000000093c2e4 Reg 17(EFL) 0x0000000000010206 12:10:51 Reg 18(CSGSFS) 0x0000000000000033 Reg 19(ERR) 0x0000000000000004 12:10:51 Reg 20(TRAPNO) 0x000000000000000e Reg 21(OLDMASK) 0x0000000000000000 12:10:51 Reg 22(CR2) 0x0000000000000000 12:10:51 12:10:51 IBM Informix Dynamic Server Version 12.10.FC10XA1AEE Software Serial Number AAA#B000000 12:10:51 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 12:10:51 Who: Session(8787837, informix@hostname, 109336, 0x9016aca8) Thread(21415575, sqlexec, 901375f8, 46) File: mtex.c Line: 420 12:10:51 Action: Please notify IBM Informix Technical Support. 12:10:51 SHM Globals and Master Pool/Master Block Adresses: 12:10:51 shmcb = 0x00000000449726d8 12:10:51 rhead = 0x00000000449df800 12:10:51 pool list = 0x00000000449727b0 12:10:51 block pool list = 0x00000000449d93b8 12:10:51 TRANSP = 0x000000009016aca8 12:10:51 PARTP = 0x0000000000000000 12:10:51 PARTNP = 0x0000000000000000 12:10:51 OPENP = 0x0000000099e613f8 12:10:51 FILEP = 0x0000000172cf0460 12:10:51 Raw hex dump of stack located in /data2/dumpdir/af.ca7fbe2a.rawstk 12:10:51 Stack for thread: 21415575 sqlexec base: 0x00000001c3e8c000 len: 266240 pc: 0x00000000013f0149 tos: 0x00000000914c96c0 state: running vp: 46 0x00000000013f0149 (oninit) afstack 0x00000000013f33c7 (oninit) afhandler 0x00000000013f3842 (oninit) affail_interface 0x00000000013f3dd1 (oninit) mt_ex_throw_sig 0x0000000001404883 (oninit) afsig_handler 0x00007fdf57bf05d0 (Linux) <signal frame> 0x000000000093c2e4 (oninit) printqual 0x000000000093c268 (oninit) printqual 0x000000000093c48d (oninit) pr_filter 0x0000000000942066 (oninit) opexplain 0x00000000007d12f2 (oninit) sqoptim 0x0000000000a00fbc (oninit) bldstructs 0x0000000000a05975 (oninit) sqcmd 0x0000000000a106aa (oninit) sq_cmnd 0x0000000000a10804 (oninit) sq_prepare 0x0000000000adfb53 (oninit) sqmain 0x000000000151c29b (oninit) spawn_thread 0x00000000013e1ca0 (oninit) th_init_initgls 0x000000000144aa38 (oninit) startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * ****************************************************************
Problem conclusion
Fixed in Informix Server 12.10.xC15 and 14.10.xC4.
Temporary fix
Comments
APAR Information
APAR number
IT31586
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
2020-01-20
Closed date
2020-12-10
Last modified date
2020-12-10
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
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]
Document Information
Modified date:
11 December 2020