-
Bug
-
-
Major
-
Resolution:
Fixed
-
10.1.18, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
-
-
A user saw the following crash when executing EXPLAIN for a complex query that exceeds the 61 table join limit:
Nov 11 13:50:44 ip-172-30-0-32 mysqld: 161111 13:50:44 [ERROR] mysqld got signal 11 ;
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: This could be because you hit a bug. It is also possible that this binary
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: or one of the libraries it was linked against is corrupt, improperly built,
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: We will try our best to scrape up some info that will hopefully help
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: diagnose the problem, but since we have already crashed,
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: something is definitely wrong and this may fail.
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: Server version: 10.1.18-MariaDB
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: key_buffer_size=134217728
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: read_buffer_size=131072
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: max_used_connections=1
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: max_threads=153
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: thread_count=1
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: It is possible that mysqld could use up to
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467121 K bytes of memory
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: Thread pointer: 0x0x7fdab1c0e008
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: Attempting backtrace. You can use the following information to find out
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: where mysqld died. If you see no messages after this, something went
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: terribly wrong...
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: stack_bottom = 0x7fdad8f9c130 thread_stack 0x48400
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fdad9b46a6e]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x2d5)[0x7fdad966c8d5]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /lib64/libpthread.so.0(+0xf100)[0x7fdad8c87100]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_ZN10TABLE_LIST20fetch_number_of_rowsEv+0x30)[0x7fdad9599d70]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(+0x47df05)[0x7fdad9535f05]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_ZN4JOIN14optimize_innerEv+0x72f)[0x7fdad953e6af]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x2f)[0x7fdad9540faf]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x8f)[0x7fdad95410ef]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z19mysql_explain_unionP3THDP18st_select_lex_unitP13select_result+0x120)[0x7fdad9541dd0]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(+0x428e8b)[0x7fdad94e0e8b]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x5f8f)[0x7fdad94ecfaf]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x352)[0x7fdad94f0952]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x25db)[0x7fdad94f3e2b]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x169)[0x7fdad94f46a9]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x18a)[0x7fdad95bb19a]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40)[0x7fdad95bb370]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /lib64/libpthread.so.0(+0x7dc5)[0x7fdad8c7fdc5]
|
Nov 11 13:50:44 ip-172-30-0-32 mysqld: /lib64/libc.so.6(clone+0x6d)[0x7fdad70a21cd]
|
- is duplicated by
-
MDEV-15632
[ERROR] mysqld got signal 11 - Service crash
-
-
Closed
{"report":{"fcp":866.8000000715256,"ttfb":188,"pageVisibility":"visible","entityId":58878,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"4f862561-b158-49b3-8539-a63324e2c131","navigationType":0,"readyForUser":929.8000000715256,"redirectCount":0,"resourceLoadedEnd":1111,"resourceLoadedStart":193.70000004768372,"resourceTiming":[{"duration":233.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":193.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":193.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":427.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":233.39999997615814,"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":194,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":427.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":248,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":194,"connectEnd":194,"connectStart":194,"domainLookupEnd":194,"domainLookupStart":194,"fetchStart":194,"redirectEnd":0,"redirectStart":0,"requestStart":194,"responseEnd":442,"responseStart":442,"secureConnectionStart":194},{"duration":294,"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":194.20000004768372,"connectEnd":194.20000004768372,"connectStart":194.20000004768372,"domainLookupEnd":194.20000004768372,"domainLookupStart":194.20000004768372,"fetchStart":194.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":194.20000004768372,"responseEnd":488.2000000476837,"responseStart":488.2000000476837,"secureConnectionStart":194.20000004768372},{"duration":297.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":194.30000007152557,"connectEnd":194.30000007152557,"connectStart":194.30000007152557,"domainLookupEnd":194.30000007152557,"domainLookupStart":194.30000007152557,"fetchStart":194.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":194.30000007152557,"responseEnd":491.8000000715256,"responseStart":491.8000000715256,"secureConnectionStart":194.30000007152557},{"duration":297.89999997615814,"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":194.30000007152557,"connectEnd":194.30000007152557,"connectStart":194.30000007152557,"domainLookupEnd":194.30000007152557,"domainLookupStart":194.30000007152557,"fetchStart":194.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":194.30000007152557,"responseEnd":492.2000000476837,"responseStart":492.2000000476837,"secureConnectionStart":194.30000007152557},{"duration":298,"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":194.5,"connectEnd":194.5,"connectStart":194.5,"domainLookupEnd":194.5,"domainLookupStart":194.5,"fetchStart":194.5,"redirectEnd":0,"redirectStart":0,"requestStart":194.5,"responseEnd":492.5,"responseStart":492.5,"secureConnectionStart":194.5},{"duration":298.39999997615814,"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":194.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":493,"responseStart":0,"secureConnectionStart":0},{"duration":298.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":194.60000002384186,"connectEnd":194.60000002384186,"connectStart":194.60000002384186,"domainLookupEnd":194.60000002384186,"domainLookupStart":194.60000002384186,"fetchStart":194.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":194.60000002384186,"responseEnd":493,"responseStart":493,"secureConnectionStart":194.60000002384186},{"duration":298.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":194.80000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":194.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":493.39999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":298.5,"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":194.89999997615814,"connectEnd":194.89999997615814,"connectStart":194.89999997615814,"domainLookupEnd":194.89999997615814,"domainLookupStart":194.89999997615814,"fetchStart":194.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":194.89999997615814,"responseEnd":493.39999997615814,"responseStart":493.39999997615814,"secureConnectionStart":194.89999997615814},{"duration":430.2999999523163,"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":200.20000004768372,"connectEnd":200.20000004768372,"connectStart":200.20000004768372,"domainLookupEnd":200.20000004768372,"domainLookupStart":200.20000004768372,"fetchStart":200.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":200.20000004768372,"responseEnd":630.5,"responseStart":630.5,"secureConnectionStart":200.20000004768372},{"duration":910.7999999523163,"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":200.20000004768372,"connectEnd":200.20000004768372,"connectStart":200.20000004768372,"domainLookupEnd":200.20000004768372,"domainLookupStart":200.20000004768372,"fetchStart":200.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":200.20000004768372,"responseEnd":1111,"responseStart":1111,"secureConnectionStart":200.20000004768372},{"duration":394.3000000715256,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":672,"connectEnd":672,"connectStart":672,"domainLookupEnd":672,"domainLookupStart":672,"fetchStart":672,"redirectEnd":0,"redirectStart":0,"requestStart":672,"responseEnd":1066.3000000715256,"responseStart":1066.3000000715256,"secureConnectionStart":672}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":31,"responseStart":188,"responseEnd":194,"domLoading":192,"domInteractive":1164,"domContentLoadedEventStart":1164,"domContentLoadedEventEnd":1200,"domComplete":2012,"loadEventStart":2012,"loadEventEnd":2014,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1145.8999999761581},{"name":"bigPipe.sidebar-id.end","time":1146.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1146.8000000715256},{"name":"bigPipe.activity-panel-pipe-id.end","time":1149.2000000476837},{"name":"activityTabFullyLoaded","time":1206.2000000476837}],"measures":[],"correlationId":"fa43694c2beb82","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":9,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}