-
Bug
-
-
Major
-
Resolution:
Fixed
-
10.0.15, 10.1.10, 10.2.0, 10.3.0, 10.4.0, 10.5.0
-
-
-
SET GLOBAL innodb_adaptive_flushing_lwm=0.0;
|
CREATE TABLE t (c DOUBLE) ENGINE=InnoDB;
|
SET GLOBAL innodb_io_capacity=18446744073709551615;
|
SELECT SLEEP (3);
|
Leads to:
10.6.0 9118fd360a3da0bba521caf2a35c424968235ac4 (Debug)
|
mysqld: /test/10.6_dbg/storage/innobase/buf/buf0flu.cc:1890: ulint af_get_pct_for_lsn(lsn_t): Assertion `srv_max_io_capacity >= srv_io_capacity' failed.
|
10.6.0 9118fd360a3da0bba521caf2a35c424968235ac4 (Debug)
|
Core was generated by `/test/MD010121-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x14f13c652700 (LWP 1553990))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x000055ee02c440d7 in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424
|
#2 0x000055ee023d8ab1 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:330
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x000014f145c21859 in __GI_abort () at abort.c:79
|
#6 0x000014f145c21729 in __assert_fail_base (fmt=0x14f145db7588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55ee03064238 "srv_max_io_capacity >= srv_io_capacity", file=0x55ee03063238 "/test/10.6_dbg/storage/innobase/buf/buf0flu.cc", line=1890, function=<optimized out>) at assert.c:92
|
#7 0x000014f145c32f36 in __GI___assert_fail (assertion=assertion@entry=0x55ee03064238 "srv_max_io_capacity >= srv_io_capacity", file=file@entry=0x55ee03063238 "/test/10.6_dbg/storage/innobase/buf/buf0flu.cc", line=line@entry=1890, function=function@entry=0x55ee03064260 "ulint af_get_pct_for_lsn(lsn_t)") at assert.c:101
|
#8 0x000055ee02ac2529 in af_get_pct_for_lsn (age=1616) at /test/10.6_dbg/storage/innobase/buf/buf0flu.cc:1890
|
#9 page_cleaner_flush_pages_recommendation (dirty_pct=0.21037000371241182, dirty_blocks=17, oldest_lsn=43230, last_pages_in=0) at /test/10.6_dbg/storage/innobase/buf/buf0flu.cc:1921
|
#10 buf_flush_page_cleaner () at /test/10.6_dbg/storage/innobase/buf/buf0flu.cc:2170
|
#11 0x000014f14612f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#12 0x000014f145d1e293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.5.9 (dbg), 10.6.0 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.37 (dbg), 10.2.37 (opt), 10.3.28 (dbg), 10.3.28 (opt), 10.4.18 (dbg), 10.4.18 (opt), 10.5.9 (opt), 10.6.0 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.50 (dbg), 5.6.50 (opt), 5.7.32 (dbg), 5.7.32 (opt), 8.0.22 (dbg), 8.0.22 (opt)
10.4 Does not crash at all on the same.
There is also this:
10.4.18 3454b5cf35a61e8f6cfab376638520dee4a50609 (Debug)
|
10.4.18>SET GLOBAL innodb_io_capacity=18446744073709551615;
|
Query OK, 0 rows affected, 2 warnings (0.000 sec)
|
|
10.4.18>SHOW WARNINGS;
|
+---------+------+------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------------------------------------------------+
|
| Warning | 1210 | Setting innodb_io_capacity to 18446744073709551615 higher than innodb_io_capacity_max 18446744073709551614 |
|
| Warning | 1210 | Setting innodb_max_io_capacity to 18446744073709551614 |
|
+---------+------+------------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.000 sec)
|
|
10.4.18>SELECT @@GLOBAL.innodb_max_io_capacity;
|
ERROR 1193 (HY000): Unknown system variable 'innodb_max_io_capacity'
|
10.4.18>SELECT @@GLOBAL.innodb_io_capacity;
|
+-----------------------------+
|
| @@GLOBAL.innodb_io_capacity |
|
+-----------------------------+
|
| 18446744073709551615 |
|
+-----------------------------+
|
1 row in set (0.000 sec)
|
Not sure if that is a separate off-by-one bug and/or a minor functionality bug or not.
Also see MDEV-7035.
- is caused by
-
MDEV-7035
Remove innodb_io_capacity setting depending on setting of innodb_io_capacity_max
-
-
Closed
{"report":{"fcp":886.7000000476837,"ttfb":143.10000014305115,"pageVisibility":"visible","entityId":95979,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"5586522a-939f-456d-b6e1-630a21026820","navigationType":0,"readyForUser":951.7000000476837,"redirectCount":0,"resourceLoadedEnd":1359.7000000476837,"resourceLoadedStart":153.20000004768372,"resourceTiming":[{"duration":142.70000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":153.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":295.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":303.2000000476837,"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":153.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":153.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":456.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":312.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":153.60000014305115,"connectEnd":153.60000014305115,"connectStart":153.60000014305115,"domainLookupEnd":153.60000014305115,"domainLookupStart":153.60000014305115,"fetchStart":153.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":153.60000014305115,"responseEnd":466.10000014305115,"responseStart":466.10000014305115,"secureConnectionStart":153.60000014305115},{"duration":337.2000000476837,"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":153.70000004768372,"connectEnd":153.70000004768372,"connectStart":153.70000004768372,"domainLookupEnd":153.70000004768372,"domainLookupStart":153.70000004768372,"fetchStart":153.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":153.70000004768372,"responseEnd":490.90000009536743,"responseStart":490.90000009536743,"secureConnectionStart":153.70000004768372},{"duration":340.60000014305115,"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":153.79999995231628,"connectEnd":153.79999995231628,"connectStart":153.79999995231628,"domainLookupEnd":153.79999995231628,"domainLookupStart":153.79999995231628,"fetchStart":153.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":153.79999995231628,"responseEnd":494.40000009536743,"responseStart":494.40000009536743,"secureConnectionStart":153.79999995231628},{"duration":341,"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":153.90000009536743,"connectEnd":153.90000009536743,"connectStart":153.90000009536743,"domainLookupEnd":153.90000009536743,"domainLookupStart":153.90000009536743,"fetchStart":153.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":153.90000009536743,"responseEnd":494.90000009536743,"responseStart":494.7999999523163,"secureConnectionStart":153.90000009536743},{"duration":341.2000000476837,"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":153.90000009536743,"connectEnd":153.90000009536743,"connectStart":153.90000009536743,"domainLookupEnd":153.90000009536743,"domainLookupStart":153.90000009536743,"fetchStart":153.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":153.90000009536743,"responseEnd":495.10000014305115,"responseStart":495.10000014305115,"secureConnectionStart":153.90000009536743},{"duration":341.59999990463257,"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":154.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":495.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":341.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":154.20000004768372,"connectEnd":154.20000004768372,"connectStart":154.20000004768372,"domainLookupEnd":154.20000004768372,"domainLookupStart":154.20000004768372,"fetchStart":154.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":154.20000004768372,"responseEnd":495.60000014305115,"responseStart":495.60000014305115,"secureConnectionStart":154.20000004768372},{"duration":341.7000000476837,"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":154.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":154.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":496,"responseStart":0,"secureConnectionStart":0},{"duration":341.7000000476837,"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":154.40000009536743,"connectEnd":154.40000009536743,"connectStart":154.40000009536743,"domainLookupEnd":154.40000009536743,"domainLookupStart":154.40000009536743,"fetchStart":154.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":154.40000009536743,"responseEnd":496.10000014305115,"responseStart":496.10000014305115,"secureConnectionStart":154.40000009536743},{"duration":588.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":164,"connectEnd":164,"connectStart":164,"domainLookupEnd":164,"domainLookupStart":164,"fetchStart":164,"redirectEnd":0,"redirectStart":0,"requestStart":164,"responseEnd":752.2000000476837,"responseStart":752.2000000476837,"secureConnectionStart":164},{"duration":1195.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":164.20000004768372,"connectEnd":164.20000004768372,"connectStart":164.20000004768372,"domainLookupEnd":164.20000004768372,"domainLookupStart":164.20000004768372,"fetchStart":164.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":164.20000004768372,"responseEnd":1359.7000000476837,"responseStart":1359.7000000476837,"secureConnectionStart":164.20000004768372},{"duration":664,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":695.2000000476837,"connectEnd":695.2000000476837,"connectStart":695.2000000476837,"domainLookupEnd":695.2000000476837,"domainLookupStart":695.2000000476837,"fetchStart":695.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":695.2000000476837,"responseEnd":1359.2000000476837,"responseStart":1359.2000000476837,"secureConnectionStart":695.2000000476837},{"duration":494.80000019073486,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":866.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":866.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1361.1000001430511,"responseStart":0,"secureConnectionStart":0}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":3,"responseStart":144,"responseEnd":164,"domLoading":152,"domInteractive":1384,"domContentLoadedEventStart":1384,"domContentLoadedEventEnd":1420,"domComplete":2026,"loadEventStart":2026,"loadEventEnd":2027,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1368.5},{"name":"bigPipe.sidebar-id.end","time":1369.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1369.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1371.7999999523163},{"name":"activityTabFullyLoaded","time":1460.4000000953674}],"measures":[],"correlationId":"38e8952085483e","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":79,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}