Buy Percona ServicesBuy Now!

InnoDB: No valid checkpoint found

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB: No valid checkpoint found

    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/...ng-innodb.html



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





  • #2
    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 ("use XtraBackup 2.4 for MariaDB Server versions beginning with 10.2") 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 percona-xtrabackup-24 .

    Backup and restore now work.

    Comment

    Working...
    X