home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC12 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