// Conf files used [root@cluster-repo mysql-advanced-5.6.23]# more master.cnf slave.cnf :::::::::::::: master.cnf :::::::::::::: #Master [mysqld] pid-file = /data/ushastry/server/mysql-advanced-5.6.23/run/master.pid socket = /data/ushastry/server/mysql-advanced-5.6.23/run/master.sock log-error=/data/ushastry/server/mysql-advanced-5.6.23/log/master_error.log slow_query_log_file=/data/ushastry/server/mysql-advanced-5.6.23/log/master_slow_query.log general_log_file=/data/ushastry/server/mysql-advanced-5.6.23/log/master_general.log port = 15000 server-id = 1 basedir = /data/ushastry/server/mysql-advanced-5.6.23 datadir = /data/ushastry/server/mysql-advanced-5.6.23/master tmpdir = /tmp log-bin = /data/ushastry/server/mysql-advanced-5.6.23/log/master-bin log-bin-index = /data/ushastry/server/mysql-advanced-5.6.23/log/master-bin.index binlog_format=ROW :::::::::::::: slave.cnf :::::::::::::: #Slave [mysqld] pid-file = /data/ushastry/server/mysql-advanced-5.6.23/run/slave.pid socket = /data/ushastry/server/mysql-advanced-5.6.23/run/slave.sock log-error=/data/ushastry/server/mysql-advanced-5.6.23/log/slave_error.log port = 15001 server-id = 2 basedir = /data/ushastry/server/mysql-advanced-5.6.23 datadir = /data/ushastry/server/mysql-advanced-5.6.23/slave tmpdir = /tmp relay-log-index = /data/ushastry/server/mysql-advanced-5.6.23/log/slave-relay-bin.index relay-log = /data/ushastry/server/mysql-advanced-5.6.23/log/slave-relay-bin binlog_format=ROW log_slow_slave_statements=ON slow_query_log=ON long_query_time=0 log-bin = /data/ushastry/server/mysql-advanced-5.6.23/log/slave-bin log-bin-index = /data/ushastry/server/mysql-advanced-5.6.23/log/slave-bin.index // MySQL build used [root@cluster-repo mysql-advanced-5.6.23]# more docs/INFO_SRC revision-id: michael.izioumtchenko@oracle.com-20141106152508-nntohvuco3v1rjjx date: 2014-11-06 16:25:08 +0100 build-date: 2014-11-06 18:00:43 +0100 revno: 6243 branch-nick: daily-5.6 MySQL source 5.6.23 // MySQL instances started with: scripts/mysql_install_db --defaults-file=./master.cnf --user=mysql bin/mysqld --defaults-file=./master.cnf --user=mysql 2>&1 & scripts/mysql_install_db --defaults-file=./slave.cnf --user=mysql bin/mysqld --defaults-file=./slave.cnf --user=mysql 2>&1 & // Setup simple Master/Slave replication ( hence, skipped 1-3 steps) // On Master, pupulate some data and follow below steps 4-8 or you may want to follow steps as reporter provided Steps to reproduce the error: 1) # service mysql start 2) mysql> CHANGE MASTER TO ... 3) mysql> START SLAVE; 4) mysql> STOP SLAVE; 5) mysql> RESET SLAVE; 6) # service mysql stop 7) # service mysql start 8) # mysqlbackup ... // Assume that 4-7 steps are followed [root@cluster-repo meb-3.11.1-el6-x86-64bit]# bin/mysqlbackup --user=root --socket=/data/ushastry/server/mysql-advanced-5.6.23/run/slave.sock --with-timestamp --backup-dir=/tmp/backup --debug --trace=3 --compress backup MySQL Enterprise Backup version 3.11.1 Linux-2.6.39-400.17.1.el6uek.x86_64-x86_64 [2014/11/04] Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... bin/mysqlbackup --user=root --socket=/data/ushastry/server/mysql-advanced-5.6.23/run/slave.sock --with-timestamp --backup-dir=/tmp/backup --debug --trace=3 --compress backup mysqlbackup: INFO: 141211 17:25:15 mysqlbackup: INFO: Checking ulimit values: core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 47694 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 47694 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited 141211 17:25:15 mysqlbackup: INFO: Checking ids: uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel) 141211 17:25:15 mysqlbackup: INFO: Checking run directory: /data/ushastry/setups/meb-3.11.1-el6-x86-64bit mysqlbackup: TRACE_2: Value for Server Variable version_compile_os is: Linux mysqlbackup: TRACE_2: Value for Server Variable datadir is: /data/ushastry/server/mysql-advanced-5.6.23/slave/ mysqlbackup: TRACE_2: Value for Server Variable innodb_data_home_dir is: mysqlbackup: TRACE_2: Value for Server Variable innodb_data_file_path is: ibdata1:12M:autoextend mysqlbackup: TRACE_2: Value for Server Variable innodb_log_group_home_dir is: ./ mysqlbackup: TRACE_2: Value for Server Variable innodb_log_files_in_group is: 2 mysqlbackup: TRACE_2: Value for Server Variable innodb_log_file_size is: 50331648 mysqlbackup: TRACE_2: Value for Server Variable innodb_undo_directory is: . mysqlbackup: TRACE_2: Value for Server Variable innodb_undo_tablespaces is: 0 mysqlbackup: TRACE_2: Value for Server Variable innodb_undo_logs is: 128 mysqlbackup: TRACE_2: Value for Server Variable innodb_page_size is: 16384 mysqlbackup: TRACE_2: Value for Server Variable innodb_checksum_algorithm is: innodb mysqlbackup: INFO: MySQL server version is '5.6.23-enterprise-commercial-advanced-log'. mysqlbackup: INFO: Got some server configuration information from running server. 141211 17:25:15 mysqlbackup: INFO: Created path '/tmp/backup/2014-12-11_17-25-15' IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'backup' run mysqlbackup prints "mysqlbackup completed OK!". 141211 17:25:15 mysqlbackup: INFO: Created path '/tmp/backup/2014-12-11_17-25-15/datadir' 141211 17:25:15 mysqlbackup: INFO: MEB logfile created at /tmp/backup/2014-12-11_17-25-15/meta/MEB_2014-12-11.17-25-15_compress_backup.log 141211 17:25:15 mysqlbackup: INFO: Created path '/tmp/backup/2014-12-11_17-25-15/meta' mysqlbackup: TRACE_3: Creating dir: /tmp/backup/2014-12-11_17-25-15/datadir for file /tmp/backup/2014-12-11_17-25-15/datadir/ibdata1 mysqlbackup: TRACE_2: [OPEN ] 5:/data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 seekable: TRUE mysqlbackup: TRACE_3: Reading /data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 file, offset 0 and size 4096. mysqlbackup: TRACE_3: [SEEK ] [OFFSET: 0] [WHENCE: 0] 5:/data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 mysqlbackup: TRACE_3: Reading completed /data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 file, offset 0 and size 4096. mysqlbackup: TRACE_2: [CLOSE] 5:/data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 mysqlbackup: TRACE_2: [OPEN ] 5:/data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 seekable: TRUE mysqlbackup: TRACE_3: Reading /data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 file, offset 0 and size 98304. mysqlbackup: TRACE_3: [SEEK ] [OFFSET: 0] [WHENCE: 0] 5:/data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 mysqlbackup: TRACE_3: Reading completed /data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 file, offset 0 and size 98304. mysqlbackup: TRACE_2: [CLOSE] 5:/data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 mysqlbackup: TRACE_3: File: /data/ushastry/server/mysql-advanced-5.6.23/slave/ibdata1 DWB Block1: 64 Block2: 128 Length: 64 -------------------------------------------------------------------- Server Repository Options: -------------------------------------------------------------------- datadir = /data/ushastry/server/mysql-advanced-5.6.23/slave/ innodb_data_home_dir = innodb_data_file_path = ibdata1:12M:autoextend innodb_log_group_home_dir = /data/ushastry/server/mysql-advanced-5.6.23/slave/ innodb_log_files_in_group = 2 innodb_log_file_size = 50331648 innodb_page_size = 16384 innodb_checksum_algorithm = innodb innodb_undo_directory = /data/ushastry/server/mysql-advanced-5.6.23/slave/ innodb_undo_tablespaces = 0 innodb_undo_logs = 128 -------------------------------------------------------------------- Backup Config Options: -------------------------------------------------------------------- datadir = /tmp/backup/2014-12-11_17-25-15/datadir innodb_data_home_dir = /tmp/backup/2014-12-11_17-25-15/datadir innodb_data_file_path = ibdata1:12M:autoextend innodb_log_group_home_dir = /tmp/backup/2014-12-11_17-25-15/datadir innodb_log_files_in_group = 2 innodb_log_file_size = 50331648 innodb_page_size = 16384 innodb_checksum_algorithm = innodb innodb_undo_directory = /tmp/backup/2014-12-11_17-25-15/datadir innodb_undo_tablespaces = 0 innodb_undo_logs = 128 mysqlbackup: INFO: Unique generated backup id for this is 14182989152468135 mysqlbackup: INFO: Uses LZ4 r109 for data compression. mysqlbackup: TRACE_1: Timestamp enabled in file system : TRUE mysqlbackup: TRACE_1: Inserting to progress table. mysqlbackup: INFO: Creating 18 buffers each of size 16794070. 141211 17:25:17 mysqlbackup: INFO: Compress Backup operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 141211 17:25:17 mysqlbackup: INFO: System tablespace file format is Antelope. 141211 17:25:17 mysqlbackup: INFO: Starting to copy all innodb files... mysqlbackup: TRACE_2: Value for Server Variable log_bin_index is: /data/ushastry/server/mysql-advanced-5.6.23/log/slave-bin.index mysqlbackup: TRACE_2: Value for Server Variable relay_log_index is: /data/ushastry/server/mysql-advanced-5.6.23/log/slave-relay-bin.index mysqlbackup: TRACE_1: Bin Log : '/data/ushastry/server/mysql-advanced-5.6.23/log/slave-bin.index' mysqlbackup: TRACE_1: Relay Log : '/data/ushastry/server/mysql-advanced-5.6.23/log/slave-relay-bin.index' stack_bottom = 0 thread_stack 0x10000 bin/mysqlbackup(my_print_stacktrace+0x35)[0x593815] bin/mysqlbackup(_ZN3meb9ExceptionC2ENS_18enum_error_numbersEPKcS3_i+0x73)[0x485c23] bin/mysqlbackup(_ZN3meb10Log_copier22init_for_online_backupEv+0x82)[0x48f962] bin/mysqlbackup(_ZN3meb15Relaylog_copier22init_for_online_backupEv+0xe)[0x49115e] bin/mysqlbackup(_ZN3meb15Relaylog_copier4initEv+0x9)[0x491079] bin/mysqlbackup(_ZN3meb8Data_set15init_log_copierEv+0x307)[0x4841a7] bin/mysqlbackup(_ZN3meb8Data_setC2Ev+0x2e3)[0x484923] bin/mysqlbackup(_ZN3meb13Read_data_mgrC2EPNS_12Buffer_queueES2_+0x25)[0x562d45] bin/mysqlbackup(_ZN3meb7ManagerC2ENS_17enum_manager_typeEPNS_12Buffer_queueES3_j+0xc3)[0x494393] bin/mysqlbackup(_ZN3meb11Meb_session4initEv+0x3e5)[0x4965f5] bin/mysqlbackup(_ZN3meb11Meb_session12init_sessionEiPPc+0x216)[0x4973d6] bin/mysqlbackup(_ZN3meb20mysqlbackup_parallelEiPPc+0x1a)[0x5523ca] bin/mysqlbackup(main+0x64)[0x552574] /lib64/libc.so.6(__libc_start_main+0xfd)[0x3deac1ed5d] bin/mysqlbackup[0x46b14d] mysqlbackup: ERROR: Error while getting current log file from server in initialization for online backup. mysqlbackup: TRACE_1: Error occurred and closing threads. mysqlbackup: TRACE_2: Value for Server Variable innodb_file_format is: Antelope mysqlbackup: TRACE_1: Inserting to history table. mysqlbackup: TRACE_1: Inserting to progress table. mysqlbackup failed with errors!