Application verifier reports an error in plugins_var test (recursive read lock on reader writer lock) for LOCK_system_variables_hash.
The lock is acquired in sql_show.cc , in fill_variables() function
mysql_rwlock_rdlock(&LOCK_system_variables_hash);
|
res= show_status_array(thd, wild, enumerate_sys_vars(thd, sorted_vars, scope),
|
scope, NULL, "", tables->table,
|
upper_case_names, partial_cond);
|
mysql_rwlock_unlock(&LOCK_system_variables_hash);
|
however the same lock is acquired again deeper inside show_status array. appverifier points to this callstack
srw_rdlock+0xa [h:\work\server\mysys\thr_rwlock.c @ 89]
|
intern_sys_var_ptr+0x9b [h:\work\server\sql\sql_plugin.cc @ 2981]
|
sys_var_pluginvar::do_value_ptr+0x15 [h:\work\server\sql\sql_plugin.cc @ 3405]
|
sys_var::value_ptr+0x42 [h:\work\server\sql\set_var.cc @ 254]
|
show_status_array+0x33e [h:\work\server\sql\sql_show.cc @ 3285]
|
fill_variables+0x148 [h:\work\server\sql\sql_show.cc @ 7197]
|
On Windows, recursive shared lock acquire can cause a deadlock. Here is the explanation of the bug given by windbg command '!analyze -v'
APPLICATION_VERIFIER_SRWLOCK_RECURSIVE_ACQUIRE (253)
The SRW lock is being acquired recursively by the same thread.
This stop is generated if the SRW lock (Param1) is being acquired
recursively by the same thread.
This will result in a deadlock and the thread would block indefinitely.
Recursive acquisition of an SRW lock in exclusive mode will cause a deadlock.
Recursive acquisition of an SRW lock in shared mode will cause a deadlock when
there is a thread waiting for exclusive access. Consider the example below:
- Thread A acquires the SRW lock in shared mode
- Thread B tries to acruire the SRW lock in exclusive mode and waits
- Thread A tries to acquire the SRW lock in shared mode recursively. This will
be successful as long as there is no exclusive waiter (in this case B). Since
SRW locks do not have writer starvation, thread A waits behind thread B.
Now, Thread B is waiting for Thread A which is inturn waiting for Thread B
causing a circular wait and hence a deadlock.
{"report":{"fcp":714.5,"ttfb":196,"pageVisibility":"visible","entityId":56579,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"b0732a02-9f07-467a-8652-cd649f437e64","navigationType":0,"readyForUser":769.2000000476837,"redirectCount":0,"resourceLoadedEnd":373.7999999523163,"resourceLoadedStart":203.60000014305115,"resourceTiming":[{"duration":3.1999998092651367,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":203.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":206.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":3.6000001430511475,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":203.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":207.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":65.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":203.90000009536743,"connectEnd":203.90000009536743,"connectStart":203.90000009536743,"domainLookupEnd":203.90000009536743,"domainLookupStart":203.90000009536743,"fetchStart":203.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":211,"responseEnd":269.40000009536743,"responseStart":233.5,"secureConnectionStart":203.90000009536743},{"duration":85.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":204,"connectEnd":204,"connectStart":204,"domainLookupEnd":204,"domainLookupStart":204,"fetchStart":204,"redirectEnd":0,"redirectStart":0,"requestStart":212,"responseEnd":289.7999999523163,"responseStart":236.5,"secureConnectionStart":204},{"duration":29.299999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":204.10000014305115,"connectEnd":204.10000014305115,"connectStart":204.10000014305115,"domainLookupEnd":204.10000014305115,"domainLookupStart":204.10000014305115,"fetchStart":204.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":212,"responseEnd":233.40000009536743,"responseStart":232.60000014305115,"secureConnectionStart":204.10000014305115},{"duration":45.700000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":204.20000004768372,"connectEnd":204.20000004768372,"connectStart":204.20000004768372,"domainLookupEnd":204.20000004768372,"domainLookupStart":204.20000004768372,"fetchStart":204.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":214,"responseEnd":249.90000009536743,"responseStart":249.10000014305115,"secureConnectionStart":204.20000004768372},{"duration":42,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":204.29999995231628,"connectEnd":204.29999995231628,"connectStart":204.29999995231628,"domainLookupEnd":204.29999995231628,"domainLookupStart":204.29999995231628,"fetchStart":204.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":214.10000014305115,"responseEnd":246.29999995231628,"responseStart":245.60000014305115,"secureConnectionStart":204.29999995231628},{"duration":10.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":204.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":214.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":10.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":204.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":204.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":215.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":46.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":204.60000014305115,"connectEnd":204.60000014305115,"connectStart":204.60000014305115,"domainLookupEnd":204.60000014305115,"domainLookupStart":204.60000014305115,"fetchStart":204.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":216.70000004768372,"responseEnd":250.79999995231628,"responseStart":250,"secureConnectionStart":204.60000014305115},{"duration":53.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":204.70000004768372,"connectEnd":204.70000004768372,"connectStart":204.70000004768372,"domainLookupEnd":204.70000004768372,"domainLookupStart":204.70000004768372,"fetchStart":204.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":217.79999995231628,"responseEnd":258.60000014305115,"responseStart":257.7999999523163,"secureConnectionStart":204.70000004768372},{"duration":160,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":213.5,"connectEnd":213.5,"connectStart":213.5,"domainLookupEnd":213.5,"domainLookupStart":213.5,"fetchStart":213.5,"redirectEnd":0,"redirectStart":0,"requestStart":231.29999995231628,"responseEnd":373.5,"responseStart":368.7999999523163,"secureConnectionStart":213.5},{"duration":160.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":213.5,"connectEnd":213.5,"connectStart":213.5,"domainLookupEnd":213.5,"domainLookupStart":213.5,"fetchStart":213.5,"redirectEnd":0,"redirectStart":0,"requestStart":235.40000009536743,"responseEnd":373.7999999523163,"responseStart":369.5,"secureConnectionStart":213.5},{"duration":176.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":475.90000009536743,"connectEnd":475.90000009536743,"connectStart":475.90000009536743,"domainLookupEnd":475.90000009536743,"domainLookupStart":475.90000009536743,"fetchStart":475.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":620.2999999523163,"responseEnd":652.4000000953674,"responseStart":651.6000001430511,"secureConnectionStart":475.90000009536743},{"duration":37.799999952316284,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":688.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":688.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":726.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":55.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":703.5,"connectEnd":703.5,"connectStart":703.5,"domainLookupEnd":703.5,"domainLookupStart":703.5,"fetchStart":703.5,"redirectEnd":0,"redirectStart":0,"requestStart":727.5,"responseEnd":759,"responseStart":758.2999999523163,"secureConnectionStart":703.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":65,"responseStart":196,"responseEnd":212,"domLoading":199,"domInteractive":820,"domContentLoadedEventStart":820,"domContentLoadedEventEnd":860,"domComplete":1429,"loadEventStart":1429,"loadEventEnd":1431,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":802.9000000953674},{"name":"bigPipe.sidebar-id.end","time":803.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":803.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":806.1000001430511},{"name":"activityTabFullyLoaded","time":870.6000001430511}],"measures":[],"correlationId":"e1a0f937197bc6","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":70,"dbReadsTimeInMs":8,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}