|
Problem IT13038
|
Status: Closed |
COMPRESSION MEMID LEAK ON INSERT INTO TAB1 SELECT FROM TAB2 WITH BYTE BLOBS LARGER THAN BLOB SPACE PAGE SIZE
|
| product: |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 |
| Problem description: |
Byte blobs in blob spaces that are larger than the blob page
size will leak buffers the size of
the blob page on statements like "insert into tab2 select * from
tab1" that involve byte blobs.
In onstat -g ses output, the "compression" mem id will
continually increase as this leak is encountered.
On 12.10.FC5W1, you will also see many mem blocks like these in
the onstat -g afr for the leaking session:
68481000 51240 compression 3568 rsblobs.c:1543
68587000 51240 compression 3568 rsblobs.c:1543
6859a000 51240 compression 3568 rsblobs.c:1543
6894b000 51240 compression 3568 rsblobs.c:1543
6864d000 51240 compression 3568 rsblobs.c:1543
6861c000 51240 compression 3568 rsblobs.c:1543 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users using blobs bigger than page size *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.01.2016
28.06.2016
28.06.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC7
|
| Problem solved according to the fixlist(s) of the following version(s) |
