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

MariaDB server can't join Galera cluster after restart

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1.12
    • 10.1.15
    • Galera, Galera SST
    • None
    • Debian Jessie 8.3.
      4 physical servers in cluster.
      63G Memory / machine
      24 CPU / machine

    Description

      Hi,

      We have configured a cluster of 4 mariaDB servers with Galera (with the SST xtrabackup-v2).
      We had some issue when joining the cluster with one node.

      Our problem is that when we launch the mysql process it tried to sync with the cluster. It clean the /var/lib/mysql folder and sync all data from an other node.
      Everything goes well until it tries to launch the process itself (at the end of the joining process).
      We have some logs that I provide in attachments (maria.log).

      So it seems that it does not found one file and when we try to start again the process it fails and sync from the begining.

      Maybe we forgot something (obvious ?) in the configuration but we can't find it.

      If you can help us it would be great.

      Thanks.
      Regards,
      Thomas.

      Attachments

        Issue Links

          Activity

            Hi,

            For the record, I've found this issue which seems related : https://jira.mariadb.org/browse/MDEV-9423.
            I've tried to change the configuration as quoted there : https://jira.mariadb.org/browse/MDEV-9423?focusedCommentId=82677&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-82677.
            But without success.

            tcheronneau Thomas Cheronneau added a comment - Hi, For the record, I've found this issue which seems related : https://jira.mariadb.org/browse/MDEV-9423 . I've tried to change the configuration as quoted there : https://jira.mariadb.org/browse/MDEV-9423?focusedCommentId=82677&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-82677 . But without success.

            Yes, its a duplicate of MDEV-9423.

            nirbhay_c Nirbhay Choubey (Inactive) added a comment - Yes, its a duplicate of MDEV-9423 .

            For the information, it is possible to fix it temporarly by adding the missing log (rsync between donor and receiver).
            It has to be done at the end of the SST process before MariaDB starts.
            But after that we've seen another issue (https://jira.mariadb.org/browse/MDEV-9423). Which is solved with the timeout in systemd (as explain on jira).
            So we managed to add the node to the cluster this way and it is working now.

            tcheronneau Thomas Cheronneau added a comment - For the information, it is possible to fix it temporarly by adding the missing log (rsync between donor and receiver). It has to be done at the end of the SST process before MariaDB starts. But after that we've seen another issue ( https://jira.mariadb.org/browse/MDEV-9423 ). Which is solved with the timeout in systemd (as explain on jira). So we managed to add the node to the cluster this way and it is working now.

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              tcheronneau Thomas Cheronneau
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.