IC73095: EXECUTING A STORED PROCEDURE RESULTS IN OPTIMIZER EXCEPTION ERROR 874 AND ASSERTION FAILURE ON LINUX.

APAR status

• Closed as program error.

Error description

• While executing a stored procedure on Linux , an optimizer
  exception 874 error is returned to the client and an Assertion
  Failure occurs.
  
  14:42:48  IBM Informix Dynamic Server Version 11.50.FC7
  Software Serial Number AAA#B000000
  
  14:42:48  Assert Failed: Exception Caught. Type: MT_EX_OS,
  Context: mem
  14:42:48  Who: Session(57, informix@host, 23784, 0x4b795120)
                  Thread(974, sqlexec, 4b757658, 1)
                  File: mtex.c Line: 417
  14:42:48  Action: Please notify IBM Informix Technical Support.
  14:42:48  Raw hex dump of stack located in
  /tmp/af.7b6ecc8.rawstk
  14:42:48  Stack for thread: 974 sqlexec
  
  afstack
  afhandler
  affail_interface
  mt_ex_throw_sig
  afsig_handler
  <signal frame>
  walkvcb
  walkvexpr
  walkvexpr
  opviewexpr
  opfiltr
  opinit
  op_opinit
  sqoptim
  ip_scuroptim
  ip_scurstart
  ip_evalcursor
  runproc
  udrlm_spl_execute
  udrlm_exec_routine
  udr_execute
  exroutine
  execproc
  aud_execproc
  excommand
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users of 11.50.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query may generate assertion failure and give -874 error   *
  * under the following conditions:                              *
  *  - query uses a view which has UNION or UNION ALL in the     *
  * view definition                                              *
  *  - one or more arms of the UNION have at least one           *
  * correlated subquery in the projection list, and also have    *
  * group by                                                     *
  *  - the main query has in its where clause a predicate        *
  * involving view column corresponding to the correlated        *
  * subquery in view projection clause                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC9.                                        *
  ****************************************************************
  

Problem conclusion

• The problem is fixed in 11.50.xC9.
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP