Informix - Problem description
Problem IT37667 | Status: Closed |
POTENTIAL FOR MEMORY CORRUPTION AND INSTANCE FAILURE WHEN ENABLING STMT_CACHE_QUERY_PLAN | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Enabling STMT_CACHE_QUERY_PLAN can result in the instance assert failing after which the instance may become unresponsive. The following reproduces the problem: create table tab1 (col1 serial, col2 datetime year to second default current year to second) lock mode row; create unique index tab1_idx1 on tab1 (col1); create index tab1_idx2 on tab1 (col2); set explain on; select max(col1) from tab1 where col2 + 500 UNITS SECOND < CURRENT; Reviewing the Assertion Failure file the following stack is seen: Stack for thread: 104 sqlexec base: 0x0000000047eb2000 len: 69632 pc: 0x00000000014c1d8d tos: 0x0000000047ec0290 state: running vp: 1 (oninit) afstack (oninit) afhandler (oninit) affail_interface (oninit) mem_asfail (oninit) mt_checkpool2 (oninit) mt_realloc (oninit) ex_gcv_print (oninit) opexplain (oninit) closecb (oninit) close_cb_subtree (oninit) closesdb (oninit) sq_close (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Local Fix: | |
Turn off STMT_CACHE_QUERY_PLAN | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 14.10.xC7. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 14.10.xC7. * **************************************************************** | |
Comment | |
Fixed in Informix Server 14.10.xC7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.07.2021 01.11.2021 01.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |