Informix - Problembeschreibung
Problem IT27616 | Status: Geschlossen |
QUERIES PERFORMING INDEX SELF JOIN MAY NOT YIELD FREQUENTLY ENOUGH LEADING TO BLOCKED CHECKPOINT REQUESTS | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
Certain types of SQL query that use an index self join on large tables where the index pages are held in the buffer pool may not yield frequently enough during their execution. This could result in a blocked checkpoint request if another thread is in critical section and waiting on the result of an I/O request and that result needs to be processed by the kaio thread running on the same CPU VP as the non-yielding query. A stack of the running thread may be similar to: btfind btsearch kposition rsstart fmstart nextlkeyrg startsubq scan_next getrow fetchrow exfetch sql_nfetch sq_nfetch sqmain As the thread is in a running state the top few functions may or may not be present. The key indicator for this problem is the function nextlkeyrg which may perform a loop operation. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Queries performing index self join may not yield frequently * * enough leading to blocked checkpoint requests. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.12.2018 03.10.2019 03.10.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC13 | |
Problem behoben lt. FixList in der Version |