I have custom tmpdir defined in /etc/my.cnf which has worked fine on MariaDB 5.2/5.5/10.0 and up to 10.1.14 and even on bugged 10.1.15. Downgrading back to 10.1.14 works and restarts mysql fine
But on upgrade from 10.1.14 to 10.1.16, mysql server doesn't start up at all and i get the complaint of
Jul 19 15:59:33 centos7 mysqld: 2016-07-19 15:59:33 140702605535360 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ibrjyVha' (Errcode: 13 "Permission denied")
|
Jul 19 15:59:33 centos7 mysqld: 2016-07-19 15:59:33 7ff7e0d26880 InnoDB: Error: unable to create temporary file; errno: 13
|
permissions
stat /tmp /home/mysqltmp/
|
File: ‘/tmp’
|
Size: 4096 Blocks: 8 IO Block: 4096 directory
|
Device: fd01h/64769d Inode: 50331777 Links: 13
|
Access: (1777/drwxrwxrwt) Uid: ( 0/ root) Gid: ( 0/ root)
|
Access: 2016-07-19 15:57:54.581779695 +0000
|
Modify: 2016-07-19 16:01:52.715423173 +0000
|
Change: 2016-07-19 16:01:52.715423173 +0000
|
Birth: -
|
File: ‘/home/mysqltmp/’
|
Size: 6 Blocks: 0 IO Block: 4096 directory
|
Device: fd01h/64769d Inode: 51183635 Links: 2
|
Access: (1777/drwxrwxrwt) Uid: ( 995/ mysql) Gid: ( 994/ mysql)
|
Access: 2016-07-19 15:55:33.114206806 +0000
|
Modify: 2016-07-19 15:55:32.923200134 +0000
|
Change: 2016-07-19 16:00:38.720451448 +0000
|
Birth: -
|
repo file
cat /etc/yum.repos.d/mariadb.repo
|
[mariadb]
|
name = MariaDB
|
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
|
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
|
gpgcheck=1
|
exclude=MariaDB-Galera-server
|
full error message
Jul 19 16:33:47 centos7 systemd: Stopped MariaDB database server.
|
Jul 19 16:33:50 centos7 systemd: Starting MariaDB database server...
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] /usr/sbin/mysqld (mysqld 10.1.16-MariaDB) starting as process 6958 ...
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: The InnoDB memory heap is disabled
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: Memory barrier is not used
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: Using Linux native AIO
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] InnoDB: Using generic crc32 instructions
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [ERROR] mysqld: Can't create/write to file '/home/mysqltmp/ibPELAkd' (Errcode: 13 "Permission denied")
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 7ff05a877880 InnoDB: Error: unable to create temporary file; errno: 13
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [ERROR] Plugin 'InnoDB' init function returned error.
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [Note] Plugin 'FEEDBACK' is disabled.
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [ERROR] Unknown/unsupported storage engine: InnoDB
|
Jul 19 16:33:50 centos7 mysqld: 2016-07-19 16:33:50 140670287706240 [ERROR] Aborting
|
Jul 19 16:33:50 centos7 systemd: mariadb.service: main process exited, code=exited, status=1/FAILURE
|
- is caused by
-
MDEV-10298
Improve systemd service hardening
-
-
Closed
{"report":{"fcp":955.9000000953674,"ttfb":262.40000009536743,"pageVisibility":"visible","entityId":57443,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"dcba9c99-1005-4942-ad9e-847f182942d9","navigationType":0,"readyForUser":1024.7999999523163,"redirectCount":0,"resourceLoadedEnd":608.2999999523163,"resourceLoadedStart":278.5,"resourceTiming":[{"duration":14.599999904632568,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":278.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":278.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":293.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":14.299999952316284,"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":278.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":278.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":293.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":232.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":279,"connectEnd":279,"connectStart":279,"domainLookupEnd":279,"domainLookupStart":279,"fetchStart":279,"redirectEnd":0,"redirectStart":0,"requestStart":295.2000000476837,"responseEnd":511.59999990463257,"responseStart":327.2000000476837,"secureConnectionStart":279},{"duration":325.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":280.09999990463257,"connectEnd":280.09999990463257,"connectStart":280.09999990463257,"domainLookupEnd":280.09999990463257,"domainLookupStart":280.09999990463257,"fetchStart":280.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":296.59999990463257,"responseEnd":605.5,"responseStart":361.7999999523163,"secureConnectionStart":280.09999990463257},{"duration":17.399999856948853,"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":280.2000000476837,"connectEnd":280.2000000476837,"connectStart":280.2000000476837,"domainLookupEnd":280.2000000476837,"domainLookupStart":280.2000000476837,"fetchStart":280.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":280.2000000476837,"responseEnd":297.59999990463257,"responseStart":297.59999990463257,"secureConnectionStart":280.2000000476837},{"duration":43.89999985694885,"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":280.40000009536743,"connectEnd":280.40000009536743,"connectStart":280.40000009536743,"domainLookupEnd":280.40000009536743,"domainLookupStart":280.40000009536743,"fetchStart":280.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":300.7000000476837,"responseEnd":324.2999999523163,"responseStart":323.40000009536743,"secureConnectionStart":280.40000009536743},{"duration":65.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":280.40000009536743,"connectEnd":280.40000009536743,"connectStart":280.40000009536743,"domainLookupEnd":280.40000009536743,"domainLookupStart":280.40000009536743,"fetchStart":280.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":300,"responseEnd":345.90000009536743,"responseStart":344,"secureConnectionStart":280.40000009536743},{"duration":19.300000190734863,"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":280.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":280.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":299.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":65.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":280.59999990463257,"connectEnd":280.59999990463257,"connectStart":280.59999990463257,"domainLookupEnd":280.59999990463257,"domainLookupStart":280.59999990463257,"fetchStart":280.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":302.90000009536743,"responseEnd":346.2999999523163,"responseStart":344.59999990463257,"secureConnectionStart":280.59999990463257},{"duration":20.90000009536743,"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":280.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":280.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":301.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":85.19999980926514,"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":280.90000009536743,"connectEnd":280.90000009536743,"connectStart":280.90000009536743,"domainLookupEnd":280.90000009536743,"domainLookupStart":280.90000009536743,"fetchStart":280.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":304.90000009536743,"responseEnd":366.09999990463257,"responseStart":362.90000009536743,"secureConnectionStart":280.90000009536743},{"duration":326,"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":281.5,"connectEnd":281.5,"connectStart":281.5,"domainLookupEnd":281.5,"domainLookupStart":281.5,"fetchStart":281.5,"redirectEnd":0,"redirectStart":0,"requestStart":324.90000009536743,"responseEnd":607.5,"responseStart":601.9000000953674,"secureConnectionStart":281.5},{"duration":326.7000000476837,"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":281.59999990463257,"connectEnd":281.59999990463257,"connectStart":281.59999990463257,"domainLookupEnd":281.59999990463257,"domainLookupStart":281.59999990463257,"fetchStart":281.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":349.59999990463257,"responseEnd":608.2999999523163,"responseStart":604,"secureConnectionStart":281.59999990463257},{"duration":248.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":719.5,"connectEnd":719.5,"connectStart":719.5,"domainLookupEnd":719.5,"domainLookupStart":719.5,"fetchStart":719.5,"redirectEnd":0,"redirectStart":0,"requestStart":937.9000000953674,"responseEnd":968,"responseStart":967.0999999046326,"secureConnectionStart":719.5},{"duration":102.29999995231628,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":930.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":930.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1033.2000000476837,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":113,"responseStart":262,"responseEnd":278,"domLoading":266,"domInteractive":1088,"domContentLoadedEventStart":1089,"domContentLoadedEventEnd":1132,"domComplete":1707,"loadEventStart":1707,"loadEventEnd":1707,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1067.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1068.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":1068.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1071},{"name":"activityTabFullyLoaded","time":1140}],"measures":[],"correlationId":"1ac2852b2e013a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":9,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
