SELECT t1.* FROM t1 JOIN (SELECT id, COUNT(*) FROM t2 GROUPBY id) sq ON sq.id= t1.a;
# Cleanup
DROPTABLE t1, t2;
bb-10.4-release 7973ffde0fed non-debug
#2 <signal handler called>
#3 0x0000558ff1103bae in ha_heap::index_flags (this=0x7f6aa403eea0, inx=<optimized out>, part=<optimized out>, all_parts=true) at /data/src/10.4-bug-2/storage/heap/ha_heap.h:58
#4 0x0000558ff0dde954 in push_index_cond (tab=tab@entry=0x7f6aa4041d58, keyno=64) at /data/src/10.4-bug-2/sql/opt_index_cond_pushdown.cc:354
#5 0x0000558ff0d1e14c in make_join_readinfo (no_jbuf_after=<optimized out>, options=<optimized out>, join=0x7f6aa4014508) at /data/src/10.4-bug-2/sql/sql_select.cc:13407
#6 JOIN::optimize_stage2 (this=this@entry=0x7f6aa4014508) at /data/src/10.4-bug-2/sql/sql_select.cc:2887
#7 0x0000558ff0d212f3 in JOIN::optimize_inner (this=this@entry=0x7f6aa4014508) at /data/src/10.4-bug-2/sql/sql_select.cc:2373
#8 0x0000558ff0d234dd in JOIN::optimize (this=this@entry=0x7f6aa4014508) at /data/src/10.4-bug-2/sql/sql_select.cc:1690
#9 0x0000558ff0d23f81 in mysql_select (thd=thd@entry=0x7f6aa4000c58, tables=0x7f6aa4010820, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f6aa40144e0, unit=0x7f6aa40049d0, select_lex=0x7f6aa4010208) at /data/src/10.4-bug-2/sql/sql_select.cc:4797
#10 0x0000558ff0d249c3 in handle_select (thd=thd@entry=0x7f6aa4000c58, lex=lex@entry=0x7f6aa4004910, result=result@entry=0x7f6aa40144e0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.4-bug-2/sql/sql_select.cc:442
#11 0x0000558ff0cb955c in execute_sqlcom_select (thd=thd@entry=0x7f6aa4000c58, all_tables=0x7f6aa4010820) at /data/src/10.4-bug-2/sql/sql_parse.cc:6463
#12 0x0000558ff0cc5a1b in mysql_execute_command (thd=thd@entry=0x7f6aa4000c58) at /data/src/10.4-bug-2/sql/sql_parse.cc:3966
#13 0x0000558ff0cc7290 in mysql_parse (thd=thd@entry=0x7f6aa4000c58, rawbuf=<optimized out>, length=84, parser_state=parser_state@entry=0x7f6abb5c9540, is_com_multi=is_com_multi@entry=false, is_next_command=<optimized out>) at /data/src/10.4-bug-2/sql/sql_parse.cc:7998
#14 0x0000558ff0cc8f55 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f6aa4000c58, packet=packet@entry=0x7f6aa4007d59 "SELECT t1.* FROM t1 JOIN (SELECT id, COUNT(*) FROM t2 GROUP BY id) sq ON sq.id= t1.a", packet_length=packet_length@entry=84, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4-bug-2/sql/sql_parse.cc:1857
#15 0x0000558ff0ccaa58 in do_command (thd=0x7f6aa4000c58) at /data/src/10.4-bug-2/sql/sql_parse.cc:1378
#16 0x0000558ff0daf984 in do_handle_one_connection (connect=connect@entry=0x558ff47565b8) at /data/src/10.4-bug-2/sql/sql_connect.cc:1420
#17 0x0000558ff0dafad4 in handle_one_connection (arg=arg@entry=0x558ff47565b8) at /data/src/10.4-bug-2/sql/sql_connect.cc:1324
#18 0x0000558ff10ce010 in pfs_spawn_thread (arg=0x558ff46afaa8) at /data/src/10.4-bug-2/storage/perfschema/pfs.cc:1869
#19 0x00007f6ac5687fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#20 0x00007f6ac57085bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
#9 0x00007f581c653df2 in __GI___assert_fail (assertion=0x5646978183c1 "n < width", file=0x5646978183d0 "/data/src/10.4-bug/sql/sql_bitmap.h", line=81, function=0x5646978183f8 "uint Bitmap<width>::bit_index(uint) const [with unsigned int width = 64; uint = unsigned int]") at ./assert/assert.c:101
#10 0x000056469690c61a in Bitmap<64u>::bit_index (this=0x7f580406bca0, n=64) at /data/src/10.4-bug/sql/sql_bitmap.h:81
#11 0x0000564696a482ef in Bitmap<64u>::is_set (this=0x7f580406bca0, n=64) at /data/src/10.4-bug/sql/sql_bitmap.h:126
#12 0x0000564696a0fc86 in make_join_readinfo (join=0x7f5804018bf0, options=0, no_jbuf_after=2) at /data/src/10.4-bug/sql/sql_select.cc:13404
#13 0x00005646969eff13 in JOIN::optimize_stage2 (this=0x7f5804018bf0) at /data/src/10.4-bug/sql/sql_select.cc:2887
#14 0x00005646969ee044 in JOIN::optimize_inner (this=0x7f5804018bf0) at /data/src/10.4-bug/sql/sql_select.cc:2373
#15 0x00005646969eb784 in JOIN::optimize (this=0x7f5804018bf0) at /data/src/10.4-bug/sql/sql_select.cc:1690
#16 0x00005646969f729c in mysql_select (thd=0x7f5804000da0, tables=0x7f5804014f08, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5804018bc8, unit=0x7f5804004cd8, select_lex=0x7f58040148f0) at /data/src/10.4-bug/sql/sql_select.cc:4797
#17 0x00005646969e610b in handle_select (thd=0x7f5804000da0, lex=0x7f5804004c18, result=0x7f5804018bc8, setup_tables_done_option=0) at /data/src/10.4-bug/sql/sql_select.cc:442
#18 0x00005646969a8e9e in execute_sqlcom_select (thd=0x7f5804000da0, all_tables=0x7f5804014f08) at /data/src/10.4-bug/sql/sql_parse.cc:6463
#19 0x000056469699f3a0 in mysql_execute_command (thd=0x7f5804000da0) at /data/src/10.4-bug/sql/sql_parse.cc:3966
#20 0x00005646969ad013 in mysql_parse (thd=0x7f5804000da0, rawbuf=0x7f58040147e8 "SELECT t1.* FROM t1 JOIN (SELECT id, COUNT(*) FROM t2 GROUP BY id) sq ON sq.id= t1.a", length=84, parser_state=0x7f58166c83c0, is_com_multi=false, is_next_command=false) at /data/src/10.4-bug/sql/sql_parse.cc:7998
#21 0x0000564696998a44 in dispatch_command (command=COM_QUERY, thd=0x7f5804000da0, packet=0x7f580400ac41 "SELECT t1.* FROM t1 JOIN (SELECT id, COUNT(*) FROM t2 GROUP BY id) sq ON sq.id= t1.a", packet_length=84, is_com_multi=false, is_next_command=false) at /data/src/10.4-bug/sql/sql_parse.cc:1857
#22 0x00005646969972ab in do_command (thd=0x7f5804000da0) at /data/src/10.4-bug/sql/sql_parse.cc:1378
#23 0x0000564696b37c60 in do_handle_one_connection (connect=0x56469a242a30) at /data/src/10.4-bug/sql/sql_connect.cc:1420
#24 0x0000564696b379c8 in handle_one_connection (arg=0x56469a242a30) at /data/src/10.4-bug/sql/sql_connect.cc:1324
#25 0x0000564697089638 in pfs_spawn_thread (arg=0x56469a288960) at /data/src/10.4-bug/storage/perfschema/pfs.cc:1869
#26 0x00007f581c6a7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#27 0x00007f581c7285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
The failure started happening on bb-10.4-release after this commit:
commit ce7ffe61d836fe9f0cfc1087f058bc40d66e5cfb
Author: Igor Babaev
Date: Tue May 2 23:17:07 2023 -0700
MDEV-26301 Split optimization refills temporary table too many times
MDEV-31194: Server crash or assertion failure with join_cache_level=4
The problem, introduced in patch for MDEV-26301:
Sergei Petrunia
added a comment -
commit 2594da7a33580bf03590502a011679c878487d0c (HEAD -> bb-10.4-release, origin/bb-10.4-release)
Author: Sergei Petrunia <sergey@mariadb.com>
Date: Fri May 5 11:16:23 2023 +0300
MDEV-31194: Server crash or assertion failure with join_cache_level=4
The problem, introduced in patch for MDEV-26301:
People
Sergei Petrunia
Elena Stepanova
Votes:
0Vote for this issue
Watchers:
3Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":849.6999998092651,"ttfb":200.39999961853027,"pageVisibility":"visible","entityId":121625,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d5854a3d-528e-4905-8d16-5dcd3db0a810","navigationType":0,"readyForUser":989.6999998092651,"redirectCount":0,"resourceLoadedEnd":915.3999996185303,"resourceLoadedStart":209.69999980926514,"resourceTiming":[{"duration":28.699999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":209.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":209.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":238.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":29.09999942779541,"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":210,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":210,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":239.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":85.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":210.30000019073486,"connectEnd":210.30000019073486,"connectStart":210.30000019073486,"domainLookupEnd":210.30000019073486,"domainLookupStart":210.30000019073486,"fetchStart":210.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":210.30000019073486,"responseEnd":295.80000019073486,"responseStart":295.80000019073486,"secureConnectionStart":210.30000019073486},{"duration":182.5,"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":210.39999961853027,"connectEnd":210.39999961853027,"connectStart":210.39999961853027,"domainLookupEnd":210.39999961853027,"domainLookupStart":210.39999961853027,"fetchStart":210.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":210.39999961853027,"responseEnd":392.8999996185303,"responseStart":392.8999996185303,"secureConnectionStart":210.39999961853027},{"duration":186.60000038146973,"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":210.5999994277954,"connectEnd":210.5999994277954,"connectStart":210.5999994277954,"domainLookupEnd":210.5999994277954,"domainLookupStart":210.5999994277954,"fetchStart":210.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":210.5999994277954,"responseEnd":397.19999980926514,"responseStart":397.19999980926514,"secureConnectionStart":210.5999994277954},{"duration":186.79999923706055,"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":210.80000019073486,"connectEnd":210.80000019073486,"connectStart":210.80000019073486,"domainLookupEnd":210.80000019073486,"domainLookupStart":210.80000019073486,"fetchStart":210.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":210.80000019073486,"responseEnd":397.5999994277954,"responseStart":397.5999994277954,"secureConnectionStart":210.80000019073486},{"duration":187,"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":211,"connectEnd":211,"connectStart":211,"domainLookupEnd":211,"domainLookupStart":211,"fetchStart":211,"redirectEnd":0,"redirectStart":0,"requestStart":211,"responseEnd":398,"responseStart":398,"secureConnectionStart":211},{"duration":306.3999996185303,"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":211.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":517.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":187.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":211.30000019073486,"connectEnd":211.30000019073486,"connectStart":211.30000019073486,"domainLookupEnd":211.30000019073486,"domainLookupStart":211.30000019073486,"fetchStart":211.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":211.30000019073486,"responseEnd":398.3999996185303,"responseStart":398.3999996185303,"secureConnectionStart":211.30000019073486},{"duration":306.3999996185303,"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":211.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":211.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":517.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":187.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":211.5999994277954,"connectEnd":211.5999994277954,"connectStart":211.5999994277954,"domainLookupEnd":211.5999994277954,"domainLookupStart":211.5999994277954,"fetchStart":211.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":211.5999994277954,"responseEnd":399.0999994277954,"responseStart":399.0999994277954,"secureConnectionStart":211.5999994277954},{"duration":609.1000003814697,"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":212.39999961853027,"connectEnd":212.39999961853027,"connectStart":212.39999961853027,"domainLookupEnd":212.39999961853027,"domainLookupStart":212.39999961853027,"fetchStart":212.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":212.39999961853027,"responseEnd":821.5,"responseStart":821.5,"secureConnectionStart":212.39999961853027},{"duration":627.3999996185303,"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":212.5,"connectEnd":212.5,"connectStart":212.5,"domainLookupEnd":212.5,"domainLookupStart":212.5,"fetchStart":212.5,"redirectEnd":0,"redirectStart":0,"requestStart":212.5,"responseEnd":839.8999996185303,"responseStart":839.8999996185303,"secureConnectionStart":212.5},{"duration":285.5999994277954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":536.3000001907349,"connectEnd":536.3000001907349,"connectStart":536.3000001907349,"domainLookupEnd":536.3000001907349,"domainLookupStart":536.3000001907349,"fetchStart":536.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":536.3000001907349,"responseEnd":821.8999996185303,"responseStart":821.8999996185303,"secureConnectionStart":536.3000001907349},{"duration":193.89999961853027,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":837.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":837.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1031.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":52.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":862.5,"connectEnd":862.5,"connectStart":862.5,"domainLookupEnd":862.5,"domainLookupStart":862.5,"fetchStart":862.5,"redirectEnd":0,"redirectStart":0,"requestStart":862.5,"responseEnd":915.3999996185303,"responseStart":915.3999996185303,"secureConnectionStart":862.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":23,"responseStart":200,"responseEnd":205,"domLoading":205,"domInteractive":1065,"domContentLoadedEventStart":1065,"domContentLoadedEventEnd":1116,"domComplete":1285,"loadEventStart":1285,"loadEventEnd":1285,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1037.3999996185303},{"name":"bigPipe.sidebar-id.end","time":1038.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1038.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":1039.3999996185303},{"name":"activityTabFullyLoaded","time":1137.1999998092651}],"measures":[],"correlationId":"426a2e369f92b6","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Blocker
commit 2594da7a33580bf03590502a011679c878487d0c (HEAD -> bb-10.4-release, origin/bb-10.4-release)Author: Sergei Petrunia <sergey@mariadb.com>Date: Fri May 5 11:16:23 2023 +0300MDEV-31194: Server crash or assertion failure with join_cache_level=4The problem, introduced in patch for MDEV-26301: