IT06431: ADDING NEW STATEMENTS TO THE STATEMENT CACHE UPON REACHING STMT_CACHE_HITS CAN CAUSE VARIOUS FAILURES

APAR status

• Closed as program error.

Error description

• In my testing, I observed a 2nd cache entry for the statement
  that
  was defunct, probably because an update stats on the underlying
  table had been run.
  
  The following stack was observed at a customer site running IDS
  12.10.FC4W1 on hpia64:
  
      (rmix/12.1FC4/bin/oninit)afstack
      (rmix/12.1FC4/bin/oninit)mt_ex_throw_sig
      (rmix/12.1FC4/bin/oninit)afsig_handler
      (rmix/12.1FC4/bin/oninit)__milli_memmove
      (rmix/12.1FC4/bin/oninit)routine_unknown
      (rmix/12.1FC4/bin/oninit)routine_operator
      (rmix/12.1FC4/bin/oninit)op_bind_rtn
      (rmix/12.1FC4/bin/oninit)buildexpr
      (rmix/12.1FC4/bin/oninit)expr2expr
      (rmix/12.1FC4/bin/oninit)op_bind_rtn
      (rmix/12.1FC4/bin/oninit)buildexpr
      (rmix/12.1FC4/bin/oninit)expr2expr
      (rmix/12.1FC4/bin/oninit)op_bind_rtn
      (rmix/12.1FC4/bin/oninit)buildexpr
      (rmix/12.1FC4/bin/oninit)expr2expr
      (rmix/12.1FC4/bin/oninit)op_bind_rtn
      (rmix/12.1FC4/bin/oninit)buildexpr
      (rmix/12.1FC4/bin/oninit)expr2expr
      (rmix/12.1FC4/bin/oninit)cond2expr
      (rmix/12.1FC4/bin/oninit)sel2cb
      (rmix/12.1FC4/bin/oninit)qblk2cb
      (rmix/12.1FC4/bin/oninit)stmt2cb
      (rmix/12.1FC4/bin/oninit)p_sp2cb
      (rmix/12.1FC4/bin/oninit)parsecmd
      (rmix/12.1FC4/bin/oninit)sqcmd
      (rmix/12.1FC4/bin/oninit)sq_cmnd
      (rmix/12.1FC4/bin/oninit)sq_prepare
      (rmix/12.1FC4/bin/oninit)sqmain
      (rmix/12.1FC4/bin/oninit)listen_verify
      (rmix/12.1FC4/bin/oninit)spawn_thread
      (rmix/12.1FC4/bin/oninit)th_init_initgls
      (rmix/12.1FC4/bin/oninit)startup
      (rmix/12.1FC4/bin/oninit)coroutine_start
  
  I reproduced many failures on linux x86_64 running 12.10.FC4W1.
  Some examples are below:
  
  (oninit) afstack
  (oninit) mt_ex_throw_sig
  (oninit) afsig_handler
  (Linux) <signal frame>
  (oninit) reduce_expr
  (oninit) evalcexpr
  (oninit) prmt_expr
  (oninit) expr2expr
  (oninit) op_bind_rtn
  (oninit) buildexpr
  (oninit) expr2expr
  (oninit) op_bind_rtn
  (oninit) buildexpr
  (oninit) expr2expr
  (oninit) cond2expr
  (oninit) sel2cb
  (oninit) qblk2cb
  (oninit) stmt2cb
  (oninit) p_sp2cb
  (oninit) parsecmd
  (oninit) sqcmd
  (oninit) sq_cmnd
  (oninit) sq_prepare
  (oninit) sqmain
  (oninit) listen_verify
  (oninit) spawn_thread
  (oninit) th_init_initgls
  (oninit) startup
  
  (oninit) afstack
  (oninit) mt_ex_throw_sig
  (oninit) afsig_handler
  (Linux) <signal frame>
  (oninit) routine_argtypes_body
  (oninit) routine_argtypes
  (oninit) routine_bind
  (oninit) sqbind
  (oninit) sq_common_bind
  (oninit) sq_bind
  (oninit) sqmain
  (oninit) listen_verify
  (oninit) spawn_thread
  (oninit) th_init_initgls
  (oninit) startup
  
  (oninit) afstack
  (oninit) mt_ex_throw_sig
  (oninit) afsig_handler
  (Linux) <signal frame>
  (oninit) old_do_rualloc
  (oninit) old_rualloc
  (oninit) chkralloc
  (oninit) new_celist
  (oninit) sqmksdb2
  (oninit) ssc_sqmksdb
  (oninit) sq_cmnd
  (oninit) sq_prepare
  (oninit) sqmain
  (oninit) listen_verify
  (oninit) spawn_thread
  (oninit) th_init_initgls
  (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Those using STMT_CACHE_HITS > 0                              *
  ****************************************************************
  * 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

  IFMX ULT WHSE E

• Fixed component ID

  IM0019BOS

Applicable component levels

• RB70 PSN

     UP

• RB70 PSY

     UP

• RC10 PSN

     UP

• RC10 PSY

     UP