Informix - Problem description
Problem IT32724 | Status: Closed |
SPL USING EXECUTE IMMEDIATE AND SQLTRACE IS ON CAN CAUSE AF ON STMTMON_SAVE_ITERATOR | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When a stored procedure is using execute immediate expressions in order to drop/create tables and indexes on the tables and SQLTRACE is on, an assertion failed may be seen: 0x00000000006d2db8 (oninit) stmtmon_save_iterator 0x00000000006dd933 (oninit) stmtmon_insert 0x00000000005fb56b (oninit) excommand 0x00000000006b9aa2 (oninit) ip_evalsql 0x00000000006ba35a (oninit) ip_execimmed 0x00000000006c18a5 (oninit) runproc 0x00000000006c2f01 (oninit) udrlm_spl_execute 0x0000000000a86c1e (oninit) udrlm_exec_routine 0x00000000006fe0f9 (oninit) udr_execute 0x0000000000704855 (oninit) exroutine 0x0000000000a4345d (oninit) sq_exproc 0x0000000000b0b6c1 (oninit) sqmain 0x000000000155d25b (oninit) spawn_thread 0x00000000014201b0 (oninit) th_init_initgls | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.05.2020 29.12.2020 29.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |