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

xtrabackup is still failing evern after upgrading Percona XtraBackup to 2.1.6

krishnakrishna ContributorInactive User Role Beginner
Hi Team,

Percona xtrabackup is upgraded to the latest version "percona-xtrabackup.x86_64 - 2.1.6-702.rhel5", but still observing the same error mentioned below.
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 2671901, but got no. 1068025125 from the log file.
xtrabackup: Error: xtrabackup_copy_logfile() failed.
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 389.
DBD::mysql::db selectrow_array failed: MySQL server has gone away at /usr/bin/innobackupex line 1325.

Here are the DB related parameters in my.cnf
innodb_file_per_table=1
innodb_max_purge_lag=100000
innodb_buffer_pool_size=120GB
innodb_log_buffer_size=80M
innodb_log_file_size=2GB
innodb_open_files=1000
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
innodb_thread_concurrency=0
innodb_flush_neighbor_pages=0
innodb_io_capacity=10000
max_allowed_packet=48M
query_cache_type = 0
query_cache_size = 10M
max_connections=40000
Backup command is a pearl script, might not be able to share that due security reasons. Could you please suggest if there needs any parameter value changes if so how much?

Kindly suggest a permanent solution please!

Best Regards,
Krishna
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.