Informix - Problem description
Problem IT32674 | Status: Closed |
MULTIPLE ASSERT FAILURES FROM EXECUTION OF STORED PROCEDURE ON ASECONDARY SERVER USING REMOTE TABLE LOCATED ON SAME SERVER | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The execution of a stored procedure on a secondary server that performs a query of a remote table where the server name given for the table is the same secondary server will result in multiple AFs. An example of the first AF: Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem Who: Session(42, informix@sechost, 16926, 10ab2e748) Thread(70, sqlexec, 10aaf86a8, 1) File: mtex.c Line: 420 Stack for thread: 70 sqlexec oninit :: remprepare + 0x144 oninit :: qd_prepare + 0x68 oninit :: qd_getqplan + 0x780 oninit :: ip_evalexpr + 0x96c oninit :: runproc + 0xca4 oninit :: udrlm_spl_execute + 0xdbc oninit :: udrlm_exec_routine + 0x71c oninit :: udr_execute + 0x17a0 oninit :: udr_spl_curnext + 0x98 oninit :: ip_curnext + 0x1ac oninit :: ip_fetch + 0x104 oninit :: getrow + 0xfc oninit :: fetchrow + 0x308 oninit :: exfetch + 0x758 oninit :: sql_nfetch + 0x8e0 oninit :: sq_nfetch + 0x298 oninit :: sqmain + 0xd68 This is then followed by a further AF when the database is closed: oninit :: release_remnode + 0x37c oninit :: walknode + 0x138 oninit :: remrelease + 0x50 oninit :: closecb + 0x658 oninit :: close_cb_subtree_r + 0xe8 oninit :: close_cb_subtree_r + 0x2a8 oninit :: close_cb_subtree + 0x9c oninit :: closesdb + 0x4a8 oninit :: doreleasesdb + 0x1e0 oninit :: drpcurlist + 0x268 oninit :: dormstproc + 0x64 oninit :: rmstproc + 0x54 oninit :: freecache + 0x4 oninit :: sqdbclose + 0x115c oninit :: aud_sqdbclose + 0x4bc oninit :: excommand + 0x15e4 oninit :: sq_execute + 0x414 oninit :: sqmain + 0xd68 An example of the query used in the stored procedure: select count(*) into nrow from testdb@hdr_svr:t1; | |
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 : | 28.04.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) |