Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.5
--source include/have_innodb.inc
CREATE TABLE t1 (pk INT , a DATE DEFAULT '0000-00-00' , PRIMARY KEY (pk), UNIQUE (a)) ENGINE=InnoDB;
INSERT INTO t1 (pk) VALUES (1);
ALTER TABLE t1 ADD COLUMN b INT ;
REPLACE INTO t1 (pk) VALUES (2),(3),(2);
# Cleanup
DROP TABLE t1;
10.5 5874aac7
mysqld: /data/src/10.5/storage/innobase/btr/btr0cur.cc:4139: void btr_cur_upd_rec_in_place(rec_t*, const dict_index_t*, const offset_t*, const upd_t*, buf_block_t*, mtr_t*): Assertion `!rec_offs_nth_sql_null(offsets, n)' failed.
200217 4:12:30 [ERROR] mysqld got signal 6 ;
#7 0x00007fe11c1d2f12 in __GI___assert_fail (assertion=0x559445daa018 "!rec_offs_nth_sql_null(offsets, n)", file=0x559445da82b0 "/data/src/10.5/storage/innobase/btr/btr0cur.cc", line=4139, function=0x559445daf3a0 <btr_cur_upd_rec_in_place(unsigned char*, dict_index_t const*, unsigned short const*, upd_t const*, buf_block_t*, mtr_t*)::__PRETTY_FUNCTION__> "void btr_cur_upd_rec_in_place(rec_t*, const dict_index_t*, const offset_t*, const upd_t*, buf_block_t*, mtr_t*)") at assert.c:101
#8 0x000055944571b007 in btr_cur_upd_rec_in_place (rec=0x7fe115d200b0 "\200", index=0x7fe0dc19f7f0, offsets=0x7fe115565390, update=0x7fe0dc09a740, block=0x7fe11582cde0, mtr=0x7fe1155655f0) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:4139
#9 0x000055944571c276 in btr_cur_update_in_place (flags=0, cursor=0x7fe115565290, offsets=0x7fe115565390, update=0x7fe0dc09a740, cmpl_info=0, thr=0x7fe0dc068518, trx_id=36, mtr=0x7fe1155655f0) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:4315
#10 0x000055944571dd47 in btr_cur_optimistic_update (flags=0, cursor=0x7fe115565290, offsets=0x7fe115565228, heap=0x7fe115565220, update=0x7fe0dc09a740, cmpl_info=0, thr=0x7fe0dc068518, trx_id=36, mtr=0x7fe1155655f0) at /data/src/10.5/storage/innobase/btr/btr0cur.cc:4559
#11 0x00005594455c94c9 in row_ins_clust_index_entry_by_modify (pcur=0x7fe115565290, flags=0, mode=2, offsets=0x7fe115565228, offsets_heap=0x7fe115565220, heap=0x7fe0dc09a6c0, entry=0x7fe0dc09a2d0, thr=0x7fe0dc068518, mtr=0x7fe1155655f0) at /data/src/10.5/storage/innobase/row/row0ins.cc:365
#12 0x00005594455cff33 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7fe0dc19f7f0, n_uniq=1, entry=0x7fe0dc09a2d0, n_ext=0, thr=0x7fe0dc068518) at /data/src/10.5/storage/innobase/row/row0ins.cc:2743
#13 0x00005594455d1955 in row_ins_clust_index_entry (index=0x7fe0dc19f7f0, entry=0x7fe0dc09a2d0, thr=0x7fe0dc068518, n_ext=0) at /data/src/10.5/storage/innobase/row/row0ins.cc:3236
#14 0x0000559445656da8 in row_upd_clust_rec_by_insert (node=0x7fe0dc0681e0, index=0x7fe0dc19f7f0, thr=0x7fe0dc068518, referenced=0, foreign=false, mtr=0x7fe1155662b0) at /data/src/10.5/storage/innobase/row/row0upd.cc:2510
#15 0x00005594456584f7 in row_upd_clust_step (node=0x7fe0dc0681e0, thr=0x7fe0dc068518) at /data/src/10.5/storage/innobase/row/row0upd.cc:2928
#16 0x00005594456588dd in row_upd (node=0x7fe0dc0681e0, thr=0x7fe0dc068518) at /data/src/10.5/storage/innobase/row/row0upd.cc:3002
#17 0x0000559445658ea3 in row_upd_step (thr=0x7fe0dc068518) at /data/src/10.5/storage/innobase/row/row0upd.cc:3146
#18 0x00005594455f8eb3 in row_update_for_mysql (prebuilt=0x7fe0dc0676b0) at /data/src/10.5/storage/innobase/row/row0mysql.cc:1889
#19 0x000055944545224e in ha_innobase::update_row (this=0x7fe0dc00a658, old_row=0x7fe0dc19ee30 "\245\003", new_row=0x7fe0dc19ee20 "\375\002") at /data/src/10.5/storage/innobase/handler/ha_innodb.cc:8569
#20 0x000055944504747b in handler::ha_update_row (this=0x7fe0dc00a658, old_data=0x7fe0dc19ee30 "\245\003", new_data=0x7fe0dc19ee20 "\375\002") at /data/src/10.5/sql/handler.cc:6702
#21 0x0000559444ca2079 in write_record (thd=0x7fe0dc000b00, table=0x7fe0dc06a2a0, info=0x7fe115566c60, sink=0x0) at /data/src/10.5/sql/sql_insert.cc:1976
#22 0x0000559444c9f402 in mysql_insert (thd=0x7fe0dc000b00, table_list=0x7fe0dc0135a0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false, result=0x0) at /data/src/10.5/sql/sql_insert.cc:1081
#23 0x0000559444cf0543 in mysql_execute_command (thd=0x7fe0dc000b00) at /data/src/10.5/sql/sql_parse.cc:4505
#24 0x0000559444cfc45c in mysql_parse (thd=0x7fe0dc000b00, rawbuf=0x7fe0dc0134a8 "REPLACE INTO t1 (pk) VALUES (2),(3),(2)", length=39, parser_state=0x7fe115567570, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7918
#25 0x0000559444ce8105 in dispatch_command (command=COM_QUERY, thd=0x7fe0dc000b00, packet=0x7fe0dc158111 "REPLACE INTO t1 (pk) VALUES (2),(3),(2)", packet_length=39, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1845
#26 0x0000559444ce684c in do_command (thd=0x7fe0dc000b00) at /data/src/10.5/sql/sql_parse.cc:1364
#27 0x0000559444e869a9 in do_handle_one_connection (connect=0x559449149c30, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1422
#28 0x0000559444e866d8 in handle_one_connection (arg=0x559449149c30) at /data/src/10.5/sql/sql_connect.cc:1319
#29 0x00005594453e3183 in pfs_spawn_thread (arg=0x5594490cb650) at /data/src/10.5/storage/perfschema/pfs.cc:1869
#30 0x00007fe11e15b4a4 in start_thread (arg=0x7fe115568700) at pthread_create.c:456
#31 0x00007fe11c28fd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
Appeared recently, I didn't bisect for the exact revision.
is caused by
MDEV-12353
Efficient InnoDB redo log record format
Closed
{"report":{"fcp":1173,"ttfb":278,"pageVisibility":"visible","entityId":83290,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c4e1a00e-c59c-4b32-8ed1-9f56af6dfe4c","navigationType":0,"readyForUser":1255.800000011921,"redirectCount":0,"resourceLoadedEnd":1372.9000000059605,"resourceLoadedStart":283,"resourceTiming":[{"duration":234,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":283,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":283,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":517,"responseStart":0,"secureConnectionStart":0},{"duration":234,"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":283.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":283.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":517.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":276.40000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":283.5,"connectEnd":283.5,"connectStart":283.5,"domainLookupEnd":283.5,"domainLookupStart":283.5,"fetchStart":283.5,"redirectEnd":0,"redirectStart":0,"requestStart":283.5,"responseEnd":559.9000000059605,"responseStart":559.8000000119209,"secureConnectionStart":283.5},{"duration":575.2999999970198,"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":283.70000000298023,"connectEnd":283.70000000298023,"connectStart":283.70000000298023,"domainLookupEnd":283.70000000298023,"domainLookupStart":283.70000000298023,"fetchStart":283.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":283.70000000298023,"responseEnd":859,"responseStart":858.9000000059605,"secureConnectionStart":283.70000000298023},{"duration":579,"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":283.90000000596046,"connectEnd":283.90000000596046,"connectStart":283.90000000596046,"domainLookupEnd":283.90000000596046,"domainLookupStart":283.90000000596046,"fetchStart":283.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":283.90000000596046,"responseEnd":862.9000000059605,"responseStart":862.9000000059605,"secureConnectionStart":283.90000000596046},{"duration":579.6000000089407,"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":284,"connectEnd":284,"connectStart":284,"domainLookupEnd":284,"domainLookupStart":284,"fetchStart":284,"redirectEnd":0,"redirectStart":0,"requestStart":284,"responseEnd":863.6000000089407,"responseStart":863.6000000089407,"secureConnectionStart":284},{"duration":579.9000000059605,"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":284.20000000298023,"connectEnd":284.20000000298023,"connectStart":284.20000000298023,"domainLookupEnd":284.20000000298023,"domainLookupStart":284.20000000298023,"fetchStart":284.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":284.20000000298023,"responseEnd":864.1000000089407,"responseStart":864.1000000089407,"secureConnectionStart":284.20000000298023},{"duration":580.4000000059605,"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":284.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":864.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":580.2000000029802,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":284.5,"connectEnd":284.5,"connectStart":284.5,"domainLookupEnd":284.5,"domainLookupStart":284.5,"fetchStart":284.5,"redirectEnd":0,"redirectStart":0,"requestStart":284.5,"responseEnd":864.7000000029802,"responseStart":864.7000000029802,"secureConnectionStart":284.5},{"duration":580.5999999940395,"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":284.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":284.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":865.4000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":580.5,"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":284.90000000596046,"connectEnd":284.90000000596046,"connectStart":284.90000000596046,"domainLookupEnd":284.90000000596046,"domainLookupStart":284.90000000596046,"fetchStart":284.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":284.90000000596046,"responseEnd":865.4000000059605,"responseStart":865.4000000059605,"secureConnectionStart":284.90000000596046},{"duration":874.8999999910593,"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":290.6000000089407,"connectEnd":290.6000000089407,"connectStart":290.6000000089407,"domainLookupEnd":290.6000000089407,"domainLookupStart":290.6000000089407,"fetchStart":290.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":290.6000000089407,"responseEnd":1165.5,"responseStart":1165.5,"secureConnectionStart":290.6000000089407},{"duration":1069.9000000059605,"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":292,"connectEnd":292,"connectStart":292,"domainLookupEnd":292,"domainLookupStart":292,"fetchStart":292,"redirectEnd":0,"redirectStart":0,"requestStart":292,"responseEnd":1361.9000000059605,"responseStart":1361.9000000059605,"secureConnectionStart":292},{"duration":302.20000000298023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":705,"connectEnd":705,"connectStart":705,"domainLookupEnd":705,"domainLookupStart":705,"fetchStart":705,"redirectEnd":0,"redirectStart":0,"requestStart":705,"responseEnd":1007.2000000029802,"responseStart":1007.2000000029802,"secureConnectionStart":705},{"duration":235.29999999701977,"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":1126.6000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1126.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1361.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":235.3999999910593,"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":1127.6000000089407,"connectEnd":1127.6000000089407,"connectStart":1127.6000000089407,"domainLookupEnd":1127.6000000089407,"domainLookupStart":1127.6000000089407,"fetchStart":1127.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":1127.6000000089407,"responseEnd":1363,"responseStart":1363,"secureConnectionStart":1127.6000000089407},{"duration":250.79999999701977,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1166.1000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1166.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1416.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":245,"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":1127.9000000059605,"connectEnd":1127.9000000059605,"connectStart":1127.9000000059605,"domainLookupEnd":1127.9000000059605,"domainLookupStart":1127.9000000059605,"fetchStart":1127.9000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":1127.9000000059605,"responseEnd":1372.9000000059605,"responseStart":1372.9000000059605,"secureConnectionStart":1127.9000000059605}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":105,"responseStart":278,"responseEnd":292,"domLoading":281,"domInteractive":1424,"domContentLoadedEventStart":1424,"domContentLoadedEventEnd":1464,"domComplete":2662,"loadEventStart":2662,"loadEventEnd":2663,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1368.4000000059605},{"name":"bigPipe.sidebar-id.end","time":1369.2000000029802},{"name":"bigPipe.activity-panel-pipe-id.start","time":1369.300000011921},{"name":"bigPipe.activity-panel-pipe-id.end","time":1371.6000000089407},{"name":"activityTabFullyLoaded","time":1476.6000000089407}],"measures":[],"correlationId":"750d4967ca114b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":91,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}