$ perl ./mtr sys_vars.secure_file_priv --mem
|
Logging: ./mtr sys_vars.secure_file_priv --mem
|
vardir: /home/elenst/maria-5.5/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory '/home/elenst/maria-5.5/mysql-test/var'...
|
- symlinking 'var' to '/dev/shm/var_auto_37xY'
|
Checking supported features...
|
MariaDB Version 5.5.29-MariaDB-debug
|
Installing system database...
|
- skipping ndbcluster
|
- SSL connections supported
|
- binaries are debug compiled
|
Collecting tests...
|
Using server port 38181
|
|
==============================================================================
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
sys_vars.secure_file_priv [ fail ]
|
Test ended at 2013-01-21 16:08:46
|
|
CURRENT_TEST: sys_vars.secure_file_priv
|
/home/elenst/maria-5.5/client/mysqltest: Error on delete of '/home/elenst/maria-5.5/mysql-test/var/mysqld.1/data//../../../bug50373.txt' (Errcode: 2)
|
mysqltest: At line 19: command "remove_file" failed with error: 1 my_errno: 2 errno: 2
|
|
The result from queries just before the failure was:
|
< snip >
|
# Bug50373 --secure-file-priv=""
|
#
|
CREATE TABLE t1 (c1 VARCHAR(50));
|
INSERT INTO t1 VALUES ("one"),("two"),("three"),("four"),("five");
|
SHOW VARIABLES LIKE 'secure_file_priv';
|
Variable_name Value
|
secure_file_priv
|
test/var/mysqld.1/data//../../../bug50373.txt
|
c1
|
one
|
two
|
three
|
four
|
five
|
loaded_file
|
NULL
|
|
More results from queries before failure can be found in /home/elenst/maria-5.5/mysql-test/var/log/secure_file_priv.log
|
{"report":{"fcp":765.6999998092651,"ttfb":180.5999994277954,"pageVisibility":"visible","entityId":22701,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"3cc46484-509b-4869-8af8-8926ef7c1e9f","navigationType":0,"readyForUser":845,"redirectCount":0,"resourceLoadedEnd":888.6999998092651,"resourceLoadedStart":186.30000019073486,"resourceTiming":[{"duration":8.09999942779541,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":186.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":194.39999961853027,"responseStart":0,"secureConnectionStart":0},{"duration":8,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":186.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":194.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":61,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":186.89999961853027,"connectEnd":186.89999961853027,"connectStart":186.89999961853027,"domainLookupEnd":186.89999961853027,"domainLookupStart":186.89999961853027,"fetchStart":186.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":186.89999961853027,"responseEnd":247.89999961853027,"responseStart":247.89999961853027,"secureConnectionStart":186.89999961853027},{"duration":143.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":187,"responseEnd":330.8999996185303,"responseStart":330.8999996185303,"secureConnectionStart":187},{"duration":147.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":187.19999980926514,"connectEnd":187.19999980926514,"connectStart":187.19999980926514,"domainLookupEnd":187.19999980926514,"domainLookupStart":187.19999980926514,"fetchStart":187.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":187.19999980926514,"responseEnd":335,"responseStart":335,"secureConnectionStart":187.19999980926514},{"duration":148,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":187.5,"connectEnd":187.5,"connectStart":187.5,"domainLookupEnd":187.5,"domainLookupStart":187.5,"fetchStart":187.5,"redirectEnd":0,"redirectStart":0,"requestStart":187.5,"responseEnd":335.5,"responseStart":335.5,"secureConnectionStart":187.5},{"duration":148.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":187.5999994277954,"connectEnd":187.5999994277954,"connectStart":187.5999994277954,"domainLookupEnd":187.5999994277954,"domainLookupStart":187.5999994277954,"fetchStart":187.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":187.5999994277954,"responseEnd":336,"responseStart":336,"secureConnectionStart":187.5999994277954},{"duration":205.4000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":187.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":187.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":393.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":149,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":188,"connectEnd":188,"connectStart":188,"domainLookupEnd":188,"domainLookupStart":188,"fetchStart":188,"redirectEnd":0,"redirectStart":0,"requestStart":188,"responseEnd":337,"responseStart":337,"secureConnectionStart":188},{"duration":205.0999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":188.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":188.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":393.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":149.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":188.39999961853027,"connectEnd":188.39999961853027,"connectStart":188.39999961853027,"domainLookupEnd":188.39999961853027,"domainLookupStart":188.39999961853027,"fetchStart":188.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":188.39999961853027,"responseEnd":337.80000019073486,"responseStart":337.80000019073486,"secureConnectionStart":188.39999961853027},{"duration":360.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":189.19999980926514,"connectEnd":189.19999980926514,"connectStart":189.19999980926514,"domainLookupEnd":189.19999980926514,"domainLookupStart":189.19999980926514,"fetchStart":189.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":189.19999980926514,"responseEnd":550,"responseStart":550,"secureConnectionStart":189.19999980926514},{"duration":599.8000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":193.5,"connectEnd":193.5,"connectStart":193.5,"domainLookupEnd":193.5,"domainLookupStart":193.5,"fetchStart":193.5,"redirectEnd":0,"redirectStart":0,"requestStart":193.5,"responseEnd":793.3000001907349,"responseStart":793.3000001907349,"secureConnectionStart":193.5},{"duration":145.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":405.19999980926514,"connectEnd":405.19999980926514,"connectStart":405.19999980926514,"domainLookupEnd":405.19999980926514,"domainLookupStart":405.19999980926514,"fetchStart":405.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":405.19999980926514,"responseEnd":550.6999998092651,"responseStart":550.6999998092651,"secureConnectionStart":405.19999980926514},{"duration":194.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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","startTime":681.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":681.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":876,"responseStart":0,"secureConnectionStart":0},{"duration":201.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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","startTime":682.5999994277954,"connectEnd":682.5999994277954,"connectStart":682.5999994277954,"domainLookupEnd":682.5999994277954,"domainLookupStart":682.5999994277954,"fetchStart":682.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":682.5999994277954,"responseEnd":883.8999996185303,"responseStart":883.8999996185303,"secureConnectionStart":682.5999994277954},{"duration":205.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/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","startTime":683,"connectEnd":683,"connectStart":683,"domainLookupEnd":683,"domainLookupStart":683,"fetchStart":683,"redirectEnd":0,"redirectStart":0,"requestStart":683,"responseEnd":888.6999998092651,"responseStart":888.6999998092651,"secureConnectionStart":683},{"duration":191.29999923706055,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":759.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":759.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":950.5999994277954,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":27,"responseStart":181,"responseEnd":187,"domLoading":184,"domInteractive":903,"domContentLoadedEventStart":903,"domContentLoadedEventEnd":945,"domComplete":1683,"loadEventStart":1683,"loadEventEnd":1685,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":890.3999996185303},{"name":"bigPipe.sidebar-id.end","time":891.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":891.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":893.8999996185303},{"name":"activityTabFullyLoaded","time":957.8999996185303}],"measures":[],"correlationId":"7895cc70dd5a0b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":86,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}