Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
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
|
Attachments
Issue Links
- relates to
-
MDEV-21295 SST should not remove ignore-db-dir directories
- Open