Found using:
innodb_read_io_threads=24
innodb_write_io_threads=24
innodb_buffer_pool_instances=32
innodb_encrypt_tables=1
Problem is that there can be more than pre-allocated number of used slots on encryption/compression because of open I/O requests.
Jan Lindström (Inactive)
made changes -
2015-06-05 08:49
Field
Original Value
New Value
Status
Open
[ 1
]
In Progress
[ 3
]
Jan Lindström (Inactive)
made changes -
2015-06-09 11:40
Fix Version/s
10.1.6
[ 19401
]
Fix Version/s
10.1
[ 16100
]
Resolution
Fixed
[ 1
]
Status
In Progress
[ 3
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:41
Workflow
MariaDB v3
[ 69838
]
MariaDB v4
[ 149239
]
{"report":{"fcp":797,"ttfb":184.5,"pageVisibility":"visible","entityId":51638,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"9968cd07-8427-4b8f-8e7f-fa2b59d6442a","navigationType":0,"readyForUser":908.1999999880791,"redirectCount":0,"resourceLoadedEnd":506.10000002384186,"resourceLoadedStart":208.4000000357628,"resourceTiming":[{"duration":6,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":208.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":208.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":214.4000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":6,"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":208.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":208.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":214.80000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":185.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":209.10000002384186,"connectEnd":216.9000000357628,"connectStart":216.9000000357628,"domainLookupEnd":216.9000000357628,"domainLookupStart":216.9000000357628,"fetchStart":209.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":217.19999998807907,"responseEnd":394.80000001192093,"responseStart":234,"secureConnectionStart":216.9000000357628},{"duration":296.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":209.60000002384186,"connectEnd":209.60000002384186,"connectStart":209.60000002384186,"domainLookupEnd":209.60000002384186,"domainLookupStart":209.60000002384186,"fetchStart":209.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":219.4000000357628,"responseEnd":506.10000002384186,"responseStart":242.5,"secureConnectionStart":209.60000002384186},{"duration":27.80000001192093,"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":209.80000001192093,"connectEnd":209.80000001192093,"connectStart":209.80000001192093,"domainLookupEnd":209.80000001192093,"domainLookupStart":209.80000001192093,"fetchStart":209.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":221.4000000357628,"responseEnd":237.60000002384186,"responseStart":236.5,"secureConnectionStart":209.80000001192093},{"duration":39.5,"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":210,"connectEnd":210,"connectStart":210,"domainLookupEnd":210,"domainLookupStart":210,"fetchStart":210,"redirectEnd":0,"redirectStart":0,"requestStart":221.9000000357628,"responseEnd":249.5,"responseStart":244.9000000357628,"secureConnectionStart":210},{"duration":39.89999997615814,"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":210.10000002384186,"connectEnd":210.10000002384186,"connectStart":210.10000002384186,"domainLookupEnd":210.10000002384186,"domainLookupStart":210.10000002384186,"fetchStart":210.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":222.19999998807907,"responseEnd":250,"responseStart":245.60000002384186,"secureConnectionStart":210.10000002384186},{"duration":11.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":210.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":210.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":221.69999998807907,"responseStart":0,"secureConnectionStart":0},{"duration":39.799999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":210.4000000357628,"connectEnd":210.4000000357628,"connectStart":210.4000000357628,"domainLookupEnd":210.4000000357628,"domainLookupStart":210.4000000357628,"fetchStart":210.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":224.4000000357628,"responseEnd":250.19999998807907,"responseStart":246.19999998807907,"secureConnectionStart":210.4000000357628},{"duration":12.699999988079071,"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":210.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":210.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":223.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":46.30000001192093,"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":210.69999998807907,"connectEnd":210.69999998807907,"connectStart":210.69999998807907,"domainLookupEnd":210.69999998807907,"domainLookupStart":210.69999998807907,"fetchStart":210.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":225.4000000357628,"responseEnd":257,"responseStart":247.80000001192093,"secureConnectionStart":210.69999998807907},{"duration":286.80000001192093,"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":214.30000001192093,"connectEnd":214.30000001192093,"connectStart":214.30000001192093,"domainLookupEnd":214.30000001192093,"domainLookupStart":214.30000001192093,"fetchStart":214.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":233.9000000357628,"responseEnd":501.10000002384186,"responseStart":495.4000000357628,"secureConnectionStart":214.30000001192093},{"duration":282.69999998807907,"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":218.60000002384186,"connectEnd":218.60000002384186,"connectStart":218.60000002384186,"domainLookupEnd":218.60000002384186,"domainLookupStart":218.60000002384186,"fetchStart":218.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":250.5,"responseEnd":501.30000001192093,"responseStart":496.10000002384186,"secureConnectionStart":218.60000002384186},{"duration":61.90000003576279,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":545,"connectEnd":545,"connectStart":545,"domainLookupEnd":545,"domainLookupStart":545,"fetchStart":545,"redirectEnd":0,"redirectStart":0,"requestStart":572.4000000357628,"responseEnd":606.9000000357628,"responseStart":606.3000000119209,"secureConnectionStart":545},{"duration":146.69999998807907,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":790.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":790.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":937.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":121.30000001192093,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":797,"connectEnd":797,"connectStart":797,"domainLookupEnd":797,"domainLookupStart":797,"fetchStart":797,"redirectEnd":0,"redirectStart":0,"requestStart":886.5,"responseEnd":918.3000000119209,"responseStart":917.6000000238419,"secureConnectionStart":797}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":28,"responseStart":185,"responseEnd":218,"domLoading":189,"domInteractive":964,"domContentLoadedEventStart":964,"domContentLoadedEventEnd":1008,"domComplete":1219,"loadEventStart":1219,"loadEventEnd":1219,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":939.3000000119209},{"name":"bigPipe.sidebar-id.end","time":940.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":940.3000000119209},{"name":"bigPipe.activity-panel-pipe-id.end","time":942.1000000238419},{"name":"activityTabFullyLoaded","time":1026.699999988079}],"measures":[],"correlationId":"f821a91306944","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":14,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
commit 4a6a61cb8190ad5b8fc3993b15e0fa48bcb730a5
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Mon Jun 8 08:09:33 2015 +0300
MDEV-8268: InnoDB: Assertion failure in file buf0buf.cc line 5842 failing assertion ut_a(free_slot != NULL);Analysis: Problem is that there is not enough temporary buffer slots
for pending IO requests.
Fixed by allocating same amount of temporary buffer slots as there
are max pending IO requests.