Type:
Bug
Priority:
Blocker
Resolution:
Fixed
Affects Version/s:
10.2(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5 , 10.6
MySQL 5.7.32 includes the following InnoDB changes:
Not applicable to MariaDB Server
Bug#30950714 CONSISTENT SNAPSHOT CAN BE CORRUPTED BY OTHER TRANSACTIONS
Bug#31205266 : CONCURRENT UPDATE CAUSE CRASH IN ROW_SEARCH_MVCC (revert , re-apply , fixup )
These are follow-up fixes to Bug#23481444 OPTIMISER CALL ROW_SEARCH_MVCC() AND READ THE INDEX APPLIED BY UNCOMMITTED ROWS , which we chose not to apply to MariaDB already in MDEV-11751 .
Bug #31560679 INNODB INTERNAL TEMP TABLE PRODUCES INCORRECT RESULTS
SQL execution in MariaDB never used InnoDB for temporary tables, and MDEV-11487 removed that code.
Bug#31313533 : IMPORT FAILS FOR ENCRYP AND COMPRESSION ENABLED TDE TABLES (fixup )
Bug#31817270 : MTR TEST FAILURE IN I_INNODB.TABLE_COMPRESS_4 FOR 8K PAGE SIZE
These are related to the MySQL 5.7 reimplementation of the MariaDB 10.1 features for encrypted or sparse-file page_compressed storage of InnoDB data files.
Bug #30594501 QUERY STALLS IN "QUERY END" STATUS FOR LONG TIME
This is also known as MySQL Bug#91078 . A comment on that page says:
This is a real bug, and there is one fix in 8.0.22 and 5.7.32 that may solve it. Please wait for that release, and search the change history notes for Bug #30594501 . It is related to previously fixed Bug #27325898 .
In MDEV-17536 (Merge new release of InnoDB 5.7.24 to 10.2) we concluded that the earlier change is not applicable to MariaDB, so neither should this follow-up fix be:
Bug #27325898 - INNODB: ASSERTION FAILURE IN THREAD 139686919030528 IN FILE TRX0TRX.IC LINE 213 is not applicable, because we already removed the TrxInInnoDB code and trx->lock.start_stmt in MDEV-13935 .
Applicable to MariaDB Server
Bug #30607708 IF ANALYZE TABLE RUNS MORE THAN 600 SECONDS DIAGNOSTIC QUERY MAY CRASH SERVER
To be addressed in MDEV-23991 .
Bug #31105262 LATCHCOUNTER::ITERATE SHOULD USE M_MUTEX PROTECTION
To be addressed in MDEV-23996 .
Bug #31036301 ASSERTION FAILURE: SYNC0RW.IC:429:LOCK->LOCK_WORD
This one we had previously filed as MDEV-23693 , and the fix is applicable for that bug.
Bug #30933728 INNODB FTS PHRASE SEARCH HIT AN ASSERT
Bug #31228694 FTS QUERY WITH LIMIT HIT AN ASSERT
The test cases for these depend on the n-gram search that we will not have before MDEV-10267 , but the code changes looked innocent enough to be applied. These are now in 10.2.
Bug #29929684 USING MANY NESTED ARGUMENTS WITH BOOLEAN FTS CAN LEAD TO TERMINATE SERVER.
Addressed by MDEV-23999 .
{"report":{"fcp":1357.9000000953674,"ttfb":603.3000000715256,"pageVisibility":"visible","entityId":92913,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c90f75dc-fbdb-40d0-9280-bfebba856ec9","navigationType":0,"readyForUser":1462.3000000715256,"redirectCount":0,"resourceLoadedEnd":1616.6000000238419,"resourceLoadedStart":609.9000000953674,"resourceTiming":[{"duration":186.59999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":609.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":609.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":796.5,"responseStart":0,"secureConnectionStart":0},{"duration":186.69999992847443,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":610.3000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":610.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":797,"responseStart":0,"secureConnectionStart":0},{"duration":239.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":610.5,"connectEnd":610.5,"connectStart":610.5,"domainLookupEnd":610.5,"domainLookupStart":610.5,"fetchStart":610.5,"redirectEnd":0,"redirectStart":0,"requestStart":610.5,"responseEnd":850.2000000476837,"responseStart":850.2000000476837,"secureConnectionStart":610.5},{"duration":397.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":610.7000000476837,"connectEnd":610.7000000476837,"connectStart":610.7000000476837,"domainLookupEnd":610.7000000476837,"domainLookupStart":610.7000000476837,"fetchStart":610.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":610.7000000476837,"responseEnd":1008.5,"responseStart":1008.4000000953674,"secureConnectionStart":610.7000000476837},{"duration":402.1999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":610.9000000953674,"connectEnd":610.9000000953674,"connectStart":610.9000000953674,"domainLookupEnd":610.9000000953674,"domainLookupStart":610.9000000953674,"fetchStart":610.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":610.9000000953674,"responseEnd":1013.1000000238419,"responseStart":1013.1000000238419,"secureConnectionStart":610.9000000953674},{"duration":402.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":611.2000000476837,"connectEnd":611.2000000476837,"connectStart":611.2000000476837,"domainLookupEnd":611.2000000476837,"domainLookupStart":611.2000000476837,"fetchStart":611.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":611.2000000476837,"responseEnd":1013.6000000238419,"responseStart":1013.6000000238419,"secureConnectionStart":611.2000000476837},{"duration":402.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":611.4000000953674,"connectEnd":611.4000000953674,"connectStart":611.4000000953674,"domainLookupEnd":611.4000000953674,"domainLookupStart":611.4000000953674,"fetchStart":611.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":611.4000000953674,"responseEnd":1014.1000000238419,"responseStart":1014,"secureConnectionStart":611.4000000953674},{"duration":403,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":611.6000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":611.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1014.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":402.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":611.8000000715256,"connectEnd":611.8000000715256,"connectStart":611.8000000715256,"domainLookupEnd":611.8000000715256,"domainLookupStart":611.8000000715256,"fetchStart":611.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":611.8000000715256,"responseEnd":1014.6000000238419,"responseStart":1014.6000000238419,"secureConnectionStart":611.8000000715256},{"duration":403.3000000715256,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":612,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":612,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1015.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":403,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":612.2000000476837,"connectEnd":612.2000000476837,"connectStart":612.2000000476837,"domainLookupEnd":612.2000000476837,"domainLookupStart":612.2000000476837,"fetchStart":612.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":612.2000000476837,"responseEnd":1015.2000000476837,"responseStart":1015.2000000476837,"secureConnectionStart":612.2000000476837},{"duration":678,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":613.5,"connectEnd":613.5,"connectStart":613.5,"domainLookupEnd":613.5,"domainLookupStart":613.5,"fetchStart":613.5,"redirectEnd":0,"redirectStart":0,"requestStart":613.5,"responseEnd":1291.5,"responseStart":1291.5,"secureConnectionStart":613.5},{"duration":996,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":620.6000000238419,"connectEnd":620.6000000238419,"connectStart":620.6000000238419,"domainLookupEnd":620.6000000238419,"domainLookupStart":620.6000000238419,"fetchStart":620.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":620.6000000238419,"responseEnd":1616.6000000238419,"responseStart":1616.6000000238419,"secureConnectionStart":620.6000000238419},{"duration":251,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1006.9000000953674,"connectEnd":1006.9000000953674,"connectStart":1006.9000000953674,"domainLookupEnd":1006.9000000953674,"domainLookupStart":1006.9000000953674,"fetchStart":1006.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1006.9000000953674,"responseEnd":1257.9000000953674,"responseStart":1257.9000000953674,"secureConnectionStart":1006.9000000953674},{"duration":392.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1302,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1302,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1694.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":391.89999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1302.6000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1302.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1694.5,"responseStart":0,"secureConnectionStart":0},{"duration":367.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1303.5,"connectEnd":1303.5,"connectStart":1303.5,"domainLookupEnd":1303.5,"domainLookupStart":1303.5,"fetchStart":1303.5,"redirectEnd":0,"redirectStart":0,"requestStart":1303.5,"responseEnd":1670.7000000476837,"responseStart":1670.7000000476837,"secureConnectionStart":1303.5},{"duration":371.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1303.9000000953674,"connectEnd":1303.9000000953674,"connectStart":1303.9000000953674,"domainLookupEnd":1303.9000000953674,"domainLookupStart":1303.9000000953674,"fetchStart":1303.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1303.9000000953674,"responseEnd":1675.7000000476837,"responseStart":1675.7000000476837,"secureConnectionStart":1303.9000000953674},{"duration":376.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/e0bf5781d46ea69fb123572974cf39de-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1304.3000000715256,"connectEnd":1304.3000000715256,"connectStart":1304.3000000715256,"domainLookupEnd":1304.3000000715256,"domainLookupStart":1304.3000000715256,"fetchStart":1304.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":1304.3000000715256,"responseEnd":1680.6000000238419,"responseStart":1680.6000000238419,"secureConnectionStart":1304.3000000715256}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":424,"responseStart":604,"responseEnd":617,"domLoading":608,"domInteractive":1639,"domContentLoadedEventStart":1639,"domContentLoadedEventEnd":1694,"domComplete":3094,"loadEventStart":3094,"loadEventEnd":3096,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1618.8000000715256},{"name":"bigPipe.sidebar-id.end","time":1619.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1619.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1622.2000000476837},{"name":"activityTabFullyLoaded","time":1706.9000000953674}],"measures":[],"correlationId":"70321415fc1ae8","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":123,"dbReadsTimeInMs":26,"dbConnsTimeInMs":37,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}