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

ZFS snapdir=visible breaks Galera rsync SST replication

Details

    Description

      Using ZFS with the following example config:

      zfs create tank/mysql
      		 
      zfs set snapdir=visible tank/mysql
      		 
      zfs set mountpoint=/mysql tank/mysql

      my.cnf:

      [mysqld]
      		 
      datadir=/mysql
      		 
       
      		 
      [galera]
      		 
      wsrep_on=ON
      		 
      wsrep_sst_method = rsync

      rsync will attempt to sync the .zfs special folder, which breaks rsync (and thus sst replication)

      incoming patch in just a few minutes.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21719 Set rsync to use MariaDB error.log

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            darkain Vincent Milum Jr created issue -
            darkain Vincent Milum Jr made changes -
            Field Original Value New Value
            darkain Vincent Milum Jr made changes -
            Summary ZFS snapdir=visible breaks Galera rsync SST replcation ZFS snapdir=visible breaks Galera rsync SST replication
            elenst Elena Stepanova made changes -
            Fix Version/s 10.4 [ 22408 ]
            Assignee Jan Lindström [ jplindst ]
            darkain Vincent Milum Jr added a comment -

            Is there any status on this issue? I've had an open PR for it for months now.

            https://github.com/MariaDB/server/pull/1445

            darkain Vincent Milum Jr added a comment - Is there any status on this issue? I've had an open PR for it for months now. https://github.com/MariaDB/server/pull/1445
            jplindst Jan Lindström (Inactive) added a comment -

            Is PR final, there was note that it did not fully solve the issue and have you tested table or database with .zfs name?

            jplindst Jan Lindström (Inactive) added a comment - Is PR final, there was note that it did not fully solve the issue and have you tested table or database with .zfs name?
            darkain Vincent Milum Jr added a comment -

            Yes, the PR is final. I have not personally tested with a table or database named .zfs, but that would be disallowed by the filesystem most likely. There is no real workaround for this. My primary concern was fixing Galera replication to work again.

            darkain Vincent Milum Jr added a comment - Yes, the PR is final. I have not personally tested with a table or database named .zfs, but that would be disallowed by the filesystem most likely. There is no real workaround for this. My primary concern was fixing Galera replication to work again.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Julius Goryavsky [ sysprg ]
            sysprg Julius Goryavsky made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Julius Goryavsky [ sysprg ] Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.4.11 [ 24013 ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2020-06-24 05:45:28.0 2020-06-24 05:45:28.024
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.5.4 [ 24264 ]
            Fix Version/s 10.2.33 [ 24307 ]
            Fix Version/s 10.3.24 [ 24306 ]
            Fix Version/s 10.4.14 [ 24305 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5.5 [ 24423 ]
            Fix Version/s 10.5.4 [ 24264 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 103873 ] MariaDB v4 [ 157315 ]

            People

              jplindst Jan Lindström (Inactive)
              darkain Vincent Milum Jr
              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.