--source include/have_innodb.inc
|
|
CREATE TABLE t1 (f1 INT, f2 INT, f3 INT, f4 VARCHAR(8)) ENGINE=InnoDB;
|
INSERT INTO t1 VALUES (1,2,3,'foo');
|
ALTER TABLE t1 ADD PRIMARY KEY (f2);
|
ALTER TABLE t1 DROP PRIMARY KEY;
|
ALTER TABLE t1 ADD PRIMARY KEY (f1);
|
ALTER TABLE t1 DROP PRIMARY KEY;
|
ALTER TABLE t1 ADD PRIMARY KEY (f4,f3);
|
ALTER TABLE t1 ADD COLUMN f5 INT;
|
UPDATE t1 SET f5 = f3;
|
UPDATE t1 SET f5 = f1;
|
|
# Cleanup
|
DROP TABLE t1;
|
10.3
|
mysqld: /data/src/10.3/storage/innobase/btr/btr0pcur.cc:313: ulint btr_pcur_restore_position_func(ulint, btr_pcur_t*, const char*, unsigned int, mtr_t*): Assertion `!cmp_rec_rec(cursor->old_rec, rec, offsets1, offsets2, index)' failed.
|
180501 2:06:46 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f1ee626cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055a998b0c68b in btr_pcur_restore_position_func (latch_mode=2, cursor=0x7f1e8400dbc0, file=0x55a999069138 "/data/src/10.3/storage/innobase/row/row0upd.cc", line=3094, mtr=0x7f1edb59c790) at /data/src/10.3/storage/innobase/btr/btr0pcur.cc:311
|
#9 0x000055a998a52ace in row_upd_clust_step (node=0x7f1e84048238, thr=0x7f1e840485d0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3094
|
#10 0x000055a998a53392 in row_upd (node=0x7f1e84048238, thr=0x7f1e840485d0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3280
|
#11 0x000055a998a53881 in row_upd_step (thr=0x7f1e840485d0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3424
|
#12 0x000055a9989f03b6 in row_update_for_mysql (prebuilt=0x7f1e840479d8) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1882
|
#13 0x000055a99889c53a in ha_innobase::update_row (this=0x7f1e84178728, old_row=0x7f1e84045188 "\376\001", new_row=0x7f1e84045168 "\376\001") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8894
|
#14 0x000055a998589936 in handler::ha_update_row (this=0x7f1e84178728, old_data=0x7f1e84045188 "\376\001", new_data=0x7f1e84045168 "\376\001") at /data/src/10.3/sql/handler.cc:6216
|
#15 0x000055a998390907 in mysql_update (thd=0x7f1e84000b00, table_list=0x7f1e84014e40, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f1edb59d6d0, updated_return=0x7f1edb59d790) at /data/src/10.3/sql/sql_update.cc:943
|
#16 0x000055a99829bca6 in mysql_execute_command (thd=0x7f1e84000b00) at /data/src/10.3/sql/sql_parse.cc:4578
|
#17 0x000055a9982a6a46 in mysql_parse (thd=0x7f1e84000b00, rawbuf=0x7f1e84014d68 "UPDATE t1 SET f5 = f1", length=21, parser_state=0x7f1edb59e5d0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:8001
|
#18 0x000055a998294229 in dispatch_command (command=COM_QUERY, thd=0x7f1e84000b00, packet=0x7f1e84125f41 "UPDATE t1 SET f5 = f1", packet_length=21, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1846
|
#19 0x000055a998292c68 in do_command (thd=0x7f1e84000b00) at /data/src/10.3/sql/sql_parse.cc:1391
|
#20 0x000055a9983f5aef in do_handle_one_connection (connect=0x55a99a9b8600) at /data/src/10.3/sql/sql_connect.cc:1402
|
#21 0x000055a9983f587c in handle_one_connection (arg=0x55a99a9b8600) at /data/src/10.3/sql/sql_connect.cc:1308
|
#22 0x000055a998879a8d in pfs_spawn_thread (arg=0x55a99aa598c0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#23 0x00007f1ee7f43494 in start_thread (arg=0x7f1edb59f700) at pthread_create.c:333
|
#24 0x00007f1ee632993f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
It appears to be a regression from this commit
commit cb16bc95ff9a7b4ce0835acf8fa6d6a06ad10c3c
|
Author: Marko Mäkelä <marko.makela@mariadb.com>
|
Date: Mon Apr 30 11:25:36 2018 +0300
|
|
MDEV-14906 Assertion index->is_instant() failed on DELETE
|
- is caused by
-
MDEV-14906
Assertion `index->is_instant()' failed in rec_init_offsets_comp_ordinary upon DELETE from table
-
-
Closed
{"report":{"fcp":789.4000000953674,"ttfb":146.09999990463257,"pageVisibility":"visible","entityId":67154,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"d319ace9-e0d6-4c06-96a7-5183b962098d","navigationType":0,"readyForUser":860.9000000953674,"redirectCount":0,"resourceLoadedEnd":681.7000000476837,"resourceLoadedStart":151.09999990463257,"resourceTiming":[{"duration":173,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":151.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":151.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":324.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":172.69999980926514,"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":151.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":151.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":324.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":183.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":151.5,"connectEnd":151.5,"connectStart":151.5,"domainLookupEnd":151.5,"domainLookupStart":151.5,"fetchStart":151.5,"redirectEnd":0,"redirectStart":0,"requestStart":151.5,"responseEnd":334.90000009536743,"responseStart":334.7999999523163,"secureConnectionStart":151.5},{"duration":244.60000014305115,"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":151.59999990463257,"connectEnd":151.59999990463257,"connectStart":151.59999990463257,"domainLookupEnd":151.59999990463257,"domainLookupStart":151.59999990463257,"fetchStart":151.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":151.59999990463257,"responseEnd":396.2000000476837,"responseStart":396.2000000476837,"secureConnectionStart":151.59999990463257},{"duration":248,"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":151.70000004768372,"connectEnd":151.70000004768372,"connectStart":151.70000004768372,"domainLookupEnd":151.70000004768372,"domainLookupStart":151.70000004768372,"fetchStart":151.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":151.70000004768372,"responseEnd":399.7000000476837,"responseStart":399.7000000476837,"secureConnectionStart":151.70000004768372},{"duration":248.40000009536743,"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":151.79999995231628,"connectEnd":151.79999995231628,"connectStart":151.79999995231628,"domainLookupEnd":151.79999995231628,"domainLookupStart":151.79999995231628,"fetchStart":151.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":151.79999995231628,"responseEnd":400.2000000476837,"responseStart":400.2000000476837,"secureConnectionStart":151.79999995231628},{"duration":248.59999990463257,"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":151.90000009536743,"connectEnd":151.90000009536743,"connectStart":151.90000009536743,"domainLookupEnd":151.90000009536743,"domainLookupStart":151.90000009536743,"fetchStart":151.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":151.90000009536743,"responseEnd":400.5,"responseStart":400.5,"secureConnectionStart":151.90000009536743},{"duration":249,"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":152,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":401,"responseStart":0,"secureConnectionStart":0},{"duration":248.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":152.09999990463257,"connectEnd":152.09999990463257,"connectStart":152.09999990463257,"domainLookupEnd":152.09999990463257,"domainLookupStart":152.09999990463257,"fetchStart":152.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":152.09999990463257,"responseEnd":401,"responseStart":401,"secureConnectionStart":152.09999990463257},{"duration":249,"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":152.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":401.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":249,"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":152.40000009536743,"connectEnd":152.40000009536743,"connectStart":152.40000009536743,"domainLookupEnd":152.40000009536743,"domainLookupStart":152.40000009536743,"fetchStart":152.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":152.40000009536743,"responseEnd":401.40000009536743,"responseStart":401.40000009536743,"secureConnectionStart":152.40000009536743},{"duration":462.5,"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":153.09999990463257,"connectEnd":153.09999990463257,"connectStart":153.09999990463257,"domainLookupEnd":153.09999990463257,"domainLookupStart":153.09999990463257,"fetchStart":153.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":153.09999990463257,"responseEnd":615.5999999046326,"responseStart":615.5999999046326,"secureConnectionStart":153.09999990463257},{"duration":528.5,"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":153.20000004768372,"connectEnd":153.20000004768372,"connectStart":153.20000004768372,"domainLookupEnd":153.20000004768372,"domainLookupStart":153.20000004768372,"fetchStart":153.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":153.20000004768372,"responseEnd":681.7000000476837,"responseStart":681.7000000476837,"secureConnectionStart":153.20000004768372},{"duration":115.39999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":544.9000000953674,"connectEnd":544.9000000953674,"connectStart":544.9000000953674,"domainLookupEnd":544.9000000953674,"domainLookupStart":544.9000000953674,"fetchStart":544.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":544.9000000953674,"responseEnd":660.2999999523163,"responseStart":660.2999999523163,"secureConnectionStart":544.9000000953674},{"duration":181.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/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":737.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":737.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":919.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":180.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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":738.7000000476837,"connectEnd":738.7000000476837,"connectStart":738.7000000476837,"domainLookupEnd":738.7000000476837,"domainLookupStart":738.7000000476837,"fetchStart":738.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":738.7000000476837,"responseEnd":919.5999999046326,"responseStart":919.5999999046326,"secureConnectionStart":738.7000000476837},{"duration":185,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/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":739,"connectEnd":739,"connectStart":739,"domainLookupEnd":739,"domainLookupStart":739,"fetchStart":739,"redirectEnd":0,"redirectStart":0,"requestStart":739,"responseEnd":924,"responseStart":924,"secureConnectionStart":739}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":24,"responseStart":146,"responseEnd":148,"domLoading":149,"domInteractive":919,"domContentLoadedEventStart":919,"domContentLoadedEventEnd":956,"domComplete":1703,"loadEventStart":1703,"loadEventEnd":1704,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":900},{"name":"bigPipe.sidebar-id.end","time":900.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":900.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":903.0999999046326},{"name":"activityTabFullyLoaded","time":969.2000000476837}],"measures":[],"correlationId":"a5437517abfc70","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":64,"dbReadsTimeInMs":10,"dbConnsTimeInMs":15,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}