Not the answer you need?
Register and ask your own question!

InnoDB: No valid checkpoint found

hammertimehammertime EntrantCurrent User Role Beginner
Hi

I'm currently at a loss, it seems that i can't get xtrabackup to work even in the most simple of setups.

OS is an up2date CentOS 7.4

Im using some sample data from https://github.com/datacharmer/test_db.git (employee.sql).
Test also doesn't work with selinux in permissive mode.

#xtrabackup -v
xtrabackup version 2.3.8 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 9328211)

#mysqld --version
mysqld Ver 10.2.9-MariaDB-log for Linux on x86_64 (MariaDB Server)

no modifications to the my.cnf(.d) where made.
innodb-data-home-dir and innodb_data_file_path are on defaults.


Running the backup after starting the db and importing the employees scheme:

# xtrabackup --backup --target-dir=/tmp
171018 01:21:30 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' (using password: NO).
171018 01:21:30 version_check Connected to MySQL server
171018 01:21:30 version_check Executing a version check against the server...
171018 01:21:30 version_check Done.
171018 01:21:30 Connecting to MySQL server host: localhost, user: not set, password: not set, port: not set, socket: not set
Using server version 10.2.9-MariaDB
xtrabackup version 2.3.8 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 9328211)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html



Not quite sure where to go from here, the setup above works on my fedora 26 machine.

Comments

  • hammertimehammertime Entrant Current User Role Beginner
    Think i have found the solution: Even though xtrabackup 2.3.8 doesn't complain about incompatibility with the mariadb verion in use (like other xtrabackup versions seem to do), the official mariadb page suggests using xtrabackup 2.4 ("") which can be downloaded from the mariadb repo which can be installed like this:

    [code]curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup |
    sudo bash -s -- --mariadb-server-version=mariadb-10.2

    the percona-xtrabackup package needed is called

    Backup and restore now work.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.