IT30544: INSERT INTO A COLLATION IN A STORED PROCEDURE LEADS TO WRONG ROWSIZE CALCULATION AND AN ALLOCATION OF MEMORY IN 4GB RANGE

APAR status

• Closed as program error.

Error 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=<dmob_get_netzbezug_ne4_ext> procid=561
  
  afstack
  afhandler
  affail_interface
  mt_ex_throw_sig
  afsig_handler
  (Linux) <signal frame>
  __memset_avx2
  alloc_changelog
  new_changelog
  cursor_insert
  ifx_coll_insert
  geval
  ...
  

Local fix

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

Problem conclusion

• Fixed in Informix Server 12.10.xC14.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels