The server crash on the following query :
|
SELECT
|
( select 1
|
from (
|
select project_id, spent_on from time_entries
|
group by project_id, spent_on
|
) te
|
where te.project_id = contract.projects_id
|
) o
|
FROM `contract`
|
GROUP BY `contract`.`id`
|
With the following database :
CREATE TABLE `contract` (
|
`id` int(11) NOT NULL,
|
`projects_id` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
CREATE TABLE `time_entries` (
|
`id` int(11) NOT NULL,
|
`project_id` int(11) NOT NULL,
|
`spent_on` date NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
ALTER TABLE `contract`
|
ADD PRIMARY KEY (`id`),
|
ADD KEY `projects_id` (`projects_id`);
|
|
ALTER TABLE `time_entries`
|
ADD PRIMARY KEY (`id`),
|
ADD KEY `project_id` (`project_id`);
|
|
ALTER TABLE `contract`
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
|
ALTER TABLE `time_entries`
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|
Here the log :
Thread pointer: 0x7f03ac000c68
|
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 = 0x7f041818ccb8 thread_stack 0x30000
|
/usr/sbin/mariadbd(my_print_stacktrace+0x2e)[0x562b56c6ecfe]
|
/usr/sbin/mariadbd(handle_fatal_signal+0x2c3)[0x562b567dc683]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x3bf90)[0x7f042b45af90]
|
/usr/sbin/mariadbd(_ZN13st_join_table21choose_best_splittingEjyPy+0x640)[0x562b56760230]
|
/usr/sbin/mariadbd(_Z16best_access_pathP4JOINP13st_join_tableyPK8POSITIONjbdPS3_S6_+0x169)[0x562b565ebb49]
|
/usr/sbin/mariadbd(+0x83b744)[0x562b565ef744]
|
/usr/sbin/mariadbd(+0x83fcaa)[0x562b565f3caa]
|
/usr/sbin/mariadbd(_Z11choose_planP4JOINy+0x318)[0x562b565f5298]
|
/usr/sbin/mariadbd(+0x862fef)[0x562b56616fef]
|
/usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x1395)[0x562b5661bd95]
|
/usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xaa)[0x562b5661c32a]
|
/usr/sbin/mariadbd(_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0xe4)[0x562b565830a4]
|
/usr/sbin/mariadbd(_ZN4JOIN15optimize_stage2Ev+0x1707)[0x562b56619547]
|
/usr/sbin/mariadbd(_ZN4JOIN14optimize_innerEv+0x1492)[0x562b5661be92]
|
/usr/sbin/mariadbd(_ZN4JOIN8optimizeEv+0xaa)[0x562b5661c32a]
|
/usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xca)[0x562b5661c40a]
|
/usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x13f)[0x562b5661cbef]
|
/usr/sbin/mariadbd(+0x7e8860)[0x562b5659c860]
|
/usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3dc5)[0x562b565a9125]
|
/usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1b5)[0x562b565aa5e5]
|
/usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1005)[0x562b565ac515]
|
/usr/sbin/mariadbd(_Z10do_commandP3THDb+0x137)[0x562b565adb27]
|
/usr/sbin/mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x3b7)[0x562b566be7b7]
|
/usr/sbin/mariadbd(handle_one_connection+0x5d)[0x562b566beb4d]
|
/usr/sbin/mariadbd(+0xc2d630)[0x562b569e1630]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x88fd4)[0x7f042b4a7fd4]
|
/lib/x86_64-linux-gnu/libc.so.6(+0x1095bc)[0x7f042b5285bc]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f03ac010fc0): SELECT
|
( select 1
|
from (
|
select project_id, spent_on from time_entries
|
group by project_id, spent_on
|
) te
|
where te.project_id = contract.projects_id
|
) o
|
FROM `contract`
|
GROUP BY `contract`.`id` LIMIT 0, 25
|
|
- duplicates
-
MDEV-31403
Server crashes in st_join_table::choose_best_splitting (still)
-
-
Closed
{"report":{"fcp":954.0999999642372,"ttfb":272.19999998807907,"pageVisibility":"visible","entityId":123207,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"41c4af0e-e26b-488a-88b8-41590b0b6e97","navigationType":0,"readyForUser":1050.800000011921,"redirectCount":0,"resourceLoadedEnd":722.5,"resourceLoadedStart":276.5999999642372,"resourceTiming":[{"duration":101,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":276.5999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":276.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":377.5999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":118.10000002384186,"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":280.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":280.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":398.5,"responseStart":0,"secureConnectionStart":0},{"duration":252.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":280.5999999642372,"connectEnd":280.5999999642372,"connectStart":280.5999999642372,"domainLookupEnd":280.5999999642372,"domainLookupStart":280.5999999642372,"fetchStart":280.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":403.30000001192093,"responseEnd":533.0999999642372,"responseStart":418.5999999642372,"secureConnectionStart":280.5999999642372},{"duration":379.5,"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":281,"connectEnd":281,"connectStart":281,"domainLookupEnd":281,"domainLookupStart":281,"fetchStart":281,"redirectEnd":0,"redirectStart":0,"requestStart":404.30000001192093,"responseEnd":660.5,"responseStart":422.30000001192093,"secureConnectionStart":281},{"duration":145,"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":281.19999998807907,"connectEnd":281.19999998807907,"connectStart":281.19999998807907,"domainLookupEnd":281.19999998807907,"domainLookupStart":281.19999998807907,"fetchStart":281.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":404.5,"responseEnd":426.19999998807907,"responseStart":423.5999999642372,"secureConnectionStart":281.19999998807907},{"duration":145,"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":281.39999997615814,"connectEnd":281.39999997615814,"connectStart":281.39999997615814,"domainLookupEnd":281.39999997615814,"domainLookupStart":281.39999997615814,"fetchStart":281.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":405.19999998807907,"responseEnd":426.39999997615814,"responseStart":424.0999999642372,"secureConnectionStart":281.39999997615814},{"duration":145.30000001192093,"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":281.5,"connectEnd":281.5,"connectStart":281.5,"domainLookupEnd":281.5,"domainLookupStart":281.5,"fetchStart":281.5,"redirectEnd":0,"redirectStart":0,"requestStart":405.39999997615814,"responseEnd":426.80000001192093,"responseStart":425,"secureConnectionStart":281.5},{"duration":121.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":281.5999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":281.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":403.0999999642372,"responseStart":0,"secureConnectionStart":0},{"duration":147.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":281.80000001192093,"connectEnd":281.80000001192093,"connectStart":281.80000001192093,"domainLookupEnd":281.80000001192093,"domainLookupStart":281.80000001192093,"fetchStart":281.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":407.39999997615814,"responseEnd":429.5999999642372,"responseStart":427.39999997615814,"secureConnectionStart":281.80000001192093},{"duration":121.89999997615814,"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":282,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":282,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":403.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":147.9000000357628,"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":282.0999999642372,"connectEnd":282.0999999642372,"connectStart":282.0999999642372,"domainLookupEnd":282.0999999642372,"domainLookupStart":282.0999999642372,"fetchStart":282.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":407.69999998807907,"responseEnd":430,"responseStart":428.39999997615814,"secureConnectionStart":282.0999999642372},{"duration":436.69999998807907,"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":285.80000001192093,"connectEnd":285.80000001192093,"connectStart":285.80000001192093,"domainLookupEnd":285.80000001192093,"domainLookupStart":285.80000001192093,"fetchStart":285.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":548.5999999642372,"responseEnd":722.5,"responseStart":719,"secureConnectionStart":285.80000001192093},{"duration":434.19999998807907,"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":285.89999997615814,"connectEnd":285.89999997615814,"connectStart":285.89999997615814,"domainLookupEnd":285.89999997615814,"domainLookupStart":285.89999997615814,"fetchStart":285.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":557.3999999761581,"responseEnd":720.0999999642372,"responseStart":713.6999999880791,"secureConnectionStart":285.89999997615814},{"duration":90.89999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":677.1999999880791,"connectEnd":677.1999999880791,"connectStart":677.1999999880791,"domainLookupEnd":677.1999999880791,"domainLookupStart":677.1999999880791,"fetchStart":677.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":735,"responseEnd":768.0999999642372,"responseStart":767.3000000119209,"secureConnectionStart":677.1999999880791},{"duration":246.69999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":878.3000000119209,"connectEnd":878.3000000119209,"connectStart":878.3000000119209,"domainLookupEnd":878.3000000119209,"domainLookupStart":878.3000000119209,"fetchStart":878.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":1091.199999988079,"responseEnd":1125,"responseStart":1124.199999988079,"secureConnectionStart":878.3000000119209}],"fetchStart":0,"domainLookupStart":46,"domainLookupEnd":65,"connectStart":65,"connectEnd":85,"secureConnectionStart":74,"requestStart":87,"responseStart":272,"responseEnd":285,"domLoading":275,"domInteractive":1115,"domContentLoadedEventStart":1115,"domContentLoadedEventEnd":1165,"domComplete":1405,"loadEventStart":1405,"loadEventEnd":1405,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1096.699999988079},{"name":"bigPipe.sidebar-id.end","time":1097.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1097.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1098.800000011921},{"name":"activityTabFullyLoaded","time":1187.3999999761581}],"measures":[],"correlationId":"16d858187504b7","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":99,"dbReadsTimeInMs":13,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Major
This is a duplicate of
MDEV-31402- and has been fixed in 10.11.4release notes