The problem does not occur on actual 10.4 or 10.3.
Its on
bb-10.4-MDEV-15563 commit 60124c0d47f8d89bf04592a300de5dda3bb84280 2019-01-10
only.
MTR test
--source include/have_innodb.inc
# Is harmless! CREATE TABLE t1 (col_int INTEGER, col_string VARCHAR(20)) ENGINE = InnoDB ROW_FORMAT = Compact ;
# Is harmless! CREATE TABLE t1 (col_int INTEGER, col_string VARCHAR(20)) ENGINE = InnoDB ROW_FORMAT = Dynamic ;
CREATE TABLE t1 (col_int INTEGER, col_string VARCHAR(20) ) ENGINE = InnoDB ROW_FORMAT = Redundant ;
# Assert with ALGORITHM = COPY too! ALTER TABLE t1 ADD INDEX idx3 ( col_string ), ALGORITHM = COPY;
ALTER TABLE t1 ADD INDEX idx3 ( col_string );
INSERT INTO t1 (col_int, col_string) VALUES ( 73, 'a' ) ;
ALTER TABLE t1 CHANGE COLUMN col_string col_string CHAR(20);
SHOW PROCESSLIST;
...
Version: '10.4.2-MariaDB-debug-log' socket: ...
mysqld: storage/innobase/row/row0merge.cc:777: ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, const dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABLE*, trx_t*): Assertion `!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)' failed.
190114 16:46:53 [ERROR] mysqld got signal 6 ;
...
Query (0x7fe2e4014190): ALTER TABLE t1 CHANGE COLUMN col_string col_string CHAR(20)
Connection ID (thread ID): 9
Status: NOT_KILLED
...
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007fe33a916f5d in __GI_abort () at abort.c:90
#6 0x00007fe33a90cf17 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55dc9258dfd0 "!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)", file=file@entry=0x55dc9258dcd0 "storage/innobase/row/row0merge.cc", line=line@entry=777, function=function@entry=0x55dc92590820 <row_merge_buf_add(row_merge_buf_t*, dict_index_t*, dict_table_t const*, dict_table_t const*, fts_psort_t*, dtuple_t const*, row_ext_t const*, unsigned long*, mem_block_info_t*, dberr_t*, mem_block_info_t**, TABLE*, trx_t*)::__PRETTY_FUNCTION__> "ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, const dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABL"...) at assert.c:92
#7 0x00007fe33a90cfc2 in __GI___assert_fail (assertion=0x55dc9258dfd0 "!col->mbmaxlen || len >= col->mbminlen * (fixed_len / col->mbmaxlen)", file=0x55dc9258dcd0 "storage/innobase/row/row0merge.cc", line=777, function=0x55dc92590820 <row_merge_buf_add(row_merge_buf_t*, dict_index_t*, dict_table_t const*, dict_table_t const*, fts_psort_t*, dtuple_t const*, row_ext_t const*, unsigned long*, mem_block_info_t*, dberr_t*, mem_block_info_t**, TABLE*, trx_t*)::__PRETTY_FUNCTION__> "ulint row_merge_buf_add(row_merge_buf_t*, dict_index_t*, const dict_table_t*, const dict_table_t*, fts_psort_t*, const dtuple_t*, const row_ext_t*, doc_id_t*, mem_heap_t*, dberr_t*, mem_heap_t**, TABL"...) at assert.c:101
#8 0x000055dc91df1631 in row_merge_buf_add (buf=0x7fe2e419bbb8, fts_index=0x0, old_table=0x7fe2e41a1388, new_table=0x7fe2e405cf38, psort_info=0x0, row=0x7fe2e4064938, ext=0x0, doc_id=0x7fe3344962d0, conv_heap=0x0, err=0x7fe3344962bc, v_heap=0x7fe3344962c8, my_table=0x7fe2e405af68, trx=0x7fe334731138) at storage/innobase/row/row0merge.cc:777
#9 0x000055dc91df72dd in row_merge_read_clustered_index (trx=0x7fe334731138, table=0x7fe2e405af68, old_table=0x7fe2e41a1388, new_table=0x7fe2e405cf38, online=true, index=0x7fe2e405cb98, fts_sort_idx=0x0, psort_info=0x0, files=0x7fe2e405eaf0, key_numbers=0x7fe2e405cba8, n_index=2, defaults=0x0, add_v=0x0, col_map=0x7fe2e405cc38, add_autoinc=18446744073709551615, sequence=..., block=0x7fe32c4aa000 <error: Cannot access memory at address 0x7fe32c4aa000>, skip_pk_sort=true, tmpfd=0x7fe334496f40, stage=0x7fe2e405dab0, pct_cost=33.333333333333336, crypt_block=0x0, eval_table=0x7fe2e405af68, allow_not_null=false) at storage/innobase/row/row0merge.cc:2373
#10 0x000055dc91dfe014 in row_merge_build_indexes (trx=0x7fe334731138, old_table=0x7fe2e41a1388, new_table=0x7fe2e405cf38, online=true, indexes=0x7fe2e405cb98, key_numbers=0x7fe2e405cba8, n_indexes=2, table=0x7fe2e405af68, defaults=0x0, col_map=0x7fe2e405cc38, add_autoinc=18446744073709551615, sequence=..., skip_pk_sort=true, stage=0x7fe2e405dab0, add_v=0x0, eval_table=0x7fe2e405af68, allow_not_null=false) at storage/innobase/row/row0merge.cc:4743
#11 0x000055dc91ce5129 in ha_innobase::inplace_alter_table (this=0x7fe2e40bade0, altered_table=0x7fe2e405af68, ha_alter_info=0x7fe334497bb0) at storage/innobase/handler/handler0alter.cc:8326
#12 0x000055dc91858367 in handler::ha_inplace_alter_table (this=0x7fe2e40bade0, altered_table=0x7fe2e405af68, ha_alter_info=0x7fe334497bb0) at sql/handler.h:4216
#13 0x000055dc9184d8d8 in mysql_inplace_alter_table (thd=0x7fe2e4000ce8, table_list=0x7fe2e40142b8, table=0x7fe2e41787b8, altered_table=0x7fe2e405af68, ha_alter_info=0x7fe334497bb0, inplace_supported=HA_ALTER_INPLACE_COPY_NO_LOCK, target_mdl_request=0x7fe334497ce0, alter_ctx=0x7fe3344988d0) at sql/sql_table.cc:7543
#14 0x000055dc918539e4 in mysql_alter_table (thd=0x7fe2e4000ce8, new_db=0x7fe2e40053b0, new_name=0x7fe2e4005780, create_info=0x7fe3344994c0, table_list=0x7fe2e40142b8, alter_info=0x7fe334499400, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:9694
#15 0x000055dc918dda72 in Sql_cmd_alter_table::execute (this=0x7fe2e4014a30, thd=0x7fe2e4000ce8) at sql/sql_alter.cc:491
#16 0x000055dc9177bf69 in mysql_execute_command (thd=0x7fe2e4000ce8) at sql/sql_parse.cc:6302
#17 0x000055dc91781124 in mysql_parse (thd=0x7fe2e4000ce8, rawbuf=0x7fe2e4014190 "ALTER TABLE t1 CHANGE COLUMN col_string col_string CHAR(20)", length=59, parser_state=0x7fe33449a5f0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8104
#18 0x000055dc9176e054 in dispatch_command (command=COM_QUERY, thd=0x7fe2e4000ce8, packet=0x7fe2e400acd9 "ALTER TABLE t1 CHANGE COLUMN col_string col_string CHAR(20)", packet_length=59, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1850
#19 0x000055dc9176ca69 in do_command (thd=0x7fe2e4000ce8) at sql/sql_parse.cc:1395
#20 0x000055dc918d7aa2 in do_handle_one_connection (connect=0x55dc93f580c8) at sql/sql_connect.cc:1402
#21 0x000055dc918d7819 in handle_one_connection (arg=0x55dc93f580c8) at sql/sql_connect.cc:1308
#22 0x000055dc921d4a11 in pfs_spawn_thread (arg=0x55dc93f9e4f8) at storage/perfschema/pfs.cc:1862
#23 0x00007fe33b5b87fc in start_thread (arg=0x7fe33449b700) at pthread_create.c:465
ts_7.test 2019-01-14 16:00 0.6 kB Matthias Leich
duplicates
MDEV-18124
PK on inplace-enlarged type fails
Closed
{"report":{"fcp":1407,"ttfb":303.3999999910593,"pageVisibility":"visible","entityId":71853,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"0a456781-ee8d-4155-bdd0-fdcb770cdc12","navigationType":0,"readyForUser":1491.5,"redirectCount":0,"resourceLoadedEnd":1617.199999988079,"resourceLoadedStart":308.5,"resourceTiming":[{"duration":617.3999999910593,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":308.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":925.8999999910593,"responseStart":0,"secureConnectionStart":0},{"duration":617.3999999910593,"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":308.79999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":926.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":625.9000000059605,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":308.8999999910593,"connectEnd":308.8999999910593,"connectStart":308.8999999910593,"domainLookupEnd":308.8999999910593,"domainLookupStart":308.8999999910593,"fetchStart":308.8999999910593,"redirectEnd":0,"redirectStart":0,"requestStart":308.8999999910593,"responseEnd":934.7999999970198,"responseStart":934.6999999880791,"secureConnectionStart":308.8999999910593},{"duration":681.7999999970198,"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":309.09999999403954,"connectEnd":309.09999999403954,"connectStart":309.09999999403954,"domainLookupEnd":309.09999999403954,"domainLookupStart":309.09999999403954,"fetchStart":309.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":309.09999999403954,"responseEnd":990.8999999910593,"responseStart":990.8999999910593,"secureConnectionStart":309.09999999403954},{"duration":685.2000000029802,"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":309.29999999701977,"connectEnd":309.29999999701977,"connectStart":309.29999999701977,"domainLookupEnd":309.29999999701977,"domainLookupStart":309.29999999701977,"fetchStart":309.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":309.29999999701977,"responseEnd":994.5,"responseStart":994.5,"secureConnectionStart":309.29999999701977},{"duration":685.3999999910593,"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":309.5,"connectEnd":309.5,"connectStart":309.5,"domainLookupEnd":309.5,"domainLookupStart":309.5,"fetchStart":309.5,"redirectEnd":0,"redirectStart":0,"requestStart":309.5,"responseEnd":994.8999999910593,"responseStart":994.8999999910593,"secureConnectionStart":309.5},{"duration":685.6000000089407,"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":309.69999998807907,"connectEnd":309.69999998807907,"connectStart":309.69999998807907,"domainLookupEnd":309.69999998807907,"domainLookupStart":309.69999998807907,"fetchStart":309.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":309.69999998807907,"responseEnd":995.2999999970198,"responseStart":995.2999999970198,"secureConnectionStart":309.69999998807907},{"duration":765.2999999970198,"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":309.79999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":309.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1075.0999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":765.1999999880791,"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":310,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":310,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1075.199999988079,"responseStart":0,"secureConnectionStart":0},{"duration":685.5999999940395,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":310,"connectEnd":310,"connectStart":310,"domainLookupEnd":310,"domainLookupStart":310,"fetchStart":310,"redirectEnd":0,"redirectStart":0,"requestStart":310,"responseEnd":995.5999999940395,"responseStart":995.5999999940395,"secureConnectionStart":310},{"duration":685.8999999910593,"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":310.29999999701977,"connectEnd":310.29999999701977,"connectStart":310.29999999701977,"domainLookupEnd":310.29999999701977,"domainLookupStart":310.29999999701977,"fetchStart":310.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":310.29999999701977,"responseEnd":996.1999999880791,"responseStart":996.1999999880791,"secureConnectionStart":310.29999999701977},{"duration":883.1999999880791,"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":311,"connectEnd":311,"connectStart":311,"domainLookupEnd":311,"domainLookupStart":311,"fetchStart":311,"redirectEnd":0,"redirectStart":0,"requestStart":311,"responseEnd":1194.199999988079,"responseStart":1194.199999988079,"secureConnectionStart":311},{"duration":1294.7000000029802,"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":311.09999999403954,"connectEnd":311.09999999403954,"connectStart":311.09999999403954,"domainLookupEnd":311.09999999403954,"domainLookupStart":311.09999999403954,"fetchStart":311.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":311.09999999403954,"responseEnd":1605.7999999970198,"responseStart":1605.7999999970198,"secureConnectionStart":311.09999999403954},{"duration":124.09999999403954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1086.7999999970198,"connectEnd":1086.7999999970198,"connectStart":1086.7999999970198,"domainLookupEnd":1086.7999999970198,"domainLookupStart":1086.7999999970198,"fetchStart":1086.7999999970198,"redirectEnd":0,"redirectStart":0,"requestStart":1086.7999999970198,"responseEnd":1210.8999999910593,"responseStart":1210.8999999910593,"secureConnectionStart":1086.7999999970198},{"duration":267.59999999403954,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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","startTime":1349.5999999940395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1349.5999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1617.199999988079,"responseStart":0,"secureConnectionStart":0},{"duration":290.79999999701977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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":1350.5,"connectEnd":1350.5,"connectStart":1350.5,"domainLookupEnd":1350.5,"domainLookupStart":1350.5,"fetchStart":1350.5,"redirectEnd":0,"redirectStart":0,"requestStart":1350.5,"responseEnd":1641.2999999970198,"responseStart":1641.2999999970198,"secureConnectionStart":1350.5},{"duration":294.8999999910593,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/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","startTime":1351,"connectEnd":1351,"connectStart":1351,"domainLookupEnd":1351,"domainLookupStart":1351,"fetchStart":1351,"redirectEnd":0,"redirectStart":0,"requestStart":1351,"responseEnd":1645.8999999910593,"responseStart":1645.8999999910593,"secureConnectionStart":1351}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":95,"responseStart":303,"responseEnd":305,"domLoading":306,"domInteractive":1623,"domContentLoadedEventStart":1623,"domContentLoadedEventEnd":1663,"domComplete":2304,"loadEventStart":2304,"loadEventEnd":2305,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1607.5},{"name":"bigPipe.sidebar-id.end","time":1608.199999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":1608.3999999910593},{"name":"bigPipe.activity-panel-pipe-id.end","time":1609.0999999940395},{"name":"activityTabFullyLoaded","time":1677.5}],"measures":[],"correlationId":"2aaca44bbf7ef9","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":118,"dbReadsTimeInMs":14,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Fix for
MDEV-18124also applicable for this case.