INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

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

**************************************************************** 
* 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 Fixed In IBM Informix Server 12.10.xC6.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.03.2015
30.12.2015
30.12.2015

12.10.xC6