Informix - Problembeschreibung
Problem IT28356 | Status: Geschlossen |
QUERY IS GETTING AN AF IN THE OPTIMZER, THREAD GETS SUSPENDED. | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 07.03.2019 03.10.2019 03.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
Problem behoben lt. FixList in der Version |