APAR status
Closed as program error.
Error description
With stores_demo database, following SQL crashes the engine: == select company, sum(ship_weight), sum(ship_charge), ratio_to_report(sum(ship_charge)) over() * 100 as ratio_charge from orders, customer where orders.customer_num=customer.customer_num group by 1,4; == 11:31:58 Assert Failed: No Exception Handler 11:31:58 IBM Informix Dynamic Server Version 12.10.FC2 11:31:58 Who: Session(63, informix@server, 10155, 10af5b7d0) Thread(231, sqlexec, 10af18d18, 10) File: mtex.c Line: 517 11:31:58 Results: Exception Caught. Type: MT_EX_OS, Context: mem 11:31:58 Action: Please notify IBM Informix Technical Support. 11:31:58 See Also: /space/ifmx/12.10.FC2/tmp/af.4cf1e8d, shmem.4cf1e8d.0 11:34:08 Need to fix... buffers no longer in res segment 11:39:20 mtex.c, line 517, thread 231, proc id 10059, No Exception Handler. 11:39:23 Fatal error in ADM VP at mt.c:14311 11:39:23 Unexpected virtual processor termination: pid = 10059, exit status = 0x1. 11:39:24 PANIC: Attempting to bring system down
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * users having RATIO_TO_REPORT function and group by * * operation. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * 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
IT09130
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-05-27
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