Note: Run with --repeat=N if it doesn't fail right away. It usually fails for me within first 1-2 attempts, but it can probably vary on different machines and builds.
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (
|
pk INT,
|
f1 INT,
|
f2 CHAR(255),
|
f3 BIGINT,
|
f4 INT,
|
f5 CHAR(255),
|
f6 CHAR(255),
|
f7 CHAR(255) NOT NULL,
|
f8 INT,
|
f9 CHAR(10),
|
PRIMARY KEY (pk)
|
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
|
|
INSERT INTO t1 VALUES
|
(1, 1, 'a', 1, 1, 'a', 'a', 'a', 1, 'a'),
|
(2, 2, 'b', 2, 2, 'b', 'b', 'b', 2, 'b'),
|
(3, 3, 'c', 3, 3, 'c', 'c', 'c', 3, 'c'),
|
(4, 4, 'd', 4, 4, 'd', 'd', 'd', 4, 'd'),
|
(5, 5, 'e', 5, 5, 'e', 'e', 'e', 5, 'e'),
|
(6, 6, 'f', 6, 6, 'f', 'f', 'f', 6, 'f'),
|
(7, 7, 'g', 7, 7, 'g', 'g', 'g', 7, 'g'),
|
(8, 8, 'h', 8, 8, 'h', 'h', 'h', 8, 'h'),
|
(9, 9, 'i', 9, 9, 'i', 'i', 'i', 9, 'i'),
|
(10, 0, 'j', 0, 0, 'j', 'j', 'j', 0, 'j'),
|
(11, 1, 'k', 1, 1, 'k', 'k', 'k', 1, 'k'),
|
(12, 2, 'l', 2, 2, 'l', 'l', 'l', 2, 'l'),
|
(13, 3, 'm', 3, 3, 'm', 'm', 'm', 3, 'm'),
|
(14, 4, 'n', 4, 4, 'n', 'n', 'n', 4, 'n'),
|
(15, 5, 'o', 5, 5, 'o', 'o', 'o', 5, 'o');
|
|
ALTER TABLE t1 ROW_FORMAT=COMPACT;
|
DELETE FROM t1 LIMIT 1;
|
|
REPLACE INTO t1 VALUES
|
(1, 1, 'a', 1, 1, 'a', 'a', 'a', 1, 'a'),
|
(2, 2, 'b', 2, 2, 'b', 'b', 'b', 2, 'b'),
|
(3, 3, 'c', 3, 3, 'c', 'c', 'c', 3, 'c'),
|
(4, 4, 'd', 4, 4, 'd', 'd', 'd', 4, 'd'),
|
(5, 5, 'e', 5, 5, 'e', 'e', 'e', 5, 'e'),
|
(6, 6, 'f', 6, 6, 'f', 'f', 'f', 6, 'f'),
|
(7, 7, 'g', 7, 7, 'g', 'g', 'g', 7, 'g'),
|
(8, 8, 'h', 8, 8, 'h', 'h', 'h', 8, 'h'),
|
(9, 9, 'i', 9, 9, 'i', 'i', 'i', 9, 'i'),
|
(10, 0, 'j', 0, 0, 'j', 'j', 'j', 0, 'j'),
|
(11, 1, 'k', 1, 1, 'k', 'k', 'k', 1, 'k'),
|
(12, 2, 'l', 2, 2, 'l', 'l', 'l', 2, 'l'),
|
(13, 3, 'm', 3, 3, 'm', 'm', 'm', 3, 'm'),
|
(14, 4, 'n', 4, 4, 'n', 'n', 'n', 4, 'n'),
|
(15, 5, 'o', 5, 5, 'o', 'o', 'o', 5, 'o');
|
|
ALTER TABLE t1 DROP COLUMN f1;
|
|
# Cleanup
|
DROP TABLE t1;
|
10.4 27f3329ff6
|
mysqld: /data/src/10.4/storage/innobase/rem/rem0rec.cc:1607: void rec_convert_dtuple_to_rec_comp(rec_t*, const dict_index_t*, const dfield_t*, ulint, rec_comp_status_t, bool) [with bool mblob = true; rec_t = unsigned char; ulint = long unsigned int]: Assertion `len == 20U' failed.
|
181125 16:44:43 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fa526be5ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055f458e11551 in rec_convert_dtuple_to_rec_comp<true> (rec=0x7fa4d81deb7f "\200", index=0x7fa4d81db328, field=0x7fa4d81e0048, n_fields=13, status=REC_STATUS_INSTANT, temp=false) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:1607
|
#9 0x000055f458e0ae42 in rec_convert_dtuple_to_rec_new (buf=0x7fa4d81deb7f "\200", index=0x7fa4d81db328, dtuple=0x7fa4d81dffb8) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:1722
|
#10 0x000055f458e0b0a5 in rec_convert_dtuple_to_rec (buf=0x7fa4d81deb78 "", index=0x7fa4d81db328, dtuple=0x7fa4d81dffb8, n_ext=0) at /data/src/10.4/storage/innobase/rem/rem0rec.cc:1766
|
#11 0x000055f458f20610 in page_cur_tuple_insert (cursor=0x7fa520126358, tuple=0x7fa4d81dffb8, index=0x7fa4d81db328, offsets=0x7fa5201262e8, heap=0x7fa5201262e0, n_ext=0, mtr=0x7fa520126770) at /data/src/10.4/storage/innobase/include/page0cur.ic:278
|
#12 0x000055f458f2a416 in btr_page_split_and_insert (flags=2, cursor=0x7fa520126350, offsets=0x7fa5201262e8, heap=0x7fa5201262e0, tuple=0x7fa4d81dffb8, n_ext=0, mtr=0x7fa520126770) at /data/src/10.4/storage/innobase/btr/btr0btr.cc:3284
|
#13 0x000055f458f4d7b7 in btr_cur_pessimistic_insert (flags=2, cursor=0x7fa520126350, offsets=0x7fa5201262e8, heap=0x7fa5201262e0, entry=0x7fa4d81dffb8, rec=0x7fa5201262f0, big_rec=0x7fa5201262d8, n_ext=0, thr=0x7fa4d81e0210, mtr=0x7fa520126770) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:3695
|
#14 0x000055f458e34f95 in row_ins_clust_index_entry_low (flags=2, mode=33, index=0x7fa4d81db328, n_uniq=1, entry=0x7fa4d81dffb8, n_ext=0, thr=0x7fa4d81e0210, dup_chk_only=false) at /data/src/10.4/storage/innobase/row/row0ins.cc:2767
|
#15 0x000055f458d2c8be in innobase_instant_try (ha_alter_info=0x7fa520128bb0, ctx=0x7fa4d8017228, altered_table=0x7fa4d807efb0, table=0x7fa4d81d5a50, trx=0x7fa520a23218) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:5647
|
#16 0x000055f458d46fcb in commit_try_norebuild (ha_alter_info=0x7fa520128bb0, ctx=0x7fa4d8017228, altered_table=0x7fa4d807efb0, old_table=0x7fa4d81d5a50, trx=0x7fa520a23218, table_name=0x7fa4d81bf89d "t1") at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10013
|
#17 0x000055f458d39d02 in ha_innobase::commit_inplace_alter_table (this=0x7fa4d80490e8, altered_table=0x7fa4d807efb0, ha_alter_info=0x7fa520128bb0, commit=true) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10642
|
#18 0x000055f4589d4a78 in handler::ha_commit_inplace_alter_table (this=0x7fa4d80490e8, altered_table=0x7fa4d807efb0, ha_alter_info=0x7fa520128bb0, commit=true) at /data/src/10.4/sql/handler.cc:4457
|
#19 0x000055f45879e918 in mysql_inplace_alter_table (thd=0x7fa4d8000b00, table_list=0x7fa4d8014e80, table=0x7fa4d81d5a50, altered_table=0x7fa4d807efb0, ha_alter_info=0x7fa520128bb0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7fa520128ce0, alter_ctx=0x7fa5201298d0) at /data/src/10.4/sql/sql_table.cc:7599
|
#20 0x000055f4587a4733 in mysql_alter_table (thd=0x7fa4d8000b00, new_db=0x7fa4d80051b8, new_name=0x7fa4d8005588, create_info=0x7fa52012a4c0, table_list=0x7fa4d8014e80, alter_info=0x7fa52012a400, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9692
|
#21 0x000055f45882d8bd in Sql_cmd_alter_table::execute (this=0x7fa4d80154e8, thd=0x7fa4d8000b00) at /data/src/10.4/sql/sql_alter.cc:497
|
#22 0x000055f4586ccab4 in mysql_execute_command (thd=0x7fa4d8000b00) at /data/src/10.4/sql/sql_parse.cc:6289
|
#23 0x000055f4586d19d8 in mysql_parse (thd=0x7fa4d8000b00, rawbuf=0x7fa4d8014d98 "ALTER TABLE t1 DROP COLUMN f1", length=29, parser_state=0x7fa52012b600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8091
|
#24 0x000055f4586becd7 in dispatch_command (command=COM_QUERY, thd=0x7fa4d8000b00, packet=0x7fa4d8093db1 "ALTER TABLE t1 DROP COLUMN f1", packet_length=29, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
|
#25 0x000055f4586bd6fb in do_command (thd=0x7fa4d8000b00) at /data/src/10.4/sql/sql_parse.cc:1396
|
#26 0x000055f458827b3c in do_handle_one_connection (connect=0x55f45cae1660) at /data/src/10.4/sql/sql_connect.cc:1402
|
#27 0x000055f4588278c0 in handle_one_connection (arg=0x55f45cae1660) at /data/src/10.4/sql/sql_connect.cc:1308
|
#28 0x000055f458cd50a1 in pfs_spawn_thread (arg=0x55f45cb66930) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#29 0x00007fa5286a1494 in start_thread (arg=0x7fa52012c700) at pthread_create.c:333
|
#30 0x00007fa526ca293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible on 10.3.
No obvious effect on a non-debug build.
{"report":{"fcp":878.3000001907349,"ttfb":148.80000019073486,"pageVisibility":"visible","entityId":70935,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"04b07315-8f0f-48fc-a78b-e4f5c0bb63af","navigationType":0,"readyForUser":974.2000000476837,"redirectCount":0,"resourceLoadedEnd":1153.7000000476837,"resourceLoadedStart":181.20000004768372,"resourceTiming":[{"duration":143.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":181.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":325.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":253.30000019073486,"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":181.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":434.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":262.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":181.5,"connectEnd":181.5,"connectStart":181.5,"domainLookupEnd":181.5,"domainLookupStart":181.5,"fetchStart":181.5,"redirectEnd":0,"redirectStart":0,"requestStart":181.5,"responseEnd":444.10000014305115,"responseStart":444.10000014305115,"secureConnectionStart":181.5},{"duration":311.40000009536743,"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":181.70000004768372,"connectEnd":181.70000004768372,"connectStart":181.70000004768372,"domainLookupEnd":181.70000004768372,"domainLookupStart":181.70000004768372,"fetchStart":181.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":181.70000004768372,"responseEnd":493.10000014305115,"responseStart":493.10000014305115,"secureConnectionStart":181.70000004768372},{"duration":315.2999999523163,"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":181.80000019073486,"connectEnd":181.80000019073486,"connectStart":181.80000019073486,"domainLookupEnd":181.80000019073486,"domainLookupStart":181.80000019073486,"fetchStart":181.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":181.80000019073486,"responseEnd":497.10000014305115,"responseStart":497.10000014305115,"secureConnectionStart":181.80000019073486},{"duration":315.59999990463257,"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":181.90000009536743,"connectEnd":181.90000009536743,"connectStart":181.90000009536743,"domainLookupEnd":181.90000009536743,"domainLookupStart":181.90000009536743,"fetchStart":181.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":181.90000009536743,"responseEnd":497.5,"responseStart":497.5,"secureConnectionStart":181.90000009536743},{"duration":315.90000009536743,"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":182,"connectEnd":182,"connectStart":182,"domainLookupEnd":182,"domainLookupStart":182,"fetchStart":182,"redirectEnd":0,"redirectStart":0,"requestStart":182,"responseEnd":497.90000009536743,"responseStart":497.90000009536743,"secureConnectionStart":182},{"duration":316.2000000476837,"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":182.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":498.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":316.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":182.20000004768372,"connectEnd":182.20000004768372,"connectStart":182.20000004768372,"domainLookupEnd":182.20000004768372,"domainLookupStart":182.20000004768372,"fetchStart":182.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":182.20000004768372,"responseEnd":498.40000009536743,"responseStart":498.40000009536743,"secureConnectionStart":182.20000004768372},{"duration":316.5,"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":182.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":498.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":316.5,"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":182.5,"connectEnd":182.5,"connectStart":182.5,"domainLookupEnd":182.5,"domainLookupStart":182.5,"fetchStart":182.5,"redirectEnd":0,"redirectStart":0,"requestStart":182.5,"responseEnd":499,"responseStart":499,"secureConnectionStart":182.5},{"duration":466.2000000476837,"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":183.20000004768372,"connectEnd":183.20000004768372,"connectStart":183.20000004768372,"domainLookupEnd":183.20000004768372,"domainLookupStart":183.20000004768372,"fetchStart":183.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":183.20000004768372,"responseEnd":649.4000000953674,"responseStart":649.4000000953674,"secureConnectionStart":183.20000004768372},{"duration":970.3999998569489,"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":183.30000019073486,"connectEnd":183.30000019073486,"connectStart":183.30000019073486,"domainLookupEnd":183.30000019073486,"domainLookupStart":183.30000019073486,"fetchStart":183.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":183.30000019073486,"responseEnd":1153.7000000476837,"responseStart":1153.7000000476837,"secureConnectionStart":183.30000019073486},{"duration":470.7000000476837,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":678.1000001430511,"connectEnd":678.1000001430511,"connectStart":678.1000001430511,"domainLookupEnd":678.1000001430511,"domainLookupStart":678.1000001430511,"fetchStart":678.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":678.1000001430511,"responseEnd":1148.8000001907349,"responseStart":1148.8000001907349,"secureConnectionStart":678.1000001430511},{"duration":301.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":857.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":857.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1159,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":13,"responseStart":149,"responseEnd":164,"domLoading":178,"domInteractive":1177,"domContentLoadedEventStart":1177,"domContentLoadedEventEnd":1218,"domComplete":1906,"loadEventStart":1906,"loadEventEnd":1908,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1158.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1159.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1159.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1161.7000000476837},{"name":"activityTabFullyLoaded","time":1222.4000000953674}],"measures":[],"correlationId":"49c56cf99cc21f","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":69,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}