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

Galera SST innobackupex-move ignores Environment settings

    XMLWordPrintable

    Details

      Description

      We use mariadb galera managed by systemd on Ubuntu 18.04. There is datadir set to environment in systemd config:

      Environment='MYSQLD_MULTI_INSTANCE=--defaults-file=/etc/mysql/mariadb-%I.cnf \
                                         --pid-file=/var/run/mariadb-%I/mariadb.pid \
                                         --port=%I \
                                         --socket=/var/run/mariadb-%I/mariadb.sock \
                                         --datadir=/var/lib/mariadb-%I \
                                         --tmpdir=/run/mariadb-%I'
      

      I've needed to add one server into cluster but it keep failing. I've check logs and found this line:

      necy1 -innobackupex-move: [00] 2021-02-23 17:08:48 Error: Move file ibdata1 to /var/lib/mysql/ibdata1 failed: Destination file exists

      This is default datadir, which we don't use. innobackupex-move seems to ignore environment settings. After adding datadir into mariadb config file innobackupex-move and whole process succeded.

      wsrep_sst_method is set to mariabackup

      I've added systemd config file for mariadb service.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sysprg Julius Goryavsky
              Reporter:
              PavelCibulka Pavel Cibulka
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration