| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT30544 | Status: Closed |
INSERT INTO A COLLATION IN A STORED PROCEDURE LEADS TO WRONG ROWSIZE CALCULATION AND AN ALLOCATION OF MEMORY IN 4GB RANGE | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
When in a SP an insert into a multiset/collation is made it may
happen that the server starts an allocation of a huge piece of
memory at one attempt. Subsequent the server faces in a
exception and reports the following stack:
16:27:58 Dynamically allocated new virtual shared memory
segment (size 4244020KB)
16:27:58 Memory sizes:resident:4796 KB, virtual:4937112 KB, no
SHMTOTAL limit
16:28:02 Assert Failed: Exception Caught. Type: MT_EX_OS,
Context: mem
16:28:02 IBM Informix Dynamic Server Version 12.10.FC12
16:28:02 Who: Session(32, user@host, 16248, 0x10b910048)
Thread(60, sqlexec, 10b8cd638, 1)
File: mtex.c Line: 420
16:28:02 Action: Please notify IBM Informix Technical Support.
16:28:02 stack trace for pid 16235 written to
/opt/informix/IBM/12.10.FC12/tmp/af.4249cf1
16:28:02 See Also:
/opt/informix/IBM/12.10.FC12/tmp/af.4249cf1, shmem.4249cf1.0
16:28:06 Exception Caught. Type: MT_EX_OS, Context: mem
16:28:06 (-9791): ERROR: Routine execution trap --
procname= procid=561
afstack
afhandler
affail_interface
mt_ex_throw_sig
afsig_handler
(Linux)
__memset_avx2
alloc_changelog
new_changelog
cursor_insert
ifx_coll_insert
geval
... | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14. * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14. * **************************************************************** | |
| Comment | |
Fixed in Informix Server 12.10.xC14. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.10.2019 25.02.2020 25.02.2020 |
| Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
