Note: The problem appeared in 10.4 tree with MDEV-371, even though there are no BLOBs in the scenario.
--source include/have_innodb.inc
|
CREATE TABLE t1 (pk INT, PRIMARY KEY USING HASH (pk)) ENGINE=InnoDB;
|
ALTER TABLE t1 ADD INDEX (pk);
|
|
# Cleanup
|
DROP TABLE t1;
|
10.4 3b47587f
|
mysqld: /data/src/10.4/storage/innobase/handler/handler0alter.cc:1489: bool instant_alter_column_possible(const dict_table_t&, const Alter_inplace_info*, const TABLE*, const TABLE*): Assertion `!pk->has_virtual()' failed.
|
190303 14:51:32 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f27ba5adee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055e41be49ed7 in instant_alter_column_possible (ib_table=..., ha_alter_info=0x7f27b4123900, table=0x7f27601a2fb0, altered_table=0x7f2760153210) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:1489
|
#9 0x000055e41be4ad44 in ha_innobase::check_if_supported_inplace_alter (this=0x7f276000d1f8, altered_table=0x7f2760153210, ha_alter_info=0x7f27b4123900) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:1915
|
#10 0x000055e41b87bb3f in mysql_alter_table (thd=0x7f2760000b00, new_db=0x7f2760005290, new_name=0x7f2760005690, create_info=0x7f27b4124cd0, table_list=0x7f2760015590, alter_info=0x7f27b4124c10, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9890
|
#11 0x000055e41b90a0ee in Sql_cmd_alter_table::execute (this=0x7f2760015d08, thd=0x7f2760000b00) at /data/src/10.4/sql/sql_alter.cc:499
|
#12 0x000055e41b79b48e in mysql_execute_command (thd=0x7f2760000b00) at /data/src/10.4/sql/sql_parse.cc:6346
|
#13 0x000055e41b7a0636 in mysql_parse (thd=0x7f2760000b00, rawbuf=0x7f27600154a8 "ALTER TABLE t1 ADD INDEX (pk)", length=29, parser_state=0x7f27b4126180, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8157
|
#14 0x000055e41b78bd24 in dispatch_command (command=COM_QUERY, thd=0x7f2760000b00, packet=0x7f2760139fd1 "ALTER TABLE t1 ADD INDEX (pk)", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#15 0x000055e41b78a4f8 in do_command (thd=0x7f2760000b00) at /data/src/10.4/sql/sql_parse.cc:1358
|
#16 0x000055e41b904003 in do_handle_one_connection (connect=0x55e41e0c4d10) at /data/src/10.4/sql/sql_connect.cc:1399
|
#17 0x000055e41b903d74 in handle_one_connection (arg=0x55e41e0c4d10) at /data/src/10.4/sql/sql_connect.cc:1302
|
#18 0x000055e41bdfad17 in pfs_spawn_thread (arg=0x55e41e10ab80) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#19 0x00007f27bc284494 in start_thread (arg=0x7f27b4127700) at pthread_create.c:333
|
#20 0x00007f27ba66a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Non-debug builds crashes with the stack trace of MDEV-18798, minus prior "no matching column" error.
10.4 non-debug 3b47587f
|
#2 <signal handler called>
|
#3 0x00005581c1a498ce in ha_innobase::commit_inplace_alter_table (this=<optimized out>, altered_table=<optimized out>, ha_alter_info=<optimized out>, commit=<optimized out>) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:11131
|
#4 0x00005581c1521714 in mysql_inplace_alter_table (thd=thd@entry=0x7f77300009a8, table_list=0x7f7730011f88, table=table@entry=0x7f77300825a8, altered_table=altered_table@entry=0x7f77300c7af8, ha_alter_info=ha_alter_info@entry=0x7f777c092e10, inplace_supported=inplace_supported@entry=HA_ALTER_INPLACE_NOCOPY_NO_LOCK, alter_ctx=0x7f777c093660, target_mdl_request=0x7f777c092eb0) at /data/src/10.4/sql/sql_table.cc:7695
|
#5 0x00005581c16ad33b in mysql_alter_table (thd=<optimized out>, new_db=<optimized out>, new_name=<optimized out>, create_info=<optimized out>, table_list=0x7f7730011f88, alter_info=0x7f777c094160, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9922
|
#6 0x00005581c16fb57b in Sql_cmd_alter_table::execute (this=0x7f7730000040, thd=0x7f77300009a8) at /data/src/10.4/sql/sql_alter.cc:499
|
#7 0x00005581c1613256 in mysql_execute_command (thd=thd@entry=0x7f77300009a8) at /data/src/10.4/sql/sql_parse.cc:6346
|
#8 0x00005581c161a711 in mysql_parse (thd=thd@entry=0x7f77300009a8, rawbuf=<optimized out>, length=29, parser_state=parser_state@entry=0x7f777c0971d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:8157
|
#9 0x00005581c161cf3f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f77300009a8, packet=packet@entry=0x7f7730009b39 "ALTER TABLE t1 ADD INDEX (pk)", packet_length=packet_length@entry=29, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.4/sql/sql_parse.cc:1829
|
#10 0x00005581c161e397 in do_command (thd=0x7f77300009a8) at /data/src/10.4/sql/sql_parse.cc:1358
|
#11 0x00005581c16f894c in do_handle_one_connection (connect=connect@entry=0x5581c376a718) at /data/src/10.4/sql/sql_connect.cc:1399
|
#12 0x00005581c16f8ab4 in handle_one_connection (arg=arg@entry=0x5581c376a718) at /data/src/10.4/sql/sql_connect.cc:1302
|
#13 0x00005581c1a16154 in pfs_spawn_thread (arg=0x5581c376a778) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#14 0x00007f77839f6494 in start_thread (arg=0x7f777c098700) at pthread_create.c:333
|
#15 0x00007f7781ddc93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
{"report":{"fcp":1514.6999998092651,"ttfb":556.9000000953674,"pageVisibility":"visible","entityId":72937,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"3d7bf351-3436-4734-9c54-7c87669460b7","navigationType":0,"readyForUser":1623.6999998092651,"redirectCount":0,"resourceLoadedEnd":1901,"resourceLoadedStart":562.7999997138977,"resourceTiming":[{"duration":439.1000003814697,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":562.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":562.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1001.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":439,"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":563.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":563.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1002.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":449.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":563.4000000953674,"connectEnd":563.4000000953674,"connectStart":563.4000000953674,"domainLookupEnd":563.4000000953674,"domainLookupStart":563.4000000953674,"fetchStart":563.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":563.4000000953674,"responseEnd":1013.1999998092651,"responseStart":1013.1999998092651,"secureConnectionStart":563.4000000953674},{"duration":559.8000001907349,"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":563.5999999046326,"connectEnd":563.5999999046326,"connectStart":563.5999999046326,"domainLookupEnd":563.5999999046326,"domainLookupStart":563.5999999046326,"fetchStart":563.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":563.5999999046326,"responseEnd":1123.4000000953674,"responseStart":1123.4000000953674,"secureConnectionStart":563.5999999046326},{"duration":563.6000003814697,"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":563.7999997138977,"connectEnd":563.7999997138977,"connectStart":563.7999997138977,"domainLookupEnd":563.7999997138977,"domainLookupStart":563.7999997138977,"fetchStart":563.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":563.7999997138977,"responseEnd":1127.4000000953674,"responseStart":1127.4000000953674,"secureConnectionStart":563.7999997138977},{"duration":564,"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":564,"connectEnd":564,"connectStart":564,"domainLookupEnd":564,"domainLookupStart":564,"fetchStart":564,"redirectEnd":0,"redirectStart":0,"requestStart":564,"responseEnd":1128,"responseStart":1128,"secureConnectionStart":564},{"duration":564.1999998092651,"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":564.0999999046326,"connectEnd":564.0999999046326,"connectStart":564.0999999046326,"domainLookupEnd":564.0999999046326,"domainLookupStart":564.0999999046326,"fetchStart":564.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":564.0999999046326,"responseEnd":1128.2999997138977,"responseStart":1128.1999998092651,"secureConnectionStart":564.0999999046326},{"duration":596,"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":564.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":564.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1160.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":564.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":564.5,"connectEnd":564.5,"connectStart":564.5,"domainLookupEnd":564.5,"domainLookupStart":564.5,"fetchStart":564.5,"redirectEnd":0,"redirectStart":0,"requestStart":564.5,"responseEnd":1128.7999997138977,"responseStart":1128.7999997138977,"secureConnectionStart":564.5},{"duration":595.7000002861023,"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":564.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":564.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1160.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":564.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":564.7999997138977,"connectEnd":564.7999997138977,"connectStart":564.7999997138977,"domainLookupEnd":564.7999997138977,"domainLookupStart":564.7999997138977,"fetchStart":564.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":564.7999997138977,"responseEnd":1129.2999997138977,"responseStart":1129.2999997138977,"secureConnectionStart":564.7999997138977},{"duration":1298.5,"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":570.5,"connectEnd":570.5,"connectStart":570.5,"domainLookupEnd":570.5,"domainLookupStart":570.5,"fetchStart":570.5,"redirectEnd":0,"redirectStart":0,"requestStart":570.5,"responseEnd":1869,"responseStart":1869,"secureConnectionStart":570.5},{"duration":1319.0999999046326,"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":570.5999999046326,"connectEnd":570.5999999046326,"connectStart":570.5999999046326,"domainLookupEnd":570.5999999046326,"domainLookupStart":570.5999999046326,"fetchStart":570.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":570.5999999046326,"responseEnd":1889.6999998092651,"responseStart":1889.6999998092651,"secureConnectionStart":570.5999999046326},{"duration":197.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1173.5,"connectEnd":1173.5,"connectStart":1173.5,"domainLookupEnd":1173.5,"domainLookupStart":1173.5,"fetchStart":1173.5,"redirectEnd":0,"redirectStart":0,"requestStart":1173.5,"responseEnd":1370.5999999046326,"responseStart":1370.5999999046326,"secureConnectionStart":1173.5},{"duration":443.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1447.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1447.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1890.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":445.8999996185303,"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":1448.4000000953674,"connectEnd":1448.4000000953674,"connectStart":1448.4000000953674,"domainLookupEnd":1448.4000000953674,"domainLookupStart":1448.4000000953674,"fetchStart":1448.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1448.4000000953674,"responseEnd":1894.2999997138977,"responseStart":1894.2999997138977,"secureConnectionStart":1448.4000000953674},{"duration":452.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1448.7999997138977,"connectEnd":1448.7999997138977,"connectStart":1448.7999997138977,"domainLookupEnd":1448.7999997138977,"domainLookupStart":1448.7999997138977,"fetchStart":1448.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1448.7999997138977,"responseEnd":1901,"responseStart":1901,"secureConnectionStart":1448.7999997138977},{"duration":401.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1506.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1506.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1908.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":376,"responseStart":557,"responseEnd":563,"domLoading":560,"domInteractive":1916,"domContentLoadedEventStart":1916,"domContentLoadedEventEnd":1960,"domComplete":2287,"loadEventStart":2287,"loadEventEnd":2287,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1891.6999998092651},{"name":"bigPipe.sidebar-id.end","time":1892.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1892.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1894},{"name":"activityTabFullyLoaded","time":1974.4000000953674}],"measures":[],"correlationId":"a4b28a6737c79a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":116,"dbReadsTimeInMs":24,"dbConnsTimeInMs":35,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}