Created
November 9, 2017 17:35
-
-
Save ShahriyarR/53fde1e31d1dd0bb8bf6fe74661efc82 to your computer and use it in GitHub Desktop.
The output of assertion
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ssh://shahriyar.rzaev@10.10.6.202:22/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/bin/python3 -u /home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/bin/autoxtrabackup -v -lf /home/shahriyar.rzaev/autoxtrabackup2.log -l DEBUG --defaults_file=/home/shahriyar.rzaev/XB_TEST/server_dir/xb_2_4_ps_5_7.conf --test_mode | |
2017-11-09 17:16:28 DEBUG <pid.PidFile object at 0x7fdc75f674a8> entering setup | |
2017-11-09 17:16:28 DEBUG <pid.PidFile object at 0x7fdc75f674a8> create pidfile: /tmp/MySQL-AutoXtraBackup/autoxtrabackup.pid | |
2017-11-09 17:16:28 DEBUG <pid.PidFile object at 0x7fdc75f674a8> check pidfile: /tmp/MySQL-AutoXtraBackup/autoxtrabackup.pid | |
2017-11-09 17:16:28 WARNING Enabled Test Mode!!! | |
2017-11-09 17:16:28 DEBUG Starting Test Mode | |
2017-11-09 17:16:28 DEBUG Trying to get basedir path... | |
2017-11-09 17:16:30 DEBUG Could get PS basedir path returning... | |
2017-11-09 17:16:30 ERROR Please pass proper already generated config file! | |
2017-11-09 17:16:30 ERROR Please check also if you have run prepare_env.bats file | |
2017-11-09 17:16:30 DEBUG Trying to get basedir path... | |
2017-11-09 17:16:30 DEBUG Could get PS basedir path returning... | |
2017-11-09 17:16:30 DEBUG Will start MySQL with --innodb_buffer_pool_size=1G --innodb_log_file_size=1G --innodb_page_size=64K --early-plugin-load=keyring_file.so --keyring_file_data=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/mysql-keyring/keyring --log-bin=mysql-bin --log-slave-updates --server-id=1 --gtid-mode=ON --enforce-gtid-consistency --binlog-format=row | |
2017-11-09 17:16:30 DEBUG Using all_no_cl script here... | |
2017-11-09 17:18:15 DEBUG Server wiped for fresh start! | |
2017-11-09 17:18:15 DEBUG Starting cycle1 | |
2017-11-09 17:18:15 DEBUG Started to run run_all_backup() | |
2017-11-09 17:18:15 DEBUG Trying to get basedir path... | |
2017-11-09 17:18:16 DEBUG Could get PS basedir path returning... | |
2017-11-09 17:18:16 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:18:16 DEBUG Could get mysql client | |
2017-11-09 17:18:16 DEBUG Trying to create DB... | |
2017-11-09 17:18:16 DEBUG Given DB is created | |
2017-11-09 17:18:16 DEBUG Trying to get socket file... | |
2017-11-09 17:18:16 DEBUG Running command -> sysbench /usr/share/sysbench/oltp_insert.lua --table-size=1000 --tables=100 --mysql-db=sysbench_test_db --mysql-user=root --threads=100 --db-driver=mysql --mysql-socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock prepare | |
2017-11-09 17:19:37 DEBUG Sysbench succeeded! | |
2017-11-09 17:19:37 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:37 DEBUG Could get mysql client | |
2017-11-09 17:19:38 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest1 encryption='Y'" | |
2017-11-09 17:19:38 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:38 DEBUG Could get mysql client | |
2017-11-09 17:19:38 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:38 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:38 DEBUG Could get mysql client | |
2017-11-09 17:19:38 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest1 compression='lz4'" | |
2017-11-09 17:19:38 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:38 DEBUG Could get mysql client | |
2017-11-09 17:19:39 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest1" | |
2017-11-09 17:19:39 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:39 DEBUG Could get mysql client | |
2017-11-09 17:19:40 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest2 encryption='Y'" | |
2017-11-09 17:19:40 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:40 DEBUG Could get mysql client | |
2017-11-09 17:19:40 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:40 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:40 DEBUG Could get mysql client | |
2017-11-09 17:19:40 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest2 compression='lz4'" | |
2017-11-09 17:19:40 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:40 DEBUG Could get mysql client | |
2017-11-09 17:19:42 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest2" | |
2017-11-09 17:19:42 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:42 DEBUG Could get mysql client | |
2017-11-09 17:19:43 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest3 encryption='Y'" | |
2017-11-09 17:19:43 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:43 DEBUG Could get mysql client | |
2017-11-09 17:19:43 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:43 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:43 DEBUG Could get mysql client | |
2017-11-09 17:19:44 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest3 compression='lz4'" | |
2017-11-09 17:19:44 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:44 DEBUG Could get mysql client | |
2017-11-09 17:19:45 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest3" | |
2017-11-09 17:19:45 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:45 DEBUG Could get mysql client | |
2017-11-09 17:19:46 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest4 encryption='Y'" | |
2017-11-09 17:19:46 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:46 DEBUG Could get mysql client | |
2017-11-09 17:19:46 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:46 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:46 DEBUG Could get mysql client | |
2017-11-09 17:19:46 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest4 compression='lz4'" | |
2017-11-09 17:19:46 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:46 DEBUG Could get mysql client | |
2017-11-09 17:19:47 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest4" | |
2017-11-09 17:19:47 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:47 DEBUG Could get mysql client | |
2017-11-09 17:19:48 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest5 encryption='Y'" | |
2017-11-09 17:19:48 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:48 DEBUG Could get mysql client | |
2017-11-09 17:19:48 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:48 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:48 DEBUG Could get mysql client | |
2017-11-09 17:19:48 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest5 compression='lz4'" | |
2017-11-09 17:19:48 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:48 DEBUG Could get mysql client | |
2017-11-09 17:19:50 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest5" | |
2017-11-09 17:19:50 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:50 DEBUG Could get mysql client | |
2017-11-09 17:19:51 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest6 encryption='Y'" | |
2017-11-09 17:19:51 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:51 DEBUG Could get mysql client | |
2017-11-09 17:19:51 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:51 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:51 DEBUG Could get mysql client | |
2017-11-09 17:19:51 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest6 compression='lz4'" | |
2017-11-09 17:19:51 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:51 DEBUG Could get mysql client | |
2017-11-09 17:19:52 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest6" | |
2017-11-09 17:19:52 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:52 DEBUG Could get mysql client | |
2017-11-09 17:19:53 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest7 encryption='Y'" | |
2017-11-09 17:19:53 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:53 DEBUG Could get mysql client | |
2017-11-09 17:19:53 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:53 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:53 DEBUG Could get mysql client | |
2017-11-09 17:19:54 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest7 compression='lz4'" | |
2017-11-09 17:19:54 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:54 DEBUG Could get mysql client | |
2017-11-09 17:19:55 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest7" | |
2017-11-09 17:19:55 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:55 DEBUG Could get mysql client | |
2017-11-09 17:19:56 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest8 encryption='Y'" | |
2017-11-09 17:19:56 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:56 DEBUG Could get mysql client | |
2017-11-09 17:19:56 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:56 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:56 DEBUG Could get mysql client | |
2017-11-09 17:19:56 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest8 compression='lz4'" | |
2017-11-09 17:19:56 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:56 DEBUG Could get mysql client | |
2017-11-09 17:19:57 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest8" | |
2017-11-09 17:19:57 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:57 DEBUG Could get mysql client | |
2017-11-09 17:19:58 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest9 encryption='Y'" | |
2017-11-09 17:19:58 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:58 DEBUG Could get mysql client | |
2017-11-09 17:19:58 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "flush tables" | |
2017-11-09 17:19:58 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:58 DEBUG Could get mysql client | |
2017-11-09 17:19:58 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "alter table sysbench_test_db.sbtest9 compression='lz4'" | |
2017-11-09 17:19:58 DEBUG Trying to get mysql client connection... | |
2017-11-09 17:19:58 DEBUG Could get mysql client | |
2017-11-09 17:20:00 DEBUG OK: Running -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql -A -uroot -S/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --force test -e "optimize table sysbench_test_db.sbtest9" | |
2017-11-09 17:20:20 DEBUG Trying to get basedir path... | |
2017-11-09 17:20:20 DEBUG Could get PS basedir path returning... | |
2017-11-09 17:20:20 DEBUG Trying to get socket file... | |
2017-11-09 17:20:20 DEBUG Running command -> sysbench /usr/share/sysbench/oltp_update_non_index.lua --table-size=1000 --tables=100 --mysql-db=sysbench_test_db --mysql-user=root --threads=100 --db-driver=mysql --mysql-socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock run | |
2017-11-09 17:20:32 DEBUG Sysbench succeeded! | |
2017-11-09 17:20:32 DEBUG Running mysqladmin command -> /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysqladmin --defaults-file= --user=root --password= status --socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock | |
mysqladmin: [Warning] Using a password on the command line interface can be insecure. | |
2017-11-09 17:20:33 DEBUG OK: Server is Up and running | |
2017-11-09 17:20:33 DEBUG OK: /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysql exists | |
2017-11-09 17:20:33 DEBUG OK: /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/bin/mysqladmin exists | |
2017-11-09 17:20:33 DEBUG Skipping my.cnf check, because it is not specified | |
2017-11-09 17:20:33 DEBUG OK: XtraBackup exists | |
2017-11-09 17:20:33 DEBUG Main backup directory does not exist | |
2017-11-09 17:20:33 DEBUG Creating Main Backup folder... | |
2017-11-09 17:20:33 DEBUG OK: Created | |
2017-11-09 17:20:33 DEBUG Full Backup directory does not exist | |
2017-11-09 17:20:33 DEBUG Creating full backup directory... | |
2017-11-09 17:20:33 DEBUG OK: Created | |
2017-11-09 17:20:33 DEBUG Increment directory does not exist | |
2017-11-09 17:20:33 DEBUG Creating increment backup directory... | |
2017-11-09 17:20:33 DEBUG OK: Created | |
2017-11-09 17:20:33 DEBUG OK: Check status | |
2017-11-09 17:20:33 DEBUG - - - - You have no backups : Taking very first Full Backup! - - - - | |
2017-11-09 17:20:33 DEBUG Trying to flush logs | |
2017-11-09 17:20:33 DEBUG OK: Log flushing completed | |
2017-11-09 17:20:33 WARNING Streaming is enabled! | |
2017-11-09 17:20:33 DEBUG The following backup command will be executed /home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup --defaults-file= --user=root --password='' --target-dir=/home/shahriyar.rzaev/XB_TEST/backup_dir/ps_5_7_x_2_4/cycle1/full/2017-11-09_17-20-33 --backup --socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --compress=quicklz --compress-chunk-size=65536 --compress-threads=4 --encrypt=AES256 --encrypt-key=VVTBwgM4UhwkTTV98fhuj+D1zyWoA89K --encrypt-threads=4 --encrypt-chunk-size=65536 --no-version-check --core-file --keyring-file-data=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/mysql-keyring/keyring --stream="xbstream" > /home/shahriyar.rzaev/XB_TEST/backup_dir/ps_5_7_x_2_4/cycle1/full/2017-11-09_17-20-33/full_backup.stream | |
2017-11-09 17:20:33 DEBUG Starting /home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup | |
2017-11-09 17:20:37 ERROR FAILED: FULL BACKUP | |
2017-11-09 17:20:37 ERROR 171109 17:20:34 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock | |
Using server version 5.7.19-17-debug-log | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup version 2.4.7 based on MySQL server 5.7.13 Linux (x86_64) (revision id: ) | |
xtrabackup: uses posix_fadvise(). | |
xtrabackup: cd to /home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-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 = 1073741824 | |
InnoDB: Number of pools: 1 | |
171109 17:20:34 >> log scanned up to (46303735) | |
xtrabackup: Generating a list of tablespaces | |
InnoDB: Allocated tablespace ID 21 for sys/sys_config, old maximum was 0 | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./ibdata1 | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./sys/sys_config.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/time_zone_name.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/innodb_table_stats.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/help_category.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/server_cost.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/plugin.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/time_zone_leap_second.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 >> log scanned up to (46303735) | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/slave_master_info.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/time_zone_transition.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/gtid_executed.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/help_topic.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/slave_relay_log_info.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/time_zone_transition_type.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/innodb_index_stats.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/servers.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/slave_worker_info.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/time_zone.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/help_relation.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/help_keyword.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./mysql/engine_cost.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest55.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest30.ibd | |
171109 17:20:35 [01] ...done | |
171109 17:20:35 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest74.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest28.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest22.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest59.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest77.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest80.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest46.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest94.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest66.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest47.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest10.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest56.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest32.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest20.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest69.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest76.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest39.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest25.ibd | |
171109 17:20:36 [01] ...done | |
171109 17:20:36 [01] Compressing, encrypting and streaming ./sysbench_test_db/sbtest8.ibd | |
2017-11-09 17:20:36 0x7feb7ebfe700 InnoDB: Assertion failure in thread 140649420547840 in file os0file.cc line 8594 | |
InnoDB: Failing assertion: dblwr_recover || memcmp(src + 16 + 4, src + (header.m_original_size + 38U) - 8 + 4, 4) == 0 | |
171109 17:20:36 >> log scanned up to (46307675) | |
InnoDB: We intentionally generate a memory trap. | |
InnoDB: Submit a detailed bug report to http://bugs.mysql.com. | |
InnoDB: If you get repeated assertion failures or crashes, even | |
InnoDB: immediately after the mysqld startup, there may be | |
InnoDB: corruption in the InnoDB tablespace. Please refer to | |
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html | |
InnoDB: about forcing recovery. | |
17:20:36 UTC - xtrabackup got signal 6 ; | |
This could be because you hit a bug or data is corrupted. | |
This error can also be caused by malfunctioning hardware. | |
Attempting to collect some information that could help diagnose the problem. | |
As this is a crash and something is definitely wrong, the information | |
collection process might fail. | |
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 0x10000 | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup(my_print_stacktrace+0x35)[0x195a471] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup(handle_fatal_signal+0x2ab)[0x11eacb2] | |
/usr/lib64/libpthread.so.0(+0xf130)[0x7feba93f7130] | |
/usr/lib64/libc.so.6(gsignal+0x37)[0x7feba70f65d7] | |
/usr/lib64/libc.so.6(abort+0x148)[0x7feba70f7cc8] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup[0x1164f2c] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup(_ZN11Compression11deserializeEbPhS0_m+0x381)[0x100fe4f] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup(_Z23os_file_decompress_pagebPhS_m+0x30)[0x100fec0] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup(_Z15xb_fil_cur_readP12xb_fil_cur_t+0x4a7)[0xddb259] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup[0xdbae76] | |
/home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup[0xdbbd8c] | |
/usr/lib64/libpthread.so.0(+0x7df5)[0x7feba93efdf5] | |
/usr/lib64/libc.so.6(clone+0x6d)[0x7feba71b71ad] | |
Please report a bug at https://bugs.launchpad.net/percona-xtrabackup | |
Writing a core file | |
/bin/sh: line 1: 15097 Aborted (core dumped) /home/shahriyar.rzaev/XB_TEST/server_dir/target/percona-xtrabackup-2.4.x-debug/bin/xtrabackup --defaults-file= --user=root --password='' --target-dir=/home/shahriyar.rzaev/XB_TEST/backup_dir/ps_5_7_x_2_4/cycle1/full/2017-11-09_17-20-33 --backup --socket=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/socket.sock --compress=quicklz --compress-chunk-size=65536 --compress-threads=4 --encrypt=AES256 --encrypt-key=VVTBwgM4UhwkTTV98fhuj+D1zyWoA89K --encrypt-threads=4 --encrypt-chunk-size=65536 --no-version-check --core-file --keyring-file-data=/home/shahriyar.rzaev/XB_TEST/server_dir/PS231017-percona-server-5.7.19-17-linux-x86_64-debug/mysql-keyring/keyring --stream="xbstream" > /home/shahriyar.rzaev/XB_TEST/backup_dir/ps_5_7_x_2_4/cycle1/full/2017-11-09_17-20-33/full_backup.stream | |
2017-11-09 17:20:37 DEBUG <pid.PidFile object at 0x7fdc75f674a8> closing pidfile: /tmp/MySQL-AutoXtraBackup/autoxtrabackup.pid | |
Traceback (most recent call last): | |
File "/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/bin/autoxtrabackup", line 11, in <module> | |
load_entry_point('mysql-autoxtrabackup==1.4.9', 'console_scripts', 'autoxtrabackup')() | |
File "/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/lib/python3.5/site-packages/click-6.7-py3.5.egg/click/core.py", line 722, in __call__ | |
return self.main(*args, **kwargs) | |
File "/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/lib/python3.5/site-packages/click-6.7-py3.5.egg/click/core.py", line 697, in main | |
rv = self.invoke(ctx) | |
File "/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/lib/python3.5/site-packages/click-6.7-py3.5.egg/click/core.py", line 895, in invoke | |
return ctx.invoke(self.callback, **ctx.params) | |
File "/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/lib/python3.5/site-packages/click-6.7-py3.5.egg/click/core.py", line 535, in invoke | |
return callback(*args, **kwargs) | |
File "/home/shahriyar.rzaev/virtualenvs/py_3_5_3_autoxtrabackup/lib/python3.5/site-packages/click-6.7-py3.5.egg/click/decorators.py", line 17, in new_func | |
return f(get_current_context(), *args, **kwargs) | |
File "/home/shahriyar.rzaev/MySQL-AutoXtraBackup/autoxtrabackup.py", line 203, in all_procedure | |
test_obj.wipe_backup_prepare_copyback(basedir=basedir) | |
File "/home/shahriyar.rzaev/MySQL-AutoXtraBackup/prepare_env_test_mode/runner_test_mode.py", line 275, in wipe_backup_prepare_copyback | |
if backup_obj.run_all_backup(): | |
File "/home/shahriyar.rzaev/MySQL-AutoXtraBackup/prepare_env_test_mode/take_backup.py", line 35, in run_all_backup | |
self.all_backup() | |
File "/home/shahriyar.rzaev/MySQL-AutoXtraBackup/master_backup_script/backuper.py", line 681, in all_backup | |
if self.full_backup(): | |
File "/home/shahriyar.rzaev/MySQL-AutoXtraBackup/master_backup_script/backuper.py", line 338, in full_backup | |
raise RuntimeError("FAILED: FULL BACKUP") | |
RuntimeError: FAILED: FULL BACKUP | |
2017-11-09 17:20:37 DEBUG <pid.PidFile object at 0x7fdc75f674a8> closing pidfile: /tmp/MySQL-AutoXtraBackup/autoxtrabackup.pid | |
Process finished with exit code 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment