#7 0x00007fa3375ddee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x0000559a7fd971c5 in dict_table_t::prepare_instant (this=0x7fa2e80a6178, old=..., col_map=0x7fa2e80a5b88, first_alter_pos=@0x7fa2e80164e8: 1) at /data/src/bb-10.4-MDEV-17520/storage/innobase/handler/handler0alter.cc:303
#9 0x0000559a7fd9c2db in ha_innobase_inplace_ctx::prepare_instant (this=0x7fa2e8016378) at /data/src/bb-10.4-MDEV-17520/storage/innobase/handler/handler0alter.cc:1059
#10 0x0000559a7fd87227 in prepare_inplace_alter_table_dict (ha_alter_info=0x7fa330920bb0, altered_table=0x7fa2e8132f00, old_table=0x7fa2e8095f70, table_name=0x7fa2e81304cd "t1", flags=33, flags2=80, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=false) at /data/src/bb-10.4-MDEV-17520/storage/innobase/handler/handler0alter.cc:6517
#11 0x0000559a7fd8c124 in ha_innobase::prepare_inplace_alter_table (this=0x7fa2e8096ba8, altered_table=0x7fa2e8132f00, ha_alter_info=0x7fa330920bb0) at /data/src/bb-10.4-MDEV-17520/storage/innobase/handler/handler0alter.cc:8064
#12 0x0000559a7fa27cbb in handler::ha_prepare_inplace_alter_table (this=0x7fa2e8096ba8, altered_table=0x7fa2e8132f00, ha_alter_info=0x7fa330920bb0) at /data/src/bb-10.4-MDEV-17520/sql/handler.cc:4437
#13 0x0000559a7f7ecd5c in mysql_inplace_alter_table (thd=0x7fa2e8000b00, table_list=0x7fa2e8014eb0, table=0x7fa2e8095f70, altered_table=0x7fa2e8132f00, ha_alter_info=0x7fa330920bb0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7fa330920ce0, alter_ctx=0x7fa3309218d0) at /data/src/bb-10.4-MDEV-17520/sql/sql_table.cc:7515
#14 0x0000559a7f7f2f79 in mysql_alter_table (thd=0x7fa2e8000b00, new_db=0x7fa2e80051b8, new_name=0x7fa2e8005588, create_info=0x7fa3309224c0, table_list=0x7fa2e8014eb0, alter_info=0x7fa330922400, order_num=0, order=0x0, ignore=false) at /data/src/bb-10.4-MDEV-17520/sql/sql_table.cc:9691
#15 0x0000559a7f87d121 in Sql_cmd_alter_table::execute (this=0x7fa2e8015610, thd=0x7fa2e8000b00) at /data/src/bb-10.4-MDEV-17520/sql/sql_alter.cc:497
#16 0x0000559a7f71ae4a in mysql_execute_command (thd=0x7fa2e8000b00) at /data/src/bb-10.4-MDEV-17520/sql/sql_parse.cc:6290
#17 0x0000559a7f71fd6e in mysql_parse (thd=0x7fa2e8000b00, rawbuf=0x7fa2e8014da8 "ALTER TABLE t1 MODIFY f2 VARCHAR (8) FIRST", length=42, parser_state=0x7fa330923600, is_com_multi=false, is_next_command=false) at /data/src/bb-10.4-MDEV-17520/sql/sql_parse.cc:8092
#18 0x0000559a7f70d05c in dispatch_command (command=COM_QUERY, thd=0x7fa2e8000b00, packet=0x7fa2e800b411 "ALTER TABLE t1 MODIFY f2 VARCHAR (8) FIRST", packet_length=42, is_com_multi=false, is_next_command=false) at /data/src/bb-10.4-MDEV-17520/sql/sql_parse.cc:1851
#19 0x0000559a7f70ba80 in do_command (thd=0x7fa2e8000b00) at /data/src/bb-10.4-MDEV-17520/sql/sql_parse.cc:1396
#20 0x0000559a7f877168 in do_handle_one_connection (connect=0x559a82ad3810) at /data/src/bb-10.4-MDEV-17520/sql/sql_connect.cc:1402
#21 0x0000559a7f876eec in handle_one_connection (arg=0x559a82ad3810) at /data/src/bb-10.4-MDEV-17520/sql/sql_connect.cc:1308
#22 0x0000559a7fd2b3e2 in pfs_spawn_thread (arg=0x559a82b58b90) at /data/src/bb-10.4-MDEV-17520/storage/perfschema/pfs.cc:1862
#23 0x00007fa339099494 in start_thread (arg=0x7fa330924700) at pthread_create.c:333
#24 0x00007fa33769a93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
Marko Mäkelä
added a comment - This happens with the first commit already, in a different form:
mysqld: /mariadb/10.4/storage/innobase/handler/handler0alter.cc:465: void dict_table_t::instant_column(const dict_table_t &, const ulint *): Assertion `c.len == o->len' failed.
This was a bogus debug assertion: The column is being both moved and enlarged at the same time. bb-10.4-MDEV-15563 fixes this (in the first commit that is not in 10.4).
At some point, I will rebase the bb-10.4-MDEV-17520 branch, so that also it will contain this fix.
Marko Mäkelä
added a comment - This was a bogus debug assertion: The column is being both moved and enlarged at the same time.
bb-10.4-MDEV-15563 fixes this (in the first commit that is not in 10.4).
At some point, I will rebase the bb-10.4- MDEV-17520 branch, so that also it will contain this fix.
People
Marko Mäkelä
Elena Stepanova
Votes:
0Vote for this issue
Watchers:
2Start 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":817.3999998569489,"ttfb":176.5,"pageVisibility":"visible","entityId":71269,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"42b43c96-6ca3-4f73-9bed-28420009a9d0","navigationType":0,"readyForUser":931.7000000476837,"redirectCount":0,"resourceLoadedEnd":536.5999999046326,"resourceLoadedStart":182.59999990463257,"resourceTiming":[{"duration":57.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":182.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":240.39999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":57.799999952316284,"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":182.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":240.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":243.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":182.89999985694885,"connectEnd":182.89999985694885,"connectStart":182.89999985694885,"domainLookupEnd":182.89999985694885,"domainLookupStart":182.89999985694885,"fetchStart":182.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":243.29999995231628,"responseEnd":426.2999999523163,"responseStart":267.7000000476837,"secureConnectionStart":182.89999985694885},{"duration":353.59999990463257,"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":183,"connectEnd":183,"connectStart":183,"domainLookupEnd":183,"domainLookupStart":183,"fetchStart":183,"redirectEnd":0,"redirectStart":0,"requestStart":243.89999985694885,"responseEnd":536.5999999046326,"responseStart":314,"secureConnectionStart":183},{"duration":92.69999980926514,"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":183.20000004768372,"connectEnd":183.20000004768372,"connectStart":183.20000004768372,"domainLookupEnd":183.20000004768372,"domainLookupStart":183.20000004768372,"fetchStart":183.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":244.59999990463257,"responseEnd":275.89999985694885,"responseStart":272.39999985694885,"secureConnectionStart":183.20000004768372},{"duration":92.79999995231628,"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":183.29999995231628,"connectEnd":183.29999995231628,"connectStart":183.29999995231628,"domainLookupEnd":183.29999995231628,"domainLookupStart":183.29999995231628,"fetchStart":183.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":245.70000004768372,"responseEnd":276.09999990463257,"responseStart":273.5,"secureConnectionStart":183.29999995231628},{"duration":96.40000009536743,"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":183.39999985694885,"connectEnd":183.39999985694885,"connectStart":183.39999985694885,"domainLookupEnd":183.39999985694885,"domainLookupStart":183.39999985694885,"fetchStart":183.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":247.09999990463257,"responseEnd":279.7999999523163,"responseStart":276.59999990463257,"secureConnectionStart":183.39999985694885},{"duration":62.200000047683716,"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":183.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":245.70000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":63.799999952316284,"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":183.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":247.39999985694885,"responseStart":0,"secureConnectionStart":0},{"duration":96.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":183.59999990463257,"connectEnd":183.59999990463257,"connectStart":183.59999990463257,"domainLookupEnd":183.59999990463257,"domainLookupStart":183.59999990463257,"fetchStart":183.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":248.09999990463257,"responseEnd":280.09999990463257,"responseStart":277.5,"secureConnectionStart":183.59999990463257},{"duration":97.29999995231628,"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":183.79999995231628,"connectEnd":183.79999995231628,"connectStart":183.79999995231628,"domainLookupEnd":183.79999995231628,"domainLookupStart":183.79999995231628,"fetchStart":183.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":250.5,"responseEnd":281.09999990463257,"responseStart":278.09999990463257,"secureConnectionStart":183.79999995231628},{"duration":323.39999985694885,"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":189.20000004768372,"connectEnd":189.20000004768372,"connectStart":189.20000004768372,"domainLookupEnd":189.20000004768372,"domainLookupStart":189.20000004768372,"fetchStart":189.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":282.39999985694885,"responseEnd":512.5999999046326,"responseStart":505.7000000476837,"secureConnectionStart":189.20000004768372},{"duration":324,"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":189.39999985694885,"connectEnd":189.39999985694885,"connectStart":189.39999985694885,"domainLookupEnd":189.39999985694885,"domainLookupStart":189.39999985694885,"fetchStart":189.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":295.2000000476837,"responseEnd":513.3999998569489,"responseStart":508.39999985694885,"secureConnectionStart":189.39999985694885},{"duration":113.10000014305115,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":574.5999999046326,"connectEnd":574.5999999046326,"connectStart":574.5999999046326,"domainLookupEnd":574.5999999046326,"domainLookupStart":574.5999999046326,"fetchStart":574.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":654.7999999523163,"responseEnd":687.7000000476837,"responseStart":686.7000000476837,"secureConnectionStart":574.5999999046326},{"duration":225.79999995231628,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":809.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":809.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1035.3999998569489,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":16,"responseStart":176,"responseEnd":183,"domLoading":180,"domInteractive":988,"domContentLoadedEventStart":988,"domContentLoadedEventEnd":1028,"domComplete":1314,"loadEventStart":1314,"loadEventEnd":1315,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":970.7000000476837},{"name":"bigPipe.sidebar-id.end","time":971.3999998569489},{"name":"bigPipe.activity-panel-pipe-id.start","time":971.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":972.7999999523163},{"name":"activityTabFullyLoaded","time":1042.2999999523163}],"measures":[],"correlationId":"9264150337b3b7","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
This is also crashing on bb-10.4-MDEV-15563, which implements NOT NULL removal for ROW_FORMAT=REDUNDANT.