|
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) |
