--source include/have_innodb.inc
CREATE TABLE t1 (a INT ) ENGINE=InnoDB KEY_BLOCK_SIZE=4;
TRUNCATE t1;
ALTER TABLE t1 ADD COLUMN b INT ;
# Cleanup
DROP TABLE t1;
10.4 27f3329ff6
mysqld: /data/src/10.4/storage/innobase/handler/handler0alter.cc:177: void dict_table_t::prepare_instant(const dict_table_t&, const ulint*, unsigned int&): Assertion `supports_instant()' failed.
181126 0:34:25 [ERROR] mysqld got signal 6 ;
#7 0x00007f6b79a2bee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055f9e98cfe45 in dict_table_t::prepare_instant (this=0x7f6b1c133028, old=..., col_map=0x7f6b1c134400, first_alter_pos=@0x7f6b1c016478: 0) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:177
#9 0x000055f9e98d51b1 in ha_innobase_inplace_ctx::prepare_instant (this=0x7f6b1c016308) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:969
#10 0x000055f9e98c06a1 in prepare_inplace_alter_table_dict (ha_alter_info=0x7f6b6ed50bb0, altered_table=0x7f6b1c134f10, old_table=0x7f6b1c095f20, table_name=0x7f6b1c094b6d "t1", flags=39, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:6385
#11 0x000055f9e98c559e in ha_innobase::prepare_inplace_alter_table (this=0x7f6b1c096b58, altered_table=0x7f6b1c134f10, ha_alter_info=0x7f6b6ed50bb0) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:7932
#12 0x000055f9e9565947 in handler::ha_prepare_inplace_alter_table (this=0x7f6b1c096b58, altered_table=0x7f6b1c134f10, ha_alter_info=0x7f6b6ed50bb0) at /data/src/10.4/sql/handler.cc:4437
#13 0x000055f9e932f516 in mysql_inplace_alter_table (thd=0x7f6b1c000b00, table_list=0x7f6b1c014e80, table=0x7f6b1c095f20, altered_table=0x7f6b1c134f10, ha_alter_info=0x7f6b6ed50bb0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7f6b6ed50ce0, alter_ctx=0x7f6b6ed518d0) at /data/src/10.4/sql/sql_table.cc:7516
#14 0x000055f9e9335733 in mysql_alter_table (thd=0x7f6b1c000b00, new_db=0x7f6b1c0051b8, new_name=0x7f6b1c005588, create_info=0x7f6b6ed524c0, table_list=0x7f6b1c014e80, alter_info=0x7f6b6ed52400, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9692
#15 0x000055f9e93be8bd in Sql_cmd_alter_table::execute (this=0x7f6b1c0155d8, thd=0x7f6b1c000b00) at /data/src/10.4/sql/sql_alter.cc:497
#16 0x000055f9e925dab4 in mysql_execute_command (thd=0x7f6b1c000b00) at /data/src/10.4/sql/sql_parse.cc:6289
#17 0x000055f9e92629d8 in mysql_parse (thd=0x7f6b1c000b00, rawbuf=0x7f6b1c014d98 "ALTER TABLE t1 ADD COLUMN b INT", length=31, parser_state=0x7f6b6ed53600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8091
#18 0x000055f9e924fcd7 in dispatch_command (command=COM_QUERY, thd=0x7f6b1c000b00, packet=0x7f6b1c00b401 "ALTER TABLE t1 ADD COLUMN b INT", packet_length=31, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
#19 0x000055f9e924e6fb in do_command (thd=0x7f6b1c000b00) at /data/src/10.4/sql/sql_parse.cc:1396
#20 0x000055f9e93b8b3c in do_handle_one_connection (connect=0x55f9ec8a03e0) at /data/src/10.4/sql/sql_connect.cc:1402
#21 0x000055f9e93b88c0 in handle_one_connection (arg=0x55f9ec8a03e0) at /data/src/10.4/sql/sql_connect.cc:1308
#22 0x000055f9e98660a1 in pfs_spawn_thread (arg=0x55f9ec9256b0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#23 0x00007f6b7b4e7494 in start_thread (arg=0x7f6b6ed54700) at pthread_create.c:333
#24 0x00007f6b79ae893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Elena Stepanova
made changes -
2018-11-25 22:35
Field
Original Value
New Value
Assignee
Marko Mäkelä
[ marko
]
Marko Mäkelä
made changes -
2018-11-26 13:04
Fix Version/s
10.3
[ 22126
]
Affects Version/s
10.4.0
[ 23115
]
Affects Version/s
10.3.0
[ 22127
]
Affects Version/s
10.4
[ 22408
]
Marko Mäkelä
made changes -
2018-11-26 13:26
Fix Version/s
10.2
[ 14601
]
Affects Version/s
10.2.19
[ 23207
]
Affects Version/s
10.3.10
[ 23140
]
Affects Version/s
10.3.0
[ 22127
]
Marko Mäkelä
made changes -
2018-11-26 14:56
issue.field.resolutiondate
2018-11-26 14:56:28.0
2018-11-26 14:56:28.901
Marko Mäkelä
made changes -
2018-11-26 14:56
Fix Version/s
10.4.1
[ 23228
]
Fix Version/s
10.2.20
[ 23212
]
Fix Version/s
10.3.12
[ 23214
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:48
Workflow
MariaDB v3
[ 90869
]
MariaDB v4
[ 155268
]
{"report":{"fcp":1420.7000000476837,"ttfb":266.60000014305115,"pageVisibility":"visible","entityId":71047,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"6a070c2c-6f48-4f1f-a774-7488e90ca5f1","navigationType":0,"readyForUser":1510.7000000476837,"redirectCount":0,"resourceLoadedEnd":1572.2999999523163,"resourceLoadedStart":297.2999999523163,"resourceTiming":[{"duration":631.1000001430511,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":297.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":297.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":928.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":631.1999998092651,"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":297.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":297.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":928.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":633.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":297.90000009536743,"connectEnd":297.90000009536743,"connectStart":297.90000009536743,"domainLookupEnd":297.90000009536743,"domainLookupStart":297.90000009536743,"fetchStart":297.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":297.90000009536743,"responseEnd":931.4000000953674,"responseStart":931.4000000953674,"secureConnectionStart":297.90000009536743},{"duration":757.3999998569489,"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":298.10000014305115,"connectEnd":298.10000014305115,"connectStart":298.10000014305115,"domainLookupEnd":298.10000014305115,"domainLookupStart":298.10000014305115,"fetchStart":298.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":298.10000014305115,"responseEnd":1055.5,"responseStart":1055.4000000953674,"secureConnectionStart":298.10000014305115},{"duration":761.7000000476837,"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":298.2000000476837,"connectEnd":298.2000000476837,"connectStart":298.2000000476837,"domainLookupEnd":298.2000000476837,"domainLookupStart":298.2000000476837,"fetchStart":298.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":298.2000000476837,"responseEnd":1059.9000000953674,"responseStart":1059.9000000953674,"secureConnectionStart":298.2000000476837},{"duration":762.1000001430511,"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":298.5,"connectEnd":298.5,"connectStart":298.5,"domainLookupEnd":298.5,"domainLookupStart":298.5,"fetchStart":298.5,"redirectEnd":0,"redirectStart":0,"requestStart":298.5,"responseEnd":1060.6000001430511,"responseStart":1060.6000001430511,"secureConnectionStart":298.5},{"duration":762.5999999046326,"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":298.60000014305115,"connectEnd":298.60000014305115,"connectStart":298.60000014305115,"domainLookupEnd":298.60000014305115,"domainLookupStart":298.60000014305115,"fetchStart":298.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":298.60000014305115,"responseEnd":1061.2000000476837,"responseStart":1061.2000000476837,"secureConnectionStart":298.60000014305115},{"duration":787.2000000476837,"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":298.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":298.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1086,"responseStart":0,"secureConnectionStart":0},{"duration":762.6000001430511,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":299,"connectEnd":299,"connectStart":299,"domainLookupEnd":299,"domainLookupStart":299,"fetchStart":299,"redirectEnd":0,"redirectStart":0,"requestStart":299,"responseEnd":1061.6000001430511,"responseStart":1061.6000001430511,"secureConnectionStart":299},{"duration":787.0999999046326,"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":299.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":299.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1086.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":763.1000001430511,"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":299.2999999523163,"connectEnd":299.2999999523163,"connectStart":299.2999999523163,"domainLookupEnd":299.2999999523163,"domainLookupStart":299.2999999523163,"fetchStart":299.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":299.2999999523163,"responseEnd":1062.4000000953674,"responseStart":1062.4000000953674,"secureConnectionStart":299.2999999523163},{"duration":1254.6999998092651,"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":305.10000014305115,"connectEnd":305.10000014305115,"connectStart":305.10000014305115,"domainLookupEnd":305.10000014305115,"domainLookupStart":305.10000014305115,"fetchStart":305.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":305.10000014305115,"responseEnd":1559.7999999523163,"responseStart":1559.7999999523163,"secureConnectionStart":305.10000014305115},{"duration":1256.7999999523163,"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":315.5,"connectEnd":315.5,"connectStart":315.5,"domainLookupEnd":315.5,"domainLookupStart":315.5,"fetchStart":315.5,"redirectEnd":0,"redirectStart":0,"requestStart":315.5,"responseEnd":1572.2999999523163,"responseStart":1572.2999999523163,"secureConnectionStart":315.5},{"duration":452.89999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1107.4000000953674,"connectEnd":1107.4000000953674,"connectStart":1107.4000000953674,"domainLookupEnd":1107.4000000953674,"domainLookupStart":1107.4000000953674,"fetchStart":1107.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1107.4000000953674,"responseEnd":1560.2999999523163,"responseStart":1560.2999999523163,"secureConnectionStart":1107.4000000953674},{"duration":164.39999985694885,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1413.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1413.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1577.7999999523163,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":38,"responseStart":267,"responseEnd":315,"domLoading":277,"domInteractive":1687,"domContentLoadedEventStart":1687,"domContentLoadedEventEnd":1768,"domComplete":2638,"loadEventStart":2638,"loadEventEnd":2639,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1643.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1644.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1644.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1647.6000001430511},{"name":"activityTabFullyLoaded","time":1793.6000001430511}],"measures":[],"correlationId":"a1c19658e2f010","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":161,"dbReadsTimeInMs":24,"dbConnsTimeInMs":35,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}