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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23580 galera_3nodes.galera_ipv6_rsync_section MTR failed: WSREP_SST: [ERROR] rsync daemon port '16008' has been taken

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              sysprg Julius Goryavsky (Inactive)
              PavelCibulka Pavel Cibulka
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 0d
                  0d
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 11d 5.25h
                  11d 5.25h

                  Git Integration

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