home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT06461 Status: Closed

QUERY WITH A SUBQUERY THAT USES GROUP AND ORDER BY CRASHES THE INSTANCE
WITH ERROR -959/-172

product:
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10
Problem description:
Running a query on 12.10.xC4W1 fails with errors 
-959/-172/-25587 and creates an Assertion Failure file. 
 
959: The current transaction has been rolled back due to an 
internal error. 
172: ISAM error:  Unexpected internal error 
25587: Network receive failed. 
 
The syntax of the query is : 
 
select col1, col2, col3, col4, col5, col6, col7, col8, col9, 
col10, col11, col12, col13, col14, col15 
from table_a 
where colX in (select colX from table_b 
                     where ........ 
                     group by 1,2,3,4,5,6, 7,8,9,10,11,12,13,14 
                     order by cola, colb, colc; 
 
$ dbaccess testdb repro 
 
Database selected. 
 
  959: The current transaction has been rolled back due to an 
internal error. 
 
  172: ISAM error:  Unexpected internal error 
Error in line 11 
Near character position 75 
 
25587: Network receive failed. 
 
online.log shows : 
 
19:15:47  Maximum server connections 1 
19:15:47  Checkpoint Statistics - Avg. Txn Block Time 0.000, # 
Txns blocked 0, Plog used 32, Llog used 1650 
 
19:17:31  Assert Failed: No Exception Handler 
19:17:31  IBM Informix Dynamic Server Version 12.10.FC4W1 
19:17:31   Who: Session(36, informix@server, 5825, 0x44e87908) 
                Thread(50, sqlexec, 44e477e8, 1) 
                File: mtex.c Line: 508 
19:17:31   Results: Exception Caught. Type: MT_EX_OS, Context: 
mem 
19:17:31   Action: Please notify IBM Informix Techical Support. 
19:17:31   See Also: /home/pd/informix/tmp1/af.41a722b 
19:17:50  Thread ID 50 will now be suspended. 
 
Stack trace: 
 
afstack 
mt_ex_throw_sig 
afsig_handler 
<signal frame> 
clp2ord 
clp2ordcol 
qblk2cb 
stmt2cb 
p_sp2cb 
parsecmd 
sqcmd 
sq_cmnd 
sq_prepare 
sqmain 
spawn_thread 
th_init_initgls 
startup
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* 12.10.XCX                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10                          * 
****************************************************************
Local Fix:
Solution
Problem Fixed In IBM Informix Server 12.10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.01.2015
16.10.2015
16.10.2015
Problem solved at the following versions (IBM BugInfos)
12.10.0
Problem solved according to the fixlist(s) of the following version(s)
12.10.xC5 FixList
12.10.xC5.W1 FixList