| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
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) | |
