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

Galera SST fails when datadir / logdir are symlinks

    XMLWordPrintable

Details

    Description

      On our servers the datadir is configured as /var/lib/mysql, the log is configured as /var/log/mysql, both directories are symlinks:

      root@node02:~# ls -al /var/lib/mysql
      lrwxrwxrwx 1 root root 15 Apr 4 16:31 /var/lib/mysql -> /database/mysql

      root@node02:~# ls -al /var/log/mysql
      lrwxrwxrwx 1 root root 13 Apr 4 09:19 /var/log/mysql -> /database/log

      when adding a second node to the cluster the SST fails:

      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 0 [ERROR] WSREP: Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script.
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 0 [ERROR] WSREP: Process completed with error: wsrep_sst_mariabackup --role 'joiner' --address '10.97.148.12' --datadir '/var/lib/mysql/' --parent 6833 --progress 0 --binlog '/var/log/mysql/mysql-bin' --binlog-index '/var/log/mysql/mariadb-bin.index' --mysqld-args --wsrep_start_position=00000000-0000-0000-0000-000000000000:-1: 2 (No such file or directory)
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 3 [Note] WSREP: SST received
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 3 [Note] WSREP: SST received: 00000000-0000-0000-0000-000000000000:-1
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 3 [Note] WSREP: SST succeeded for position 00000000-0000-0000-0000-000000000000:-1
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 0 [Note] WSREP: Joiner monitor thread ended with total time 15 sec
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 2 [ERROR] WSREP: Application received wrong state:
      Apr 4 16:35:14 node02 mariadbd[6833]: #011Received: 00000000-0000-0000-0000-000000000000
      Apr 4 16:35:14 node02 mariadbd[6833]: #011Required: b9e3e449-d2da-11ed-ae66-72a327b8e5ab
      Apr 4 16:35:14 node02 mariadbd[6833]: 2023-04-04 16:35:14 2 [ERROR] WSREP: Application state transfer failed. This is unrecoverable condition, restart required.

      This issue was already reported as MDEV-28669 and has been marked as fixed.
      After testing the fixed version I've added a comment with the above results 2 weeks ago, since the issue is closed, my comment may have not been seen, hence the registration of a new issue.

      Attachments

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              rtuk Rick Tuk
              Votes:
              1 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.