Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26317

Distributed mariadb.service Systed service file prevents start with default datadir

Details

    Description

      When using our -systemd- binary tarballs the distributed mysqld.service systemd service file has

      ProtectSystem=full
      

      set since MDEV-10298. As this leads to everything under /usr being read-only, but the binary tarball builds having the data dir set up under /usr/local/mariadb-.../data by default.

      So trying to bring the MariaDB server up using default settings, according to our instructions in

      https://mariadb.com/kb/en/installing-mariadb-binary-tarball

      leads to "funny" errors like:

      2021-08-06 10:44:49 0 [ERROR] mysqld: File '/usr/local/mariadb-10.4.18-linux-systemd-x86_64/data/aria_log_control' not found (Errcode: 30 "Read-only file system")
      

      while starting the server manually works just fine.

      So I'd suggest to add

      ReadWritePaths=/usr/local/mysql/data
      

      to the bundled mariadb.service file. As /usr/local/mysql/data is a symlink, and SystemD resolves this link to the actual data directory, this should work across all releases without requiring per-release adjustments.

      A more complete fix would be to allow both the symlink and the actual versioned path, like e.g.:

      ReadWritePaths=/usr/local/mysql/data /usr/local/mariadb-10.4.18-linux-systemd-x86_64/data/
      

      Attachments

        Issue Links

          Activity

            cvicentiu I tried but it just said that it doesn't fit in to regex..

            illuusio Tuukka Pasanen added a comment - cvicentiu I tried but it just said that it doesn't fit in to regex..

            doesn't seem to be merged anywhere

            serg Sergei Golubchik added a comment - doesn't seem to be merged anywhere

            serg Sorry my bad.. I just looked GIthub very straigly it was approved not merged!.. I re-open if I can

            illuusio Tuukka Pasanen added a comment - serg Sorry my bad.. I just looked GIthub very straigly it was approved not merged!.. I re-open if I can

            This just Approved not merged.

            illuusio Tuukka Pasanen added a comment - This just Approved not merged.

            Just by coincidence I ran into the same yesterday (didn't even really remember I had encountered it before, and especially not that I created this ticked), and for now updated the KB entries on tarball installation and on systemD to mention this problem and how to deal with it with a simple extra systemd service include file:

            https://mariadb.com/kb/en/installing-mariadb-binary-tarballs/#auto-start-of-mysqld

            https://mariadb.com/kb/en/systemd/#configuring-the-data-directory

            hholzgra Hartmut Holzgraefe added a comment - Just by coincidence I ran into the same yesterday (didn't even really remember I had encountered it before, and especially not that I created this ticked), and for now updated the KB entries on tarball installation and on systemD to mention this problem and how to deal with it with a simple extra systemd service include file: https://mariadb.com/kb/en/installing-mariadb-binary-tarballs/#auto-start-of-mysqld https://mariadb.com/kb/en/systemd/#configuring-the-data-directory

            People

              danblack Daniel Black
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.