Informix - Problembeschreibung
Problem IT11351 | Status: Geschlossen |
ER DATASYNC THREAD LEAKS MEMORY IN CDRD POOL ON TARGET NODE WHEN A SINGLE TRANSACTION DELETES LARGE NUMBER OF ROWS | |
Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problembeschreibung: | |
When a single transaction deletes a large number of rows which have cascade deletes and triggers that execute UDRs, the target node seems to consume/leak huge amounts of memory in CDRD pool. On an informix instance setup with small SHMTOTAL such as 500mb the delete causes an Out of Memory situation. The memory consumption can be seen by running "onstat -g mem" as shown below: IBM Informix Dynamic Server Version 12.10.UC5W1X3 -- On-Line -- Up 01:35:19 -- 525620 Kbytes Pool Summary: name class addr totalsize freesize #allocfrag #freefrag CDRD_1 V 48435028 384778240 71947352 1560302 55105 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.09.2015 30.12.2015 30.12.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
Problem behoben lt. FixList in der Version | |
12.10.xC6 |