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 |