Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
10.6.10 , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL)
Environment:
query_cache_type = 1
query_cache_size = 64M
CentOS 7
Almalinux 8
Hi,
With MariaDB 10.6 ( no matter of the subversion but tested mostly with 10.6.10 ) when particular query cache is present you are unable to drop database.
You will need the files all.sql and source_db_schema.sql which are attached to this task.
Then just execute from bash console:
mysql -e "create database source_db"
mysql source_db < source_db_schema.sql
mysql -e 'RESET QUERY CACHE' ;
mysql -e "create database destination_db" ; mysqldump source_db | mysql destination_db
mysql 'source_db' -e "select option_name from VbVoptions;" ;
mysql destination_db < all.sql;
mysql -e "drop database destination_db ;"
echo "drop successfully"
source_db_schema.sql
all.sql
In summary if specific query cache is present, you are unable to drop database and it just hangs (MariaDB uses 100% cpu) and no restart ( without "kill -9" ) can be performed .
{"report":{"fcp":924.9000000953674,"ttfb":256,"pageVisibility":"visible","entityId":115417,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"07312b37-5ca0-460c-b989-b0fdc6a6d47e","navigationType":0,"readyForUser":1006.5,"redirectCount":0,"resourceLoadedEnd":883,"resourceLoadedStart":261.5,"resourceTiming":[{"duration":213.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":261.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":475.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":213.70000004768372,"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":261.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":475.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":222.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":261.90000009536743,"connectEnd":261.90000009536743,"connectStart":261.90000009536743,"domainLookupEnd":261.90000009536743,"domainLookupStart":261.90000009536743,"fetchStart":261.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":261.90000009536743,"responseEnd":484.5,"responseStart":484.5,"secureConnectionStart":261.90000009536743},{"duration":311.10000014305115,"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":262,"connectEnd":262,"connectStart":262,"domainLookupEnd":262,"domainLookupStart":262,"fetchStart":262,"redirectEnd":0,"redirectStart":0,"requestStart":262,"responseEnd":573.1000001430511,"responseStart":573.1000001430511,"secureConnectionStart":262},{"duration":314.5,"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":262.10000014305115,"connectEnd":262.10000014305115,"connectStart":262.10000014305115,"domainLookupEnd":262.10000014305115,"domainLookupStart":262.10000014305115,"fetchStart":262.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":262.10000014305115,"responseEnd":576.6000001430511,"responseStart":576.6000001430511,"secureConnectionStart":262.10000014305115},{"duration":315.10000014305115,"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":262.2000000476837,"connectEnd":262.2000000476837,"connectStart":262.2000000476837,"domainLookupEnd":262.2000000476837,"domainLookupStart":262.2000000476837,"fetchStart":262.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":262.2000000476837,"responseEnd":577.3000001907349,"responseStart":577.3000001907349,"secureConnectionStart":262.2000000476837},{"duration":315.5,"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":262.2000000476837,"connectEnd":262.2000000476837,"connectStart":262.2000000476837,"domainLookupEnd":262.2000000476837,"domainLookupStart":262.2000000476837,"fetchStart":262.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":262.2000000476837,"responseEnd":577.7000000476837,"responseStart":577.7000000476837,"secureConnectionStart":262.2000000476837},{"duration":316.19999980926514,"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":262.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":578.5,"responseStart":0,"secureConnectionStart":0},{"duration":316.7000000476837,"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":262.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":579.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":316,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":262.5,"connectEnd":262.5,"connectStart":262.5,"domainLookupEnd":262.5,"domainLookupStart":262.5,"fetchStart":262.5,"redirectEnd":0,"redirectStart":0,"requestStart":262.5,"responseEnd":578.5,"responseStart":578.5,"secureConnectionStart":262.5},{"duration":316.60000014305115,"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":262.7000000476837,"connectEnd":262.7000000476837,"connectStart":262.7000000476837,"domainLookupEnd":262.7000000476837,"domainLookupStart":262.7000000476837,"fetchStart":262.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":262.7000000476837,"responseEnd":579.3000001907349,"responseStart":579.3000001907349,"secureConnectionStart":262.7000000476837},{"duration":618.5999999046326,"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":263.60000014305115,"connectEnd":263.60000014305115,"connectStart":263.60000014305115,"domainLookupEnd":263.60000014305115,"domainLookupStart":263.60000014305115,"fetchStart":263.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":263.60000014305115,"responseEnd":882.2000000476837,"responseStart":882.2000000476837,"secureConnectionStart":263.60000014305115},{"duration":619.3999998569489,"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":263.60000014305115,"connectEnd":263.60000014305115,"connectStart":263.60000014305115,"domainLookupEnd":263.60000014305115,"domainLookupStart":263.60000014305115,"fetchStart":263.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":263.60000014305115,"responseEnd":883,"responseStart":883,"secureConnectionStart":263.60000014305115},{"duration":121,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":633.5,"connectEnd":633.5,"connectStart":633.5,"domainLookupEnd":633.5,"domainLookupStart":633.5,"fetchStart":633.5,"redirectEnd":0,"redirectStart":0,"requestStart":633.5,"responseEnd":754.5,"responseStart":754.5,"secureConnectionStart":633.5}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":23,"responseStart":256,"responseEnd":258,"domLoading":259,"domInteractive":1060,"domContentLoadedEventStart":1060,"domContentLoadedEventEnd":1103,"domComplete":2081,"loadEventStart":2081,"loadEventEnd":2082,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1042.3000001907349},{"name":"bigPipe.sidebar-id.end","time":1043},{"name":"bigPipe.activity-panel-pipe-id.start","time":1043.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.end","time":1045.6000001430511},{"name":"activityTabFullyLoaded","time":1111.4000000953674}],"measures":[],"correlationId":"584e823ca38120","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":176,"dbReadsTimeInMs":109,"dbConnsTimeInMs":116,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}