Informix - Problem description
Problem IT34973 | Status: Closed |
UPDATE WITH SUBQUERY 'SELECT...UNION' FAILS AS ERROR: 959/172 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
10:17:11 Assert Failed: No Exception Handler 10:17:11 IBM Informix Dynamic Server Version 12.10.FC14 10:17:11 Who: Session(47, yyyyy@xxxxxx, 23473, 0x44f3c988) Thread(235, sqlexec, 44ef6388, 1) File: mtex.c Line: 508 10:17:11 Results: Exception Caught. Type: MT_EX_OS, Context: mem 10:17:11 Action: Please notify IBM Informix Technical Support. 10:17:11 See Also: /opt/informix/IBM/12.10.FC14/manesh115_darkwood/af.4d3e696 10:17:16 Thread ID 235 will now be suspended. 0x0000000001410459 (oninit) afstack 0x0000000001413f41 (oninit) mt_ex_throw_sig 0x000000000141de13 (oninit) afsig_handler 0x00007f01c80b3b10 (Linux) 0x00007f01c6f503a5 (/lib64/libc-2.22.so) __memset_avx2 0x00000000013a676b (oninit) rvalstring 0x00000000013be762 (oninit) rvalval 0x00000000006d8407 (oninit) eval_cast_internal 0x00000000006d6341 (oninit) udr_execute 0x00000000005ee1a8 (oninit) sqexcmp 0x0000000000879ab6 (oninit) chkrmk 0x000000000087ec89 (oninit) execute_union_leaf 0x000000000087fa12 (oninit) execute_union_node 0x000000000087fd8e (oninit) exusubq 0x00000000008800a5 (oninit) exsubq 0x000000000164e16f (oninit) ev_cb 0x000000000164d63e (oninit) new_eval 0x000000000089699e (oninit) eval_projection_list 0x0000000000897af1 (oninit) dodmlrow 0x00000000008996f0 (oninit) dodelupd 0x00000000005d4c33 (oninit) excommand 0x0000000000a27753 (oninit) sq_execute_workhorse 0x0000000000a27d6e (oninit) sq_execute 0x0000000000ae7b71 (oninit) sqmain 0x000000000154290b (oninit) spawn_thread 0x0000000001401c70 (oninit) th_init_initgls 0x0000000001448997 (oninit) startup create table t1 ( col1 int, col3 set(int not null) ); create table t2 ( col1 int, col3 set(int not null) ); insert into t1 values(0, "set{9}"); insert into t1 values(1, "set{9}"); insert into t2 values(0, "set{8}"); update t1 a set col1 = ( select 77 from t2 b WHERE b.col3 = a.col3 union select 77 from t2 b WHERE b.col3 = a.col3 ); 959: The current transaction has been rolled back due to an internal error. 172: ISAM error: Unexpected internal error | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC6 (when available). * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.11.2020 12.05.2021 12.05.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |