Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-2162

percona-xtrabackup-80 does not work with mysql 8.0.20

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.12
    • Component/s: None
    • Labels:
      None
    • Environment:

      Ubuntu 18.04
      Mysql server 8.0.20-1ubuntu18.04
      percona-xtrabackup-80 8.0.11-1.bionic

      Description

      Hello all, 

      percona-xtrabackup-80 does not work with latest mysql server. 
      Error is below: 

      xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --innodb_buffer_pool_size=240G --innodb_log_file_size=1G --server-id=67
      xtrabackup: recognized client arguments: --socket=/var/run/mysqld/mysqld.sock --password=* --backup=1 --stream=xbstream --slave-info=1 --safe-slave-backup=1 --parallel=2
      xtrabackup version 8.0.11 based on MySQL server 8.0.18 Linux (x86_64) (revision id: 486c270)
      200428 11:23:03 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/var/run/mysqld/mysqld.sock' (using password: YES).
      200428 11:23:03 version_check Connected to MySQL server
      200428 11:23:03 version_check Executing a version check against the server...
      200428 11:23:03 version_check Done.
      200428 11:23:03 Connecting to MySQL server host: localhost, user: not set, password: set, port: not set, socket: /var/run/mysqld/mysqld.sock
      Using server version 8.0.20
      xtrabackup: uses posix_fadvise().
      xtrabackup: cd to /var/lib/mysql
      xtrabackup: open files limit requested 0, set to 1024
      xtrabackup: using the following InnoDB configuration:
      xtrabackup: innodb_data_home_dir = .
      xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
      xtrabackup: innodb_log_group_home_dir = ./
      xtrabackup: innodb_log_files_in_group = 2
      xtrabackup: innodb_log_file_size = 1073741824
      Number of pools: 1
      200428 11:23:03 Connecting to MySQL server host: localhost, user: not set, password: set, port: not set, socket: /var/run/mysqld/mysqld.sock
      Unknown redo log format (4). Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/ upgrading-downgrading.html.
      xtrabackup: Error: recv_find_max_checkpoint() failed.

       

      Part from change notes (https://docs.oracle.com/cd/E17952_01/mysql-8.0-relnotes-en/news-8-0-20.html) that possibly is related to the issue:

      InnoDB: Redo log records for modifications to undo tablespaces increased in size in MySQL 8.0 due to a change in undo tablespace ID values, which required additional bytes. The change in redo log record size caused a performance regression in workloads with heavy write I/O. To address this issue, the redo log format was modified to reduce redo log record size for modifications to undo tablespaces. (Bug #29536710)

      Thanks

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                rahul.malik Rahul Malik
                Reporter:
                pavelvoronov1337 Pavel Voronov
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: