# InnoDB: No valid checkpoint found

**URL:** <https://forums.percona.com/t/innodb-no-valid-checkpoint-found/5944>\
**Category:** Percona XtraBackup\
**Created:** [October 17, 2017, 5:59pm UTC](https://forums.percona.com/t/innodb-no-valid-checkpoint-found/5944 "2017-10-17T17:59:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hammertime](https://avatars.discourse-cdn.com/v4/letter/h/e5b9ba/32.png) [@hammertime](https://forums.percona.com/u/hammertime)\
**Post date:** [October 17, 2017, 5:59pm UTC](https://forums.percona.com/t/innodb-no-valid-checkpoint-found/5944/1 "2017-10-17T17:59:27Z")

</div>

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](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](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.

---

<div class="post-metadata">

**Author:** ![hammertime](https://avatars.discourse-cdn.com/v4/letter/h/e5b9ba/32.png) [@hammertime](https://forums.percona.com/u/hammertime)\
**Post date:** [October 18, 2017, 8:08am UTC](https://forums.percona.com/t/innodb-no-valid-checkpoint-found/5944/2 "2017-10-18T08:08:46Z")

</div>

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:

```auto
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.
```