|
Problem IT10336
|
Status: Closed |
DUPLICATES IN ROUTINE RESOLUTION CACHE POSSIBLE WHEN FUNCTIONS WITH THE SAME NAME IN DIFFERENT DATABASES ARE CONCURRENTLY RUN |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
You may observe many duplicate entries for a function of the
same name called in different databases in the routine
resolution cache, for example:
Routine Resolution Cache:
Number of lists : 31
DS_POOLSIZE : 127
Routine Resolution Cache Entries:
list id ref drop hits heap_ptr udr_name
--------------------------------------------------------------
18 0 0 0 0 47627838
rr5@server:.ikeyextractcolno
18 0 0 1 1 4762a438
rr2@server:.ikeyextractcolno
18 0 0 1 1 475a0c38
rr4@server:.ikeyextractcolno
18 0 0 1 1 47627438
rr2@server:.ikeyextractcolno
18 0 0 1 1 475a0838
rr4@server:.ikeyextractcolno
18 0 0 1 1 47627c38
rr2@server:.ikeyextractcolno
18 0 0 1 1 46dd7038
rr5@server:.ikeyextractcolno
18 0 0 1 1 475a0438
rr4@server:.ikeyextractcolno
18 0 0 1 1 475a0038
rr2@server:.ikeyextractcolno
18 0 0 1 1 46dda838
rr2@server:.ikeyextractcolno
18 0 0 1 1 475dac38
rr2@server:.ikeyextractcolno
18 0 0 1 1 475da838
rr1@server:.ikeyextractcolno
18 0 0 1 1 46ddac38
rr2@server:.ikeyextractcolno
18 0 0 1 1 475da438
rr5@server:.ikeyextractcolno
...
You will note that almost all entries are having a 1 in the drop
column indicating that they are essentially marked as dropped
but do not get deleted from the list.
This situation will not be static and the number of entries can
fluctuate, however, it seems not to decrease back to the
expected low number without a restart of the instance.
This can also lead to a contention of the RR_ID mutex as
observed via onstat -g wmx for example:
Mutexes with waiters:
mid addr name holder lkcnt
waiter waittime
5736 50f516b8 RR_ID hash 18 6481133 0
6481083 0
6480532 0
6479989 0
6481093 0
6481218 0
6480452 0
6458429 0
6481199 0
6481066 0
6481189 0
6479901 0
6481137 0
6481193 0
6409288 0
6479929 0
6468481 0
6479116 0
6481113 0
... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Those executing same functions in parallel sessions. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.07.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
