Type:
Priority:
Resolution:
Unresolved
Fix Version/s:
None
After restore with mariabackup --copy-back the files have to be chown'd because in the majority of cases the restore is performed as O/S user root and not as O/S user mysql.
This is an additional unnecessary error prone step. It would be really nice if mariabackup would store the ownership (and also umask?) of each file during backup and would also restore those owenerships during restore.
Should note be a big deal...
See also: MDEV-14976 MDEV-16076
made changes -
2021-01-31 19:24
Affects Version/s
10.5
[ 23123
]
Affects Version/s
10.6
[ 24028
]
Environment
n.a.
Issue Type
Bug
[ 1
]
Task
[ 3
]
made changes -
2021-12-06 21:21
Workflow
MariaDB v3
[ 118575
]
MariaDB v4
[ 131444
]
made changes -
2024-10-01 08:11
Issue Type
Task
[ 3
]
New Feature
[ 2
]
made changes -
2025-02-14 20:07
Summary
Feature Request: mariabackup should memorize ownership of files
mariabackup should memorize ownership of files
made changes -
2025-02-14 20:07
Description
After restore with mariabackup --copy-back the files have to be chown'd because in the majority of cases the restore is performed as O/S user root and not as O/S user mysql.
https://jira.mariadb.org/browse/MDEV-14976
https://jira.mariadb.org/browse/MDEV-16076
After restore with mariabackup --copy-back the files have to be chown'd because in the majority of cases the restore is performed as O/S user root and not as O/S user mysql.
MDEV-14976 MDEV-16076
{"report":{"fcp":1531.4000000953674,"ttfb":341.30000019073486,"pageVisibility":"visible","entityId":96369,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"5e108974-c92c-494e-b232-808f2ac25523","navigationType":0,"readyForUser":1615.7000002861023,"redirectCount":0,"resourceLoadedEnd":2248.4000000953674,"resourceLoadedStart":349.5,"resourceTiming":[{"duration":519.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":349.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":349.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":869,"responseStart":0,"secureConnectionStart":0},{"duration":519.5999999046326,"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":349.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":349.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":869.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":533.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":350,"connectEnd":350,"connectStart":350,"domainLookupEnd":350,"domainLookupStart":350,"fetchStart":350,"redirectEnd":0,"redirectStart":0,"requestStart":350,"responseEnd":883.4000000953674,"responseStart":883.4000000953674,"secureConnectionStart":350},{"duration":666.1999998092651,"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":350.2000002861023,"connectEnd":350.2000002861023,"connectStart":350.2000002861023,"domainLookupEnd":350.2000002861023,"domainLookupStart":350.2000002861023,"fetchStart":350.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":350.2000002861023,"responseEnd":1016.4000000953674,"responseStart":1016.4000000953674,"secureConnectionStart":350.2000002861023},{"duration":671.5,"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":350.40000009536743,"connectEnd":350.40000009536743,"connectStart":350.40000009536743,"domainLookupEnd":350.40000009536743,"domainLookupStart":350.40000009536743,"fetchStart":350.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":350.40000009536743,"responseEnd":1021.9000000953674,"responseStart":1021.9000000953674,"secureConnectionStart":350.40000009536743},{"duration":672.9000000953674,"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":350.59999990463257,"connectEnd":350.59999990463257,"connectStart":350.59999990463257,"domainLookupEnd":350.59999990463257,"domainLookupStart":350.59999990463257,"fetchStart":350.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":350.59999990463257,"responseEnd":1023.5,"responseStart":1023.5,"secureConnectionStart":350.59999990463257},{"duration":673.7999997138977,"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":350.7000002861023,"connectEnd":350.7000002861023,"connectStart":350.7000002861023,"domainLookupEnd":350.7000002861023,"domainLookupStart":350.7000002861023,"fetchStart":350.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":350.7000002861023,"responseEnd":1024.5,"responseStart":1024.5,"secureConnectionStart":350.7000002861023},{"duration":770.8000001907349,"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":350.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":350.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1121.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":674.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":351.09999990463257,"connectEnd":351.09999990463257,"connectStart":351.09999990463257,"domainLookupEnd":351.09999990463257,"domainLookupStart":351.09999990463257,"fetchStart":351.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":351.09999990463257,"responseEnd":1026,"responseStart":1026,"secureConnectionStart":351.09999990463257},{"duration":770.4000000953674,"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":351.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":351.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1121.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":675.8000001907349,"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":351.59999990463257,"connectEnd":351.59999990463257,"connectStart":351.59999990463257,"domainLookupEnd":351.59999990463257,"domainLookupStart":351.59999990463257,"fetchStart":351.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":351.59999990463257,"responseEnd":1027.4000000953674,"responseStart":1027.4000000953674,"secureConnectionStart":351.59999990463257},{"duration":1034.0999999046326,"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":352.7000002861023,"connectEnd":352.7000002861023,"connectStart":352.7000002861023,"domainLookupEnd":352.7000002861023,"domainLookupStart":352.7000002861023,"fetchStart":352.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":352.7000002861023,"responseEnd":1386.8000001907349,"responseStart":1386.8000001907349,"secureConnectionStart":352.7000002861023},{"duration":1892.9000000953674,"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":355.5,"connectEnd":355.5,"connectStart":355.5,"domainLookupEnd":355.5,"domainLookupStart":355.5,"fetchStart":355.5,"redirectEnd":0,"redirectStart":0,"requestStart":355.5,"responseEnd":2248.4000000953674,"responseStart":2248.4000000953674,"secureConnectionStart":355.5},{"duration":252.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1139.3000001907349,"connectEnd":1139.3000001907349,"connectStart":1139.3000001907349,"domainLookupEnd":1139.3000001907349,"domainLookupStart":1139.3000001907349,"fetchStart":1139.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1139.3000001907349,"responseEnd":1391.9000000953674,"responseStart":1391.9000000953674,"secureConnectionStart":1139.3000001907349}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":172,"responseStart":341,"responseEnd":344,"domLoading":345,"domInteractive":2290,"domContentLoadedEventStart":2290,"domContentLoadedEventEnd":2346,"domComplete":2789,"loadEventStart":2789,"loadEventEnd":2790,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2259.5},{"name":"bigPipe.sidebar-id.end","time":2260.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":2260.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":2263.0999999046326},{"name":"activityTabFullyLoaded","time":2366}],"measures":[],"correlationId":"dcf14cd55b9e9b","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":21,"dbConnsTimeInMs":31,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Minor
MDEV-14976 Service mysql fail to start after restoring from mariabackup
