|
Problem IT35940
|
Status: Closed |
MEMORY LEAK ON RALLOC ON REMOTE SERVERWHERE DATE(DATETIME_COL) =SUBQUERY WITH DATE_COL FROM A SYNONYM TO THE REMOTE SERVER
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Memory leak on ralloc on remote server when using where
date(datetime_col) = select date_col from a synonym to the
remote server
On a query like:
SELECT col2 FROM tablea WHERE DATE(col2) =
(SELECT rcol4 FROM rtableb WHERE rcol1="XXXX" AND rcol2 = "XXXX"
and rcol3 = "XXXX")
AND col1 = "XXX"
informix@farias-ThinkPad-P50:~/prods/14.10/FC5$ onstat -g ses 72
IBM Informix Dynamic Server Version 14.10.FC5AEE -- On-Line --
Up 01:43:20 -- 507908 Kbytes
2021-02-16 15:09:34
session effective #RSAM
total used dynamic
id user user tty pid hostname threads
memory memory explain
72 informix - 0 30902 xxxxxxxx 1
114688 103128 off
Program :
/home/informix/prods/14.10/FC5/bin/oninit
tid name rstcb flags curstk status
83 srvinfx 45962e48 Y--P--- 3824 cond wait
netnorm -
Memory pools count 2
name class addr totalsize freesize
#allocfrag #freefrag
72 V 4867f040 110592 10816 128
16
72*O0 V 4817f040 4096 744 1
1
name free used name free
used
overhead 0 6704 scb 0
144
opentable 0 4880 filetable 0
712
log 0 16536 temprec 0
2208
ralloc 0 30944 gentcb 0
1648
ostcb 0 2992 sqscb 0
22592
hashfiletab 0 552 osenv 0
3344
sqtcb 0 9392 fragman 0
336
sapi 0 144
sqscb info
scb sqscb optofc pdqpriority
optcompind directives
463011c0 481aa028 0 0 2
1
Sess SQL Current Iso Lock SQL
ISAM F.E.
Id Stmt type Database Lvl Mode ERR
ERR Vers Explain
72 - testcases CR Not Wait 0
0 9.59 Off
Last parsed SQL statement :
select x0.rcol4 from testcases:"informix".tableb x0 where
(((x0.rcol1 =
'IF2101' ) AND (x0.rcol2 = 'SIPP' ) ) AND (x0.rcol3 = 'INV'
) )
Subsequent runs of the query, remote server ralloc shows:
onstat -g ses 72|grep ralloc
ralloc 0 61960 gentcb 0
1648
onstat -g ses 72|grep ralloc
ralloc 0 92872 gentcb 0
1648
onstat -g ses 72|grep ralloc
ralloc 0 123784 gentcb 0
1648 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC6 (when available). *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC6. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC6 (when available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC15 and 14.10.xC6. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.02.2021
12.05.2021
12.05.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
