Announcement

Announcement Module
Collapse
No announcement yet.

xtrabackup failing due to log block number mismatch or child process dead

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

  • xtrabackup failing due to log block number mismatch or child process dead

    We are running xtrabackup 2.0 for taking Mysql backup. However, during the process we get errors like below.
    xtrabackup: error: log block numbers mismatch:
    xtrabackup: error: expected log block no. 254974, but got no. 1065608198 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.

    Having gone through the details, it was identified as a bug. Could you please suggest if this is taken into consideration and fixed in the latest releases if so share the release details so that I can upgrade xtracbakup for smooth functionality.


  • #2
    There are some bugs reported on it. You can try latest version of Percona Xtrabackup but before this it probably be related to redo log files size. Can you please try to increase the InnoDB redo log files size and retry when server is not heavily loaded because of write activity it not able to keep up with log copying thread. Also, can you please share your complete backup command with InnoDB specific parameters of my.cnf

    Comment


    • #3
      Thanks for the update Irfan. Will try to share the my.cnf parameters and will try with the latest version of xtrabackup and get in touch with you.

      Comment


      • #4
        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 which parameter value to be changed and how much. Will try to install the latest xtracbackup 2.1 with the parameter value and post the status. Thanks again for your prompt response!

        Comment


        • #5
          Hi Irfan,

          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.

          Required parameters are shared above. Kindly suggest a permanent solution please!

          Best Regards,
          Krishna

          Comment


          • #6
            Did you tried increasing innodb_log_file_size and try to backup during low database load. Look likes your database server is actively busy during backup.

            Comment


            • #7
              Currently innodb_log_file_size in our case it is 2GB. How much do you want me to increase to! Load on the database should be quite low since backup runs during non-business hours and we do not run anyother jobs or processes on the slave host.

              Comment

              Working...
              X