This used to be bug http://bugs.mysql.com/bug.php?id=55983 in MySQL
While running in MTR-1 mode, MTR produces bootsrap SQL file starting with
"use mysql-- Copyright ..."
(no semicolon and line break after 'use mysql')
While earlier the syntax was accepted and handled, with the new implementation of server bootstrap it is not anymore, which makes server startup fail.
It might be a problem for those who uses runall.pl RQG script (unlike runall-new.pl, it still uses MTR1 to start server)
How to repeat:
export MTR_VERSION=1
|
perl ./mysql-test-run.pl main.1st
|
Fix (for 10.0-serg revno 3452):
=== modified file 'mysql-test/lib/v1/mysql-test-run.pl'
|
--- mysql-test/lib/v1/mysql-test-run.pl 2012-01-13 14:50:02 +0000
|
+++ mysql-test/lib/v1/mysql-test-run.pl 2012-10-29 01:46:12 +0000
|
@@ -3223,7 +3223,7 @@
|
my $bootstrap_sql_file= "$opt_vardir/tmp/bootstrap.sql";
|
|
# Use the mysql database for system tables
|
- mtr_tofile($bootstrap_sql_file, "use mysql");
|
+ mtr_tofile($bootstrap_sql_file, "use mysql;\n");
|
|
# Add the offical mysql system tables
|
# for a production system
|
There are no comments yet on this issue.
{"report":{"fcp":1046.2000002861023,"ttfb":257.1000003814697,"pageVisibility":"visible","entityId":21609,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"10979eb1-2583-44ba-928c-0346a29df0fc","navigationType":0,"readyForUser":1124.3000001907349,"redirectCount":0,"resourceLoadedEnd":1257.4000000953674,"resourceLoadedStart":262.40000009536743,"resourceTiming":[{"duration":252.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":262.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":514.5,"responseStart":0,"secureConnectionStart":0},{"duration":252.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":262.7000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":514.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":263.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":262.90000009536743,"connectEnd":262.90000009536743,"connectStart":262.90000009536743,"domainLookupEnd":262.90000009536743,"domainLookupStart":262.90000009536743,"fetchStart":262.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":262.90000009536743,"responseEnd":526.6000003814697,"responseStart":526.6000003814697,"secureConnectionStart":262.90000009536743},{"duration":349.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":263,"connectEnd":263,"connectStart":263,"domainLookupEnd":263,"domainLookupStart":263,"fetchStart":263,"redirectEnd":0,"redirectStart":0,"requestStart":263,"responseEnd":612.9000000953674,"responseStart":612.8000001907349,"secureConnectionStart":263},{"duration":353.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":263.2000002861023,"connectEnd":263.2000002861023,"connectStart":263.2000002861023,"domainLookupEnd":263.2000002861023,"domainLookupStart":263.2000002861023,"fetchStart":263.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":263.2000002861023,"responseEnd":616.9000000953674,"responseStart":616.9000000953674,"secureConnectionStart":263.2000002861023},{"duration":353.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":263.5,"connectEnd":263.5,"connectStart":263.5,"domainLookupEnd":263.5,"domainLookupStart":263.5,"fetchStart":263.5,"redirectEnd":0,"redirectStart":0,"requestStart":263.5,"responseEnd":617.3000001907349,"responseStart":617.3000001907349,"secureConnectionStart":263.5},{"duration":354.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":263.6000003814697,"connectEnd":263.6000003814697,"connectStart":263.6000003814697,"domainLookupEnd":263.6000003814697,"domainLookupStart":263.6000003814697,"fetchStart":263.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":263.6000003814697,"responseEnd":617.7000002861023,"responseStart":617.7000002861023,"secureConnectionStart":263.6000003814697},{"duration":407.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":263.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":263.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":671.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":354.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":264,"connectEnd":264,"connectStart":264,"domainLookupEnd":264,"domainLookupStart":264,"fetchStart":264,"redirectEnd":0,"redirectStart":0,"requestStart":264,"responseEnd":618.1000003814697,"responseStart":618.1000003814697,"secureConnectionStart":264},{"duration":407.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":264.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":264.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":672,"responseStart":0,"secureConnectionStart":0},{"duration":354.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":264.30000019073486,"connectEnd":264.30000019073486,"connectStart":264.30000019073486,"domainLookupEnd":264.30000019073486,"domainLookupStart":264.30000019073486,"fetchStart":264.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":264.30000019073486,"responseEnd":618.8000001907349,"responseStart":618.8000001907349,"secureConnectionStart":264.30000019073486},{"duration":570.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":265.1000003814697,"connectEnd":265.1000003814697,"connectStart":265.1000003814697,"domainLookupEnd":265.1000003814697,"domainLookupStart":265.1000003814697,"fetchStart":265.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":265.1000003814697,"responseEnd":835.7000002861023,"responseStart":835.7000002861023,"secureConnectionStart":265.1000003814697},{"duration":991.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":265.1000003814697,"connectEnd":265.1000003814697,"connectStart":265.1000003814697,"domainLookupEnd":265.1000003814697,"domainLookupStart":265.1000003814697,"fetchStart":265.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":265.1000003814697,"responseEnd":1256.4000000953674,"responseStart":1256.4000000953674,"secureConnectionStart":265.1000003814697},{"duration":152.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":683.6000003814697,"connectEnd":683.6000003814697,"connectStart":683.6000003814697,"domainLookupEnd":683.6000003814697,"domainLookupStart":683.6000003814697,"fetchStart":683.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":683.6000003814697,"responseEnd":836.1000003814697,"responseStart":836,"secureConnectionStart":683.6000003814697},{"duration":313.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":944.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":944.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1257.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":312.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":944.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":944.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1257.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":362.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":945.5,"connectEnd":945.5,"connectStart":945.5,"domainLookupEnd":945.5,"domainLookupStart":945.5,"fetchStart":945.5,"redirectEnd":0,"redirectStart":0,"requestStart":945.5,"responseEnd":1307.9000000953674,"responseStart":1307.9000000953674,"secureConnectionStart":945.5},{"duration":366.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":945.9000000953674,"connectEnd":945.9000000953674,"connectStart":945.9000000953674,"domainLookupEnd":945.9000000953674,"domainLookupStart":945.9000000953674,"fetchStart":945.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":945.9000000953674,"responseEnd":1312.4000000953674,"responseStart":1312.4000000953674,"secureConnectionStart":945.9000000953674},{"duration":367.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/e0bf5781d46ea69fb123572974cf39de-CDN/lu2cib/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":946.1000003814697,"connectEnd":946.1000003814697,"connectStart":946.1000003814697,"domainLookupEnd":946.1000003814697,"domainLookupStart":946.1000003814697,"fetchStart":946.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":946.1000003814697,"responseEnd":1313.8000001907349,"responseStart":1313.8000001907349,"secureConnectionStart":946.1000003814697}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":110,"responseStart":257,"responseEnd":260,"domLoading":260,"domInteractive":1281,"domContentLoadedEventStart":1281,"domContentLoadedEventEnd":1319,"domComplete":1823,"loadEventStart":1823,"loadEventEnd":1824,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1266.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1267.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.start","time":1267.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1268.4000000953674},{"name":"activityTabFullyLoaded","time":1325.8000001907349}],"measures":[],"correlationId":"46cd1afc82ba31","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":87,"dbReadsTimeInMs":9,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Minor