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