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