Type:
Bug
Priority:
Blocker
Resolution:
Fixed
Affects Version/s:
10.6
I have set it tentatively to blocker and regression, as very similar issues were observed and fixed during testing of MDEV-31957 – so similar in fact that I think one of the fixes made in bb-10.6-monty may have gotten lost while force-pushing or merging into main.
10.6 8bf17c579b9a2d8d2f3c611f4b22fa5edb8e117c
0x000055f5938ab1f1 in Alter_info::add_stat_drop_index (this=0x7f5c95976f90, thd=0x30c044000aa8, key_name=0x30c044014250) at /data/for_monty/10.6/sql/sql_alter.cc:343
343 if (key_info->name.length &&
(rr) bt
#0 0x000055f5938ab1f1 in Alter_info::add_stat_drop_index (this=0x7f5c95976f90, thd=0x30c044000aa8, key_name=0x30c044014250) at /data/for_monty/10.6/sql/sql_alter.cc:343
#1 0x000055f5937ea3c3 in mysql_prepare_create_table (thd=0x30c044000aa8, create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, db_options=0x7f5c9597628c, file=0x30c044014360,
key_info_buffer=0x7f5c95976bd0, key_count=0x7f5c95976bc4, create_table_mode=0) at /data/for_monty/10.6/sql/sql_table.cc:2904
#2 0x000055f5937ee059 in mysql_create_frm_image (thd=0x30c044000aa8, create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, create_table_mode=0, key_info=0x7f5c95976bd0, key_count=0x7f5c95976bc4,
frm=0x7f5c95976c00) at /data/for_monty/10.6/sql/sql_table.cc:4094
#3 0x000055f5937eed3a in create_table_impl (thd=0x30c044000aa8, ddl_log_state_create=0x7f5c95976e90, ddl_log_state_rm=0x7f5c95976eb0, orig_db=..., orig_table_name=..., db=..., table_name=..., path=...,
options=..., create_info=0x7f5c95977100, alter_info=0x7f5c95976f90, create_table_mode=0, is_trans=0x7f5c95976e63, key_info=0x7f5c95976bd0, key_count=0x7f5c95976bc4, frm=0x7f5c95976c00)
at /data/for_monty/10.6/sql/sql_table.cc:4408
#4 0x000055f5937ef2d0 in mysql_create_table_no_lock (thd=0x30c044000aa8, ddl_log_state_create=0x7f5c95976e90, ddl_log_state_rm=0x7f5c95976eb0, create_info=0x7f5c95977100, alter_info=0x7f5c95976f90,
is_trans=0x7f5c95976e63, create_table_mode=0, table_list=0x30c044013030) at /data/for_monty/10.6/sql/sql_table.cc:4533
#5 0x000055f5937f1251 in mysql_create_like_table (thd=0x30c044000aa8, table=0x30c044013030, src_table=0x30c0440137d0, create_info=0x7f5c959789e0) at /data/for_monty/10.6/sql/sql_table.cc:5210
#6 0x000055f59380532e in Sql_cmd_create_table_like::execute (this=0x30c044012fd0, thd=0x30c044000aa8) at /data/for_monty/10.6/sql/sql_table.cc:11995
#7 0x000055f593703856 in mysql_execute_command (thd=0x30c044000aa8, is_called_from_prepared_stmt=false) at /data/for_monty/10.6/sql/sql_parse.cc:6026
#8 0x000055f5937093f0 in mysql_parse (thd=0x30c044000aa8, rawbuf=0x30c044012ed0 "/* WRK-1 QNO 2007 */ CREATE TABLE IF NOT EXISTS r LIKE `alt_table_db`.`alt_t1`", length=79, parser_state=0x7f5c95979390)
at /data/for_monty/10.6/sql/sql_parse.cc:8050
#9 0x000055f5936f5f74 in dispatch_command (command=COM_QUERY, thd=0x30c044000aa8, packet=0x30c04400ab29 "/* WRK-1 QNO 2007 */ CREATE TABLE IF NOT EXISTS r LIKE `alt_table_db`.`alt_t1`",
packet_length=79, blocking=true) at /data/for_monty/10.6/sql/sql_parse.cc:1896
#10 0x000055f5936f4995 in do_command (thd=0x30c044000aa8, blocking=true) at /data/for_monty/10.6/sql/sql_parse.cc:1410
#11 0x000055f5938a17de in do_handle_one_connection (connect=0x55f59782efd8, put_in_cache=true) at /data/for_monty/10.6/sql/sql_connect.cc:1416
#12 0x000055f5938a153f in handle_one_connection (arg=0x55f59782efd8) at /data/for_monty/10.6/sql/sql_connect.cc:1318
#13 0x000055f593dcb642 in pfs_spawn_thread (arg=0x55f5976794f8) at /data/for_monty/10.6/storage/perfschema/pfs.cc:2201
#14 0x000055f595b216ba in start_thread (arg=0x7f5c9597a700) at pthread_create.c:333
#15 0x00001d205aa7251d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
{"report":{"fcp":1093.4000000059605,"ttfb":386.09999999403954,"pageVisibility":"visible","entityId":125737,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"0729b041-0f1f-401d-be3f-fef1fc51f6cc","navigationType":0,"readyForUser":1164.5,"redirectCount":0,"resourceLoadedEnd":1428.9000000059605,"resourceLoadedStart":391.40000000596046,"resourceTiming":[{"duration":198.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":391.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":391.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":590.0999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":198.80000001192093,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":391.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":391.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":590.4000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":236.2999999821186,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":391.90000000596046,"connectEnd":391.90000000596046,"connectStart":391.90000000596046,"domainLookupEnd":391.90000000596046,"domainLookupStart":391.90000000596046,"fetchStart":391.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":391.90000000596046,"responseEnd":628.1999999880791,"responseStart":628.1999999880791,"secureConnectionStart":391.90000000596046},{"duration":291.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":392,"connectEnd":392,"connectStart":392,"domainLookupEnd":392,"domainLookupStart":392,"fetchStart":392,"redirectEnd":0,"redirectStart":0,"requestStart":392,"responseEnd":683.6999999880791,"responseStart":683.6999999880791,"secureConnectionStart":392},{"duration":295.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":392.19999998807907,"connectEnd":392.19999998807907,"connectStart":392.19999998807907,"domainLookupEnd":392.19999998807907,"domainLookupStart":392.19999998807907,"fetchStart":392.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":392.19999998807907,"responseEnd":687.5,"responseStart":687.5,"secureConnectionStart":392.19999998807907},{"duration":295.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":392.5,"connectEnd":392.5,"connectStart":392.5,"domainLookupEnd":392.5,"domainLookupStart":392.5,"fetchStart":392.5,"redirectEnd":0,"redirectStart":0,"requestStart":392.5,"responseEnd":688,"responseStart":688,"secureConnectionStart":392.5},{"duration":295.7000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":392.59999999403954,"connectEnd":392.59999999403954,"connectStart":392.59999999403954,"domainLookupEnd":392.59999999403954,"domainLookupStart":392.59999999403954,"fetchStart":392.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":392.59999999403954,"responseEnd":688.3000000119209,"responseStart":688.3000000119209,"secureConnectionStart":392.59999999403954},{"duration":382.09999999403954,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":392.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":392.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":774.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":295.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":392.90000000596046,"connectEnd":392.90000000596046,"connectStart":392.90000000596046,"domainLookupEnd":392.90000000596046,"domainLookupStart":392.90000000596046,"fetchStart":392.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":392.90000000596046,"responseEnd":688.5999999940395,"responseStart":688.5999999940395,"secureConnectionStart":392.90000000596046},{"duration":382,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":393.09999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":393.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":775.0999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":295.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":393.30000001192093,"connectEnd":393.30000001192093,"connectStart":393.30000001192093,"domainLookupEnd":393.30000001192093,"domainLookupStart":393.30000001192093,"fetchStart":393.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":393.30000001192093,"responseEnd":689.1999999880791,"responseStart":689.1999999880791,"secureConnectionStart":393.30000001192093},{"duration":536.8000000119209,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":394.09999999403954,"connectEnd":394.09999999403954,"connectStart":394.09999999403954,"domainLookupEnd":394.09999999403954,"domainLookupStart":394.09999999403954,"fetchStart":394.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":394.09999999403954,"responseEnd":930.9000000059605,"responseStart":930.9000000059605,"secureConnectionStart":394.09999999403954},{"duration":1034.800000011921,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":394.09999999403954,"connectEnd":394.09999999403954,"connectStart":394.09999999403954,"domainLookupEnd":394.09999999403954,"domainLookupStart":394.09999999403954,"fetchStart":394.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":394.09999999403954,"responseEnd":1428.9000000059605,"responseStart":1428.9000000059605,"secureConnectionStart":394.09999999403954},{"duration":149.10000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":786.1999999880791,"connectEnd":786.1999999880791,"connectStart":786.1999999880791,"domainLookupEnd":786.1999999880791,"domainLookupStart":786.1999999880791,"fetchStart":786.1999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":786.1999999880791,"responseEnd":935.3000000119209,"responseStart":935.3000000119209,"secureConnectionStart":786.1999999880791},{"duration":409.40000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&slack-enabled=true","startTime":1036.5999999940395,"connectEnd":1036.5999999940395,"connectStart":1036.5999999940395,"domainLookupEnd":1036.5999999940395,"domainLookupStart":1036.5999999940395,"fetchStart":1036.5999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":1036.5999999940395,"responseEnd":1446,"responseStart":1446,"secureConnectionStart":1036.5999999940395}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":227,"responseStart":386,"responseEnd":388,"domLoading":389,"domInteractive":1446,"domContentLoadedEventStart":1446,"domContentLoadedEventEnd":1484,"domComplete":2329,"loadEventStart":2329,"loadEventEnd":2331,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1430.699999988079},{"name":"bigPipe.sidebar-id.end","time":1431.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1431.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1434},{"name":"activityTabFullyLoaded","time":1488.699999988079}],"measures":[],"correlationId":"115be54814b0f","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":97,"dbReadsTimeInMs":12,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}