|
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
|
 |
