Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.5
Recent MDEV-19964 patch did not check flags2_inited before
to access flags2 itself.
The latter may be randomly non-zero (see Query_log_event constructor) which
eventulizes on rpl.rpl_mariadb_slave_capability with the following mismatch pattern:
-slave-relay-bin.000005 # Query # # BEGIN
+slave-relay-bin.000005 # Query # # set foreign_key_checks=1, check_constraint_checks=1; BEGIN
where the '+' extra is cause by the random flags2 .
The case should be fixed with following the pattern of first checking flags2_inited .
{"report":{"fcp":738.6000003814697,"ttfb":176.80000019073486,"pageVisibility":"visible","entityId":90588,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"be6d3f35-bc65-4769-bbf7-3a602055e169","navigationType":0,"readyForUser":801.6000003814697,"redirectCount":0,"resourceLoadedEnd":637.3000001907349,"resourceLoadedStart":182.5,"resourceTiming":[{"duration":22.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":182.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":204.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":22.5,"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":182.70000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":182.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":205.20000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":81,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":182.9000005722046,"connectEnd":182.9000005722046,"connectStart":182.9000005722046,"domainLookupEnd":182.9000005722046,"domainLookupStart":182.9000005722046,"fetchStart":182.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":182.9000005722046,"responseEnd":263.9000005722046,"responseStart":263.9000005722046,"secureConnectionStart":182.9000005722046},{"duration":131.30000019073486,"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":183,"connectEnd":183,"connectStart":183,"domainLookupEnd":183,"domainLookupStart":183,"fetchStart":183,"redirectEnd":0,"redirectStart":0,"requestStart":183,"responseEnd":314.30000019073486,"responseStart":314.30000019073486,"secureConnectionStart":183},{"duration":126.70000076293945,"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":183,"connectEnd":183,"connectStart":183,"domainLookupEnd":183,"domainLookupStart":183,"fetchStart":183,"redirectEnd":0,"redirectStart":0,"requestStart":183,"responseEnd":309.70000076293945,"responseStart":309.70000076293945,"secureConnectionStart":183},{"duration":132.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":183.20000076293945,"connectEnd":183.20000076293945,"connectStart":183.20000076293945,"domainLookupEnd":183.20000076293945,"domainLookupStart":183.20000076293945,"fetchStart":183.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":183.20000076293945,"responseEnd":315.70000076293945,"responseStart":315.70000076293945,"secureConnectionStart":183.20000076293945},{"duration":134.9000005722046,"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":183.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":318.20000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":133.4000005722046,"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":183.30000019073486,"connectEnd":183.30000019073486,"connectStart":183.30000019073486,"domainLookupEnd":183.30000019073486,"domainLookupStart":183.30000019073486,"fetchStart":183.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":183.30000019073486,"responseEnd":316.70000076293945,"responseStart":316.70000076293945,"secureConnectionStart":183.30000019073486},{"duration":134.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":183.5,"connectEnd":183.5,"connectStart":183.5,"domainLookupEnd":183.5,"domainLookupStart":183.5,"fetchStart":183.5,"redirectEnd":0,"redirectStart":0,"requestStart":183.5,"responseEnd":317.9000005722046,"responseStart":317.9000005722046,"secureConnectionStart":183.5},{"duration":137.30000019073486,"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":183.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":183.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":320.9000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":135.69999980926514,"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":183.70000076293945,"connectEnd":183.70000076293945,"connectStart":183.70000076293945,"domainLookupEnd":183.70000076293945,"domainLookupStart":183.70000076293945,"fetchStart":183.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":183.70000076293945,"responseEnd":319.4000005722046,"responseStart":319.4000005722046,"secureConnectionStart":183.70000076293945},{"duration":436.20000076293945,"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":189.5,"connectEnd":189.5,"connectStart":189.5,"domainLookupEnd":189.5,"domainLookupStart":189.5,"fetchStart":189.5,"redirectEnd":0,"redirectStart":0,"requestStart":189.5,"responseEnd":625.7000007629395,"responseStart":625.7000007629395,"secureConnectionStart":189.5},{"duration":445.69999980926514,"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":191.60000038146973,"connectEnd":191.60000038146973,"connectStart":191.60000038146973,"domainLookupEnd":191.60000038146973,"domainLookupStart":191.60000038146973,"fetchStart":191.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":191.60000038146973,"responseEnd":637.3000001907349,"responseStart":637.3000001907349,"secureConnectionStart":191.60000038146973},{"duration":151.5999994277954,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":483.70000076293945,"connectEnd":483.70000076293945,"connectStart":483.70000076293945,"domainLookupEnd":483.70000076293945,"domainLookupStart":483.70000076293945,"fetchStart":483.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":483.70000076293945,"responseEnd":635.3000001907349,"responseStart":635.3000001907349,"secureConnectionStart":483.70000076293945}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":55,"responseStart":177,"responseEnd":192,"domLoading":181,"domInteractive":849,"domContentLoadedEventStart":849,"domContentLoadedEventEnd":881,"domComplete":1998,"loadEventStart":1998,"loadEventEnd":1999,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":831},{"name":"bigPipe.sidebar-id.end","time":831.7000007629395},{"name":"bigPipe.activity-panel-pipe-id.start","time":831.9000005722046},{"name":"bigPipe.activity-panel-pipe-id.end","time":835},{"name":"activityTabFullyLoaded","time":889.5}],"measures":[],"correlationId":"ead31f1fb2e6d1","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}