Cannot autostart mysqld from systemd on Debian Stretch after update
Problem with starting mariadb (mysqld 10.1.37-MariaDB-0+deb9u1) over systemd on Debian Stretch after latest update.
Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 GNU/Linux
Syslog: # tail -n 10 /var/log/syslog
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [Warning] Can't create test file /home/mysql/fsrv.lower-test
Jan 10 10:40:45 fsrv mysqld[24116]: #007/usr/sbin/mysqld: Can't change dir to '/home/mysql/' (Errcode: 13 "Permission denied")
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [ERROR] Aborting
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 10 10:40:45 fsrv systemd[1]: Failed to start MariaDB 10.1.37 database server.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Unit entered failed state.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Failed with result 'exit-code'.
After that i check permission on mysqld work directory # ls -lh /home/mysql
total 227M
drwxr-xr-x 2 mysql mysql 4.0K Feb 19 2016 access
-rwxr-xr-x 1 mysql mysql 16K Jan 10 10:39 aria_log.00000001
-rwxr-xr-x 1 mysql mysql 52 Jan 10 10:39 aria_log_control
drwxr-xr-x 2 mysql mysql 4.0K Mar 3 2016 auto
-rwxr-xr-x 1 mysql mysql 0 Feb 18 2016 debian-5.5.flag
drwxr-xr-x 2 mysql mysql 4.0K Nov 28 2017 glove
drwxr-xr-x 2 mysql mysql 4.0K Aug 3 15:49 Guard
-rwxr-xr-x 1 mysql mysql 130M Jan 10 10:40 ibdata1
-rwxr-xr-x 1 mysql mysql 48M Jan 10 10:40 ib_logfile0
-rwxr-xr-x 1 mysql mysql 48M Feb 15 2018 ib_logfile1
-rwxr-xr-x 1 mysql mysql 0 Feb 15 2018 multi-master.info
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 mysql
-rwxr-xr-x 1 mysql mysql 6 Dec 15 2017 mysql_upgrade_info
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 old_guard
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 performance_schema
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 phpmyadmin
-rwxr-xr-x 1 mysql mysql 24K Jan 10 10:40 tc.log
drwxr-xr-x 2 mysql mysql 4.0K Nov 19 14:47 TempGuard
drwxr-xr-x 2 mysql mysql 4.0K Feb 14 2018 test
User mysql have permission for write, but it cannot start.
From console mysqld starts: /usr/sbin/mysqld
2019-01-10 11:04:52 140460271694272 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-01-10 11:04:52 140460271694272 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 25616 ...
mysql systemd autostart debian-stretch mariadb
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
add a comment |
Problem with starting mariadb (mysqld 10.1.37-MariaDB-0+deb9u1) over systemd on Debian Stretch after latest update.
Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 GNU/Linux
Syslog: # tail -n 10 /var/log/syslog
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [Warning] Can't create test file /home/mysql/fsrv.lower-test
Jan 10 10:40:45 fsrv mysqld[24116]: #007/usr/sbin/mysqld: Can't change dir to '/home/mysql/' (Errcode: 13 "Permission denied")
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [ERROR] Aborting
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 10 10:40:45 fsrv systemd[1]: Failed to start MariaDB 10.1.37 database server.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Unit entered failed state.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Failed with result 'exit-code'.
After that i check permission on mysqld work directory # ls -lh /home/mysql
total 227M
drwxr-xr-x 2 mysql mysql 4.0K Feb 19 2016 access
-rwxr-xr-x 1 mysql mysql 16K Jan 10 10:39 aria_log.00000001
-rwxr-xr-x 1 mysql mysql 52 Jan 10 10:39 aria_log_control
drwxr-xr-x 2 mysql mysql 4.0K Mar 3 2016 auto
-rwxr-xr-x 1 mysql mysql 0 Feb 18 2016 debian-5.5.flag
drwxr-xr-x 2 mysql mysql 4.0K Nov 28 2017 glove
drwxr-xr-x 2 mysql mysql 4.0K Aug 3 15:49 Guard
-rwxr-xr-x 1 mysql mysql 130M Jan 10 10:40 ibdata1
-rwxr-xr-x 1 mysql mysql 48M Jan 10 10:40 ib_logfile0
-rwxr-xr-x 1 mysql mysql 48M Feb 15 2018 ib_logfile1
-rwxr-xr-x 1 mysql mysql 0 Feb 15 2018 multi-master.info
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 mysql
-rwxr-xr-x 1 mysql mysql 6 Dec 15 2017 mysql_upgrade_info
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 old_guard
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 performance_schema
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 phpmyadmin
-rwxr-xr-x 1 mysql mysql 24K Jan 10 10:40 tc.log
drwxr-xr-x 2 mysql mysql 4.0K Nov 19 14:47 TempGuard
drwxr-xr-x 2 mysql mysql 4.0K Feb 14 2018 test
User mysql have permission for write, but it cannot start.
From console mysqld starts: /usr/sbin/mysqld
2019-01-10 11:04:52 140460271694272 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-01-10 11:04:52 140460271694272 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 25616 ...
mysql systemd autostart debian-stretch mariadb
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
See this answer for the solution: serverfault.com/questions/872478/…
– andrew
Feb 8 at 20:46
add a comment |
Problem with starting mariadb (mysqld 10.1.37-MariaDB-0+deb9u1) over systemd on Debian Stretch after latest update.
Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 GNU/Linux
Syslog: # tail -n 10 /var/log/syslog
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [Warning] Can't create test file /home/mysql/fsrv.lower-test
Jan 10 10:40:45 fsrv mysqld[24116]: #007/usr/sbin/mysqld: Can't change dir to '/home/mysql/' (Errcode: 13 "Permission denied")
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [ERROR] Aborting
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 10 10:40:45 fsrv systemd[1]: Failed to start MariaDB 10.1.37 database server.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Unit entered failed state.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Failed with result 'exit-code'.
After that i check permission on mysqld work directory # ls -lh /home/mysql
total 227M
drwxr-xr-x 2 mysql mysql 4.0K Feb 19 2016 access
-rwxr-xr-x 1 mysql mysql 16K Jan 10 10:39 aria_log.00000001
-rwxr-xr-x 1 mysql mysql 52 Jan 10 10:39 aria_log_control
drwxr-xr-x 2 mysql mysql 4.0K Mar 3 2016 auto
-rwxr-xr-x 1 mysql mysql 0 Feb 18 2016 debian-5.5.flag
drwxr-xr-x 2 mysql mysql 4.0K Nov 28 2017 glove
drwxr-xr-x 2 mysql mysql 4.0K Aug 3 15:49 Guard
-rwxr-xr-x 1 mysql mysql 130M Jan 10 10:40 ibdata1
-rwxr-xr-x 1 mysql mysql 48M Jan 10 10:40 ib_logfile0
-rwxr-xr-x 1 mysql mysql 48M Feb 15 2018 ib_logfile1
-rwxr-xr-x 1 mysql mysql 0 Feb 15 2018 multi-master.info
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 mysql
-rwxr-xr-x 1 mysql mysql 6 Dec 15 2017 mysql_upgrade_info
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 old_guard
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 performance_schema
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 phpmyadmin
-rwxr-xr-x 1 mysql mysql 24K Jan 10 10:40 tc.log
drwxr-xr-x 2 mysql mysql 4.0K Nov 19 14:47 TempGuard
drwxr-xr-x 2 mysql mysql 4.0K Feb 14 2018 test
User mysql have permission for write, but it cannot start.
From console mysqld starts: /usr/sbin/mysqld
2019-01-10 11:04:52 140460271694272 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-01-10 11:04:52 140460271694272 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 25616 ...
mysql systemd autostart debian-stretch mariadb
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
Problem with starting mariadb (mysqld 10.1.37-MariaDB-0+deb9u1) over systemd on Debian Stretch after latest update.
Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 GNU/Linux
Syslog: # tail -n 10 /var/log/syslog
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [Warning] Can't create test file /home/mysql/fsrv.lower-test
Jan 10 10:40:45 fsrv mysqld[24116]: #007/usr/sbin/mysqld: Can't change dir to '/home/mysql/' (Errcode: 13 "Permission denied")
Jan 10 10:40:45 fsrv mysqld[24116]: 2019-01-10 10:40:45 140402857677248 [ERROR] Aborting
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 10 10:40:45 fsrv systemd[1]: Failed to start MariaDB 10.1.37 database server.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Unit entered failed state.
Jan 10 10:40:45 fsrv systemd[1]: mariadb.service: Failed with result 'exit-code'.
After that i check permission on mysqld work directory # ls -lh /home/mysql
total 227M
drwxr-xr-x 2 mysql mysql 4.0K Feb 19 2016 access
-rwxr-xr-x 1 mysql mysql 16K Jan 10 10:39 aria_log.00000001
-rwxr-xr-x 1 mysql mysql 52 Jan 10 10:39 aria_log_control
drwxr-xr-x 2 mysql mysql 4.0K Mar 3 2016 auto
-rwxr-xr-x 1 mysql mysql 0 Feb 18 2016 debian-5.5.flag
drwxr-xr-x 2 mysql mysql 4.0K Nov 28 2017 glove
drwxr-xr-x 2 mysql mysql 4.0K Aug 3 15:49 Guard
-rwxr-xr-x 1 mysql mysql 130M Jan 10 10:40 ibdata1
-rwxr-xr-x 1 mysql mysql 48M Jan 10 10:40 ib_logfile0
-rwxr-xr-x 1 mysql mysql 48M Feb 15 2018 ib_logfile1
-rwxr-xr-x 1 mysql mysql 0 Feb 15 2018 multi-master.info
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 mysql
-rwxr-xr-x 1 mysql mysql 6 Dec 15 2017 mysql_upgrade_info
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 old_guard
drwxr-xr-x 2 mysql mysql 4.0K Jan 9 15:17 performance_schema
drwxr-xr-x 2 mysql mysql 4.0K Feb 15 2018 phpmyadmin
-rwxr-xr-x 1 mysql mysql 24K Jan 10 10:40 tc.log
drwxr-xr-x 2 mysql mysql 4.0K Nov 19 14:47 TempGuard
drwxr-xr-x 2 mysql mysql 4.0K Feb 14 2018 test
User mysql have permission for write, but it cannot start.
From console mysqld starts: /usr/sbin/mysqld
2019-01-10 11:04:52 140460271694272 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2019-01-10 11:04:52 140460271694272 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 25616 ...
mysql systemd autostart debian-stretch mariadb
mysql systemd autostart debian-stretch mariadb
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
edited Jan 10 at 9:20
Bogdan Goral
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
asked Jan 10 at 9:15
Bogdan GoralBogdan Goral
12
12
See this answer for the solution: serverfault.com/questions/872478/…
– andrew
Feb 8 at 20:46
add a comment |
See this answer for the solution: serverfault.com/questions/872478/…
– andrew
Feb 8 at 20:46
See this answer for the solution: serverfault.com/questions/872478/…
– andrew
Feb 8 at 20:46
See this answer for the solution: serverfault.com/questions/872478/…
– andrew
Feb 8 at 20:46
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1392671%2fcannot-autostart-mysqld-from-systemd-on-debian-stretch-after-update%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1392671%2fcannot-autostart-mysqld-from-systemd-on-debian-stretch-after-update%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
See this answer for the solution: serverfault.com/questions/872478/…
– andrew
Feb 8 at 20:46