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

Galera SST rsync wants to replicate snapshot directory

Details

    Description

      A new Galera Cluster was installed with some hosts and the MariaDB-Datadir is on an NetApp storage with NFS access.
      The bootstrap of the first node worked fine but then at the second node its impossible to start the mariadb.service because of endless restart of the service and permissions denies of the .snapshot directory of the mounted share.

      rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/aria_log.00000001" (in rsync_sst) failed: Permission denied (13)
      May 23 10:12:22 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/aria_log_control" (in rsync_sst) failed: Permission denied (13)
      May 23 10:12:22 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/debian-10.5.flag" (in rsync_sst) failed: Permission denied (13)
      May 23 10:12:22 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/galera.cache" (in rsync_sst) failed: Read-only file system (30)
      May 23 10:12:22 rsyncd[24965]: sent 48 bytes  received 374 bytes  total size 61
      May 23 10:12:22 rsyncd[24964]: sent 1815 bytes  received 3493527 bytes  total size 3486785
      May 23 10:12:23 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/grastate.dat" (in rsync_sst) failed: Read-only file system (30)
      May 23 10:12:23 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/gvwstate.dat" (in rsync_sst) failed: Read-only file system (30)
      May 23 10:12:23 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/ib_buffer_pool" (in rsync_sst) failed: Permission denied (13)
      May 23 10:12:23 rsyncd[24966]: rsync: [receiver] open "/.snapshot/hourly.2023-05-23_1005/ib_logfile0" (in rsync_sst) failed: Permission denied (13)

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-10487 Galera SST using rsync does not filter out lost+found

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-28483 Include the details about 10.4 to 10.5 and newer major versions upgrades for Galera clusters into the Knowledge Base

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

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment - - edited

            Quick solution is to append `.snapshot` to the ignored filelist in the wsrep_sst_rsync script here.

            danblack Daniel Black added a comment - - edited Quick solution is to append `.snapshot` to the ignored filelist in the wsrep_sst_rsync script here .
            danblack Daniel Black added a comment -

            sysprg can a .* be filtered out like: -f '- /.*'?

            danblack Daniel Black added a comment - sysprg can a .* be filtered out like: -f '- /.*' ?
            danblack Daniel Black added a comment -

            Can we just ignore the server ignore_db_dirs maybe?

            danblack Daniel Black added a comment - Can we just ignore the server ignore_db_dirs maybe?
            danblack Daniel Black added a comment -

            Hi,

            PR for review with test case:

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

            danblack Daniel Black added a comment - Hi, PR for review with test case: https://github.com/MariaDB/server/pull/2702
            sysprg Julius Goryavsky added a comment -

            Fix merged as https://github.com/MariaDB/server/commit/9b5275b8f5343bf8f00c1a75fff3b2343afa89c2

            sysprg Julius Goryavsky added a comment - Fix merged as https://github.com/MariaDB/server/commit/9b5275b8f5343bf8f00c1a75fff3b2343afa89c2

            People

              sysprg Julius Goryavsky
              dcz01 Daniel Czadek
              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.