In a recent test run on 10.6, we got an assertion failure on shutdown:
10.6 e6a06113880fe3842fe7068d42bcae8bb02ab024
|
Thread 1 received signal SIGUSR1, User defined signal 1.
|
0x0000000070000002 in syscall_traced ()
|
(rr) c
|
Continuing.
|
2022-01-13 12:10:28 0 [Note] /data/Server_bin/10.6M_asan/bin/mysqld (initiated by: root[root] @ localhost [127.0.0.1]): Normal shutdown
|
2022-01-13 12:10:28 0 [Warning] Aborted connection 80 to db: 'mysql' user: 'root' host: 'localhost' (KILLED)
|
2022-01-13 12:10:28 0 [Warning] Aborted connection 15 to db: 'mysql' user: 'root' host: 'localhost' (KILLED)
|
2022-01-13 12:10:28 15 [Warning] Aborted connection 15 to db: 'mysql' user: 'root' host: 'localhost' (This connection closed normally)
|
2022-01-13 12:10:29 80 [Warning] Aborted connection 80 to db: 'mysql' user: 'root' host: 'localhost' (This connection closed normally)
|
2022-01-13 12:10:29 0 [Note] InnoDB: FTS optimize thread exiting.
|
2022-01-13 12:10:29 0 [Note] InnoDB: Starting shutdown...
|
2022-01-13 12:10:29 0 [Note] InnoDB: Dumping buffer pool(s) to /data/rqg/1642089155/22/1/data/ib_buffer_pool
|
2022-01-13 12:10:29 0 [Note] InnoDB: Buffer pool(s) dump completed at 220113 12:10:29
|
mysqld: /data/Server/10.6M/storage/innobase/btr/btr0sea.cc:942: void buf_pool_t::clear_hash_index(): Assertion `s >= buf_page_t::UNFIXED || s == buf_page_t::REMOVE_HASH' failed.
|
[New Thread 95798.194791]
|
This assertion is stricter since MDEV-27058. Previously, it did not assert that the page has not been marked as free. I think that the following (untested) patch for 10.6 should fix the cause of this bug:
diff --git a/storage/innobase/buf/buf0buf.cc b/storage/innobase/buf/buf0buf.cc
|
index 11d820be305..93934dd2b5b 100644
|
--- a/storage/innobase/buf/buf0buf.cc
|
+++ b/storage/innobase/buf/buf0buf.cc
|
@@ -2238,6 +2238,10 @@ void buf_page_free(fil_space_t *space, uint32_t page, mtr_t *mtr)
|
}
|
|
block->page.lock.x_lock();
|
+#ifdef BTR_CUR_HASH_ADAPT
|
+ if (block->index)
|
+ btr_search_drop_page_hash_index(block);
|
+#endif /* BTR_CUR_HASH_ADAPT */
|
block->page.set_freed(block->page.state());
|
mtr->memo_push(block, MTR_MEMO_PAGE_X_FIX);
|
}
|
The 10.5 version is slightly different:
diff --git a/storage/innobase/buf/buf0buf.cc b/storage/innobase/buf/buf0buf.cc
|
index 37f99a94cee..7be40ac38e7 100644
|
--- a/storage/innobase/buf/buf0buf.cc
|
+++ b/storage/innobase/buf/buf0buf.cc
|
@@ -2500,6 +2500,11 @@ void buf_page_free(fil_space_t *space, uint32_t page, mtr_t *mtr,
|
rw_lock_x_lock_inline(&block->lock, 0, file, line);
|
buf_block_dbg_add_level(block, SYNC_NO_ORDER_CHECK);
|
|
+#ifdef BTR_CUR_HASH_ADAPT
|
+ if (block->index)
|
+ btr_search_drop_page_hash_index(block);
|
+#endif /* BTR_CUR_HASH_ADAPT */
|
+
|
block->page.status= buf_page_t::FREED;
|
return;
|
}
|
mleich, can you please test these?
- is caused by
-
MDEV-15528
Avoid writing freed InnoDB pages
-
-
Closed
{"report":{"fcp":689,"ttfb":154,"pageVisibility":"visible","entityId":106768,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"9f78dd57-a555-4222-8ea2-6b2f2535677b","navigationType":0,"readyForUser":767.2000000476837,"redirectCount":0,"resourceLoadedEnd":764.9000000953674,"resourceLoadedStart":159.60000014305115,"resourceTiming":[{"duration":6.700000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":159.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":166.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":6.799999952316284,"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":159.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":159.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":166.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":60.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":160,"connectEnd":160,"connectStart":160,"domainLookupEnd":160,"domainLookupStart":160,"fetchStart":160,"redirectEnd":0,"redirectStart":0,"requestStart":160,"responseEnd":220.60000014305115,"responseStart":220.60000014305115,"secureConnectionStart":160},{"duration":143.70000004768372,"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":160.20000004768372,"connectEnd":160.20000004768372,"connectStart":160.20000004768372,"domainLookupEnd":160.20000004768372,"domainLookupStart":160.20000004768372,"fetchStart":160.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":160.20000004768372,"responseEnd":303.90000009536743,"responseStart":303.90000009536743,"secureConnectionStart":160.20000004768372},{"duration":139.90000009536743,"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":160.20000004768372,"connectEnd":160.20000004768372,"connectStart":160.20000004768372,"domainLookupEnd":160.20000004768372,"domainLookupStart":160.20000004768372,"fetchStart":160.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":160.20000004768372,"responseEnd":300.10000014305115,"responseStart":300.10000014305115,"secureConnectionStart":160.20000004768372},{"duration":144,"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":160.30000019073486,"connectEnd":160.30000019073486,"connectStart":160.30000019073486,"domainLookupEnd":160.30000019073486,"domainLookupStart":160.30000019073486,"fetchStart":160.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":160.30000019073486,"responseEnd":304.30000019073486,"responseStart":304.30000019073486,"secureConnectionStart":160.30000019073486},{"duration":144.29999995231628,"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":160.40000009536743,"connectEnd":160.40000009536743,"connectStart":160.40000009536743,"domainLookupEnd":160.40000009536743,"domainLookupStart":160.40000009536743,"fetchStart":160.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":160.40000009536743,"responseEnd":304.7000000476837,"responseStart":304.7000000476837,"secureConnectionStart":160.40000009536743},{"duration":144.5,"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":160.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":160.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":305,"responseStart":0,"secureConnectionStart":0},{"duration":144.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":160.60000014305115,"connectEnd":160.60000014305115,"connectStart":160.60000014305115,"domainLookupEnd":160.60000014305115,"domainLookupStart":160.60000014305115,"fetchStart":160.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":160.60000014305115,"responseEnd":305,"responseStart":305,"secureConnectionStart":160.60000014305115},{"duration":144.59999990463257,"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":160.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":160.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":305.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":144.70000004768372,"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":160.90000009536743,"connectEnd":160.90000009536743,"connectStart":160.90000009536743,"domainLookupEnd":160.90000009536743,"domainLookupStart":160.90000009536743,"fetchStart":160.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":160.90000009536743,"responseEnd":305.60000014305115,"responseStart":305.60000014305115,"secureConnectionStart":160.90000009536743},{"duration":393.2000000476837,"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":161.60000014305115,"connectEnd":161.60000014305115,"connectStart":161.60000014305115,"domainLookupEnd":161.60000014305115,"domainLookupStart":161.60000014305115,"fetchStart":161.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":161.60000014305115,"responseEnd":554.8000001907349,"responseStart":554.8000001907349,"secureConnectionStart":161.60000014305115},{"duration":419.2000000476837,"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":161.60000014305115,"connectEnd":161.60000014305115,"connectStart":161.60000014305115,"domainLookupEnd":161.60000014305115,"domainLookupStart":161.60000014305115,"fetchStart":161.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":161.60000014305115,"responseEnd":580.8000001907349,"responseStart":580.8000001907349,"secureConnectionStart":161.60000014305115},{"duration":124.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":438.90000009536743,"connectEnd":438.90000009536743,"connectStart":438.90000009536743,"domainLookupEnd":438.90000009536743,"domainLookupStart":438.90000009536743,"fetchStart":438.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":438.90000009536743,"responseEnd":563.4000000953674,"responseStart":563.3000001907349,"secureConnectionStart":438.90000009536743},{"duration":127,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&slack-enabled=true","startTime":637.9000000953674,"connectEnd":637.9000000953674,"connectStart":637.9000000953674,"domainLookupEnd":637.9000000953674,"domainLookupStart":637.9000000953674,"fetchStart":637.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":637.9000000953674,"responseEnd":764.9000000953674,"responseStart":764.8000001907349,"secureConnectionStart":637.9000000953674},{"duration":96.60000014305115,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":669.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":669.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":766.1000001430511,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":23,"responseStart":154,"responseEnd":158,"domLoading":158,"domInteractive":831,"domContentLoadedEventStart":831,"domContentLoadedEventEnd":873,"domComplete":1755,"loadEventStart":1755,"loadEventEnd":1755,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":807.1000001430511},{"name":"bigPipe.sidebar-id.end","time":807.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":808},{"name":"bigPipe.activity-panel-pipe-id.end","time":810.6000001430511},{"name":"activityTabFullyLoaded","time":883.2000000476837}],"measures":[],"correlationId":"2c1ef1cadb89af","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":73,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}