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 number
IT07694
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-03-13
Closed date
2015-12-30
Last modified date
2024-11-10
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 November 2024