Announcement

Announcement Module
Collapse
No announcement yet.

xtrabackup is still failing evern after upgrading Percona XtraBackup to 2.1.6

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • xtrabackup is still failing evern after upgrading Percona XtraBackup to 2.1.6

    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
    Last edited by krishna; 12-06-2013, 08:02 PM.
Working...
X