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

PXB is unable to connect to the database with transition-key when password is specified

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 8.0.6, 2.4.15
    • 8.0.7, 2.4.16
    • None
    • None

    Description

      PS8.0.16-6 is running with tablespace encryption and has some tables created:

      /home/mchawla/PS230719_8_0_16_6_debug/bin/mysqld --no-defaults --core-file --basedir=/home/mchawla/PS230719_8_0_16_6_debug --tmpdir=/home/mchawla/PS230719_8_0_16_6_debug/data --datadir=/home/mchawla/PS230719_8_0_16_6_debug/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so --socket=/home/mchawla/PS230719_8_0_16_6_debug/socket.sock --port=12915 --log-error=/home/mchawla/PS230719_8_0_16_6_debug/log/master.err --server-id=100 --early-plugin-load=keyring_file.so --keyring_file_data=/home/mchawla/PS230719_8_0_16_6_debug/keyring --binlog-encryption --innodb-undo-log-encrypt --default-table-encryption=ON --innodb_encrypt_online_alter_logs=ON --innodb_temp_tablespace_encrypt=ON --log-bin=mysql-bin --log-slave-updates --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row --master_verify_checksum=ON --binlog_checksum=CRC32 --encrypt-tmp-files --innodb_sys_tablespace_encrypt --innodb_parallel_dblwr_encrypt --binlog-rotate-encryption-master-key-at-startup --table-encryption-privilege-check=ON --innodb-default-encryption-key-id=4294967295 --innodb-encryption-threads=10

      Take a full backup using user, password, and transition-key parameters

      ./xtrabackup --user=root --password='' --backup --target-dir=$HOME/dbbackup_PS8/full -S $HOME/PS230719_8_0_16_6_debug/socket.sock --datadir=$HOME/PS230719_8_0_16_6_debug/data --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin --transition-key=abc
       xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --datadir=/home/mchawla/PS230719_8_0_16_6_debug/data 
       xtrabackup: recognized client arguments: --user=root --password=* --backup=1 --target-dir=/home/mchawla/dbbackup_PS8/full --socket=/home/mchawla/PS230719_8_0_16_6_debug/socket.sock --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_7_debug/lib/plugin --transition-key=* 
       ./xtrabackup version 8.0.6 based on MySQL server 8.0.16 Linux (x86_64) (revision id: 8704f50)
       190730 13:44:24  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/home/mchawla/PS230719_8_0_16_6_debug/socket.sock' as 'root'  (using password: YES).
       Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup;mysql_socket=/home/mchawla/PS230719_8_0_16_6_debug/socket.sock','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at - line 1535.
       190730 13:44:24 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /home/mchawla/PS230719_8_0_16_6_debug/socket.sock
       Failed to connect to MySQL server: Access denied for user 'root'@'localhost' (using password: YES).

      Issue: PXB fails to connect to the database.

      Take a full backup using user and transition-key parameters

      ./xtrabackup --user=root --backup --target-dir=$HOME/dbbackup_PS8/full -S $HOME/PS230719_8_0_16_6_debug/socket.sock --datadir=$HOME/PS230719_8_0_16_6_debug/data --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin --transition-key=abc
      xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --datadir=/home/mchawla/PS230719_8_0_16_6_debug/data 
      xtrabackup: recognized client arguments: --user=root --backup=1 --target-dir=/home/mchawla/dbbackup_PS8/full --socket=/home/mchawla/PS230719_8_0_16_6_debug/socket.sock --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_7_debug/lib/plugin --transition-key=* 
      ./xtrabackup version 8.0.6 based on MySQL server 8.0.16 Linux (x86_64) (revision id: 8704f50)
      190730 13:51:50 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/home/mchawla/PS230719_8_0_16_6_debug/socket.sock' as 'root' (using password: NO).
      190730 13:51:50 version_check Connected to MySQL server
      190730 13:51:50 version_check Executing a version check against the server...
      190730 13:51:50 version_check Done.
      190730 13:51:50 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: /home/mchawla/PS230719_8_0_16_6_debug/socket.sock
      Using server version 8.0.16-6-debug
      xtrabackup: uses posix_fadvise().
      xtrabackup: cd to /home/mchawla/PS230719_8_0_16_6_debug/data
      xtrabackup: open files limit requested 0, set to 1048576
      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 = 50331648
      ...

      PXB is able to connect to the database and the backup is successful.

      Attachments

        Activity

          People

            sergei.glushchenko Sergei Glushchenko (Inactive)
            manish.chawla Manish Chawla
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 4 hours, 35 minutes
                4h 35m

                Smart Checklist