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 number
IC73095
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-07
Closed date
2011-09-27
Last modified date
2011-09-27
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
27 September 2011