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 |
