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 |
|
| 12.10.xC5.W1 |
|