IT05035: IWA MEMORY ERROR WHEN CALLING IFX_TRICKLEFEED_INSTRIGPROC() VIA A TRIGGER

APAR status

• Closed as program error.

Error description

• An Informix Warehouse Accelerator feed set run against a
  compressed table in IDS 12.10.FC3 on HP-UX 11.31 will experience
  a memory error with the following stack:
  
  The stack trace seen is as follows:
  
  15:29:53  IBM Informix Dynamic Server Version 12.10.FC3 Software
  Serial Number AAA#B000000
  
  15:29:53  Assert Failed: Memory block header corruption detected
  in mt_shm_malloc_segid 6
  15:29:53   Who: Session(3227, db@server, 7216, c00000080fafb790)
    Thread(7913, sqlexec, c00000080fad0970, 8)
    File: mtshpool.c Line: 1937
  15:29:53   Results: Pool not repaired
  15:29:53   Action: Please notify IBM Informix Technical Support.
  15:29:53  Raw hex dump of stack located in
  /ifxwork1/dba/temp/af.22d18060.rawstk
  15:29:53  Stack for thread: 7913 sqlexec
  
   base: 0xc0000008372af000
    len:   102400
     pc: 0x0000000000000000
    tos: 0xc0000008372c58c0
  state: running
     vp: 8
  
  afstack
  afhandler
  affail_interface
  mt_shm_malloc_segid
  mt_malloc
  mi_dalloc_internal
  mi_dalloc
  ifx_TrickleFeed_insTrigProc
  ifx_TrickleFeed_insTrigProc
  udrlm_clang_execute_internal
  udrlm_clang_execute
  udrlm_exec_routine
  udr_execute
  exroutine
  execproc
  aud_execproc
  excommand
  dotrstmts
  dotrigs
  ferafttrig
  addone
  insert_next
  doinsert
  aud_doinsert
  excommand
  sq_execute
  sqmain
  listen_verify
  spawn_thread
  th_init_initgls
  startup
  coroutine_start
  
  If the trigger calling the 'ifx_tricklefeed_instrigproc()' is
  removed, then everything works fine.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IWA users with tricklefeed on fact table having defined a    *
  * datetime column as last column in the data mart definition   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10                          *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10
  

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

• RC10 PSY

     UP