Informix - Problem description
Problem IT32097 | Status: Closed |
SELECT FROM SYSSQLTRACE_ITER WHERE SQL_ID IS NEGATIVE YIELDS ASSERT FAILURE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC4. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC4. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.03.2020 11.12.2020 11.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |