Xtrabackup fails with errors on check point file

[ajstark123]

We are using Percona xtranackup version 24-2.4.20-1 to create a backup of a My SQL 5.7.29 database.

We have intermentent errors where xtraback fails to back up the database.

Does anybody know why this is happening.

The last failure occured fo4 this command.

• List item

xtrabackup --defaults-file=<<the_db_dir>>/db.cnf --host=localhost --user=<<the_user>> --port=<<the_port> --password=<<the_password>> --no-timestamp --backup --target-dir=<<the_target_dir>>/FULL

The errors we are getting

• xtrabackup: Error: cannot open <<the_target_dir>>/FULL//xtrabackup_checkpoints
• xtrabackup: error: failed to read metadata from <<the_target_dir>>/FULL//xtrabackup_checkpoints

[Marcelo_Altmann]

Hi @ajstark123

This error means you are trying to prepare a backup from a target-dir that doesn’t contain a proper backup.

See below an example when I try to prepare a backup from an empty target-dir:

marcelo@marce-bld:~$ mkdir /tmp/backups/full/
marcelo@marce-bld:~$ /work/pxb/ins/2.4/bin/xtrabackup --prepare --target-dir=/tmp/backups/full --user=root --host=127.1 --port=3311
xtrabackup: recognized server arguments:
xtrabackup: recognized client arguments: --prepare=1 --target-dir=/tmp/backups/full --user=root --host=127.1 --port=3311
/work/pxb/ins/2.4/bin/xtrabackup version 2.4.20 based on MySQL server 5.7.26 Linux (x86_64) (revision id: 04f49bd0957)
xtrabackup: cd to /tmp/backups/full/
xtrabackup: Error: cannot open ./xtrabackup_checkpoints
xtrabackup: Error: failed to read metadata from './xtrabackup_checkpoints'

Please send us the full output of your xtrabackup prepare command, the output of xtrabackup when you originaly created this backup and the output of ls to list the files from target-dir.

[ajstark123]

We are getting the error when we are trying to create a backup. The prepare commad was not run.