These sleeps, however crude, help to reproduce the problem (on my machine reliably):
diff --git a/storage/innobase/row/row0quiesce.cc b/storage/innobase/row/row0quiesce.cc
|
index dd6289c..e75137f 100644
|
--- a/storage/innobase/row/row0quiesce.cc
|
+++ b/storage/innobase/row/row0quiesce.cc
|
@@ -600,6 +600,7 @@ row_quiesce_table_complete(
|
|
os_file_delete_if_exists(innodb_data_file_key, cfg_name, NULL);
|
|
+ my_sleep(2000000);
|
ib::info() << "Deleting the meta-data file '" << cfg_name << "'";
|
}
|
|
diff --git a/storage/innobase/trx/trx0purge.cc b/storage/innobase/trx/trx0purge.cc
|
index 4e51796..45afd72 100644
|
--- a/storage/innobase/trx/trx0purge.cc
|
+++ b/storage/innobase/trx/trx0purge.cc
|
@@ -1783,6 +1783,7 @@ trx_purge_run(void)
|
{
|
rw_lock_x_lock(&purge_sys->latch);
|
|
+ my_sleep(1000000);
|
switch (purge_sys->state) {
|
case PURGE_STATE_INIT:
|
case PURGE_STATE_EXIT:
|
--source include/have_innodb.inc
|
CREATE OR REPLACE TABLE t1 (t TIMESTAMP) ENGINE=InnoDB;
|
FLUSH TABLE t1 FOR EXPORT;
|
shutdown;
|
10.2 0e69d0b094365 with the patch above
|
2017-12-13 3:10:50 139949094012672 [Note] InnoDB: Writing table metadata to './test/t1.cfg'
|
2017-12-13 3:10:50 139949094012672 [Note] InnoDB: Table `test`.`t1` flushed to disk
|
2017-12-13 3:10:50 139948960823040 [Note] /data/src/10.2-bug/sql/mysqld (root[root] @ localhost []): Normal shutdown
|
|
2017-12-13 3:10:50 139948841735936 [Note] InnoDB: FTS optimize thread exiting.
|
2017-12-13 3:10:50 139948960823040 [Note] Event Scheduler: Purging the queue. 0 events
|
2017-12-13 3:10:52 139949094012672 [Note] InnoDB: Deleting the meta-data file './test/t1.cfg'
|
2017-12-13 03:10:53 0x7f4870090700 InnoDB: Assertion failure in file /data/src/10.2-bug/storage/innobase/trx/trx0purge.cc line 1837
|
InnoDB: We intentionally generate a memory trap.
|
|
#5 0x00007f4875dbc3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x00005594dd7a7b88 in ut_dbg_assertion_failed (expr=0x0, file=0x5594ddc9a748 "/data/src/10.2-bug/storage/innobase/trx/trx0purge.cc", line=1837) at /data/src/10.2-bug/storage/innobase/ut/ut0dbg.cc:61
|
#7 0x00005594dd772f30 in trx_purge_run () at /data/src/10.2-bug/storage/innobase/trx/trx0purge.cc:1837
|
#8 0x00005594dd734762 in row_quiesce_table_complete (table=0x7f4818149778, trx=0x7f486bc000d8) at /data/src/10.2-bug/storage/innobase/row/row0quiesce.cc:608
|
#9 0x00005594dd5a7aa4 in ha_innobase::external_lock (this=0x7f4818131f88, thd=0x7f4818000b00, lock_type=2) at /data/src/10.2-bug/storage/innobase/handler/ha_innodb.cc:16324
|
#10 0x00005594dd28ecdc in handler::ha_external_lock (this=0x7f4818131f88, thd=0x7f4818000b00, lock_type=2) at /data/src/10.2-bug/sql/handler.cc:5903
|
#11 0x00005594dd399776 in unlock_external (thd=0x7f4818000b00, table=0x7f481816d628, count=1) at /data/src/10.2-bug/sql/lock.cc:719
|
#12 0x00005594dd398c4e in mysql_unlock_tables (thd=0x7f4818000b00, sql_lock=0x7f481816d610, free_lock=true) at /data/src/10.2-bug/sql/lock.cc:429
|
#13 0x00005594dd398bb9 in mysql_unlock_tables (thd=0x7f4818000b00, sql_lock=0x7f481816d610) at /data/src/10.2-bug/sql/lock.cc:418
|
#14 0x00005594dcf9c46b in close_thread_tables (thd=0x7f4818000b00) at /data/src/10.2-bug/sql/sql_base.cc:840
|
#15 0x00005594dcf9edf0 in Locked_tables_list::unlock_locked_tables (this=0x7f4818004510, thd=0x7f4818000b00) at /data/src/10.2-bug/sql/sql_base.cc:2154
|
#16 0x00005594dcfc61cd in THD::cleanup (this=0x7f4818000b00) at /data/src/10.2-bug/sql/sql_class.cc:1453
|
#17 0x00005594dcf30b25 in unlink_thd (thd=0x7f4818000b00) at /data/src/10.2-bug/sql/mysqld.cc:2904
|
#18 0x00005594dcf30fc6 in one_thread_per_connection_end (thd=0x7f4818000b00, put_in_cache=true) at /data/src/10.2-bug/sql/mysqld.cc:3049
|
#19 0x00005594dd15843a in do_handle_one_connection (connect=0x5594e07220c0) at /data/src/10.2-bug/sql/sql_connect.cc:1373
|
#20 0x00005594dd1580de in handle_one_connection (arg=0x5594e07220c0) at /data/src/10.2-bug/sql/sql_connect.cc:1260
|
#21 0x00005594dd576a76 in pfs_spawn_thread (arg=0x5594e072c630) at /data/src/10.2-bug/storage/perfschema/pfs.cc:1863
|
#22 0x00007f4877a8a494 in start_thread (arg=0x7f4870090700) at pthread_create.c:333
|
#23 0x00007f4875e7093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Also reproducible on 10.3.
{"report":{"fcp":906.3999996185303,"ttfb":141.89999961853027,"pageVisibility":"visible","entityId":64345,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"b9370e6c-d3e8-4a61-b87e-03f0e3d3c622","navigationType":0,"readyForUser":979.8999996185303,"redirectCount":0,"resourceLoadedEnd":845.3000001907349,"resourceLoadedStart":146.69999980926514,"resourceTiming":[{"duration":270.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":146.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":146.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":417.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":266.5,"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.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":151.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":417.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":284.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":151.39999961853027,"connectEnd":151.39999961853027,"connectStart":151.39999961853027,"domainLookupEnd":151.39999961853027,"domainLookupStart":151.39999961853027,"fetchStart":151.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":151.39999961853027,"responseEnd":435.5999994277954,"responseStart":435.5999994277954,"secureConnectionStart":151.39999961853027},{"duration":308.5,"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":152.0999994277954,"connectEnd":152.0999994277954,"connectStart":152.0999994277954,"domainLookupEnd":152.0999994277954,"domainLookupStart":152.0999994277954,"fetchStart":152.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":152.0999994277954,"responseEnd":460.5999994277954,"responseStart":460.5999994277954,"secureConnectionStart":152.0999994277954},{"duration":311.69999980926514,"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":152.19999980926514,"connectEnd":152.19999980926514,"connectStart":152.19999980926514,"domainLookupEnd":152.19999980926514,"domainLookupStart":152.19999980926514,"fetchStart":152.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":152.19999980926514,"responseEnd":463.8999996185303,"responseStart":463.80000019073486,"secureConnectionStart":152.19999980926514},{"duration":312.29999923706055,"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":152.30000019073486,"connectEnd":152.30000019073486,"connectStart":152.30000019073486,"domainLookupEnd":152.30000019073486,"domainLookupStart":152.30000019073486,"fetchStart":152.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":152.30000019073486,"responseEnd":464.5999994277954,"responseStart":464.5999994277954,"secureConnectionStart":152.30000019073486},{"duration":327.8999996185303,"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.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":480.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":312.8999996185303,"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":152.5,"connectEnd":152.5,"connectStart":152.5,"domainLookupEnd":152.5,"domainLookupStart":152.5,"fetchStart":152.5,"redirectEnd":0,"redirectStart":0,"requestStart":152.5,"responseEnd":465.3999996185303,"responseStart":465.3999996185303,"secureConnectionStart":152.5},{"duration":313.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":152.5999994277954,"connectEnd":152.5999994277954,"connectStart":152.5999994277954,"domainLookupEnd":152.5999994277954,"domainLookupStart":152.5999994277954,"fetchStart":152.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":152.5999994277954,"responseEnd":465.8999996185303,"responseStart":465.8999996185303,"secureConnectionStart":152.5999994277954},{"duration":328,"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.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":152.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":480.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":313.8999996185303,"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.80000019073486,"connectEnd":152.80000019073486,"connectStart":152.80000019073486,"domainLookupEnd":152.80000019073486,"domainLookupStart":152.80000019073486,"fetchStart":152.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":152.80000019073486,"responseEnd":466.69999980926514,"responseStart":466.69999980926514,"secureConnectionStart":152.80000019073486},{"duration":402.0999994277954,"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":154.5,"connectEnd":154.5,"connectStart":154.5,"domainLookupEnd":154.5,"domainLookupStart":154.5,"fetchStart":154.5,"redirectEnd":0,"redirectStart":0,"requestStart":154.5,"responseEnd":556.5999994277954,"responseStart":556.5,"secureConnectionStart":154.5},{"duration":690.7000007629395,"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":154.5999994277954,"connectEnd":154.5999994277954,"connectStart":154.5999994277954,"domainLookupEnd":154.5999994277954,"domainLookupStart":154.5999994277954,"fetchStart":154.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":154.5999994277954,"responseEnd":845.3000001907349,"responseStart":845.3000001907349,"secureConnectionStart":154.5999994277954}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":4,"responseStart":142,"responseEnd":155,"domLoading":145,"domInteractive":1040,"domContentLoadedEventStart":1040,"domContentLoadedEventEnd":1072,"domComplete":2281,"loadEventStart":2281,"loadEventEnd":2283,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1021.3999996185303},{"name":"bigPipe.sidebar-id.end","time":1022.0999994277954},{"name":"bigPipe.activity-panel-pipe-id.start","time":1022.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1024.5999994277954},{"name":"activityTabFullyLoaded","time":1079}],"measures":[],"correlationId":"e34cd081032849","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":80,"dbReadsTimeInMs":12,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}