The Mariadb process become non-responsive in 1-3 days time after its start in environment where NTP is enabled.
This could be specifically seen when the ntp server switches system time in the middle on mariadb server start up.
Checking the process list on DB shows all the queries in stuck state
below is strace on the mariadb server process :
The issue is not seen on 10.6.14-MariaDB-log MariaDB Server . The problems start appearing after we upgraded to 10.6.16-MariaDB-log MariaDB Server & 10.11.6-MariaDB-log
{"report":{"fcp":1240.199999988079,"ttfb":288,"pageVisibility":"visible","entityId":130141,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"db82cfd3-3e57-42ed-a9e5-6389970608c1","navigationType":0,"readyForUser":1328.2999999970198,"redirectCount":0,"resourceLoadedEnd":1780.3999999910593,"resourceLoadedStart":293,"resourceTiming":[{"duration":483.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":293,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":776.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":484.29999999701977,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":293.29999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":777.5999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":494.3999999910593,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":293.5,"connectEnd":293.5,"connectStart":293.5,"domainLookupEnd":293.5,"domainLookupStart":293.5,"fetchStart":293.5,"redirectEnd":0,"redirectStart":0,"requestStart":293.5,"responseEnd":787.8999999910593,"responseStart":787.8999999910593,"secureConnectionStart":293.5},{"duration":549.9000000059605,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":293.59999999403954,"connectEnd":293.59999999403954,"connectStart":293.59999999403954,"domainLookupEnd":293.59999999403954,"domainLookupStart":293.59999999403954,"fetchStart":293.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":293.59999999403954,"responseEnd":843.5,"responseStart":843.5,"secureConnectionStart":293.59999999403954},{"duration":554.0999999940395,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":293.79999999701977,"connectEnd":293.79999999701977,"connectStart":293.79999999701977,"domainLookupEnd":293.79999999701977,"domainLookupStart":293.79999999701977,"fetchStart":293.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":293.79999999701977,"responseEnd":847.8999999910593,"responseStart":847.8999999910593,"secureConnectionStart":293.79999999701977},{"duration":554.6000000089407,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":293.8999999910593,"connectEnd":293.8999999910593,"connectStart":293.8999999910593,"domainLookupEnd":293.8999999910593,"domainLookupStart":293.8999999910593,"fetchStart":293.8999999910593,"redirectEnd":0,"redirectStart":0,"requestStart":293.8999999910593,"responseEnd":848.5,"responseStart":848.5,"secureConnectionStart":293.8999999910593},{"duration":555.2000000029802,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":294.19999998807907,"connectEnd":294.19999998807907,"connectStart":294.19999998807907,"domainLookupEnd":294.19999998807907,"domainLookupStart":294.19999998807907,"fetchStart":294.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":294.19999998807907,"responseEnd":849.3999999910593,"responseStart":849.3999999910593,"secureConnectionStart":294.19999998807907},{"duration":636.2999999970198,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":294.29999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":294.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":930.5999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":555.5999999940395,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":294.5,"connectEnd":294.5,"connectStart":294.5,"domainLookupEnd":294.5,"domainLookupStart":294.5,"fetchStart":294.5,"redirectEnd":0,"redirectStart":0,"requestStart":294.5,"responseEnd":850.0999999940395,"responseStart":850.0999999940395,"secureConnectionStart":294.5},{"duration":636.2000000029802,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":294.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":294.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":930.7999999970198,"responseStart":0,"secureConnectionStart":0},{"duration":556,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":294.79999999701977,"connectEnd":294.79999999701977,"connectStart":294.79999999701977,"domainLookupEnd":294.79999999701977,"domainLookupStart":294.79999999701977,"fetchStart":294.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":294.79999999701977,"responseEnd":850.7999999970198,"responseStart":850.7999999970198,"secureConnectionStart":294.79999999701977},{"duration":1478.6000000089407,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":300.8999999910593,"connectEnd":300.8999999910593,"connectStart":300.8999999910593,"domainLookupEnd":300.8999999910593,"domainLookupStart":300.8999999910593,"fetchStart":300.8999999910593,"redirectEnd":0,"redirectStart":0,"requestStart":300.8999999910593,"responseEnd":1779.5,"responseStart":1779.5,"secureConnectionStart":300.8999999910593},{"duration":1479.3999999910593,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":301,"connectEnd":301,"connectStart":301,"domainLookupEnd":301,"domainLookupStart":301,"fetchStart":301,"redirectEnd":0,"redirectStart":0,"requestStart":301,"responseEnd":1780.3999999910593,"responseStart":1780.3999999910593,"secureConnectionStart":301},{"duration":803.9000000059605,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":942.0999999940395,"connectEnd":942.0999999940395,"connectStart":942.0999999940395,"domainLookupEnd":942.0999999940395,"domainLookupStart":942.0999999940395,"fetchStart":942.0999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":942.0999999940395,"responseEnd":1746,"responseStart":1746,"secureConnectionStart":942.0999999940395},{"duration":563,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1233.5999999940395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1233.5999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1796.5999999940395,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":127,"responseStart":288,"responseEnd":299,"domLoading":291,"domInteractive":1802,"domContentLoadedEventStart":1802,"domContentLoadedEventEnd":1842,"domComplete":3412,"loadEventStart":3412,"loadEventEnd":3414,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1784.5999999940395},{"name":"bigPipe.sidebar-id.end","time":1785.199999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":1785.3999999910593},{"name":"bigPipe.activity-panel-pipe-id.end","time":1787.5999999940395},{"name":"activityTabFullyLoaded","time":1850.199999988079}],"measures":[],"correlationId":"c67689ae0f5c13","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":101,"dbReadsTimeInMs":15,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Critical
