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

PXB crashes when it cannot connect to server

    XMLWordPrintable

    Details

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

      Description

      PS8.0.17-8 is running with encryption options

      /home/mchawla/PS241019_8_0_17_8_debug/bin/mysqld --no-defaults --core-file --basedir=/home/mchawla/PS241019_8_0_17_8_debug --tmpdir=/home/mchawla/PS241019_8_0_17_8_debug/data --datadir=/home/mchawla/PS241019_8_0_17_8_debu/data --plugin-load-add=tokudb=ha_tokudb.so --tokudb-check-jemalloc=0 --plugin-load-add=rocksdb=ha_rocksdb.so --socket=/home/mchawla/PS241019_8_0_17_8_debug/socket.sock --port=11764 --log-error=/home/mchawla/PS241019_8_0_17_8_debug/log/master.err --server-id=100 --early-plugin-load=keyring_file.so --keyring_file_data=/home/mchawla/PS241019_8_0_17_8_debug/keyring --binlog-encryption --innodb-undo-log-encrypt --innodb-redo-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

      Create some data and run a load such that there no connections left

      sysbench /usr/share/sysbench/oltp_insert.lua --tables=10 --mysql-db=test --mysql-user=root --threads=150 --db-driver=mysql --mysql-socket=${PWD}/socket.sock --time=20 run

      Take full backup, pxb crashes

      ./xtrabackup --user=root --password='' --backup --target-dir=$HOME/dbbackup_PS8/full -S $HOME/PS241019_8_0_17_8_debug/socket.sock --datadir=$HOME/PS241019_8_0_17_8_debug/data --keyring_file_data=$HOME/PS241019_8_0_17_8_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_8_debug/lib/plugin --transition-key=abc 2>&1 | tee full_backup_$(date +"%d_%m_%Y")_log
      xtrabackup: recognized server arguments: --datadir=/var/lib/mysql --datadir=/home/mchawla/PS241019_8_0_17_8_debug/data 
      xtrabackup: recognized client arguments: --user=root --password=* --backup=1 --target-dir=/home/mchawla/dbbackup_PS8/full --socket=/home/mchawla/PS241019_8_0_17_8_debug/socket.sock --xtrabackup-plugin-dir=/home/mchawla/pxb_8_0_8_debug/lib/plugin --transition-key=* 
      ./xtrabackup version 8.0.7 based on MySQL server 8.0.17 Linux (x86_64) (revision id: fe48ac0)
      191101 09:07:45 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/home/mchawla/PS241019_8_0_17_8_debug/socket.sock' as 'root' (using password: NO).
      191101 09:07:45 version_check Connected to MySQL server
      191101 09:07:45 version_check Executing a version check against the server...
      *******************************************************************
       Using the default of SSL_verify_mode of SSL_VERIFY_NONE for client
       is deprecated! Please set SSL_verify_mode to SSL_VERIFY_PEER
       possibly with SSL_ca_file|SSL_ca_path for verification.
       If you really don't want to verify the certificate and keep the
       connection open to Man-In-The-Middle attacks please set
       SSL_verify_mode explicitly to SSL_VERIFY_NONE in your application.
      *******************************************************************
       at - line 244.
      *******************************************************************
       Using the default of SSL_verify_mode of SSL_VERIFY_NONE for client
       is deprecated! Please set SSL_verify_mode to SSL_VERIFY_PEER
       possibly with SSL_ca_file|SSL_ca_path for verification.
       If you really don't want to verify the certificate and keep the
       connection open to Man-In-The-Middle attacks please set
       SSL_verify_mode explicitly to SSL_VERIFY_NONE in your application.
      *******************************************************************
       at - line 244.
      # A software update is available:
      # * The current version for Percona::Toolkit is 3.0.5
      191101 09:07:45 version_check Done.
      191101 09:07:45 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /home/mchawla/PS241019_8_0_17_8_debug/socket.sock
      Using server version 8.0.17-8-debug
      xtrabackup: uses posix_fadvise().
      xtrabackup: cd to /home/mchawla/PS241019_8_0_17_8_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
      Number of pools: 1
      191101 09:07:45 Added plugin 'keyring_file.so' to load list.
      Read redo log encryption metadata successful.
      191101 09:07:46 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /home/mchawla/PS241019_8_0_17_8_debug/socket.sock
      Starting to parse redo log at lsn = 25112160
      Recovery parsing buffer extended to 4194304.
      Failed to connect to MySQL server: Too many connections.
      09:07:46 UTC - mysqld got signal 11 ;
      Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
      Thread pointer: 0x0
      Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0 thread_stack 0x46000
      ./xtrabackup(my_print_stacktrace(unsigned char*, unsigned long)+0x43) [0x4604285]
      ./xtrabackup(handle_fatal_signal+0x291) [0x30a9b3b]
      /usr/lib64/libpthread.so.0(+0xf5f0) [0x7fe3969935f0]
      ./xtrabackup(mysql_send_query+0xc0) [0x3086b43]
      ./xtrabackup(mysql_real_query+0x116) [0x3086e3e]
      ./xtrabackup(mysql_query+0x32) [0x305b8a9]
      ./xtrabackup(xb_mysql_query(MYSQL*, char const*, bool, bool)+0x36) [0x299c042]
      ./xtrabackup(read_mysql_variables(MYSQL*, char const*, mysql_variable*, bool)+0x33) [0x299c3c2]
      ./xtrabackup(Archived_Redo_Log_Monitor::thread_func()+0x111) [0x29da06d]
      ./xtrabackup() [0x29d9acd]
      ./xtrabackup() [0x29dd09d]
      ./xtrabackup() [0x29dd041]
      ./xtrabackup() [0x29dcfcc]
      ./xtrabackup() [0x29dcf04]
      ./xtrabackup() [0x29dcbe2]
      ./xtrabackup() [0x29dc470]
      ./xtrabackup() [0x29dbf73]
      ./xtrabackup() [0x29dd2ef]
      ./xtrabackup() [0x29dd259]
      ./xtrabackup() [0x29dd214]
      ./xtrabackup() [0x48a784f]
      /usr/lib64/libpthread.so.0(+0x7e65) [0x7fe39698be65]
      /usr/lib64/libc.so.6(clone+0x6d) [0x7fe3946d488d]
      Please report a bug at https://jira.percona.com/projects/PXB

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              sergei.glushchenko Sergei Glushchenko (Inactive)
              Reporter:
              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 - 2 hours
                  2h