Informix - Problem description
Problem IT34066 | Status: Closed |
SET EXPLAIN OFF CAN CAUSE ASSERT FAIL CALLING MT_AIO_FCLOSE FROMSETEXPLAIN | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Shortly after bringing the server on-line, it's possible for the server to assert with a stack like below when running set explain off. 0x00000000014e501d (oninit) afstack 0x00000000014eabe1 (oninit) mt_ex_throw_sig 0x00000000014f8d68 (oninit) afsig_handler 0x00007fa64fe205e0 (Linux) 0x00000000014cc299 (oninit) mt_aio_fclose 0x0000000000646a84 (oninit) setexplain 0x00000000007502de (oninit) aud_setexplain 0x0000000000640bd7 (oninit) excommand 0x0000000000af260b (oninit) sq_execute_workhorse 0x0000000000af2e4d (oninit) sq_execute 0x0000000000bc655e (oninit) sqmain 0x0000000001613a7a (oninit) spawn_thread 0x00000000014d5cf2 (oninit) th_init_initgls 0x000000000151c00f (oninit) startup The problem has a generally reliable reproduction, but after it asserts for the first time on a cpu vp it seems to no longer reproduce. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Setting the following onconfig parameter may work around the problem: STMT_CACHE_QUERY_PLAN 0 | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.08.2020 07.12.2020 07.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |