Informix - Problem description
Problem IT31586 | Status: Closed |
874 & ASSERT FAILURE ON PRINTQUAL WHEN RUNNING A QUERY ON VIEW WITH TS TABLES WITH SET EXPLAIN ON | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem 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) 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 | |
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. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * 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. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.01.2020 10.12.2020 10.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |