Type:
Bug
Priority:
Major
Resolution:
Duplicate
Affects Version/s:
10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11
Debug discussion with Thiru. Seen in bb-10.10-MDEV-28883 , but likely unrelated as per discussions with Thiru. Core+mysqld+libs+error log sent via drive/email.
10.10.0 2db18fdb3d68d906fbd188ec570a64502ba55849 (Debug)
(gdb) bt
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x0000153a4b571859 in __GI_abort () at abort.c:79
#2 0x000055eb6d644864 in safe_mutex_destroy (mp=mp@entry=0x1539c84caf50,
file=file@entry=0x55eb6da857d8 "/test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc", line=line@entry=274)
at /test/bb-10.10-MDEV-28883_dbg/mysys/thr_mutex.c:602
#3 0x000055eb6d57deef in inline_mysql_mutex_destroy (src_line=274,
src_file=0x55eb6da857d8 "/test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc", that=0x1539c84caf50)
at /test/bb-10.10-MDEV-28883_dbg/include/mysql/psi/mysql_thread.h:724
#4 fts_cache_destroy (cache=0x1539c84caf50) at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:274
#5 0x000055eb6d5828f0 in fts_t::~fts_t (this=0x1539c8201250, __in_chrg=<optimized out>)
at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:5080
#6 0x000055eb6d58295c in fts_free (table=table@entry=0x1539c84c5790)
at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc:5117
#7 0x000055eb6d5147f5 in dict_sys_t::remove (this=this@entry=0x55eb6e05c940 <dict_sys>, table=0x1539c84c5790,
lru=lru@entry=false, keep=keep@entry=false) at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/dict/dict0dict.cc:1957
#8 0x000055eb6d514cfb in dict_sys_t::close (this=0x55eb6e05c940 <dict_sys>)
at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/dict/dict0dict.cc:4592
#9 0x000055eb6d4025f3 in innodb_shutdown () at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/srv/srv0start.cc:1765
#10 0x000055eb6d1fd64c in innobase_end () at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/handler/ha_innodb.cc:4310
#11 0x000055eb6cefdff9 in ha_finalize_handlerton (plugin=0x55eb6fecc900) at /test/bb-10.10-MDEV-28883_dbg/sql/handler.cc:596
#12 0x000055eb6cc3354a in plugin_deinitialize (plugin=0x55eb6fecc900, ref_check=ref_check@entry=true)
at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:1269
#13 0x000055eb6cc3742b in reap_plugins () at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:1343
#14 0x000055eb6cc37f0e in plugin_shutdown () at /test/bb-10.10-MDEV-28883_dbg/sql/sql_plugin.cc:2051
#15 0x000055eb6cadd2b0 in clean_up (print_message=print_message@entry=true) at /test/bb-10.10-MDEV-28883_dbg/sql/mysqld.cc:1987
#16 0x000055eb6cae966c in mysqld_main (argc=<optimized out>, argv=<optimized out>)
at /test/bb-10.10-MDEV-28883_dbg/sql/mysqld.cc:5937
#17 0x000055eb6cadcb66 in main (argc=<optimized out>, argv=<optimized out>) at /test/bb-10.10-MDEV-28883_dbg/sql/main.cc:34
10.10.0 2db18fdb3d68d906fbd188ec570a64502ba55849 (Debug)
2022-07-02 5:06:35 0 [ERROR] InnoDB: (Too many concurrent transactions) while getting next doc id for table `test`.`articles`
2022-07-02 5:06:35 0 [ERROR] InnoDB: (Too many concurrent transactions) during SYNC of table `test`.`articles`
2022-07-02 5:06:35 0 [Note] InnoDB: FTS optimize thread exiting.
2022-07-02 5:06:35 0 [Note] InnoDB: Starting shutdown...
safe_mutex: Found wrong usage of mutex 'cache->lock' and 'LOCK_global_system_variables'
Mutex currently locked (in reverse order):
LOCK_global_system_variables /test/bb-10.10-MDEV-28883_dbg/storage/innobase/buf/buf0dump.cc line 182
cache->lock /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc line 4077
2022-07-02 5:06:35 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/130567/9332/data/ib_buffer_pool
2022-07-02 5:06:35 0 [Note] InnoDB: Buffer pool(s) dump completed at 220702 5:06:35
safe_mutex: Trying to destroy a mutex cache->lock that was locked at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc, line 4077 at /test/bb-10.10-MDEV-28883_dbg/storage/innobase/fts/fts0fts.cc, line 274
{"report":{"fcp":1393.800000011921,"ttfb":342.10000002384186,"pageVisibility":"visible","entityId":112566,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ba30180f-f682-427a-a51d-620b7f5aaa9c","navigationType":0,"readyForUser":1478.800000011921,"redirectCount":0,"resourceLoadedEnd":2343.300000011921,"resourceLoadedStart":348,"resourceTiming":[{"duration":464.30000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":348,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":348,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":812.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":464.30000001192093,"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":348.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":348.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":812.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":505.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":348.5,"connectEnd":348.5,"connectStart":348.5,"domainLookupEnd":348.5,"domainLookupStart":348.5,"fetchStart":348.5,"redirectEnd":0,"redirectStart":0,"requestStart":348.5,"responseEnd":854.3000000119209,"responseStart":854.3000000119209,"secureConnectionStart":348.5},{"duration":552.3000000119209,"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":348.60000002384186,"connectEnd":348.60000002384186,"connectStart":348.60000002384186,"domainLookupEnd":348.60000002384186,"domainLookupStart":348.60000002384186,"fetchStart":348.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":348.60000002384186,"responseEnd":900.9000000357628,"responseStart":900.9000000357628,"secureConnectionStart":348.60000002384186},{"duration":555.7999999523163,"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":348.9000000357628,"connectEnd":348.9000000357628,"connectStart":348.9000000357628,"domainLookupEnd":348.9000000357628,"domainLookupStart":348.9000000357628,"fetchStart":348.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":348.9000000357628,"responseEnd":904.6999999880791,"responseStart":904.6999999880791,"secureConnectionStart":348.9000000357628},{"duration":556.0999999642372,"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":349.10000002384186,"connectEnd":349.10000002384186,"connectStart":349.10000002384186,"domainLookupEnd":349.10000002384186,"domainLookupStart":349.10000002384186,"fetchStart":349.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":349.10000002384186,"responseEnd":905.1999999880791,"responseStart":905.1999999880791,"secureConnectionStart":349.10000002384186},{"duration":556.1999999880791,"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":349.30000001192093,"connectEnd":349.30000001192093,"connectStart":349.30000001192093,"domainLookupEnd":349.30000001192093,"domainLookupStart":349.30000001192093,"fetchStart":349.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":349.30000001192093,"responseEnd":905.5,"responseStart":905.5,"secureConnectionStart":349.30000001192093},{"duration":647.1999999880791,"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":349.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":349.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":996.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":556.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":349.69999998807907,"connectEnd":349.69999998807907,"connectStart":349.69999998807907,"domainLookupEnd":349.69999998807907,"domainLookupStart":349.69999998807907,"fetchStart":349.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":349.69999998807907,"responseEnd":905.9000000357628,"responseStart":905.9000000357628,"secureConnectionStart":349.69999998807907},{"duration":647,"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":349.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":349.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":996.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":556.6000000238419,"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":350,"connectEnd":350,"connectStart":350,"domainLookupEnd":350,"domainLookupStart":350,"fetchStart":350,"redirectEnd":0,"redirectStart":0,"requestStart":350,"responseEnd":906.6000000238419,"responseStart":906.6000000238419,"secureConnectionStart":350},{"duration":1670.6000000238419,"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":351,"connectEnd":351,"connectStart":351,"domainLookupEnd":351,"domainLookupStart":351,"fetchStart":351,"redirectEnd":0,"redirectStart":0,"requestStart":351,"responseEnd":2021.6000000238419,"responseStart":2021.6000000238419,"secureConnectionStart":351},{"duration":1992.300000011921,"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":351,"connectEnd":351,"connectStart":351,"domainLookupEnd":351,"domainLookupStart":351,"fetchStart":351,"redirectEnd":0,"redirectStart":0,"requestStart":351,"responseEnd":2343.300000011921,"responseStart":2343.300000011921,"secureConnectionStart":351},{"duration":1015.8000000119209,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1008.5,"connectEnd":1008.5,"connectStart":1008.5,"domainLookupEnd":1008.5,"domainLookupStart":1008.5,"fetchStart":1008.5,"redirectEnd":0,"redirectStart":0,"requestStart":1008.5,"responseEnd":2024.300000011921,"responseStart":2024.300000011921,"secureConnectionStart":1008.5},{"duration":1043.3999999761581,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1366.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1366.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2409.800000011921,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":156,"responseStart":342,"responseEnd":344,"domLoading":345,"domInteractive":2364,"domContentLoadedEventStart":2364,"domContentLoadedEventEnd":2406,"domComplete":3595,"loadEventStart":3595,"loadEventEnd":3596,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2347.900000035763},{"name":"bigPipe.sidebar-id.end","time":2348.699999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":2348.900000035763},{"name":"bigPipe.activity-panel-pipe-id.end","time":2351.400000035763},{"name":"activityTabFullyLoaded","time":2413.5}],"measures":[],"correlationId":"2fb456a7a6507","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":112,"dbReadsTimeInMs":16,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}