Failed to not validate first page of the file mysql/innodb_table_stats, error 42 - Source

Revision: 102716
User: Jeong-eun Noh
Date: 2020-12-22 02:10

Hi, 
Would it be possible to get some help?

* CentOS 7.8
* Mariadb 10.3.27

<<code>>
# mariabackup --backup --user=root --password={password} --target-dir={backup_folder_path}
[00] 2020-11-30 09:42:23 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
[00] 2020-11-30 09:42:23 Using server version 10.3.27-MariaDB-log
mariabackup based on MariaDB server 10.3.27-MariaDB Linux (x86_64)
[00] 2020-11-30 09:42:23 uses posix_fadvise().
[00] 2020-11-30 09:42:23 cd to /var/lib/mysql/
[00] 2020-11-30 09:42:23 open files limit requested 1024, set to 1024
[00] 2020-11-30 09:42:23 mariabackup: using the following InnoDB configuration:
[00] 2020-11-30 09:42:23 innodb_data_home_dir =
[00] 2020-11-30 09:42:23 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2020-11-30 09:42:23 innodb_log_group_home_dir = ./
[00] 2020-11-30 09:42:23 InnoDB: Using Linux native AIO
2020-11-30  9:42:23 0 [Note] InnoDB: Number of pools: 1
[00] 2020-11-30 09:42:23 mariabackup: Generating a list of tablespaces
2020-11-30  9:42:23 0 [Warning] InnoDB: Allocated tablespace ID 1 for {table_name}, old maximum was 0
2020-11-30  9:42:23 0 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace {table_name} at filepath: ./{table_name}.ibd uses space ID: 1. Cannot open filepath: ./mysql/innodb_table_stats.ibd which uses the same space ID.
[00] FATAL ERROR: 2020-11-30 09:42:23 Failed to not validate first page of the file mysql/innodb_table_stats, error 42
<</code>>

What should I do?
Thanks for help.

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Failed to not validate first page of the file mysql/innodb_table_stats, error 42 - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB