Cannot autostart mysqld from systemd on Debian Stretch after update












0















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 ...










share|improve this question





























    0















    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 ...










    share|improve this question



























      0












      0








      0








      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 ...










      share|improve this question
















      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






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 10 at 9:20







      Bogdan Goral

















      asked Jan 10 at 9:15









      Bogdan GoralBogdan Goral

      12




      12






















          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
          });


          }
          });














          draft saved

          draft discarded


















          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
















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          How to make a Squid Proxy server?

          Is this a new Fibonacci Identity?

          Touch on Surface Book