Informix - Problembeschreibung
Problem IT18223 | Status: Geschlossen |
QUERY THAT USED TO RUN FINE IN 11.50 NOW ALLOCATES SO MUCH MEMORY THAT THE INSTANCE RUNS OUT | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
When running a version of IDS that has the fix for APAR IT17068, a large query allocates huge amounts of memory: Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 143 V 12cf0d040 4122255360 86936 252812 61 ... ...consisting mainly of ralloc memory: name free used ralloc 0 4121483264 ...until the server runs out of memory and returns -208 to the client. The "onstat -g afr " output shows these allocations over and over: addr size memid fileid location ... 15479b000 16384 ralloc 4341 sqhash.c:1379 ... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Users of 12.10.xC1 through 12.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * A query may require large amount of memory (RALLOC memory) * * under the following conditions: * * - query contains GROUP BY clause * * - there are large number of GROUP BY columns (e.g. > 10) * * - at least one of the GROUP BY columns is of type LVARCHAR * * - query produces large number of rows for the GROUP BY * * operation (e.g., > 40 K) * * - there is also a large number of resulting groups (e.g. > * * 20 K) * * - PDQ is not on, and DS_NONPDQ_QUERY_MEM is either not * * configured or configured to a small amount (e.g. 256) * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC9 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 02.12.2016 10.07.2017 10.07.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC9 | |
Problem behoben lt. FixList in der Version |