Informix - Problem description
Problem IT34205 | Status: Closed |
STATEMENT WITH GROUP BY CAN CAUSE -640 ERROR IN STATEMENT CACHE AND THEN TRIGGER SEGV ASSERTION TRYING TO CLEANUP | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
Here is the stack trace for the SIGSEGV assertion failure: 0x00000000014a458d (oninit) afstack 0x00000000014aa4b1 (oninit) mt_ex_throw_sig 0x00000000014b88a8 (oninit) afsig_handler 0x00007fc7ba70b5e0 (Linux) 0x00000000009e2134 (oninit) oplooksubq 0x00000000009e2210 (oninit) oplooksubq 0x00000000007c803d (oninit) remrelease 0x0000000000660dd7 (oninit) closecb 0x0000000000661eb6 (oninit) close_cb_subtree 0x0000000000662cf7 (oninit) closesdb 0x000000000066306a (oninit) doreleasesdb 0x000000000075e028 (oninit) ssc_link 0x0000000000aa7452 (oninit) parsecmd 0x0000000000aa78b3 (oninit) sqcmd 0x0000000000aa7f3d (oninit) sq_prepare 0x0000000000b8eeae (oninit) sqmain 0x00000000015d2e3b (oninit) spawn_thread 0x0000000001495103 (oninit) th_init_initgls 0x00000000014dc0bf (oninit) startup Here is the SQL statement from the onstat -g ses output that also shows the -640 error that is triggering the code to get into the above code path: Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 4 SELECT db1 CR Not Wait -640 0 9.41 Off Current SQL statement (550) : SELECT FIRST 1 l.emp, l.intenc, l.intart, l.dcoart, l.dtmart, l.qtdanu , sum(nvl(b.qtdanu,0)) FROM x_enclin l , outer x_encanu b WHERE l.emp = ? AND l.intenc = ? AND b.emp = l.emp AND b.intenc = l.intenc AND b.intart = l.intart AND b.dtmart = l.dtmart AND b.dcoart = l.dcoart GROUP BY 1,2,3,4,5,6 HAVING ( sum(nvl(b.qtdanu,0)) != l.qtdanu) The server has the following values in the $ONCONFIG indicating the sql statement cache is in use: STMT_CACHE 2 STMT_CACHE_HITS 3 STMT_CACHE_SIZE 5120 STMT_CACHE_NOLIMIT 0 STMT_CACHE_NUMPOOL 1 | |
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: | |
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 : | 14.09.2020 09.12.2020 09.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |