IT07694: ASSERT FAILURE AND CRASH ON A QUERY UTILIZING VIEW MATERIALIZATION IF IFX_FOLDVIEW IS ENABLED

APAR status

• Closed as program error.

Error description

• You are running a query involving tables and views with
  IFX_FOLDVIEW set to 1. The query fails with the following error
  codes:
  
    959: The current transaction has been rolled back due to an
  internal error.
  
    172: ISAM error:  Unexpected internal error
  
  At the same time an Assert Failure is reported in the message
  log file (usually referenced as online.log). For example:
  
  08:15:40  Assert Failed: No Exception Handler
  08:15:40  IBM Informix Dynamic Server Version 12.10.FC5
  08:15:40   Who: Session(34, informix@server, 12854, 0x44ca8b18)
    Thread(62, sqlexec, 44c687e8, 1)
    File: mtex.c Line: 508
  08:15:40   Results: Exception Caught. Type: MT_EX_OS, Context:
  mem
  08:15:40   Action: Please notify IBM Informix Techical Support.
  08:15:40   See Also: /usr/informix/tmp/af.4265efc,
  shmem.4265efc.0
  
  You checked the af.* file produced and found the failure stack
  similar to the following:
  
  afstack
  mt_ex_throw_sig
  afsig_handler
  <signal frame>
  _wordcopy_fwd_dest_aligned
  __GI_memmove
  evalcols
  filltemp
  scan_open
  materialize_viewtmp
  materialize_viewtmp
  materialize_viewtmp
  materialize_viewtmp
  prepselect
  open_cursor
  sql_open
  sq_open
  sqmain
  spawn_thread
  th_init_initgls
  startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of 12.10.xC4.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query may result in assertion failure under the following  *
  * conditions:                                                  *
  *   - query references multiple views and derived tables in    *
  * the same query block, one of which is a UNION ALL view,      *
  * which can be folded, the other is a derived table that is    *
  * materialized into a temp table                               *
  *   - the UNION ALL view is simple, does not contain group by, *
  * order by, aggregation, skip/first options                    *
  *   - the derived table contains group by                      *
  *   - the derived table is specified before the UNION ALL view *
  * in the FROM clause of the query                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC6.                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC6.
  

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 PSN

     UP