IT32022: RUNNING "UPDATE STATISTICS FOR PROCEDURE ..." CAUSES ASSERTION FAILURES HOWEVER THE UPDATES STATISTICS FINISHES WITHOUT ERRORS

APAR status

• Closed as program error.

Error description

• Running "update statistics for procedure ..."  causes assertion
  failures with following stack trace :
  
  0x00000000014e501d (oninit) afstack
  0x00000000014e9d5d (oninit) afhandler
  0x00000000014ea372 (oninit) affail_interface
  0x00000000014eae3a (oninit) mt_ex_throw_sig
  0x00000000014f8d68 (oninit) afsig_handler
  0x00007f1eb6634d80 (Linux) <signal frame>
  0x00000000006fb8f3 (oninit) col2expr
  0x00000000006fcc7d (oninit) dotted2expr
  0x00000000006f5d98 (oninit) expr2expr
  0x00000000006fdd1d (oninit) elist2arg
  0x000000000076dd74 (oninit) common_routine2expr
  0x00000000006f60a9 (oninit) expr2expr
  0x000000000095566e (oninit) bldtabtrigs
  0x0000000000958199 (oninit) bldtrigs
  0x00000000008bc540 (oninit) itcallbldquery
  0x00000000008c2be5 (oninit) itbldroot
  0x00000000008738b0 (oninit) sqoptim
  0x00000000007113bf (oninit) ip_sqloptim
  0x0000000000732afb (oninit) cmp_stmt
  0x00000000007330a5 (oninit) pr_compile
  0x0000000000750181 (oninit) aud_pr_compile
  0x0000000000734339 (oninit) updprocstat
  0x0000000000640bfe (oninit) excommand
  0x0000000000af260b (oninit) sq_execute_workhorse
  0x0000000000af2e4d (oninit) sq_execute
  0x0000000000bc655e (oninit) sqmain
  0x0000000001613a7a (oninit) spawn_thread
  0x00000000014d5cf2 (oninit) th_init_initgls
  0x000000000151c00f (oninit) startup
  
  however the updates statistics finishes without errors :
  
  update statistics for procedure xxxxxxxxx;
  
  Database selected.
  Routine Statistics updated.
  Database closed.
  
  When the "update statistics for procedure .." is executed, it
  generates the assertion failures but instance does not crash.
  

Local fix

Problem summary

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

Problem conclusion

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