This issue was first found during the development of MDEV-12894 . As mentioned in MDEV-13900 , a part of innodb.instant_alter test would crash when the test is run with special parameters. With these parameters, MDEV-12894 is adding a hidden column to the PRIMARY KEY and converting certain UPDATE to UPDATE and INSERT .
The test below reproduces the problem in plain MariaDB 10.3 when system versioning is not used.
--source include/have_innodb.inc
CREATE TABLE t2
(id INT , foo INT DEFAULT 0, c1 VARCHAR (4000),
p GEOMETRY NOT NULL DEFAULT ST_GeomFromText( 'LINESTRING(0 0,0 1,1 1)' ),
PRIMARY KEY (id,foo))
ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
INSERT INTO t2 (id,c1) VALUES (1, REPEAT( 'a' , 4000)), (2, REPEAT( 'a' , 4000));
ALTER TABLE t2 ADD COLUMN d1 INT ;
BEGIN ;
UPDATE t2 SET c1 = repeat( '1' , 4000), foo=1 WHERE id=1;
INSERT INTO t2 (id,c1) VALUES (1, REPEAT( 'a' , 4000));
UPDATE t2 SET c1 = repeat( '2' , 4000), foo=1 WHERE id=2;
ROLLBACK ;
BEGIN ;
UPDATE t2 SET d1 = 1,foo=2 WHERE id=1;
INSERT INTO t2 (id,foo,c1) VALUES (1, 1, REPEAT( '1' , 4000));
COMMIT ;
DROP TABLE t2;
The last INSERT that crashes must for some reason be in the same transaction as the UPDATE . I have optimized away an INSERT from the first (rolled-back) transaction, because the crash reproduces also without it:
stack trace
lock/lock0lock.cc:3836(lock_move_rec_list_start(buf_block_t const*, buf_block_t const*, unsigned char const*, unsigned char const*))[0x1c98ce3]
page/page0page.cc:940(page_copy_rec_list_start(buf_block_t*, buf_block_t*, unsigned char*, dict_index_t*, mtr_t*))[0x1d99991]
page/page0page.cc:1402(page_move_rec_list_start(buf_block_t*, buf_block_t*, unsigned char*, dict_index_t*, mtr_t*))[0x1d9c9f5]
btr/btr0btr.cc:3165(btr_page_split_and_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t const*, unsigned long, mtr_t*))[0x21a523d]
btr/btr0cur.cc:3463(btr_cur_pessimistic_insert(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, dtuple_t*, unsigned char**, big_rec_t**, unsigned long, que_thr_t*, mtr_t*))[0x21fec97]
Marko Mäkelä
made changes -
2017-12-15 10:59
Status
Open
[ 1
]
Confirmed
[ 10101
]
Marko Mäkelä
made changes -
2017-12-15 10:59
Status
Confirmed
[ 10101
]
In Progress
[ 3
]
Marko Mäkelä
made changes -
2017-12-15 12:22
issue.field.resolutiondate
2017-12-15 12:22:41.0
2017-12-15 12:22:41.276
Marko Mäkelä
made changes -
2017-12-15 12:22
Fix Version/s
10.3.3
[ 22644
]
Fix Version/s
10.3
[ 22126
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:46
Workflow
MariaDB v3
[ 84442
]
MariaDB v4
[ 153358
]
{"report":{"fcp":1458.1000003814697,"ttfb":317.5,"pageVisibility":"visible","entityId":64840,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"5e163a9a-1e8e-4edf-8149-54290fb464dc","navigationType":0,"readyForUser":1566,"redirectCount":0,"resourceLoadedEnd":1606.1000003814697,"resourceLoadedStart":326.30000019073486,"resourceTiming":[{"duration":263.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":326.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":326.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":589.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":263.3999996185303,"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":326.6000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":326.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":590,"responseStart":0,"secureConnectionStart":0},{"duration":579.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":326.80000019073486,"connectEnd":326.80000019073486,"connectStart":326.80000019073486,"domainLookupEnd":326.80000019073486,"domainLookupStart":326.80000019073486,"fetchStart":326.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":326.80000019073486,"responseEnd":906.6999998092651,"responseStart":906.6999998092651,"secureConnectionStart":326.80000019073486},{"duration":728.1999998092651,"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":327,"connectEnd":327,"connectStart":327,"domainLookupEnd":327,"domainLookupStart":327,"fetchStart":327,"redirectEnd":0,"redirectStart":0,"requestStart":327,"responseEnd":1055.1999998092651,"responseStart":1055.1999998092651,"secureConnectionStart":327},{"duration":732,"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":327.19999980926514,"connectEnd":327.19999980926514,"connectStart":327.19999980926514,"domainLookupEnd":327.19999980926514,"domainLookupStart":327.19999980926514,"fetchStart":327.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":327.19999980926514,"responseEnd":1059.1999998092651,"responseStart":1059.1999998092651,"secureConnectionStart":327.19999980926514},{"duration":732.2999992370605,"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":327.4000005722046,"connectEnd":327.4000005722046,"connectStart":327.4000005722046,"domainLookupEnd":327.4000005722046,"domainLookupStart":327.4000005722046,"fetchStart":327.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":327.4000005722046,"responseEnd":1059.6999998092651,"responseStart":1059.6999998092651,"secureConnectionStart":327.4000005722046},{"duration":732.6000003814697,"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":327.5,"connectEnd":327.5,"connectStart":327.5,"domainLookupEnd":327.5,"domainLookupStart":327.5,"fetchStart":327.5,"redirectEnd":0,"redirectStart":0,"requestStart":327.5,"responseEnd":1060.1000003814697,"responseStart":1060.1000003814697,"secureConnectionStart":327.5},{"duration":733.9000005722046,"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":327.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":327.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1061.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":732.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":327.9000005722046,"connectEnd":327.9000005722046,"connectStart":327.9000005722046,"domainLookupEnd":327.9000005722046,"domainLookupStart":327.9000005722046,"fetchStart":327.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":327.9000005722046,"responseEnd":1060.5,"responseStart":1060.5,"secureConnectionStart":327.9000005722046},{"duration":733.5999994277954,"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":328.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":328.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1061.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":732.6999998092651,"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":328.30000019073486,"connectEnd":328.30000019073486,"connectStart":328.30000019073486,"domainLookupEnd":328.30000019073486,"domainLookupStart":328.30000019073486,"fetchStart":328.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":328.30000019073486,"responseEnd":1061,"responseStart":1061,"secureConnectionStart":328.30000019073486},{"duration":914.5,"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":334.5,"connectEnd":334.5,"connectStart":334.5,"domainLookupEnd":334.5,"domainLookupStart":334.5,"fetchStart":334.5,"redirectEnd":0,"redirectStart":0,"requestStart":334.5,"responseEnd":1249,"responseStart":1249,"secureConnectionStart":334.5},{"duration":1247.5,"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":343.1000003814697,"connectEnd":343.1000003814697,"connectStart":343.1000003814697,"domainLookupEnd":343.1000003814697,"domainLookupStart":343.1000003814697,"fetchStart":343.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":343.1000003814697,"responseEnd":1590.6000003814697,"responseStart":1590.6000003814697,"secureConnectionStart":343.1000003814697},{"duration":191.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1057.1999998092651,"connectEnd":1057.1999998092651,"connectStart":1057.1999998092651,"domainLookupEnd":1057.1999998092651,"domainLookupStart":1057.1999998092651,"fetchStart":1057.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1057.1999998092651,"responseEnd":1248.5,"responseStart":1248.5,"secureConnectionStart":1057.1999998092651},{"duration":257.69999980926514,"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":1348.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1348.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1606.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":314.3999996185303,"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":1349.3000001907349,"connectEnd":1349.3000001907349,"connectStart":1349.3000001907349,"domainLookupEnd":1349.3000001907349,"domainLookupStart":1349.3000001907349,"fetchStart":1349.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1349.3000001907349,"responseEnd":1663.6999998092651,"responseStart":1663.6999998092651,"secureConnectionStart":1349.3000001907349},{"duration":335.20000076293945,"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":1349.6999998092651,"connectEnd":1349.6999998092651,"connectStart":1349.6999998092651,"domainLookupEnd":1349.6999998092651,"domainLookupStart":1349.6999998092651,"fetchStart":1349.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1349.6999998092651,"responseEnd":1684.9000005722046,"responseStart":1684.9000005722046,"secureConnectionStart":1349.6999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":120,"responseStart":318,"responseEnd":343,"domLoading":325,"domInteractive":1635,"domContentLoadedEventStart":1635,"domContentLoadedEventEnd":1686,"domComplete":2184,"loadEventStart":2184,"loadEventEnd":2185,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1618.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1619.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1619.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1622.3000001907349},{"name":"activityTabFullyLoaded","time":1715.6000003814697}],"measures":[],"correlationId":"1297773ec4d752","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":119,"dbReadsTimeInMs":19,"dbConnsTimeInMs":27,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}