[MDEV-29592] SST via rsync fails with innodb_undo_directory != datadir Created: 2022-09-21  Updated: 2023-10-12  Resolved: 2023-10-12

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
Fix Version/s: 10.4.27, 10.5.18, 10.6.11, 10.8.6, 10.9.4, 10.10.2, 10.11.0

Type: Bug Priority: Major
Reporter: Julius Goryavsky Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Issue split
split from MDEV-28669 Cannot join second node to new cluste... Closed

 Description   

SST via rsync fails if set innodb_undo_directory not equal to datadir and pointing to a separate directory:

 

WSREP_SST: [INFO] rsync SST completed on joiner (20220921 14:39:49.396)
WSREP_SST: [INFO] Joiner cleanup: rsync PID=0, stunnel PID=1417018 (20220921 14:39:49.400)
2022-09-21 14:39:49 0 [Note] WSREP: (794a7ffd, 'tcp://0.0.0.0:16005') turning message relay requesting off
WSREP_SST: [INFO] Joiner cleanup done. (20220921 14:39:49.941)
2022-09-21 14:39:49 0 [Note] WSREP: SST complete, seqno: 12
2022-09-21 14:39:49 0 [Note] Plugin 'partition' is disabled.
2022-09-21 14:39:49 0 [Note] InnoDB: Using Linux native AIO
2022-09-21 14:39:49 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
2022-09-21 14:39:49 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21 14:39:49 0 [Note] InnoDB: Uses event mutexes
2022-09-21 14:39:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21 14:39:49 0 [Note] InnoDB: Number of pools: 1
2022-09-21 14:39:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-21 14:39:50 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2022-09-21 14:39:50 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21 14:39:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-09-21 14:39:50 0 [ERROR] InnoDB: Unable to open undo tablespace '/home/panda/mariadb-10.3/build/mysql-test/var/mysqld.2/innodb_undo2/undo001'.
2022-09-21 14:39:50 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1908] with error Generic error
2022-09-21 14:39:50 0 [Note] InnoDB: Starting shutdown...
2022-09-21 14:39:50 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-09-21 14:39:50 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.code}



 Comments   
Comment by Julius Goryavsky [ 2023-10-12 ]

Already fixed as part of https://jira.mariadb.org/browse/MDEV-28669

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