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

datadir must be specified in [mysqld] section of configuration file for mariabackup SST

Details

    Description

      If datadir is not specified in the [mysqld] section of the MariaDB configuration file, then mariabackup SST attempts will fail on the joiner with errors in innobackup.move.log similar to this:

      170530 12:06:47 innobackupex: Starting the move-back operation
      		 
       
      		 
      IMPORTANT: Please check that the move-back run completes successfully.
      		 
                 At the end of a successful move-back run innobackupex
      		 
                 prints "completed OK!".
      		 
       
      		 
      innobackupex based on MariaDB server 10.1.23-MariaDB Linux (x86_64)
      		 
      Error: datadir must be specified.

      I believe that this behavior was inherited from the xtrabackup-v2 SST method, but it seems a bit unnecessary and it might be fixable. The server obviously knows its own datadir, so can't it specify the value on the command-line or something like that?

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14966 Fail to restore data with mariabackup without specified data dir

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15836 MariaDB galera SST broken using mariabackup

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18863 Galera SST scripts can't read mysqld_multi's [mysqldN] option groups

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

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            Labels backup galera mariabackup sst
            elenst Elena Stepanova added a comment -

            sachin.setiya.007, please reassign to wlad if needed.

            elenst Elena Stepanova added a comment - sachin.setiya.007 , please reassign to wlad if needed.
            elenst Elena Stepanova made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ]
            anikitin Andrii Nikitin (Inactive) made changes -
            anikitin Andrii Nikitin (Inactive) added a comment -

            This should be fixed in 10.1.25 and 10.2.7 as part of MDEV-11459 . Thus I am closing this as duplicate.

            anikitin Andrii Nikitin (Inactive) added a comment - This should be fixed in 10.1.25 and 10.2.7 as part of MDEV-11459 . Thus I am closing this as duplicate.
            anikitin Andrii Nikitin (Inactive) made changes -
            Fix Version/s 10.2.7 [ 22543 ]
            Fix Version/s 10.1.25 [ 22542 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Duplicate [ 3 ]
            Status Open [ 1 ] Closed [ 6 ]
            laocius TAO ZHOU added a comment -

            I am running 10.2.7 on FreeBSD and I am still having this error. I checked the code I built from and it has the fix mentioned here.

            laocius TAO ZHOU added a comment - I am running 10.2.7 on FreeBSD and I am still having this error. I checked the code I built from and it has the fix mentioned here.
            anikitin Andrii Nikitin (Inactive) made changes -
            Resolution Duplicate [ 3 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            anikitin Andrii Nikitin (Inactive) made changes -
            Assignee Sachin Setiya [ sachin.setiya.007 ] Andrii Nikitin [ anikitin ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1.25 [ 22542 ]
            Fix Version/s 10.2.7 [ 22543 ]
            anikitin Andrii Nikitin (Inactive) made changes -
            anikitin Andrii Nikitin (Inactive) made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Assignee Andrii Nikitin [ anikitin ]
            elenst Elena Stepanova made changes -
            Comment [ Setting to Confirmed based on the comments above. ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            wlad Vladislav Vaintroub made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Comment [ I am sorry for initial misjudging, the problem should be solved as part of MDEV-14030 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Jan Lindström [ jplindst ]
            manjot Manjot Singh (Inactive) added a comment -

            having this issue in 10.2.16 with customer

            manjot Manjot Singh (Inactive) added a comment - having this issue in 10.2.16 with customer
            umoser Ulrich Moser (Inactive) made changes -
            wlad Vladislav Vaintroub made changes -
            wlad Vladislav Vaintroub made changes -
            wlad Vladislav Vaintroub made changes -
            Fix Version/s 10.2.18 [ 23112 ]
            Fix Version/s 10.1.36 [ 23117 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            wlad Vladislav Vaintroub made changes -
            Assignee Jan Lindström [ jplindst ] Vladislav Vaintroub [ wlad ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            Fix Version/s 10.3.10 [ 23140 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 81013 ] MariaDB v4 [ 152246 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 173690

            People

              wlad Vladislav Vaintroub
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              7 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.