-
Task
-
-
Major
-
Resolution:
Fixed
-
-
-
Currently mtr doc doesn't have xml-report option documented. It is related to:
xml-report=<file> Output jUnit xml file of the results.
|
The feature is added with MDEV-22176 pushed to 10.1.45, 10.2.32, 10.3.23, 10.4.13, 10.5.3 with commit 5720db2b4349.
Example of the call:
$ ./mtr alias --xml-report=mtr.xml
|
$ cat mysql-test/mtr.xml
|
<?xml version="1.0" encoding="UTF-8"?>
|
<testsuites disabled="0" errors="" failures="0" name="" tests="1" time="0.040">
|
<testsuite disabled="" errors="" failures="" hostname="anel" id="0" name="main" package="" skipped="" tests="1" time="0.040" timestamp="2021-02-01T10:03:01Z">
|
<testcase assertions="" classname="main" name="alias" status="MTR_RES_PASSED" time="0.040" />
|
</testsuite>
|
</testsuites>
|
tail-lines are added with commit f43726a15da3 in 10.3.4, 10.4.0, 10.5.0
tail-lines=N Number of lines of the result to include in a failure report.
|
Example:
We can inspect from stdout or mysql-test/var/log/stdout.log
$ ./mysql-test/mtr alias # failure after <snip> there are 20 lines (default)
|
|
The result from queries just before the failure was:
|
< snip >
|
(select t2.* from t2)
|
99
|
99
|
select a, (select t2.* from t2) from t1;
|
a (select t2.* from t2)
|
1 99
|
11 99
|
select t1.*, (select t2.* from t2) from t1;
|
a b c (select t2.* from t2)
|
1 2 3 99
|
11 22 33 99
|
insert into t3 select t1.* from t1;
|
insert into t3 select t2.*, 1, 2 from t2;
|
insert into t3 select t2.*, d as 'x', d as 'z' from t2;
|
insert into t3 select t2.*, t2.*, 3 from t2;
|
create table t4 select t1.* from t1;
|
drop table t4;
|
create table t4 select t2.*, 1, 2 from t2;
|
drop table t4;
|
create table t4 select t2.*, d as 'x', d as 'z' from tt;
|
|
|
|
$ ./mysql-test/mtr alias --tail-lines=3 # failure after <snip> there are 3 lines (as set)
|
|
The result from queries just before the failure was:
|
< snip >
|
create table t4 select t2.*, 1, 2 from t2;
|
drop table t4;
|
create table t4 select t2.*, d as 'x', d as 'z' from tt;
|
Or the same information we can get from mysql-test/var/log/mysqltest.log
- relates to
-
MDEV-22176
Add JUnit support to MTR to generate XML test result
-
-
Closed
There are no comments yet on this issue.
{"report":{"fcp":1031.2000000476837,"ttfb":480.7000000476837,"pageVisibility":"visible","entityId":96472,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"e58b34b4-cafb-49f0-a80b-813b09c529ec","navigationType":0,"readyForUser":1093.2999999523163,"redirectCount":0,"resourceLoadedEnd":933.6000001430511,"resourceLoadedStart":487,"resourceTiming":[{"duration":71.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":487,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":487,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":558.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":71.10000014305115,"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":487.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":487.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":558.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":83.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":487.40000009536743,"connectEnd":487.40000009536743,"connectStart":487.40000009536743,"domainLookupEnd":487.40000009536743,"domainLookupStart":487.40000009536743,"fetchStart":487.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":487.40000009536743,"responseEnd":571,"responseStart":571,"secureConnectionStart":487.40000009536743},{"duration":149.20000004768372,"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":487.5,"connectEnd":487.5,"connectStart":487.5,"domainLookupEnd":487.5,"domainLookupStart":487.5,"fetchStart":487.5,"redirectEnd":0,"redirectStart":0,"requestStart":487.5,"responseEnd":636.7000000476837,"responseStart":636.7000000476837,"secureConnectionStart":487.5},{"duration":145.40000009536743,"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":487.5,"connectEnd":487.5,"connectStart":487.5,"domainLookupEnd":487.5,"domainLookupStart":487.5,"fetchStart":487.5,"redirectEnd":0,"redirectStart":0,"requestStart":487.5,"responseEnd":632.9000000953674,"responseStart":632.9000000953674,"secureConnectionStart":487.5},{"duration":149.5,"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":487.7000000476837,"connectEnd":487.7000000476837,"connectStart":487.7000000476837,"domainLookupEnd":487.7000000476837,"domainLookupStart":487.7000000476837,"fetchStart":487.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":487.7000000476837,"responseEnd":637.2000000476837,"responseStart":637.2000000476837,"secureConnectionStart":487.7000000476837},{"duration":150.20000004768372,"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":487.7000000476837,"connectEnd":487.7000000476837,"connectStart":487.7000000476837,"domainLookupEnd":487.7000000476837,"domainLookupStart":487.7000000476837,"fetchStart":487.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":487.7000000476837,"responseEnd":637.9000000953674,"responseStart":637.9000000953674,"secureConnectionStart":487.7000000476837},{"duration":150.29999995231628,"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":487.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":487.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":638.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":150.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":488,"connectEnd":488,"connectStart":488,"domainLookupEnd":488,"domainLookupStart":488,"fetchStart":488,"redirectEnd":0,"redirectStart":0,"requestStart":488,"responseEnd":638.4000000953674,"responseStart":638.4000000953674,"secureConnectionStart":488},{"duration":150.69999980926514,"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":488.10000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":488.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":638.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":150.70000004768372,"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":488.2000000476837,"connectEnd":488.2000000476837,"connectStart":488.2000000476837,"domainLookupEnd":488.2000000476837,"domainLookupStart":488.2000000476837,"fetchStart":488.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":488.2000000476837,"responseEnd":638.9000000953674,"responseStart":638.9000000953674,"secureConnectionStart":488.2000000476837},{"duration":427.7000000476837,"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":493.2999999523163,"connectEnd":493.2999999523163,"connectStart":493.2999999523163,"domainLookupEnd":493.2999999523163,"domainLookupStart":493.2999999523163,"fetchStart":493.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":493.2999999523163,"responseEnd":921,"responseStart":921,"secureConnectionStart":493.2999999523163},{"duration":440.2000000476837,"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":493.40000009536743,"connectEnd":493.40000009536743,"connectStart":493.40000009536743,"domainLookupEnd":493.40000009536743,"domainLookupStart":493.40000009536743,"fetchStart":493.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":493.40000009536743,"responseEnd":933.6000001430511,"responseStart":933.6000001430511,"secureConnectionStart":493.40000009536743},{"duration":148.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":780.7999999523163,"connectEnd":780.7999999523163,"connectStart":780.7999999523163,"domainLookupEnd":780.7999999523163,"domainLookupStart":780.7999999523163,"fetchStart":780.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":780.7999999523163,"responseEnd":929.2000000476837,"responseStart":929.2000000476837,"secureConnectionStart":780.7999999523163},{"duration":2.1000001430511475,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":949.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":949.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":951.9000000953674,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":40,"responseStart":481,"responseEnd":489,"domLoading":485,"domInteractive":1145,"domContentLoadedEventStart":1145,"domContentLoadedEventEnd":1178,"domComplete":1589,"loadEventStart":1589,"loadEventEnd":1590,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1130.9000000953674},{"name":"bigPipe.sidebar-id.end","time":1131.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1131.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1132.2999999523163},{"name":"activityTabFullyLoaded","time":1185}],"measures":[],"correlationId":"e5d588bfeedd1","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":357,"dbReadsTimeInMs":8,"dbConnsTimeInMs":14,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}