Type:
Priority:
Resolution:
Unresolved
Sprint:
Q2/2025 Development
DROP USER deletes specified user, while there is connected session of user deleted. After deletion user is still able to select or modify data in that session. Is that a bug or designed behavior? How can I prevent deleted user from further actions in that session?
Version:11.4.2-MariaDB
{"report":{"fcp":1072.7999999970198,"ttfb":218.69999999552965,"pageVisibility":"visible","entityId":131983,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d5f1fea2-a7fe-4797-afd3-1c34f4aa807e","navigationType":0,"readyForUser":1141.1999999955297,"redirectCount":0,"resourceLoadedEnd":1409.5,"resourceLoadedStart":223.89999999850988,"resourceTiming":[{"duration":368.6000000014901,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":223.89999999850988,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":223.89999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":592.5,"responseStart":0,"secureConnectionStart":0},{"duration":368.6000000014901,"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":224.19999999552965,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.19999999552965,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":592.7999999970198,"responseStart":0,"secureConnectionStart":0},{"duration":377.1000000014901,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":224.29999999701977,"connectEnd":224.29999999701977,"connectStart":224.29999999701977,"domainLookupEnd":224.29999999701977,"domainLookupStart":224.29999999701977,"fetchStart":224.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":224.29999999701977,"responseEnd":601.3999999985099,"responseStart":601.3999999985099,"secureConnectionStart":224.29999999701977},{"duration":417.29999999701977,"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":224.60000000149012,"connectEnd":224.60000000149012,"connectStart":224.60000000149012,"domainLookupEnd":224.60000000149012,"domainLookupStart":224.60000000149012,"fetchStart":224.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":224.60000000149012,"responseEnd":641.8999999985099,"responseStart":641.8999999985099,"secureConnectionStart":224.60000000149012},{"duration":421.20000000298023,"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":224.69999999552965,"connectEnd":224.69999999552965,"connectStart":224.69999999552965,"domainLookupEnd":224.69999999552965,"domainLookupStart":224.69999999552965,"fetchStart":224.69999999552965,"redirectEnd":0,"redirectStart":0,"requestStart":224.69999999552965,"responseEnd":645.8999999985099,"responseStart":645.8999999985099,"secureConnectionStart":224.69999999552965},{"duration":421.6000000014901,"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":225,"connectEnd":225,"connectStart":225,"domainLookupEnd":225,"domainLookupStart":225,"fetchStart":225,"redirectEnd":0,"redirectStart":0,"requestStart":225,"responseEnd":646.6000000014901,"responseStart":646.6000000014901,"secureConnectionStart":225},{"duration":422,"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":225.10000000149012,"connectEnd":225.10000000149012,"connectStart":225.10000000149012,"domainLookupEnd":225.10000000149012,"domainLookupStart":225.10000000149012,"fetchStart":225.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":225.10000000149012,"responseEnd":647.1000000014901,"responseStart":647.1000000014901,"secureConnectionStart":225.10000000149012},{"duration":518.8000000044703,"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":225.29999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":744.1000000014901,"responseStart":0,"secureConnectionStart":0},{"duration":422.19999999552965,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":225.5,"connectEnd":225.5,"connectStart":225.5,"domainLookupEnd":225.5,"domainLookupStart":225.5,"fetchStart":225.5,"redirectEnd":0,"redirectStart":0,"requestStart":225.5,"responseEnd":647.6999999955297,"responseStart":647.6999999955297,"secureConnectionStart":225.5},{"duration":518.6000000014901,"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":225.69999999552965,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225.69999999552965,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":744.2999999970198,"responseStart":0,"secureConnectionStart":0},{"duration":422.6000000014901,"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":225.79999999701977,"connectEnd":225.79999999701977,"connectStart":225.79999999701977,"domainLookupEnd":225.79999999701977,"domainLookupStart":225.79999999701977,"fetchStart":225.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":225.79999999701977,"responseEnd":648.3999999985099,"responseStart":648.3999999985099,"secureConnectionStart":225.79999999701977},{"duration":736.2000000029802,"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":226.89999999850988,"connectEnd":226.89999999850988,"connectStart":226.89999999850988,"domainLookupEnd":226.89999999850988,"domainLookupStart":226.89999999850988,"fetchStart":226.89999999850988,"redirectEnd":0,"redirectStart":0,"requestStart":226.89999999850988,"responseEnd":963.1000000014901,"responseStart":963.1000000014901,"secureConnectionStart":226.89999999850988},{"duration":1182.5,"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":227,"connectEnd":227,"connectStart":227,"domainLookupEnd":227,"domainLookupStart":227,"fetchStart":227,"redirectEnd":0,"redirectStart":0,"requestStart":227,"responseEnd":1409.5,"responseStart":1409.5,"secureConnectionStart":227},{"duration":219.39999999850988,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":755.7999999970198,"connectEnd":755.7999999970198,"connectStart":755.7999999970198,"domainLookupEnd":755.7999999970198,"domainLookupStart":755.7999999970198,"fetchStart":755.7999999970198,"redirectEnd":0,"redirectStart":0,"requestStart":755.7999999970198,"responseEnd":975.1999999955297,"responseStart":975.1999999955297,"secureConnectionStart":755.7999999970198},{"duration":426.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&slack-enabled=true","startTime":1028.3999999985099,"connectEnd":1028.3999999985099,"connectStart":1028.3999999985099,"domainLookupEnd":1028.3999999985099,"domainLookupStart":1028.3999999985099,"fetchStart":1028.3999999985099,"redirectEnd":0,"redirectStart":0,"requestStart":1028.3999999985099,"responseEnd":1454.8999999985099,"responseStart":1454.8999999985099,"secureConnectionStart":1028.3999999985099}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":69,"responseStart":219,"responseEnd":220,"domLoading":222,"domInteractive":1427,"domContentLoadedEventStart":1427,"domContentLoadedEventEnd":1465,"domComplete":3260,"loadEventStart":3260,"loadEventEnd":3262,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1411.3999999985099},{"name":"bigPipe.sidebar-id.end","time":1412.3999999985099},{"name":"bigPipe.activity-panel-pipe-id.start","time":1412.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1414.8999999985099},{"name":"activityTabFullyLoaded","time":1472.2999999970198}],"measures":[],"correlationId":"79809d035355c1","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":97,"dbReadsTimeInMs":9,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Critical
MDEV-36429 Counters of used resources are not reset when account is recreated
MDBF-996 Blog about the idea of disconnecting users after DROP USER