--source include/have_innodb.inc
|
|
CREATE TABLE t1 (c CHAR(3), KEY(c)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES ('foo');
|
ALTER IGNORE TABLE t1 MODIFY c CHAR(0);
|
|
# Cleanup
|
DROP TABLE t1;
|
10.3 06e5f28f9
|
mysqld: /data/src/10.3/storage/innobase/btr/btr0cur.cc:984: ulint btr_node_ptr_max_size(const dict_index_t*): Assertion `!strcmp(index->table->name.m_name, "SYS_FOREIGN") || !strcmp(index->table->name.m_name, "SYS_FOREIGN_COLS")' failed.
|
181123 13:43:13 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fb029844ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000560efe2241cc in btr_node_ptr_max_size (index=0x7fafa02c3758) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:981
|
#9 0x0000560efe225399 in btr_cur_search_to_nth_level_func (index=0x7fafa02c3758, level=0, tuple=0x7fafa00ed460, mode=PAGE_CUR_LE, latch_mode=2, cursor=0x7fb01409f160, ahi_latch=0x0, file=0x560efe78b840 "/data/src/10.3/storage/innobase/row/row0ins.cc", line=2982, mtr=0x7fb01409fc70, autoinc=0) at /data/src/10.3/storage/innobase/btr/btr0cur.cc:1352
|
#10 0x0000560efe1035e2 in row_ins_sec_index_entry_low (flags=3, mode=2, index=0x7fafa02c3758, offsets_heap=0x7fafa03ec970, heap=0x7fafa022f980, entry=0x7fafa00ed460, trx_id=3106, thr=0x7fafa0337a50, dup_chk_only=false) at /data/src/10.3/storage/innobase/row/row0ins.cc:2982
|
#11 0x0000560efe1045df in row_ins_sec_index_entry (index=0x7fafa02c3758, entry=0x7fafa00ed460, thr=0x7fafa0337a50, dup_chk_only=false) at /data/src/10.3/storage/innobase/row/row0ins.cc:3334
|
#12 0x0000560efe1047b3 in row_ins_index_entry (index=0x7fafa02c3758, entry=0x7fafa00ed460, thr=0x7fafa0337a50) at /data/src/10.3/storage/innobase/row/row0ins.cc:3380
|
#13 0x0000560efe104d5a in row_ins_index_entry_step (node=0x7fafa0337090, thr=0x7fafa0337a50) at /data/src/10.3/storage/innobase/row/row0ins.cc:3528
|
#14 0x0000560efe105194 in row_ins (node=0x7fafa0337090, thr=0x7fafa0337a50) at /data/src/10.3/storage/innobase/row/row0ins.cc:3671
|
#15 0x0000560efe105999 in row_ins_step (thr=0x7fafa0337a50) at /data/src/10.3/storage/innobase/row/row0ins.cc:3916
|
#16 0x0000560efe126198 in row_insert_for_mysql (mysql_rec=0x7fafa032e618 "\375\377\377\375\357\377", prebuilt=0x7fafa0335f98, ins_mode=ROW_INS_NORMAL) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1459
|
#17 0x0000560efdfce9f8 in ha_innobase::write_row (this=0x7fafa02e0178, record=0x7fafa032e618 "\375\377\377\375\357\377") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8032
|
#18 0x0000560efdcb91a4 in handler::ha_write_row (this=0x7fafa02e0178, buf=0x7fafa032e618 "\375\377\377\375\357\377") at /data/src/10.3/sql/handler.cc:6237
|
#19 0x0000560efda9414d in copy_data_between_tables (thd=0x7fafa0000b00, from=0x7fafa03ed270, to=0x7fafa01f3f80, create=..., ignore=false, order_num=0, order=0x0, copied=0x7fb0140a12d0, deleted=0x7fb0140a12d8, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=0x7fb0140a20e0) at /data/src/10.3/sql/sql_table.cc:10446
|
#20 0x0000560efda9213e in mysql_alter_table (thd=0x7fafa0000b00, new_db=0x7fafa00051b8, new_name=0x7fafa0005578, create_info=0x7fb0140a2cd0, table_list=0x7fafa0014538, alter_info=0x7fb0140a2c10, order_num=0, order=0x0, ignore=false) at /data/src/10.3/sql/sql_table.cc:9883
|
#21 0x0000560efdb19447 in Sql_cmd_alter_table::execute (this=0x7fafa0014d38, thd=0x7fafa0000b00) at /data/src/10.3/sql/sql_alter.cc:497
|
#22 0x0000560efd9bb043 in mysql_execute_command (thd=0x7fafa0000b00) at /data/src/10.3/sql/sql_parse.cc:6283
|
#23 0x0000560efd9c0113 in mysql_parse (thd=0x7fafa0000b00, rawbuf=0x7fafa00142e8 "ALTER TABLE `table150_innodb_compressed_int` MODIFY `col_varchar_utf8_unique_default_null` CHAR( 0 ) NULL FIRST /* QNO 2417 CON_ID 18 */", length=136, parser_state=0x7fb0140a4640, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8090
|
#24 0x0000560efd9ad2d9 in dispatch_command (command=COM_QUERY, thd=0x7fafa0000b00, packet=0x7fafa000b1e1 "ALTER TABLE `table150_innodb_compressed_int` MODIFY `col_varchar_utf8_unique_default_null` CHAR( 0 ) NULL FIRST /* QNO 2417 CON_ID 18 */", packet_length=136, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1850
|
#25 0x0000560efd9abcfd in do_command (thd=0x7fafa0000b00) at /data/src/10.3/sql/sql_parse.cc:1395
|
#26 0x0000560efdb139d2 in do_handle_one_connection (connect=0x560f022beb80) at /data/src/10.3/sql/sql_connect.cc:1402
|
#27 0x0000560efdb13756 in handle_one_connection (arg=0x560f022beb80) at /data/src/10.3/sql/sql_connect.cc:1308
|
#28 0x00007fb02b300494 in start_thread (arg=0x7fb0140a5700) at pthread_create.c:333
|
#29 0x00007fb02990193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible on 10.1.
Transition |
Time In Source Status |
Execution Times |
Open |
|
In Progress |
|
18d 22h 58m
|
1
|
In Progress |
|
Closed |
|
50m 16s
|
1
|
{"report":{"fcp":1135.7000000476837,"ttfb":443.8000000715256,"pageVisibility":"visible","entityId":71023,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"810c9cd2-daca-46cb-8e20-4fadc5f97eae","navigationType":0,"readyForUser":1221.2000000476837,"redirectCount":0,"resourceLoadedEnd":1091.5,"resourceLoadedStart":449,"resourceTiming":[{"duration":116,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":449,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":449,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":565,"responseStart":0,"secureConnectionStart":0},{"duration":116,"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":449.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":449.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":565.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":171,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":449.5,"connectEnd":449.5,"connectStart":449.5,"domainLookupEnd":449.5,"domainLookupStart":449.5,"fetchStart":449.5,"redirectEnd":0,"redirectStart":0,"requestStart":566.1000000238419,"responseEnd":620.5,"responseStart":581.2000000476837,"secureConnectionStart":449.5},{"duration":191,"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":449.60000002384186,"connectEnd":449.60000002384186,"connectStart":449.60000002384186,"domainLookupEnd":449.60000002384186,"domainLookupStart":449.60000002384186,"fetchStart":449.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":566.7000000476837,"responseEnd":640.6000000238419,"responseStart":580.7000000476837,"secureConnectionStart":449.60000002384186},{"duration":129.89999997615814,"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":449.8000000715256,"connectEnd":449.8000000715256,"connectStart":449.8000000715256,"domainLookupEnd":449.8000000715256,"domainLookupStart":449.8000000715256,"fetchStart":449.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":568.3000000715256,"responseEnd":579.7000000476837,"responseStart":579.1000000238419,"secureConnectionStart":449.8000000715256},{"duration":134.40000009536743,"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":449.89999997615814,"connectEnd":449.89999997615814,"connectStart":449.89999997615814,"domainLookupEnd":449.89999997615814,"domainLookupStart":449.89999997615814,"fetchStart":449.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":570.2000000476837,"responseEnd":584.3000000715256,"responseStart":583.5,"secureConnectionStart":449.89999997615814},{"duration":152.89999997615814,"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":450.10000002384186,"connectEnd":450.10000002384186,"connectStart":450.10000002384186,"domainLookupEnd":450.10000002384186,"domainLookupStart":450.10000002384186,"fetchStart":450.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":573.5,"responseEnd":603,"responseStart":602.3000000715256,"secureConnectionStart":450.10000002384186},{"duration":124,"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":450.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":450.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":574.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":164.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":450.5,"connectEnd":450.5,"connectStart":450.5,"domainLookupEnd":450.5,"domainLookupStart":450.5,"fetchStart":450.5,"redirectEnd":0,"redirectStart":0,"requestStart":578.5,"responseEnd":615.2000000476837,"responseStart":613.6000000238419,"secureConnectionStart":450.5},{"duration":125.60000002384186,"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":450.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":450.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":576.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":158.09999990463257,"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":450.8000000715256,"connectEnd":593,"connectStart":593,"domainLookupEnd":593,"domainLookupStart":593,"fetchStart":450.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":593.5,"responseEnd":608.8999999761581,"responseStart":605.7000000476837,"secureConnectionStart":593},{"duration":516.2000000476837,"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":462.10000002384186,"connectEnd":462.10000002384186,"connectStart":462.10000002384186,"domainLookupEnd":462.10000002384186,"domainLookupStart":462.10000002384186,"fetchStart":462.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":810.3999999761581,"responseEnd":978.3000000715256,"responseStart":973.8999999761581,"secureConnectionStart":462.10000002384186},{"duration":629,"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":462.5,"connectEnd":462.5,"connectStart":462.5,"domainLookupEnd":462.5,"domainLookupStart":462.5,"fetchStart":462.5,"redirectEnd":0,"redirectStart":0,"requestStart":1080.3000000715256,"responseEnd":1091.5,"responseStart":1090.6000000238419,"secureConnectionStart":462.5},{"duration":241.60000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":866.7000000476837,"connectEnd":866.7000000476837,"connectStart":866.7000000476837,"domainLookupEnd":866.7000000476837,"domainLookupStart":866.7000000476837,"fetchStart":866.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1072,"responseEnd":1108.3000000715256,"responseStart":1107.6000000238419,"secureConnectionStart":866.7000000476837},{"duration":144.89999997615814,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1119.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1119.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1264.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":178,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1145.2000000476837,"connectEnd":1145.2000000476837,"connectStart":1145.2000000476837,"domainLookupEnd":1145.2000000476837,"domainLookupStart":1145.2000000476837,"fetchStart":1145.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1286.8999999761581,"responseEnd":1323.2000000476837,"responseStart":1322.5,"secureConnectionStart":1145.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":277,"responseStart":444,"responseEnd":462,"domLoading":448,"domInteractive":1288,"domContentLoadedEventStart":1288,"domContentLoadedEventEnd":1331,"domComplete":1937,"loadEventStart":1937,"loadEventEnd":1938,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1266.6000000238419},{"name":"bigPipe.sidebar-id.end","time":1267.3999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":1267.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1268.5},{"name":"activityTabFullyLoaded","time":1349.8999999761581}],"measures":[],"correlationId":"eaeb4ace09da62","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":101,"dbReadsTimeInMs":20,"dbConnsTimeInMs":29,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}