Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11
A log excerpt that was originally posted in MDEV-27784
2022-10-24 23:20:16 0 [Note] InnoDB: FTS optimize thread exiting.
2022-10-24 23:20:16 0 [Note] InnoDB: to purge 5 transactions
2022-10-24 23:20:17 0 [Note] InnoDB: Starting shutdown...
2022-10-24 23:20:17 0 [Note] InnoDB: Dumping buffer pool(s) to /data/maria_data/ib_buffer_pool
2022-10-24 23:20:17 0 [Note] InnoDB: Restricted to 354860 pages due to innodb_buf_pool_dump_pct=25
2022-10-24 23:20:17 0 [Note] InnoDB: Buffer pool(s) dump completed at 221024 23:20:17
2022-10-24 23:57:37 0 [ERROR] InnoDB: The age of the last checkpoint is 966373838, which exceeds the log capacity 966365799.
2022-10-24 23:57:53 0 [ERROR] InnoDB: The age of the last checkpoint is 974973721, which exceeds the log capacity 966365799.
2022-10-24 23:58:09 0 [ERROR] InnoDB: The age of the last checkpoint is 983054253, which exceeds the log capacity 966365799.
2022-10-24 23:58:25 0 [ERROR] InnoDB: The age of the last checkpoint is 991661268, which exceeds the log capacity 966365799.
...
2022-10-25 2:02:57 0 [ERROR] InnoDB: The age of the last checkpoint is 4351924949, which exceeds the log capacity 966365799.
At this point, the server was forcibly killed, and it was unable to recover, because the last valid checkpoint had been overwritten 4½ times.
A design constraint is that before any buffer page latch is acquired in a mini-transaction that will write something, log_free_check() must be called. In the entire change buffer subsystem, only the function ibuf_remove_free_page() contains such a call, added in MDEV-13637
{"report":{"fcp":852.4000000953674,"ttfb":144.5,"pageVisibility":"visible","entityId":116138,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"6218f3e0-ab0c-45f3-9ce7-4bb8c7370591","navigationType":0,"readyForUser":915.9000000953674,"redirectCount":0,"resourceLoadedEnd":1357.4000000953674,"resourceLoadedStart":178.10000014305115,"resourceTiming":[{"duration":225.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":178.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":403.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":225.29999995231628,"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":178.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":178.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":403.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":234.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":178.60000014305115,"connectEnd":178.60000014305115,"connectStart":178.60000014305115,"domainLookupEnd":178.60000014305115,"domainLookupStart":178.60000014305115,"fetchStart":178.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":178.60000014305115,"responseEnd":412.7000000476837,"responseStart":412.7000000476837,"secureConnectionStart":178.60000014305115},{"duration":260.09999990463257,"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":178.60000014305115,"connectEnd":178.60000014305115,"connectStart":178.60000014305115,"domainLookupEnd":178.60000014305115,"domainLookupStart":178.60000014305115,"fetchStart":178.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":178.60000014305115,"responseEnd":438.7000000476837,"responseStart":438.7000000476837,"secureConnectionStart":178.60000014305115},{"duration":263.7000000476837,"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":178.70000004768372,"connectEnd":178.70000004768372,"connectStart":178.70000004768372,"domainLookupEnd":178.70000004768372,"domainLookupStart":178.70000004768372,"fetchStart":178.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":178.70000004768372,"responseEnd":442.40000009536743,"responseStart":442.40000009536743,"secureConnectionStart":178.70000004768372},{"duration":264.09999990463257,"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":178.90000009536743,"connectEnd":178.90000009536743,"connectStart":178.90000009536743,"domainLookupEnd":178.90000009536743,"domainLookupStart":178.90000009536743,"fetchStart":178.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":178.90000009536743,"responseEnd":443,"responseStart":443,"secureConnectionStart":178.90000009536743},{"duration":264.60000014305115,"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":179,"connectEnd":179,"connectStart":179,"domainLookupEnd":179,"domainLookupStart":179,"fetchStart":179,"redirectEnd":0,"redirectStart":0,"requestStart":179,"responseEnd":443.60000014305115,"responseStart":443.60000014305115,"secureConnectionStart":179},{"duration":265.2999999523163,"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":179.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":179.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":444.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":265,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":179.20000004768372,"connectEnd":179.20000004768372,"connectStart":179.20000004768372,"domainLookupEnd":179.20000004768372,"domainLookupStart":179.20000004768372,"fetchStart":179.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":179.20000004768372,"responseEnd":444.2000000476837,"responseStart":444.2000000476837,"secureConnectionStart":179.20000004768372},{"duration":265.5,"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":179.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":179.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":444.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":265.5,"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":179.5,"connectEnd":179.5,"connectStart":179.5,"domainLookupEnd":179.5,"domainLookupStart":179.5,"fetchStart":179.5,"redirectEnd":0,"redirectStart":0,"requestStart":179.5,"responseEnd":445,"responseStart":445,"secureConnectionStart":179.5},{"duration":470.7000000476837,"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":180.5,"connectEnd":180.5,"connectStart":180.5,"domainLookupEnd":180.5,"domainLookupStart":180.5,"fetchStart":180.5,"redirectEnd":0,"redirectStart":0,"requestStart":180.5,"responseEnd":651.2000000476837,"responseStart":651.2000000476837,"secureConnectionStart":180.5},{"duration":1176.9000000953674,"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":180.5,"connectEnd":180.5,"connectStart":180.5,"domainLookupEnd":180.5,"domainLookupStart":180.5,"fetchStart":180.5,"redirectEnd":0,"redirectStart":0,"requestStart":180.5,"responseEnd":1357.4000000953674,"responseStart":1357.4000000953674,"secureConnectionStart":180.5},{"duration":662.4000000953674,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":649.9000000953674,"connectEnd":649.9000000953674,"connectStart":649.9000000953674,"domainLookupEnd":649.9000000953674,"domainLookupStart":649.9000000953674,"fetchStart":649.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":649.9000000953674,"responseEnd":1312.3000001907349,"responseStart":1312.3000001907349,"secureConnectionStart":649.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":145,"responseEnd":151,"domLoading":176,"domInteractive":1412,"domContentLoadedEventStart":1412,"domContentLoadedEventEnd":1450,"domComplete":2182,"loadEventStart":2182,"loadEventEnd":2183,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1391.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1392.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1392.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1395.3000001907349},{"name":"activityTabFullyLoaded","time":1456.2000000476837}],"measures":[],"correlationId":"86b7420096897b","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":75,"dbReadsTimeInMs":16,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
MDEV-27734 Set innodb_change_buffering=none by default