[MDEV-31332] Galera SST rsync wants to replicate snapshot directory Created: 2023-05-24  Updated: 2024-01-17  Resolved: 2023-09-26

Status: Closed
Project: MariaDB Server
Component/s: Galera SST, Replication, wsrep
Affects Version/s: 10.5.19
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3

Type: Bug Priority: Major
Reporter: Daniel Czadek Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: galera
Environment:

Debian 11

Issue Links:
Relates
relates to MDEV-10487 Galera SST using rsync does not filte... Closed
relates to MDEV-28483 Include the details about 10.4 to 10.... In Progress

 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)

 Comments   
Comment by Daniel Black [ 2023-05-25 ]

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

Comment by Daniel Black [ 2023-07-06 ]

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

Comment by Daniel Black [ 2023-07-17 ]

Can we just ignore the server ignore_db_dirs maybe?

Comment by Daniel Black [ 2023-07-18 ]

Hi,

PR for review with test case:

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

Comment by Julius Goryavsky [ 2023-09-26 ]

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

Generated at Thu Feb 08 10:23:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.