The simple query below reproduces the problem without host
variables which were present in the original HQ query against
12.10.FC13 on linux x86_64.
In dbaccess, the first query below (where sql_id = 4) runs fine
and returns no rows, but the second query (where sql_id = -4)
causes an assert failurewith below stack:
As informix:
$ dbaccess sysmaster -
> SELECT sql_id, sql_itr_id, sql_itr_left, sql_itr_right,
sql_itr_sender,
> sql_itr_nxtsender, sql_itr_cost, sql_itr_estrows,
sql_itr_numrows,
> sql_itr_type, sql_itr_misc, sql_itr_info, sql_itr_time,
sql_itr_partnum
> FROM syssqltrace_iter WHERE sql_id = 4 ORDER BY sql_itr_id;
No rows found.
> SELECT sql_id, sql_itr_id, sql_itr_left, sql_itr_right,
sql_itr_sender,
> sql_itr_nxtsender, sql_itr_cost, sql_itr_estrows,
sql_itr_numrows,
> sql_itr_type, sql_itr_misc, sql_itr_info, sql_itr_time,
sql_itr_partnum
> FROM syssqltrace_iter WHERE sql_id = -4 ORDER BY sql_itr_id;
959: The current transaction has been rolled back due to an
internal error.
172: ISAM error: Unexpected internal error
Error in line 4
Near character position 57
>
From online.log:
03/08/20 21:22:21 Assert Failed: No Exception Handler
03/08/20 21:22:21 IBM Informix Dynamic Server Version
12.10.FC13
03/08/20 21:22:21 Who: Session(43, informix@hostname,
21312, 0x451ec4e8)
Thread(57, sqlexec, 451ad528, 8)
File: mtex.c Line: 508
03/08/20 21:22:21 Results: Exception Caught. Type: MT_EX_OS,
Context: mem
03/08/20 21:22:21 Action: Please notify IBM Informix Technical
Support.
03/08/20 21:22:21 See Also:
$INFORMIXDIR/tmp/af.421a85c
03/08/20 21:22:23 Thread ID 57 will now be suspended.
21:22:21 Stack for thread: 57 sqlexec
base: 0x0000000059dc6000
len: 266240
pc: 0x000000000142e819
tos: 0x000000005923a310
state: running
vp: 8
0x000000000142e819 (oninit) afstack
0x0000000001432301 (oninit) mt_ex_throw_sig
0x000000000143b453 (oninit) afsig_handler
0x0000003ddfa0e4c0 (Linux)
0x0000000000e61dce (oninit) pstposit
0x0000000000e6c6c3 (oninit) pststart
0x0000000000d3a641 (oninit) rsstart
0x000000000151d2d3 (oninit) fmstart
0x000000000081b371 (oninit) readidx_new
0x000000000081e734 (oninit) gettupl
0x00000000008213b4 (oninit) scan_next
0x0000000000848606 (oninit) sort_open
0x000000000082524e (oninit) prepselect
0x0000000000a4582e (oninit) open_cursor
0x0000000000a4d799 (oninit) sql_open
0x0000000000a4d986 (oninit) sq_open
0x0000000000b0b641 (oninit) sqmain
0x000000000155d1ab (oninit) spawn_thread
0x0000000001420130 (oninit) th_init_initgls
0x0000000001465c48 (oninit) startup |
