Failed to upgrade from 10.3.9 to 10.4.7
Scenario 1:
Follow normal procedures:
1. install 10.4.7.
2. Start MariaDB on the 10.3.9.
3. Run mysql_upgrade and everything is OK.
4. Restart MariaDB but it hangs. No socket file is generated. "mysqld.err.upgrade" is attached for reference.
Scenario 2:
Use export/import method:
1. install 10.4.7.
2. Start MariaDB on the 10.3.9.
3. Run mysql_upgrade and everything is OK.
4. Run mysqldump to export user database and 'mysql' database data.
5. Run mysql_install_db to create a new a new 'empty' MariaDB server.
6. Import the user database data into the new MariaDB server and restart it sucessfully.
7. import the 'mysql' database data into the new MariaDB server. "mysql_data.sql" is attached for reference.
8. Restart the new server but it hangs. same symptom as scenario 1, no socket file is generated. "mysqld.err.dump" is attached for reference.
9 It can restart MariaDB successfully with --skip-grant-tables option.
It seems that mysql_upgrade cannot ensures that the system tables in the mysql database are fully compatible with the new version. "my.cnf" is attached for reference.
Please advise how to solve the upgrade problem.
- is duplicated by
-
MDEV-19918
Server hangs or crashes while trying to lock mutex when the mutex was already locked upon startup with server_audit and orphan records in mysql.plugin
-
-
Closed
{"report":{"fcp":785,"ttfb":177.29999995231628,"pageVisibility":"visible","entityId":78589,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"ac92b2ea-dfad-4d34-8bc2-cd60a8caf4a0","navigationType":0,"readyForUser":848.5,"redirectCount":0,"resourceLoadedEnd":404.40000009536743,"resourceLoadedStart":186,"resourceTiming":[{"duration":5.200000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":191.20000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":5.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":186.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":191.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":152.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":186.40000009536743,"connectEnd":186.40000009536743,"connectStart":186.40000009536743,"domainLookupEnd":186.40000009536743,"domainLookupStart":186.40000009536743,"fetchStart":186.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":192.40000009536743,"responseEnd":338.5,"responseStart":209.90000009536743,"secureConnectionStart":186.40000009536743},{"duration":217.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":187,"connectEnd":187,"connectStart":187,"domainLookupEnd":187,"domainLookupStart":187,"fetchStart":187,"redirectEnd":0,"redirectStart":0,"requestStart":194,"responseEnd":404.40000009536743,"responseStart":220.70000004768372,"secureConnectionStart":187},{"duration":44.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":187.10000014305115,"connectEnd":187.10000014305115,"connectStart":187.10000014305115,"domainLookupEnd":187.10000014305115,"domainLookupStart":187.10000014305115,"fetchStart":187.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":197.20000004768372,"responseEnd":231.5,"responseStart":226.90000009536743,"secureConnectionStart":187.10000014305115},{"duration":44.799999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":187.20000004768372,"connectEnd":187.20000004768372,"connectStart":187.20000004768372,"domainLookupEnd":187.20000004768372,"domainLookupStart":187.20000004768372,"fetchStart":187.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":198,"responseEnd":232,"responseStart":227.60000014305115,"secureConnectionStart":187.20000004768372},{"duration":45.200000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":187.20000004768372,"connectEnd":187.20000004768372,"connectStart":187.20000004768372,"domainLookupEnd":187.20000004768372,"domainLookupStart":187.20000004768372,"fetchStart":187.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":199.10000014305115,"responseEnd":232.40000009536743,"responseStart":228.29999995231628,"secureConnectionStart":187.20000004768372},{"duration":9.399999856948853,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":187.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":196.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":45.200000047683716,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":187.40000009536743,"connectEnd":187.40000009536743,"connectStart":187.40000009536743,"domainLookupEnd":187.40000009536743,"domainLookupStart":187.40000009536743,"fetchStart":187.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":199.40000009536743,"responseEnd":232.60000014305115,"responseStart":228.90000009536743,"secureConnectionStart":187.40000009536743},{"duration":11.299999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":187.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":198.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":49.299999952316284,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":187.60000014305115,"connectEnd":187.60000014305115,"connectStart":187.60000014305115,"domainLookupEnd":187.60000014305115,"domainLookupStart":187.60000014305115,"fetchStart":187.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":202.29999995231628,"responseEnd":236.90000009536743,"responseStart":233.90000009536743,"secureConnectionStart":187.60000014305115},{"duration":197.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":189.40000009536743,"connectEnd":189.40000009536743,"connectStart":189.40000009536743,"domainLookupEnd":189.40000009536743,"domainLookupStart":189.40000009536743,"fetchStart":189.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":236,"responseEnd":386.7999999523163,"responseStart":382.7999999523163,"secureConnectionStart":189.40000009536743},{"duration":197.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":189.60000014305115,"connectEnd":189.60000014305115,"connectStart":189.60000014305115,"domainLookupEnd":189.60000014305115,"domainLookupStart":189.60000014305115,"fetchStart":189.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":238.20000004768372,"responseEnd":387.10000014305115,"responseStart":383.5,"secureConnectionStart":189.60000014305115},{"duration":243.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":537.7000000476837,"connectEnd":537.7000000476837,"connectStart":537.7000000476837,"domainLookupEnd":537.7000000476837,"domainLookupStart":537.7000000476837,"fetchStart":537.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":721.2000000476837,"responseEnd":781.6000001430511,"responseStart":749.9000000953674,"secureConnectionStart":537.7000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":40,"responseStart":178,"responseEnd":189,"domLoading":181,"domInteractive":903,"domContentLoadedEventStart":903,"domContentLoadedEventEnd":949,"domComplete":1825,"loadEventStart":1825,"loadEventEnd":1825,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":882.7999999523163},{"name":"bigPipe.sidebar-id.end","time":883.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":883.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":885.2000000476837},{"name":"activityTabFullyLoaded","time":962.5}],"measures":[],"correlationId":"641707b156056b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":76,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Major
What does "Start MariaDB on the 10.3.9" mean in both your scenarios? Start MariaDB server 10.3.9, or start MariaDB server 10.4.7 on the database created by 10.3.9, or...?