[MDEV-27974] Galera joiner node startup is not skipping the DBs listed in ignore_db_dirs Created: 2022-03-01  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6, 10.7
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Ramesh Sivaraman Assignee: Julius Goryavsky
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-21295 SST should not remove ignore-db-dir d... Open

 Description   

Galera joiner node startup is not skipping the DBs listed in ignore_db_dirs Joiner node shows file missing error messages in error log even after skipping the ignored DBs in SST.

Backup prepare log 

2022-03-01 15:39:12 22652255254464 [Note] InnoDB: Number of pools: 1
 
[00] 2022-03-01 15:39:12 mariabackup: Generating a list of tablespaces
 
Skipping db: ./test_one

Joiner node error log (Server started without any issues)

2022-03-01 15:39:21 23178567489472 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 
2022-03-01 15:39:21 23178567489472 [Note] InnoDB: New log files created, LSN=394424549
 
2022-03-01 15:39:21 23178567489472 [Note] InnoDB: Highest supported file format is Barracuda.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: Operating system error number 2 in a file operation.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: The error means the system cannot find the path specified.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: Cannot open datafile for read-only: './test_one/sbtest1.ibd' OS error: 71
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: Operating system error number 2 in a file operation.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: The error means the system cannot find the path specified.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
 
2022-03-01 15:39:21 23178567489472 [ERROR] InnoDB: Could not find a valid tablespace file for `test_one/sbtest1`. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
 
 
 
 
 
$ ls -l node2/test_one
 
ls: cannot access 'node2/test_one': No such file or directory

cnf info

ignore_db_dirs=test_one


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