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

Galera joiner node startup is not skipping the DBs listed in ignore_db_dirs

    XMLWordPrintable

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)
    • 10.5, 10.6
    • Galera SST
    • 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

          Activity

            People

              sysprg Julius Goryavsky
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.