|
Problem IT28486
|
Status: Closed |
INSERT/UPDATE OPERATION ON TABLE WITH A HIGH NUMBER OF REF CONSTRAINTS CAUSE INH LIST MUTEX CONTENTION
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
The testcase environment consists on a table as a master table
where referential constraints
are defined for a higher number of tables. In the testcase 1000,
in the original customer
environment on the first level a one to 150 relation and more on
the level below.
When an insert is done on the master table for this environment
in concurrency on the mutex
side the following wait situation is seen
Locked mutexes:
mid addr name holder lkcnt
waiter waittime
3638 45d4b6b8 bld ref 27 0 24
6837 46a2dbf8 INH list 1372 1
1382 0
1377 0
1383 0
1384 0
1379 0
1367 0
1375 0
1366 0
1380 0
1362 0
1378 0
1370 0
1363 0
1369 0
1373 0
1361 0
1374 0
1376 0
The stack for the waiter is
Stack for thread: 236238 sqlexec
base: 0x000000052d9d7000
len: 167936
pc: 0x0000000001434167
tos: 0x000000052d9fe420
state: mutex wait
vp: 75
0x0000000001434167 (/opt/informix_vegas/bin/oninit)
yield_processor_mvp
0x000000000144063e (/opt/informix_vegas/bin/oninit) mt_lock_wait
0x0000000001440b7c (/opt/informix_vegas/bin/oninit)
mt_lock_relmutex
0x000000000073e39e (/opt/informix_vegas/bin/oninit)
getinheritcache
0x000000000073ed03 (/opt/informix_vegas/bin/oninit)
lookupinherits
0x00000000008a44e3 (/opt/informix_vegas/bin/oninit)
make_constr_tab_hierarchy
0x00000000008a67cc (/opt/informix_vegas/bin/oninit)
set_per_constr_tabs
0x00000000008ab7b7 (/opt/informix_vegas/bin/oninit) bldrefsx
0x0000000000a2abf3 (/opt/informix_vegas/bin/oninit)
maybe_bldrefs
0x0000000000a2af38 (/opt/informix_vegas/bin/oninit) sqbind
0x0000000000a4520e (/opt/informix_vegas/bin/oninit)
sq_common_bind
0x0000000000b0a271 (/opt/informix_vegas/bin/oninit) sqmain
0x000000000154a14b (/opt/informix_vegas/bin/oninit) spawn_thread
0x000000000140f0e0 (/opt/informix_vegas/bin/oninit)
th_init_initgls
0x0000000001454908 (/opt/informix_vegas/bin/oninit) startup
The owner is in a similar stack
bldsubtype
0x000000000073e39e (/opt/informix_vegas/bin/oninit)
getinheritcache
0x000000000073ed03 (/opt/informix_vegas/bin/oninit)
lookupinherits
0x00000000008a44e3 (/opt/informix_vegas/bin/oninit)
make_constr_tab_hierarchy
0x00000000008a67cc (/opt/informix_vegas/bin/oninit)
set_per_constr_tabs
0x00000000008ab7b7 (/opt/informix_vegas/bin/oninit) bldrefsx
0x0000000000a2abf3 (/opt/informix_vegas/bin/oninit)
maybe_bldrefs
0x0000000000a2af38 (/opt/informix_vegas/bin/oninit) sqbind
0x0000000000a4520e (/opt/informix_vegas/bin/oninit)
sq_common_bind
0x0000000000b0a271 (/opt/informix_vegas/bin/oninit) sqmain
0x000000000154a14b (/opt/informix_vegas/bin/oninit) spawn_thread
0x000000000140f0e0 (/opt/informix_vegas/bin/oninit)
th_init_initgls
0x0000000001454908 (/opt/informix_vegas/bin/oninit) startup
The inheritance cache, this is the one we are working on, should
be empty as also the
catalog table sysinherits is empty. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Insert/Update operation on table with a high number of *
* referential constraints causes INH list mutex contention. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.03.2019
24.09.2019
24.09.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
