Informix - Problem description
Problem IT30021 | Status: Closed |
EXECUTE QUERY THAT CREATES AN AUTO FUNCTIONAL INDEX IN A TRANSACTION THAT IT HAS NOT PREPARED WILL SEGV IN IS_MULTIROW_UDR | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
This problem was originally reported in 12.10.FC12W1 on linux x86_64 and the repro I developed dupes on the same platform running IDS 12.10.FC13. It is probably not linux specific. The test case prepares a statement that when executed creates an auto functional index. The statement is executed and current transaction is committed. Another transaction is started and an execute of the prepared statement will assert the server with a stack comparable to: 0x000000000142e819 (oninit) afstack 0x0000000001432301 (oninit) mt_ex_throw_sig 0x000000000143b453 (oninit) afsig_handler 0x0000003ddfa0e4c0 (Linux) 0x00000000005f0ad0 (oninit) is_multirow_udr 0x0000000001512ebe (oninit) fmamaddindex 0x000000000151a6e9 (oninit) fmaddindex 0x000000000080636f (oninit) filltemp_sqisaddindex 0x000000000080fc8c (oninit) tmptab_create_index 0x0000000000810d69 (oninit) filltemp 0x000000000081848f (oninit) scan_open 0x0000000000b7fe71 (oninit) join_open 0x0000000000b7fe53 (oninit) join_open 0x0000000000848131 (oninit) sort_open 0x000000000082524e (oninit) prepselect 0x00000000005fb681 (oninit) excommand 0x0000000000a4cc25 (oninit) sq_exselect 0x0000000000b0b641 (oninit) sqmain 0x000000000155d1ab (oninit) spawn_thread 0x0000000001420130 (oninit) th_init_initgls Description | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Comment | |
Update to Informix Server 12.10.xC14 or 14.10.xC3. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.08.2019 24.02.2020 24.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC3 | |
Problem solved according to the fixlist(s) of the following version(s) |