IT31506: RUNNING A SPECIFIC QUERY RETURNING IN MEMORY CORRUPTIONS, INVALID MUTEX TYPES OR AN EXCEPTION IN GROUPCOPYFUNC

APAR status

• Closed as program error.

Error description

• When running a quite specific query with a sophisticates logic
  in the select list
  containing case expression combined with nested build in
  functions but having a
  simple select on a few tables with a group and a order cause
  memory corruption
  messages during the execution or at the cleanup.
  
  When setting up Memory scribbling the query showed an exception
  in the stack
  
  0x00000000014e545d (oninit) afstack
  0x00000000014eb021 (oninit) mt_ex_throw_sig
  0x00000000014f9398 (oninit) afsig_handler
  0x00007fedec8bdb10 (Linux) <signal frame>
  0x00007fedeb73551f (/lib64/libc-2.22.so) __memmove_avx_unaligned
  0x0000000000c000fd (oninit) groupcopyfunc
  0x0000000000c06100 (oninit) ha_insrt_hashtab_or_ovrfl_page
  0x0000000000c01591 (oninit) initgrpcols
  0x0000000000c0411b (oninit) group_open
  0x00000000008c9e19 (oninit) sort_open
  0x00000000008a2a21 (oninit) prepselect
  0x0000000000ada7bb (oninit) open_cursor
  0x0000000000af3aea (oninit) sq_open
  0x0000000000bc6afe (oninit) sqmain
  0x000000000161400a (oninit) spawn_thread
  0x00000000014d6122 (oninit) th_init_initgls
  0x000000000151c55f (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 12.10.xC14 or 14.10.xC4 (when      *
  * available).                                                  *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC14 and 14.10.xC4.
  

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