Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
None
This commit (sha may vary due to force pushes) fails on mac with a crash during bootstrap:
commit 0e58234e2d85777d6d91f58b26a3c083f895d7a8 (HEAD)
Author: Sergei Golubchik <serg@mariadb.org>
Date: Wed Dec 11 17:11:34 2024 +0100
MDEV-35049 fix innodb-adaptive-hash-index scalability with multiple threads
from bb-11.8-innodb-ahi-cursor
On my mac system, it crashes during bootstrap in this way:
Installing MariaDB/MySQL system tables in './sql/data' ...
Assertion failed: (!initialized), function <unknown>, file srw_lock.h, line 46.
241212 9:54:53 [ERROR] mysqld got signal 6 ;
Sorry, we probably made a mistake, and this is a bug.
Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 11.8.0-MariaDB-debug source revision: 2d7ccce4f409a20a0a1c38c510796251a948de8f
read_buffer_size=131072
max_used_connections=0
thread_count=0
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000
0 mariadbd 0x0000000103c2d6a4 my_print_stacktrace + 64
Printing to addr2line failed
0 mariadbd 0x0000000102c81aec handle_fatal_signal + 1084
0 libsystem_platform.dylib 0x00000001927bc184 _sigtramp + 56
0 libsystem_pthread.dylib 0x0000000192786f70 pthread_kill + 288
0 libsystem_c.dylib 0x0000000192693908 abort + 128
0 libsystem_c.dylib 0x0000000192692c1c err + 0
0 mariadbd 0x0000000103753160 _ZN21pthread_mutex_wrapperILb0EED2Ev + 144
0 mariadbd 0x00000001037530c0 _ZN21pthread_mutex_wrapperILb0EED1Ev + 28
0 mariadbd 0x0000000103753094 _ZN7btr_sea9partitionD2Ev + 32
0 mariadbd 0x0000000103753064 _ZN7btr_sea9partitionD1Ev + 28
0 mariadbd 0x000000010375301c _ZN7btr_seaD2Ev + 64
0 mariadbd 0x0000000103748694 _ZN7btr_seaD1Ev + 28
0 libsystem_c.dylib 0x0000000192642998 __cxa_finalize_ranges + 476
0 libsystem_c.dylib 0x000000019264275c exit + 44
0 mariadbd 0x0000000102ecf7d8 _ZL11mysqld_exiti + 388
0 mariadbd 0x0000000102eceee8 unireg_abort + 604
0 mariadbd 0x0000000102ed291c _Z11mysqld_mainiPPc + 2528
0 mariadbd 0x0000000102b94928 main + 36
0 dyld 0x0000000192404274 start + 2840
The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/ contains
information that should help you find out what is causing the crash.
Core pattern: /cores/core.%P
./scripts/mariadb-install-db: line 567: 15172 Abort trap: 6 "$mysqld_bootstrap" $defaults $defaults_group_suffix "$mysqld_opt" --bootstrap $silent_startup "--basedir=$basedir" "--datadir=$ldata" --log-warnings=0 --enforce-storage-engine="" "--plugin-dir=${plugindir}" $args --max_allowed_packet=8M --net_buffer_length=16K
Using a debugger, I’ve isolated the problem to this:
(lldb) bt
* thread #1, queue = 'com.apple.main-thread', stop reason = hit program assert
frame #0: 0x000000019274e600 libsystem_kernel.dylib`__pthread_kill + 8
frame #1: 0x0000000192786f70 libsystem_pthread.dylib`pthread_kill + 288
frame #2: 0x0000000192693908 libsystem_c.dylib`abort + 128
frame #3: 0x0000000192692c1c libsystem_c.dylib`__assert_rtn + 284
* frame #4: 0x0000000100b9fa90 mariadbd`pthread_mutex_wrapper<false>::~pthread_mutex_wrapper(this=0x000000010191d2e0) at srw_lock.h:46:39
frame #5: 0x0000000100b9f9f0 mariadbd`pthread_mutex_wrapper<false>::~pthread_mutex_wrapper(this=0x000000010191d2e0) at srw_lock.h:46:37
frame #6: 0x0000000100b9f9c4 mariadbd`btr_sea::partition::~partition(this=0x000000010191d200) at btr0sea.h:118:10
frame #7: 0x0000000100b9f994 mariadbd`btr_sea::partition::~partition(this=0x000000010191d200) at btr0sea.h:118:10
frame #8: 0x0000000100b9f94c mariadbd`btr_sea::~btr_sea(this=0x00000001018ed300) at btr0sea.h:103:8
frame #9: 0x0000000100b94fc4 mariadbd`btr_sea::~btr_sea(this=0x00000001018ed300) at btr0sea.h:103:8
frame #10: 0x0000000192642998 libsystem_c.dylib`__cxa_finalize_ranges + 476
frame #11: 0x000000019264275c libsystem_c.dylib`exit + 44
frame #12: 0x0000000100339138 mariadbd`mysqld_exit(exit_code=1) at mysqld.cc:1963:3
frame #13: 0x0000000100338848 mariadbd`unireg_abort(exit_code=1) at mysqld.cc:1931:3
frame #14: 0x000000010033fed8 mariadbd`init_server_components() at mysqld.cc:5472:9
frame #15: 0x000000010033bfb8 mariadbd`mysqld_main(argc=15, argv=0x0000000140f04768) at mysqld.cc:6009:7
frame #16: 0x0000000100005218 mariadbd`main(argc=13, argv=0x000000016fdff228) at main.cc:34:10
frame #17: 0x0000000192404274 dyld`start + 2840
The ut_ad(!initialized); assertion fails from ~pthread_mutex_wrapper() (srw_lock.h:46) during mysqld_exit() when called during unireg_abort() at mysqld.cc:1963. . Somehow the pthread_mutex_wrapper was instantiated/created but its init() method not called before it was destroyed. (edited)
is caused by
MDEV-35049
fix innodb-adaptive-hash-index scalability with multiple threads
Closed
{"report":{"fcp":735.2999999523163,"ttfb":154.59999990463257,"pageVisibility":"visible","entityId":132062,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d8be8bf1-b985-4f55-96ab-212538cec89f","navigationType":0,"readyForUser":820.0999999046326,"redirectCount":0,"resourceLoadedEnd":434.09999990463257,"resourceLoadedStart":170.79999995231628,"resourceTiming":[{"duration":15.099999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":170.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":185.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":15.5,"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":171.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":171.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":186.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":107,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":171.29999995231628,"connectEnd":171.29999995231628,"connectStart":171.29999995231628,"domainLookupEnd":171.29999995231628,"domainLookupStart":171.29999995231628,"fetchStart":171.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":189.29999995231628,"responseEnd":278.2999999523163,"responseStart":233.5,"secureConnectionStart":171.29999995231628},{"duration":262.40000009536743,"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":171.69999980926514,"connectEnd":171.69999980926514,"connectStart":171.69999980926514,"domainLookupEnd":171.69999980926514,"domainLookupStart":171.69999980926514,"fetchStart":171.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":193.79999995231628,"responseEnd":434.09999990463257,"responseStart":216.59999990463257,"secureConnectionStart":171.69999980926514},{"duration":44.5,"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":171.89999985694885,"connectEnd":171.89999985694885,"connectStart":171.89999985694885,"domainLookupEnd":171.89999985694885,"domainLookupStart":171.89999985694885,"fetchStart":171.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":194.89999985694885,"responseEnd":216.39999985694885,"responseStart":209.5,"secureConnectionStart":171.89999985694885},{"duration":50.5,"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":171.89999985694885,"connectEnd":171.89999985694885,"connectStart":171.89999985694885,"domainLookupEnd":171.89999985694885,"domainLookupStart":171.89999985694885,"fetchStart":171.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":196.69999980926514,"responseEnd":222.39999985694885,"responseStart":219.59999990463257,"secureConnectionStart":171.89999985694885},{"duration":50.19999980926514,"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":172,"connectEnd":172,"connectStart":172,"domainLookupEnd":172,"domainLookupStart":172,"fetchStart":172,"redirectEnd":0,"redirectStart":0,"requestStart":197,"responseEnd":222.19999980926514,"responseStart":219.09999990463257,"secureConnectionStart":172},{"duration":24.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":172.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":196.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":24.59999990463257,"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":172.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":172.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":196.89999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":51.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":172.29999995231628,"connectEnd":172.29999995231628,"connectStart":172.29999995231628,"domainLookupEnd":172.29999995231628,"domainLookupStart":172.29999995231628,"fetchStart":172.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":197.59999990463257,"responseEnd":223.79999995231628,"responseStart":221.19999980926514,"secureConnectionStart":172.29999995231628},{"duration":57.700000047683716,"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":172.39999985694885,"connectEnd":172.39999985694885,"connectStart":172.39999985694885,"domainLookupEnd":172.39999985694885,"domainLookupStart":172.39999985694885,"fetchStart":172.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":199.89999985694885,"responseEnd":230.09999990463257,"responseStart":228.19999980926514,"secureConnectionStart":172.39999985694885},{"duration":231.09999990463257,"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":197.79999995231628,"connectEnd":197.79999995231628,"connectStart":197.79999995231628,"domainLookupEnd":197.79999995231628,"domainLookupStart":197.79999995231628,"fetchStart":197.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":218.29999995231628,"responseEnd":428.89999985694885,"responseStart":422.19999980926514,"secureConnectionStart":197.79999995231628},{"duration":230.70000004768372,"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":199.09999990463257,"connectEnd":199.09999990463257,"connectStart":199.09999990463257,"domainLookupEnd":199.09999990463257,"domainLookupStart":199.09999990463257,"fetchStart":199.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":244.39999985694885,"responseEnd":429.7999999523163,"responseStart":423.89999985694885,"secureConnectionStart":199.09999990463257},{"duration":64.70000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":424.2999999523163,"connectEnd":424.2999999523163,"connectStart":424.2999999523163,"domainLookupEnd":424.2999999523163,"domainLookupStart":424.2999999523163,"fetchStart":424.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":454,"responseEnd":489,"responseStart":488.19999980926514,"secureConnectionStart":424.2999999523163},{"duration":148.79999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":655.5999999046326,"connectEnd":655.5999999046326,"connectStart":655.5999999046326,"domainLookupEnd":655.5999999046326,"domainLookupStart":655.5999999046326,"fetchStart":655.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":774.2999999523163,"responseEnd":804.3999998569489,"responseStart":803.8999998569489,"secureConnectionStart":655.5999999046326},{"duration":146.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":728.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":728.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":874.8999998569489,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":22,"responseStart":154,"responseEnd":199,"domLoading":158,"domInteractive":883,"domContentLoadedEventStart":883,"domContentLoadedEventEnd":932,"domComplete":1571,"loadEventStart":1571,"loadEventEnd":1573,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":865.1999998092651},{"name":"bigPipe.sidebar-id.end","time":865.8999998569489},{"name":"bigPipe.activity-panel-pipe-id.start","time":866.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":868.5999999046326},{"name":"activityTabFullyLoaded","time":940.5}],"measures":[],"correlationId":"ff93021cdf6688","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":67,"dbReadsTimeInMs":9,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}