home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT09130 Status: Geschlossen

RATIO_TO_REPORT IN GROUP BY CLAUSE CRASHES ENGINE

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* 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                      * 
****************************************************************
Local-Fix:


Lösung


Problem Fixed In IBM Informix Server 12.10.xC6


Workaround


keiner bekannt / siehe Local-Fix


Weitere Daten


Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.05.2015
30.12.2015
30.12.2015


Problem behoben ab folgender Versionen (IBM BugInfos)


12.10.xC6



Problem behoben lt. FixList in der Version


12.10.xC6

FixList