Type:
Priority:
Resolution:
Unresolved
Affects Version/s:
10.4.8 , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL)
INSTALL PLUGIN server_audit SONAME 'server_audit.so';
# 0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S: 135
# 1 0x00007ffa57d4ae01 in _L_lock_1093 () from /usr/lib64/libpthread.so. 0
# 2 0x00007ffa57d4ada2 in __GI___pthread_mutex_lock (mutex=mutex @entry = 0x7ffa59800600 <LOCK_global_system_variables>) at ../nptl/pthread_mutex_lock.c: 133
# 3 0x00007ffa587ad083 in inline_mysql_mutex_lock (src_file= 0x7ffa58ead250 "/data01/jinmh/mdb_4.0/mariadb-10.4.8/sql/sql_plugin.cc" , src_line= 3037 ,
that=<optimized out>) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /include/mysql/psi/mysql_thread.h: 712
# 4 sync_dynamic_session_variables (thd=thd @entry = 0x7ff8c0002ea8 , global_lock=global_lock @entry = true )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_plugin.cc: 3037
# 5 0x00007ffa587ad12c in intern_sys_var_ptr (thd= 0x7ff8c0002ea8 , offset= 128 , global_lock=<optimized out>)
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_plugin.cc: 3104
# 6 0x00007ff9901f3d25 in get_loc_info (thd= 0x7ff8c0002ea8 ) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /plugin/server_audit/server_audit.c: 953
# 7 mark_always_logged (thd= 0x7ff8c0002ea8 ) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /plugin/server_audit/server_audit.c: 2594
# 8 update_logging (thd= 0x7ff8c0002ea8 , var=<optimized out>, var_ptr=<optimized out>, save=<optimized out>)
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /plugin/server_audit/server_audit.c: 2864
# 9 0x00007ffa587ad84b in sys_var_pluginvar::global_update ( this = 0x7ff90c0fbf58 , thd= 0x7ff8c0002ea8 , var= 0x7ff8c000acc8 )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_plugin.cc: 3567
# 10 0x00007ffa58703033 in sys_var::update ( this = 0x7ff90c0fbf58 , thd= 0x7ff8c0002ea8 , var= 0x7ff8c000acc8 )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/set_var.cc: 208
# 11 0x00007ffa58703567 in set_var::update ( this =<optimized out>, thd=<optimized out>) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/set_var.cc: 837
# 12 0x00007ffa587048c9 in sql_set_variables (thd=thd @entry = 0x7ff8c0002ea8 , var_list= 0x7ff8c000a018 , var_list @entry = 0x0 , free=free @entry = true )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/set_var.cc: 740
# 13 0x00007ffa587a2a87 in mysql_execute_command (thd=thd @entry = 0x7ff8c0002ea8 ) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_parse.cc: 4964
# 14 0x00007ffa587b25f8 in Execute_sql_statement::execute_server_code ( this =<optimized out>, thd= 0x7ff8c0002ea8 )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_prepare.cc: 3757
# 15 0x00007ffa587b6141 in Prepared_statement::execute_server_runnable ( this = this @entry = 0x7ff8ca7f75a0 ,
server_runnable=server_runnable @entry = 0x7ff8ca7f7990 ) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_prepare.cc: 4452
# 16 0x00007ffa587b6ff3 in Ed_connection::execute_direct ( this = this @entry = 0x7ff8ca7f8260 , server_runnable=server_runnable @entry = 0x7ff8ca7f7990 )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_prepare.cc: 5041
# 17 0x00007ffa587b70cf in Ed_connection::execute_direct ( this = this @entry = 0x7ff8ca7f8260 , sql_text=...)
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /sql/sql_prepare.cc: 5009
# 18 0x00007ff9a9d40223 in mdb::Mdb_inner_caller::execute_query ( this = 0x7ff8c0000f40 , sql_text=..., result=result @entry = 0x7ff8ca7f86b0 ,
errmsg=errmsg @entry = 0x7ff8ca7f86d0 ) at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /storage/mdb/src/handler/mdb_inner_caller.cc: 269
# 19 0x00007ff9a9ea6223 in mdb::CMiscWorker::exec_dmdb_sql (param=param @entry = 0x7ff9cc1fa900 )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /storage/mdb/src/rpl/mdb_misc_worker.cpp: 192
# 20 0x00007ff9a9eb32ee in mdb::handle_forward_sql (p= 0x7ff9cc1fa900 )
at /data01/jinmh/mdb_4. 0 /mariadb- 10.4 . 8 /storage/mdb/src/session/mdb_session_service.cc: 81
# 21 0x00007ffa57d48dd5 in start_thread (arg= 0x7ff8ca7f9700 ) at pthread_create.c: 307
# 22 0x00007ffa55855ead in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S: 111
{"report":{"fcp":751.8999998569489,"ttfb":151.20000004768372,"pageVisibility":"visible","entityId":98260,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":1,"journeyId":"28ceacdf-ef6e-46d0-a969-15c2da69f6ad","navigationType":0,"readyForUser":831.0999999046326,"redirectCount":0,"resourceLoadedEnd":736.5,"resourceLoadedStart":157.20000004768372,"resourceTiming":[{"duration":131.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":157.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":288.5,"responseStart":0,"secureConnectionStart":0},{"duration":131,"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":157.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":288.5,"responseStart":0,"secureConnectionStart":0},{"duration":140.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":157.70000004768372,"connectEnd":157.70000004768372,"connectStart":157.70000004768372,"domainLookupEnd":157.70000004768372,"domainLookupStart":157.70000004768372,"fetchStart":157.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":157.70000004768372,"responseEnd":297.89999985694885,"responseStart":297.89999985694885,"secureConnectionStart":157.70000004768372},{"duration":203.39999985694885,"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":157.70000004768372,"connectEnd":157.70000004768372,"connectStart":157.70000004768372,"domainLookupEnd":157.70000004768372,"domainLookupStart":157.70000004768372,"fetchStart":157.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":157.70000004768372,"responseEnd":361.09999990463257,"responseStart":361.09999990463257,"secureConnectionStart":157.70000004768372},{"duration":206.70000004768372,"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":157.79999995231628,"connectEnd":157.79999995231628,"connectStart":157.79999995231628,"domainLookupEnd":157.79999995231628,"domainLookupStart":157.79999995231628,"fetchStart":157.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":157.79999995231628,"responseEnd":364.5,"responseStart":364.5,"secureConnectionStart":157.79999995231628},{"duration":207.29999995231628,"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":158,"connectEnd":158,"connectStart":158,"domainLookupEnd":158,"domainLookupStart":158,"fetchStart":158,"redirectEnd":0,"redirectStart":0,"requestStart":158,"responseEnd":365.2999999523163,"responseStart":365.2999999523163,"secureConnectionStart":158},{"duration":207.89999985694885,"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":158,"connectEnd":158,"connectStart":158,"domainLookupEnd":158,"domainLookupStart":158,"fetchStart":158,"redirectEnd":0,"redirectStart":0,"requestStart":158,"responseEnd":365.89999985694885,"responseStart":365.89999985694885,"secureConnectionStart":158},{"duration":208.39999985694885,"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":158.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":208.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":158.29999995231628,"connectEnd":158.29999995231628,"connectStart":158.29999995231628,"domainLookupEnd":158.29999995231628,"domainLookupStart":158.29999995231628,"fetchStart":158.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":158.29999995231628,"responseEnd":366.59999990463257,"responseStart":366.59999990463257,"secureConnectionStart":158.29999995231628},{"duration":208.70000004768372,"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":158.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":367.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":208.79999995231628,"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":158.5,"connectEnd":158.5,"connectStart":158.5,"domainLookupEnd":158.5,"domainLookupStart":158.5,"fetchStart":158.5,"redirectEnd":0,"redirectStart":0,"requestStart":158.5,"responseEnd":367.2999999523163,"responseStart":367.2999999523163,"secureConnectionStart":158.5},{"duration":576.4000000953674,"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":159.39999985694885,"connectEnd":159.39999985694885,"connectStart":159.39999985694885,"domainLookupEnd":159.39999985694885,"domainLookupStart":159.39999985694885,"fetchStart":159.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":159.39999985694885,"responseEnd":735.7999999523163,"responseStart":735.7999999523163,"secureConnectionStart":159.39999985694885},{"duration":572.6000001430511,"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":163.89999985694885,"connectEnd":163.89999985694885,"connectStart":163.89999985694885,"domainLookupEnd":163.89999985694885,"domainLookupStart":163.89999985694885,"fetchStart":163.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":163.89999985694885,"responseEnd":736.5,"responseStart":736.5,"secureConnectionStart":163.89999985694885},{"duration":177.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":507.39999985694885,"connectEnd":507.39999985694885,"connectStart":507.39999985694885,"domainLookupEnd":507.39999985694885,"domainLookupStart":507.39999985694885,"fetchStart":507.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":507.39999985694885,"responseEnd":684.8999998569489,"responseStart":684.8999998569489,"secureConnectionStart":507.39999985694885},{"duration":192.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":725,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":725,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":917.0999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":20,"responseStart":152,"responseEnd":156,"domLoading":155,"domInteractive":898,"domContentLoadedEventStart":898,"domContentLoadedEventEnd":941,"domComplete":1729,"loadEventStart":1729,"loadEventEnd":1731,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":879.7000000476837},{"name":"bigPipe.sidebar-id.end","time":880.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":880.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":883},{"name":"activityTabFullyLoaded","time":953.3999998569489}],"measures":[],"correlationId":"310ca1a610ad20","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":73,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
MDEV-19665 Server hangs on client connection with concurrent setting of server audit variable
