Have not seen this in the wild, same backtrace for 11.4.4. We suspect related to addition of POINT column/secondary index.
After rebuilding the table with POINT column/index, crashes went away.
1: 250211 22:01:27 [ERROR] mysqld got signal 11 ;
|
2: Sorry, we probably made a mistake, and this is a bug.
|
3:
|
4: Your assistance in bug reporting will enable us to fix this for the next release.
|
5: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
6:
|
7: We will try our best to scrape up some info that will hopefully help
|
8: diagnose the problem, but since we have already crashed,
|
9: something is definitely wrong and this may fail.
|
10:
|
11: Server version: 10.6.18-MariaDB-log source revision:
|
12: key_buffer_size=16777216
|
13: read_buffer_size=262144
|
14: max_used_connections=3
|
15: max_threads=1313
|
16: thread_count=3
|
17: It is possible that mysqld could use up to
|
18: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3074192 K bytes of memory
|
19: Hope that's ok; if not, decrease some variables in the equation.
|
20:
|
21: Thread pointer: 0x4000390f9858
|
22: Attempting backtrace. You can use the following information to find out
|
23: where mysqld died. If you see no messages after this, something went
|
24: terribly wrong...
|
25: stack_bottom = 0x40003de08f28 thread_stack 0x40000
|
26: mysys/stacktrace.c:215(my_print_stacktrace)[0xaaaae118c14c]
|
27: sql/signal_handler.cc:235(handle_fatal_signal)[0xaaaae0a1b710]
|
28: addr2line: 'linux-vdso.so.1': No such file
|
29: linux-vdso.so.1(__kernel_rt_sigreturn+0x0)[0x40002c17d850]
|
30: include/rem0rec.h:605(rec_offs_n_fields(unsigned short const*))[0xaaaae101e6e0]
|
31: btr/btr0btr.cc:3758(btr_compress(btr_cur_t*, bool, mtr_t*))[0xaaaae10245a8]
|
32: btr/btr0cur.cc:4517(btr_cur_compress_if_useful(btr_cur_t*, bool, mtr_t*))[0xaaaae1035628]
|
33: btr/btr0cur.cc:4977(btr_cur_pessimistic_delete(dberr_t*, unsigned long, btr_cur_t*, unsigned long, bool, mtr_t*))[0xaaaae103b67c]
|
34: row/row0purge.cc:417(row_purge_remove_sec_if_poss_tree(purge_node_t*, dict_index_t*, dtuple_t const*))[0xaaaae0fc5bac]
|
35: row/row0purge.cc:585(row_purge_remove_sec_if_poss)[0xaaaae0fc5ee4]
|
36: row/row0purge.cc:1188(row_purge)[0xaaaae0fc68a8]
|
37: que/que0que.cc:588(que_thr_step)[0xaaaae0f8de88]
|
38: psi/mysql_thread.h:745(inline_mysql_mutex_lock)[0xaaaae0fe70cc]
|
39: tpool/task_group.cc:56(tpool::task_group::execute(tpool::task*))[0xaaaae1100b54]
|
40: tpool/tpool_generic.cc:581(tpool::thread_pool_generic::worker_main(tpool::worker_data*))[0xaaaae10feb64]
|
41: bits/unique_ptr.h:78(std::default_delete<std::thread::_State>::operator()(std::thread::_State*) const)[0xaaaae126ae3c]
|
42: /lib64/libpthread.so.0(+0x7230)[0x40002c358230]
|
43: /lib64/libc.so.6(+0xdb7dc)[0x40002c4617dc]
|
- relates to
-
MDEV-27675
Index corruption / assertion failure in rtr_page_get_father_node_ptr with spatial key
-
-
Confirmed
{"report":{"fcp":1989.7999999523163,"ttfb":1202.0999999046326,"pageVisibility":"visible","entityId":133049,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"68ce2370-6f0c-4f9e-9fa1-8f8b3a61991d","navigationType":0,"readyForUser":2066.699999809265,"redirectCount":0,"resourceLoadedEnd":1816.1999998092651,"resourceLoadedStart":1207.3999998569489,"resourceTiming":[{"duration":257.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1207.3999998569489,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1207.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1465.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":257.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1207.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1207.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1465.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":304.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1207.8999998569489,"connectEnd":1207.8999998569489,"connectStart":1207.8999998569489,"domainLookupEnd":1207.8999998569489,"domainLookupStart":1207.8999998569489,"fetchStart":1207.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1470.7999999523163,"responseEnd":1512.6999998092651,"responseStart":1487.2999999523163,"secureConnectionStart":1207.8999998569489},{"duration":318.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":1208.0999999046326,"connectEnd":1208.0999999046326,"connectStart":1208.0999999046326,"domainLookupEnd":1208.0999999046326,"domainLookupStart":1208.0999999046326,"fetchStart":1208.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1470.8999998569489,"responseEnd":1526.8999998569489,"responseStart":1482.3999998569489,"secureConnectionStart":1208.0999999046326},{"duration":293.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":1208.2999999523163,"connectEnd":1208.2999999523163,"connectStart":1208.2999999523163,"domainLookupEnd":1208.2999999523163,"domainLookupStart":1208.2999999523163,"fetchStart":1208.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1476.1999998092651,"responseEnd":1502.0999999046326,"responseStart":1501.3999998569489,"secureConnectionStart":1208.2999999523163},{"duration":297.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":1208.3999998569489,"connectEnd":1208.3999998569489,"connectStart":1208.3999998569489,"domainLookupEnd":1208.3999998569489,"domainLookupStart":1208.3999998569489,"fetchStart":1208.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1478.5,"responseEnd":1506.1999998092651,"responseStart":1505.5,"secureConnectionStart":1208.3999998569489},{"duration":298.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":1208.5999999046326,"connectEnd":1208.5999999046326,"connectStart":1208.5999999046326,"domainLookupEnd":1208.5999999046326,"domainLookupStart":1208.5999999046326,"fetchStart":1208.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1478.6999998092651,"responseEnd":1507.0999999046326,"responseStart":1506.3999998569489,"secureConnectionStart":1208.5999999046326},{"duration":271,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":1208.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1208.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1479.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":286.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1208.8999998569489,"connectEnd":1483.6999998092651,"connectStart":1483.6999998092651,"domainLookupEnd":1483.6999998092651,"domainLookupStart":1483.6999998092651,"fetchStart":1208.8999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1484,"responseEnd":1495.1999998092651,"responseStart":1493.7999999523163,"secureConnectionStart":1483.6999998092651},{"duration":272.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":1209.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1209.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1481.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":290.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":1209.1999998092651,"connectEnd":1209.1999998092651,"connectStart":1209.1999998092651,"domainLookupEnd":1209.1999998092651,"domainLookupStart":1209.1999998092651,"fetchStart":1209.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1486.5,"responseEnd":1499.6999998092651,"responseStart":1497.0999999046326,"secureConnectionStart":1209.1999998092651},{"duration":580.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1218.5,"connectEnd":1218.5,"connectStart":1218.5,"domainLookupEnd":1218.5,"domainLookupStart":1218.5,"fetchStart":1218.5,"redirectEnd":0,"redirectStart":0,"requestStart":1611.3999998569489,"responseEnd":1798.5999999046326,"responseStart":1796.3999998569489,"secureConnectionStart":1218.5},{"duration":593.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1222.3999998569489,"connectEnd":1222.3999998569489,"connectStart":1222.3999998569489,"domainLookupEnd":1222.3999998569489,"domainLookupStart":1222.3999998569489,"fetchStart":1222.3999998569489,"redirectEnd":0,"redirectStart":0,"requestStart":1711.0999999046326,"responseEnd":1816.1999998092651,"responseStart":1813.1999998092651,"secureConnectionStart":1222.3999998569489},{"duration":207.39999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1722.7999999523163,"connectEnd":1722.7999999523163,"connectStart":1722.7999999523163,"domainLookupEnd":1722.7999999523163,"domainLookupStart":1722.7999999523163,"fetchStart":1722.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1892.5999999046326,"responseEnd":1930.1999998092651,"responseStart":1929.2999999523163,"secureConnectionStart":1722.7999999523163}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":626,"responseStart":1202,"responseEnd":1221,"domLoading":1206,"domInteractive":2131,"domContentLoadedEventStart":2131,"domContentLoadedEventEnd":2171,"domComplete":2666,"loadEventStart":2666,"loadEventEnd":2666,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2109.699999809265},{"name":"bigPipe.sidebar-id.end","time":2110.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":2110.699999809265},{"name":"bigPipe.activity-panel-pipe-id.end","time":2111.7999999523163},{"name":"activityTabFullyLoaded","time":2193.399999856949}],"measures":[],"correlationId":"119f9a461f60b3","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":508,"dbReadsTimeInMs":20,"dbConnsTimeInMs":30,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Yes, this crash looks similar to the one reported for 10.6 in MDEV-27675: rtr_page_get_father_block() returns nullptr, which will be dereferenced, triggering SIGSEGV.
The title of MDEV-27675 mentions both index corruption and assertion failure, while the title of this report only mentions a crash. It would be rather straightforward to fix the debug assertion failure or crash, but fixing the root cause of the corruption could require more fundamental changes, such as redesigning the locking, which we know to be broken (MDEV-15275, MDEV-15284, MDEV-26123).
I would not say that this report is a duplicate of MDEV-27675. This one is primarily about treating the consequences of the corruption, while MDEV-27675 is also about the corruption itself.