|
Problem IT11369
|
Status: Closed |
DBEXPORT OR UNLOAD OF TABLE CONTAINING SMART BLOB ( SBLOB ) DATA USES AN EXCESSIVE AMOUNT OF SESSION PARTN MEMORY
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Linux 12.10.FC5W1 but can see the same behaviour on 12.10.FC1
and 11.70.FC1.
When running a dbexport of the database, the engine ran out of
memory and the online.log showed many new memory segments being
added. All of the machines available memory was used so it was
not possible to complete the export. Even doing a single unload
had mixed results. This was originally seen on a RSS node but
the same issue can be seen on the primary. Investigations have
now shown that this can be seen on stand-alone / normal setup.
The problem can be seen with a simple unload statement. If the
statement completes, all of the memory is freed. The same
select without "unload to ..." does not exhibit this excessive
memory usage. If you run an onstat -g ses you will see
the memory growing and the breakdown shows partn as the main
contributor. An onstat -g afr shows many of these
entries. ...
4f1149d8 72 partn 2339 sapimem.c:292
4f114a20 72 ID(1024) 2339 sapimem.c:292
4f114a68 72 partn 2339 sapimem.c:292
4f114ab0 72 ID(1024) 2339 sapimem.c:292
4f114af8 72 partn 2339 sapimem.c:292 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* informix users using dbexport or unload with smart blobs *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.09.2015
19.01.2016
19.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
