IT30899: QUERYING SYSMASTER:SYSSQEXPLAIN WITH CLIENT_LOCALE SET GENERATESASSERT FAILURE

APAR status

• Closed as program error.

Error description

• export CLIENT_LOCALE=en_US.8859-1
  select * from syssqexplain;
  
  This query will generate following error and stack:
  
  07:43:45  Assert Failed: Condition Failed (Bad allocation size
  (0) for pool 'mt' (0x44532040)), In (mt_shm_malloc_segid)
  07:43:45  IBM Informix Dynamic Server Version 14.10.FC2
  07:43:45   Who: Session(38, informix@machine1, 22769,
  0x454ac2a8)
                  Thread(52, sqlexec, 4546bc48, 1)
                  File: mtshpool.c Line: 4710
  07:43:45   Action: Please notify IBM Informix Technical Support.
  07:43:45  stack trace for pid 22492 written to
  /version/14.10.FC2/tmp/af.41c0321
  07:43:45   See Also: /version/14.10.FC2/tmp/af.41c0321,
  shmem.41c0321.0
  
  STACK :
  
   mem_asfail
   mt_malloc
   mt_realloc
   mt_aio_vfprintf
   gcv_vfprintf
   ex_gcv_print
   smi_opexplain
   smi_storeexplainflags
   prconblock
   pstread
   rsread
   fmread
   readidx_new
   gettupl
   scan_next
   join_next
   getrow
   fetchrow
   exfetch
   sql_nfetch
   sq_nfetch
   sqmain
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC4.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 14.10.xC4.                         *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 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