|
Problem IT28356
|
Status: Closed |
QUERY IS GETTING AN AF IN THE OPTIMZER, THREAD GETS SUSPENDED.
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
A query using outer joins and subqueries will abend with the
following stack:
84 sqlexec
base: 0x0000000046fd7000
len: 135168
pc: 0x000000000141f989
tos: 0x000000004455c6c0
state: running
vp: 1
0x000000000141f989 (oninit) afstack
0x0000000001422961 (oninit) afhandler
0x0000000001423142 (oninit) affail_interface
0x00000000014236d1 (oninit) mt_ex_throw_sig
0x000000000142e343 (oninit) afsig_handler
0x00007faf98b74b10 (Linux)
0x00000000007fa5b6 (oninit) opinit
0x00000000007ff1e5 (oninit) op_opinit
0x00000000007f110c (oninit) sqoptim
0x0000000000a2c36c (oninit) bldstructs
0x0000000000a30d25 (oninit) sqcmd
0x0000000000a3ba5a (oninit) sq_cmnd
0x0000000000a3bbb4 (oninit) sq_prepare
0x0000000000b0b011 (oninit) sqmain
0x000000000154ca1b (oninit) spawn_thread
0x0000000001411450 (oninit) th_init_initgls
0x0000000001456d88 (oninit) startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Query is generating an assert failure in the optimzer; *
* thread gets suspended. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.03.2019
03.10.2019
03.10.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
