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 .
There are no comments yet on this issue.
{"report":{"fcp":1240,"ttfb":704.9000000953674,"pageVisibility":"visible","entityId":92913,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b63362e0-20ec-45f7-8ac9-7fcf3365aeaf","navigationType":0,"readyForUser":1315.2999999523163,"redirectCount":0,"resourceLoadedEnd":1102.9000000953674,"resourceLoadedStart":712.2000000476837,"resourceTiming":[{"duration":4.599999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":712.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":712.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":716.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":4.6000001430511475,"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":712.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":712.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":717.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":86.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":712.6000001430511,"connectEnd":712.6000001430511,"connectStart":712.6000001430511,"domainLookupEnd":712.6000001430511,"domainLookupStart":712.6000001430511,"fetchStart":712.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":721.2000000476837,"responseEnd":799.1000001430511,"responseStart":747.2000000476837,"secureConnectionStart":712.6000001430511},{"duration":97.70000004768372,"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":712.9000000953674,"connectEnd":712.9000000953674,"connectStart":712.9000000953674,"domainLookupEnd":712.9000000953674,"domainLookupStart":712.9000000953674,"fetchStart":712.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":721.7000000476837,"responseEnd":810.6000001430511,"responseStart":747.7000000476837,"secureConnectionStart":712.9000000953674},{"duration":42.5,"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":713.1000001430511,"connectEnd":713.1000001430511,"connectStart":713.1000001430511,"domainLookupEnd":713.1000001430511,"domainLookupStart":713.1000001430511,"fetchStart":713.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":723.2999999523163,"responseEnd":755.6000001430511,"responseStart":754.9000000953674,"secureConnectionStart":713.1000001430511},{"duration":40.59999990463257,"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":713.2000000476837,"connectEnd":713.2000000476837,"connectStart":713.2000000476837,"domainLookupEnd":713.2000000476837,"domainLookupStart":713.2000000476837,"fetchStart":713.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":723.2000000476837,"responseEnd":753.7999999523163,"responseStart":753.1000001430511,"secureConnectionStart":713.2000000476837},{"duration":43,"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":713.4000000953674,"connectEnd":713.4000000953674,"connectStart":713.4000000953674,"domainLookupEnd":713.4000000953674,"domainLookupStart":713.4000000953674,"fetchStart":713.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":724.9000000953674,"responseEnd":756.4000000953674,"responseStart":755.7000000476837,"secureConnectionStart":713.4000000953674},{"duration":9.5,"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":713.6000001430511,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":713.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":723.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":58.700000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":713.7000000476837,"connectEnd":713.7000000476837,"connectStart":713.7000000476837,"domainLookupEnd":713.7000000476837,"domainLookupStart":713.7000000476837,"fetchStart":713.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":729.2000000476837,"responseEnd":772.4000000953674,"responseStart":771.5,"secureConnectionStart":713.7000000476837},{"duration":11.400000095367432,"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":714,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":714,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":725.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":62.69999980926514,"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":714.1000001430511,"connectEnd":714.1000001430511,"connectStart":714.1000001430511,"domainLookupEnd":714.1000001430511,"domainLookupStart":714.1000001430511,"fetchStart":714.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":730.2999999523163,"responseEnd":776.7999999523163,"responseStart":772.6000001430511,"secureConnectionStart":714.1000001430511},{"duration":158.39999985694885,"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":732.6000001430511,"connectEnd":732.6000001430511,"connectStart":732.6000001430511,"domainLookupEnd":732.6000001430511,"domainLookupStart":732.6000001430511,"fetchStart":732.6000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":759.9000000953674,"responseEnd":891,"responseStart":889.6000001430511,"secureConnectionStart":732.6000001430511},{"duration":367.90000009536743,"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":735,"connectEnd":735,"connectStart":735,"domainLookupEnd":735,"domainLookupStart":735,"fetchStart":735,"redirectEnd":0,"redirectStart":0,"requestStart":1006.4000000953674,"responseEnd":1102.9000000953674,"responseStart":1101,"secureConnectionStart":735},{"duration":190.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":989.2000000476837,"connectEnd":989.2000000476837,"connectStart":989.2000000476837,"domainLookupEnd":989.2000000476837,"domainLookupStart":989.2000000476837,"fetchStart":989.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1144.2000000476837,"responseEnd":1179.6000001430511,"responseStart":1178.9000000953674,"secureConnectionStart":989.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":136,"responseStart":705,"responseEnd":735,"domLoading":708,"domInteractive":1368,"domContentLoadedEventStart":1368,"domContentLoadedEventEnd":1401,"domComplete":2235,"loadEventStart":2235,"loadEventEnd":2235,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1354.5},{"name":"bigPipe.sidebar-id.end","time":1355.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.start","time":1355.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1355.9000000953674},{"name":"activityTabFullyLoaded","time":1413.2000000476837}],"measures":[],"correlationId":"d5db35b49aabf2","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":509,"dbReadsTimeInMs":25,"dbConnsTimeInMs":36,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}