A Spider test wrongly depends on the contents of /etc/mysql/mariadb.conf.d. On my Debian GNU/Linux Sid (unstable) system, I had files in that directory installed by the following packages:
sudo apt purge mariadb-common mariadb-client-10.3
|
./mtr spider/bugfix.return_found_rows_update
|
sudo apt install mariadb-common mariadb-client-10.3
|
./mtr spider/bugfix.return_found_rows_update
|
The two files /etc/mysql/mariadb.conf.d/50-client.cnf and /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf include the setting
default-character-set = utf8mb4
|
which affects the test result. Side note: I will need the following fix in order to be able to compile Spider using clang++-10. It would fail due to {{ -Wsometimes-uninitialized}}:
diff --git a/storage/spider/spd_db_conn.cc b/storage/spider/spd_db_conn.cc
|
index afdd3a4c828..7b61678dabd 100644
|
--- a/storage/spider/spd_db_conn.cc
|
+++ b/storage/spider/spd_db_conn.cc
|
@@ -5861,6 +5861,7 @@ int spider_db_simple_action(
|
#endif
|
default:
|
DBUG_ASSERT(0);
|
+ error_num= -1;
|
break;
|
}
|
DBUG_RETURN(error_num);
|
The test fails for me with the following result difference:
CURRENT_TEST: spider/bugfix.return_found_rows_update
|
--- /mariadb/10.4/storage/spider/mysql-test/spider/bugfix/r/return_found_rows_update.result 2020-02-06 12:50:30.534105414 +0200
|
+++ /mariadb/10.4/storage/spider/mysql-test/spider/bugfix/r/return_found_rows_update.reject 2020-03-24 08:55:55.829888665 +0200
|
@@ -48,7 +48,7 @@
|
connection child2_1;
|
SELECT argument FROM mysql.general_log WHERE argument LIKE '%update %';
|
argument
|
-update `auto_test_remote`.`tbl_a` set `tm` = _latin1'12:00:00' where (`skey` = 0)
|
+update `auto_test_remote`.`tbl_a` set `tm` = _utf8mb4'12:00:00' where (`skey` = 0)
|
SELECT argument FROM mysql.general_log WHERE argument LIKE '%update %'
|
SELECT skey, dt, tm FROM tbl_a ORDER BY skey;
|
skey dt tm
|
|
mysqltest: Result length mismatch
|
If I purge the packages from Debian, then the test would pass.
Apparently, this test is not being run on buildbot, because the buildbot cross-reference has no data on this test.
| Transition |
Time In Source Status |
Execution Times |
|
Open |
|
Closed |
|
52m 15s
|
1
|
{"report":{"fcp":802,"ttfb":266.90000009536743,"pageVisibility":"visible","entityId":84482,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"9989506c-5b1d-4f5c-9816-6bf852ba6d97","navigationType":0,"readyForUser":866,"redirectCount":0,"resourceLoadedEnd":677.0999999046326,"resourceLoadedStart":272.09999990463257,"resourceTiming":[{"duration":24.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":272.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":272.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":296.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":24.299999713897705,"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":272.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":272.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":296.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":77,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":272.5,"connectEnd":272.5,"connectStart":272.5,"domainLookupEnd":272.5,"domainLookupStart":272.5,"fetchStart":272.5,"redirectEnd":0,"redirectStart":0,"requestStart":304.69999980926514,"responseEnd":349.5,"responseStart":316.7999997138977,"secureConnectionStart":272.5},{"duration":103.5,"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":272.59999990463257,"connectEnd":272.59999990463257,"connectStart":272.59999990463257,"domainLookupEnd":272.59999990463257,"domainLookupStart":272.59999990463257,"fetchStart":272.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":304.69999980926514,"responseEnd":376.09999990463257,"responseStart":317.69999980926514,"secureConnectionStart":272.59999990463257},{"duration":58.80000019073486,"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":272.69999980926514,"connectEnd":272.69999980926514,"connectStart":272.69999980926514,"domainLookupEnd":272.69999980926514,"domainLookupStart":272.69999980926514,"fetchStart":272.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":306.2999997138977,"responseEnd":331.5,"responseStart":330.90000009536743,"secureConnectionStart":272.69999980926514},{"duration":60.700000286102295,"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":272.7999997138977,"connectEnd":272.7999997138977,"connectStart":272.7999997138977,"domainLookupEnd":272.7999997138977,"domainLookupStart":272.7999997138977,"fetchStart":272.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":308.09999990463257,"responseEnd":333.5,"responseStart":332.7999997138977,"secureConnectionStart":272.7999997138977},{"duration":57.799999713897705,"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":272.90000009536743,"connectEnd":272.90000009536743,"connectStart":272.90000009536743,"domainLookupEnd":272.90000009536743,"domainLookupStart":272.90000009536743,"fetchStart":272.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":308.19999980926514,"responseEnd":330.69999980926514,"responseStart":329.90000009536743,"secureConnectionStart":272.90000009536743},{"duration":35,"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":273,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":308,"responseStart":0,"secureConnectionStart":0},{"duration":36.09999990463257,"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":273.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":273.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":309.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":63.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":273.19999980926514,"connectEnd":273.19999980926514,"connectStart":273.19999980926514,"domainLookupEnd":273.19999980926514,"domainLookupStart":273.19999980926514,"fetchStart":273.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":311.2999997138977,"responseEnd":336.7999997138977,"responseStart":336,"secureConnectionStart":273.19999980926514},{"duration":68.5,"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":273.2999997138977,"connectEnd":273.2999997138977,"connectStart":273.2999997138977,"domainLookupEnd":273.2999997138977,"domainLookupStart":273.2999997138977,"fetchStart":273.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":313.59999990463257,"responseEnd":341.7999997138977,"responseStart":340.2999997138977,"secureConnectionStart":273.2999997138977},{"duration":384.59999990463257,"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":286.90000009536743,"connectEnd":286.90000009536743,"connectStart":286.90000009536743,"domainLookupEnd":286.90000009536743,"domainLookupStart":286.90000009536743,"fetchStart":286.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":388.59999990463257,"responseEnd":671.5,"responseStart":665.4000000953674,"secureConnectionStart":286.90000009536743},{"duration":382.90000009536743,"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":294.19999980926514,"connectEnd":294.19999980926514,"connectStart":294.19999980926514,"domainLookupEnd":294.19999980926514,"domainLookupStart":294.19999980926514,"fetchStart":294.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":567.4000000953674,"responseEnd":677.0999999046326,"responseStart":673.4000000953674,"secureConnectionStart":294.19999980926514},{"duration":213.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":559.0999999046326,"connectEnd":559.0999999046326,"connectStart":559.0999999046326,"domainLookupEnd":559.0999999046326,"domainLookupStart":559.0999999046326,"fetchStart":559.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":739.6999998092651,"responseEnd":772.5999999046326,"responseStart":771.5999999046326,"secureConnectionStart":559.0999999046326},{"duration":167,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":778.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":778.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":945.5999999046326,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":138,"responseStart":267,"responseEnd":294,"domLoading":270,"domInteractive":917,"domContentLoadedEventStart":917,"domContentLoadedEventEnd":951,"domComplete":1647,"loadEventStart":1647,"loadEventEnd":1648,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":900.9000000953674},{"name":"bigPipe.sidebar-id.end","time":901.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":901.7999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":902.7999997138977},{"name":"activityTabFullyLoaded","time":964}],"measures":[],"correlationId":"f60cd4fa5e4959","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":70,"dbReadsTimeInMs":12,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major