--source include/have_innodb.inc
|
|
CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB;
|
INSERT IGNORE INTO t1 VALUES (1,1);
|
ALTER TABLE t1 ADD f DATE AFTER a;
|
ALTER TABLE t1 DROP b, DROP f;
|
|
# Cleanup
|
DROP TABLE t1;
|
10.4 4edb29380c9
|
mysqld: /data/src/10.4/storage/innobase/handler/handler0alter.cc:461: void dict_index_t::instant_add_field(const dict_index_t&): Assertion `instant.fields[i].col->same_format(*fields[i] .col)' failed.
|
190121 1:20:54 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fdcd296eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005651a9ea7013 in dict_index_t::instant_add_field (this=0x7fdc7815aa28, instant=...) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:460
|
#9 0x00005651a9ea87ee in dict_table_t::instant_column (this=0x7fdc781560e8, table=..., col_map=0x7fdc7806f728) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:625
|
#10 0x00005651a9eaa89b in ha_innobase_inplace_ctx::instant_column (this=0x7fdc78016320) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:1080
|
#11 0x00005651a9e90937 in innobase_instant_try (ha_alter_info=0x7fdccc4e4bc0, ctx=0x7fdc78016320, altered_table=0x7fdc7815cca0, table=0x7fdc7818d060, trx=0x7fdccc77f258) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:5495
|
#12 0x00005651a9eadb73 in commit_try_norebuild (ha_alter_info=0x7fdccc4e4bc0, ctx=0x7fdc78016320, altered_table=0x7fdc7815cca0, old_table=0x7fdc7818d060, trx=0x7fdccc77f258, table_name=0x7fdc78070e5d "t1") at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10160
|
#13 0x00005651a9e9f8e6 in ha_innobase::commit_inplace_alter_table (this=0x7fdc7818dc98, altered_table=0x7fdc7815cca0, ha_alter_info=0x7fdccc4e4bc0, commit=true) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10793
|
#14 0x00005651a9b2ff82 in handler::ha_commit_inplace_alter_table (this=0x7fdc7818dc98, altered_table=0x7fdc7815cca0, ha_alter_info=0x7fdccc4e4bc0, commit=true) at /data/src/10.4/sql/handler.cc:4492
|
#15 0x00005651a98ef570 in mysql_inplace_alter_table (thd=0x7fdc78000b00, table_list=0x7fdc780150a0, table=0x7fdc7818d060, altered_table=0x7fdc7815cca0, ha_alter_info=0x7fdccc4e4bc0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7fdccc4e4cf0, alter_ctx=0x7fdccc4e58e0) at /data/src/10.4/sql/sql_table.cc:7590
|
#16 0x00005651a98f53d1 in mysql_alter_table (thd=0x7fdc78000b00, new_db=0x7fdc780051e0, new_name=0x7fdc780055b0, create_info=0x7fdccc4e64d0, table_list=0x7fdc780150a0, alter_info=0x7fdccc4e6410, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9690
|
#17 0x00005651a997fa4f in Sql_cmd_alter_table::execute (this=0x7fdc78015730, thd=0x7fdc78000b00) at /data/src/10.4/sql/sql_alter.cc:497
|
#18 0x00005651a981cceb in mysql_execute_command (thd=0x7fdc78000b00) at /data/src/10.4/sql/sql_parse.cc:6314
|
#19 0x00005651a9821c16 in mysql_parse (thd=0x7fdc78000b00, rawbuf=0x7fdc78014fb8 "ALTER TABLE t1 DROP b, DROP f", length=29, parser_state=0x7fdccc4e7600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8116
|
#20 0x00005651a980edb3 in dispatch_command (command=COM_QUERY, thd=0x7fdc78000b00, packet=0x7fdc7800b441 "ALTER TABLE t1 DROP b, DROP f", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1852
|
#21 0x00005651a980d7d7 in do_command (thd=0x7fdc78000b00) at /data/src/10.4/sql/sql_parse.cc:1397
|
#22 0x00005651a9979a92 in do_handle_one_connection (connect=0x5651ad1bdcf0) at /data/src/10.4/sql/sql_connect.cc:1402
|
#23 0x00005651a9979816 in handle_one_connection (arg=0x5651ad1bdcf0) at /data/src/10.4/sql/sql_connect.cc:1308
|
#24 0x00005651a9e38dec in pfs_spawn_thread (arg=0x5651ad1b8c70) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#25 0x00007fdcd4645494 in start_thread (arg=0x7fdccc4e8700) at pthread_create.c:333
|
#26 0x00007fdcd2a2b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible on 10.3.
- relates to
-
MDEV-18316
Assertion `is_added()' failed in dict_col_t::instant_value
-
-
Closed
{"report":{"fcp":675.7999999523163,"ttfb":117.79999995231628,"pageVisibility":"visible","entityId":72033,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"3e04efcd-dc67-4003-8918-307408f4161e","navigationType":0,"readyForUser":785.7999999523163,"redirectCount":0,"resourceLoadedEnd":765.4000000953674,"resourceLoadedStart":122.90000009536743,"resourceTiming":[{"duration":145.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":122.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":122.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":145.69999980926514,"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":123.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":123.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":268.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":156.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":123.20000004768372,"connectEnd":123.20000004768372,"connectStart":123.20000004768372,"domainLookupEnd":123.20000004768372,"domainLookupStart":123.20000004768372,"fetchStart":123.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":123.20000004768372,"responseEnd":279.90000009536743,"responseStart":279.90000009536743,"secureConnectionStart":123.20000004768372},{"duration":244.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":123.20000004768372,"connectEnd":123.20000004768372,"connectStart":123.20000004768372,"domainLookupEnd":123.20000004768372,"domainLookupStart":123.20000004768372,"fetchStart":123.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":123.20000004768372,"responseEnd":367.7000000476837,"responseStart":367.7000000476837,"secureConnectionStart":123.20000004768372},{"duration":247.90000009536743,"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":123.29999995231628,"connectEnd":123.29999995231628,"connectStart":123.29999995231628,"domainLookupEnd":123.29999995231628,"domainLookupStart":123.29999995231628,"fetchStart":123.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":123.29999995231628,"responseEnd":371.2000000476837,"responseStart":371.2000000476837,"secureConnectionStart":123.29999995231628},{"duration":248.29999995231628,"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":123.40000009536743,"connectEnd":123.40000009536743,"connectStart":123.40000009536743,"domainLookupEnd":123.40000009536743,"domainLookupStart":123.40000009536743,"fetchStart":123.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":123.40000009536743,"responseEnd":371.7000000476837,"responseStart":371.7000000476837,"secureConnectionStart":123.40000009536743},{"duration":249,"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":123.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":123.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":248.5,"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":123.60000014305115,"connectEnd":123.60000014305115,"connectStart":123.60000014305115,"domainLookupEnd":123.60000014305115,"domainLookupStart":123.60000014305115,"fetchStart":123.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":123.60000014305115,"responseEnd":372.10000014305115,"responseStart":372.10000014305115,"secureConnectionStart":123.60000014305115},{"duration":248.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":123.70000004768372,"connectEnd":123.70000004768372,"connectStart":123.70000004768372,"domainLookupEnd":123.70000004768372,"domainLookupStart":123.70000004768372,"fetchStart":123.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":123.70000004768372,"responseEnd":372.60000014305115,"responseStart":372.60000014305115,"secureConnectionStart":123.70000004768372},{"duration":249.09999990463257,"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":123.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":123.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":373,"responseStart":0,"secureConnectionStart":0},{"duration":249,"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":124.10000014305115,"connectEnd":124.10000014305115,"connectStart":124.10000014305115,"domainLookupEnd":124.10000014305115,"domainLookupStart":124.10000014305115,"fetchStart":124.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":124.10000014305115,"responseEnd":373.10000014305115,"responseStart":373.10000014305115,"secureConnectionStart":124.10000014305115},{"duration":301.7999999523163,"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":129,"connectEnd":129,"connectStart":129,"domainLookupEnd":129,"domainLookupStart":129,"fetchStart":129,"redirectEnd":0,"redirectStart":0,"requestStart":129,"responseEnd":430.7999999523163,"responseStart":430.7999999523163,"secureConnectionStart":129},{"duration":344.2000000476837,"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":129,"connectEnd":129,"connectStart":129,"domainLookupEnd":129,"domainLookupStart":129,"fetchStart":129,"redirectEnd":0,"redirectStart":0,"requestStart":129,"responseEnd":473.2000000476837,"responseStart":473.2000000476837,"secureConnectionStart":129},{"duration":27.799999952316284,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":446.10000014305115,"connectEnd":446.10000014305115,"connectStart":446.10000014305115,"domainLookupEnd":446.10000014305115,"domainLookupStart":446.10000014305115,"fetchStart":446.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":446.10000014305115,"responseEnd":473.90000009536743,"responseStart":473.90000009536743,"secureConnectionStart":446.10000014305115},{"duration":95.60000014305115,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":669.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":669.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":765.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":89.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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","startTime":676.2000000476837,"connectEnd":676.2000000476837,"connectStart":676.2000000476837,"domainLookupEnd":676.2000000476837,"domainLookupStart":676.2000000476837,"fetchStart":676.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":676.2000000476837,"responseEnd":765.4000000953674,"responseStart":765.4000000953674,"secureConnectionStart":676.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":118,"responseEnd":122,"domLoading":121,"domInteractive":846,"domContentLoadedEventStart":846,"domContentLoadedEventEnd":888,"domComplete":1357,"loadEventStart":1357,"loadEventEnd":1358,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":824},{"name":"bigPipe.sidebar-id.end","time":824.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":825},{"name":"bigPipe.activity-panel-pipe-id.end","time":827.2999999523163},{"name":"activityTabFullyLoaded","time":898.1000001430511}],"measures":[],"correlationId":"4f3a98b9f0aecc","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":62,"dbReadsTimeInMs":8,"dbConnsTimeInMs":14,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}