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

xtrabackup: Error: cannot open ./xtrabackup_checkpoints

silaphetsilaphet EntrantInactive User Role Beginner
Hi Forums,

I''m trying to setup the master-slave replication by using xtrabackup method. However, when trying to run hot backups and Percona is complaining missing something. Here is complete output.


​​​​​​innobackupex --apply-log /apps/perconabackup/

161220 14:26:27 innobackupex: Starting the apply-log operation



IMPORTANT: Please check that the apply-log run completes successfully.

At the end of a successful apply-log run innobackupex

prints "completed OK!".


innobackupex version 2.4.5 based on MySQL server 5.7.13 Linux (x86_64) (revision id: e41c0be)

xtrabackup: cd to /apps/perconabackup/

xtrabackup: Error: cannot open ./xtrabackup_checkpoints

xtrabackup: Error: failed to read metadata from './xtrabackup_checkpoints'


here is environment setup:
RHEL 7.0

xtrabackup --version
xtrabackup version 2.4.5 based on MySQL server 5.7.13 Linux (x86_64) (revision id: e41c0be)

​​​​​​mysql -V
mysql Ver 14.14 Distrib 5.7.14-8, for Linux (x86_64) using 6.2


Here are my.cnf options file on the master.

cat /etc/my.cnf

# Template my.cnf for PXC

# Edit to your requirements.

[client]

socket=/var/lib/mysql/mysql.sock

[mysqld]

server-id=1

datadir=/apps/mysql/datafile

socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

log_slave_updates


# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0
# Path to Galera library

wsrep_provider=/usr/lib64/galera3/libgalera_smm.so


# Cluster connection URL contains IPs of nodes

#If no IP is found, this implies that a new cluster needs to be created,

#in order to do that you need to bootstrap this node

wsrep_cluster_address=gcomm://


###InnoDB

default_storage_engine=InnoDB

innodb_log_file_size=128M

innodb_flush_method = O_DIRECT

innodb_file_per_table=1

innodb_data_home_dir=/apps/mysql/datafile/

innodb_log_group_home_dir =/apps/mysql/datafile/


## Replication and binlogs


binlog_format=ROW

binlog_cache_size = 1M

max_binlog_files=300

max_binlog_size=128M

log_bin=/apps/mysql/logfile/percona1-binary-log

expire_logs_days=3


What is exactly am I missing here?

Your help or instruction is really appreciated.

Thanks,
Silaphet

Comments

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.