Informix - Problem description
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) |