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

Galera SST on maria-backup causes donor node to be unresponsive

Details

    Description

      Scenario:

      • MariaDB Galera cluster with 3 nodes.
      • Take down 2 of the nodes
      • Use SST to create a new node (using mariadb-backup)

      At some point during the SST, the node stops responding to DML queries for long times.
      As the new mariadb-backup in 10.11 is using BACKUP LOCK's this should not happen.

      Attachments

        1. galera_backup_stage.test
          2 kB
        2. mariabackup.diff
          3 kB
        3. node1.cnf
          0.7 kB
        4. node2.cnf
          0.7 kB
        5. node3.cnf
          0.7 kB
        6. prep.sh
          0.2 kB
        7. run.ods
          57 kB
        8. run.sh
          0.2 kB

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33278 Assertion failure in thd_get_thread_id at lock_wait_wsrep

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

          Activity

            Ascending order - Click to sort in descending order
            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            Summary Galera SST on maria-backup causes donor node to be inresponsive Galera SST on maria-backup causes donor node to be unresponsive
            monty Michael Widenius made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ]
            janlindstrom Jan Lindström made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            janlindstrom Jan Lindström made changes -
            Attachment mariabackup.diff [ 72786 ]
            janlindstrom Jan Lindström made changes -
            Attachment node1.cnf [ 72787 ]
            Attachment node2.cnf [ 72788 ]
            Attachment node3.cnf [ 72789 ]
            janlindstrom Jan Lindström made changes -
            Attachment run.sh [ 72790 ]
            janlindstrom Jan Lindström made changes -
            Attachment run.sh [ 72790 ]
            janlindstrom Jan Lindström made changes -
            Attachment prep.sh [ 72792 ]
            janlindstrom Jan Lindström made changes -
            Attachment run.sh [ 72793 ]
            janlindstrom Jan Lindström made changes -
            Attachment run.ods [ 72794 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 10.11.7 [ 29519 ]
            janlindstrom Jan Lindström made changes -
            Attachment galera_backup_stage.test [ 72827 ]
            janlindstrom Jan Lindström made changes -
            JIraAutomate JiraAutomate made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            janlindstrom Jan Lindström made changes -
            Fix Version/s 10.11.8 [ 29630 ]
            Fix Version/s 10.11 [ 27614 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 11.0.6 [ 29628 ]
            Fix Version/s 11.1.5 [ 29629 ]
            Fix Version/s 11.2.4 [ 29631 ]

            People

              janlindstrom Jan Lindström
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.