// [umshastr@hod03]/export/umesh/server/source: wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.24.tar.gz . . Length: 33178592 (32M) [application/x-tar-gz] Saving to: ‘mysql-5.6.24.tar.gz’ 100%[========================================================================================================================================================>] 33,178,592 331KB/s in 1m 43s 2015-05-07 07:48:42 (316 KB/s) - ‘mysql-5.6.24.tar.gz’ saved [33178592/33178592] [umshastr@hod03]/export/umesh/server/source: md5sum mysql-5.6.24.tar.gz 68e1911f70eb1b02170d4f96bf0f0f88 mysql-5.6.24.tar.gz [umshastr@hod03]/export/umesh/server/source: tar -zxvf mysql-5.6.24.tar.gz [umshastr@hod03]/export/umesh/server/source: cd mysql-5.6.24 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: ll total 688 drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 BUILD -rw-r--r-- 1 umshastr common 142 Mar 25 17:34 BUILD-CMAKE drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 client drwxr-xr-x 4 umshastr common 4096 Mar 25 17:35 cmake -rw-r--r-- 1 umshastr common 21511 Mar 25 17:34 CMakeLists.txt drwxr-xr-x 3 umshastr common 28 Mar 25 17:35 cmd-line-utils -rw-r--r-- 1 umshastr common 19678 Mar 25 17:34 config.h.cmake -rw-r--r-- 1 umshastr common 36826 Mar 25 17:34 configure.cmake -rw-r--r-- 1 umshastr common 17987 Mar 25 17:34 COPYING drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 dbug drwxr-xr-x 2 umshastr common 121 Mar 25 17:35 Docs -rw-r--r-- 1 umshastr common 65958 Mar 25 17:34 Doxyfile-perfschema drwxr-xr-x 3 umshastr common 4096 Mar 25 17:35 extra drwxr-xr-x 4 umshastr common 4096 Mar 25 17:35 include -rw-r--r-- 1 umshastr common 395974 Mar 25 17:35 INSTALL-SOURCE -rw-r--r-- 1 umshastr common 247 Mar 25 17:34 INSTALL-WIN-SOURCE drwxr-xr-x 7 umshastr common 4096 Mar 25 17:35 libevent drwxr-xr-x 3 umshastr common 4096 Mar 25 17:35 libmysql drwxr-xr-x 3 umshastr common 4096 Mar 25 17:35 libmysqld drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 libservices drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 man drwxr-xr-x 10 umshastr common 4096 Mar 25 17:35 mysql-test drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 mysys drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 mysys_ssl drwxr-xr-x 11 umshastr common 4096 Mar 25 17:35 packaging drwxr-xr-x 9 umshastr common 4096 Mar 25 17:35 plugin -rw-r--r-- 1 umshastr common 2496 Mar 25 17:34 README drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 regex drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 scripts drwxr-xr-x 4 umshastr common 12288 Mar 25 17:35 sql drwxr-xr-x 5 umshastr common 4096 Mar 25 17:35 sql-bench drwxr-xr-x 2 umshastr common 147 Mar 25 17:35 sql-common drwxr-xr-x 13 umshastr common 4096 Mar 25 17:35 storage drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 strings drwxr-xr-x 5 umshastr common 4096 Mar 25 17:35 support-files drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 tests drwxr-xr-x 5 umshastr common 125 Mar 25 17:35 unittest -rw-r--r-- 1 umshastr common 88 Mar 25 17:34 VERSION drwxr-xr-x 3 umshastr common 4096 Mar 25 17:35 vio drwxr-xr-x 2 umshastr common 39 Mar 25 17:35 win drwxr-xr-x 2 umshastr common 4096 Mar 25 17:35 zlib [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: vi sql/binlog.cc [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: vi sql/binlog.h [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: vi sql/rpl_slave.cc [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: cmake . -DWITH_DEBUG=1 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: cmake . -DWITH_DEBUG=1 -- Running cmake version 2.8.11 -- Found Git: /usr/bin/git (found version "2.1.0") -- The C compiler identification is GNU 4.8.2 -- The CXX compiler identification is GNU 4.8.2 -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working CXX compiler: /usr/bin/c++ -- Check for working CXX compiler: /usr/bin/c++ -- works -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done . . -- CMAKE_BUILD_TYPE: Debug -- COMPILE_DEFINITIONS: HAVE_CONFIG_H -- CMAKE_C_FLAGS: -fPIC -Wall -Wextra -Wformat-security -Wvla -Wwrite-strings -Wdeclaration-after-statement -Werror -- CMAKE_CXX_FLAGS: -fPIC -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter -Werror -- CMAKE_C_FLAGS_DEBUG: -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DENABLED_DEBUG_SYNC -DSAFE_MUTEX -- CMAKE_CXX_FLAGS_DEBUG: -g -fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing -DENABLED_DEBUG_SYNC -DSAFE_MUTEX -- Configuring done -- Generating done -- Build files have been written to: /export/umesh/server/source/mysql-5.6.24 [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: make -j 16 Scanning dependencies of target INFO_SRC Scanning dependencies of target INFO_BIN Scanning dependencies of target abi_check Scanning dependencies of target zlib Scanning dependencies of target gen_dtrace_header [ 0%] Scanning dependencies of target yassl Scanning dependencies of target vio Scanning dependencies of target regex Scanning dependencies of target taocrypt [ 0%] Scanning dependencies of target comp_sql Scanning dependencies of target mysqlservices Scanning dependencies of target gen_lex_hash Scanning dependencies of target my_safe_process Scanning dependencies of target strings Generating help.c Generating common.h [ 0%] [ 1%] [ 1%] [ 1%] [ 1%] [ 2%] Building C object scripts/CMakeFiles/comp_sql.dir/comp_sql.c.o . . [ 99%] Generating mysqld_dtrace_all.o [100%] [100%] [100%] Building CXX object storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/__/__/__/sql/sql_builtin.cc.o Building CXX object storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/pfs_connect_attr-t.cc.o Building C object storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/__/__/__/mysys/string.c.o Linking CXX executable pfs_connect_attr-t [100%] Built target mysqld_dtrace_all Scanning dependencies of target mysqld [100%] Building CXX object sql/CMakeFiles/mysqld.dir/main.cc.o Linking CXX executable mysqld [100%] Built target pfs_connect_attr-t [100%] Built target mysqld Scanning dependencies of target udf_example [100%] Building CXX object sql/CMakeFiles/udf_example.dir/udf_example.cc.o Linking CXX shared module udf_example.so [100%] Built target udf_example [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24: cd mysql-tests [umshastr@hod03]/export/umesh/server/source/mysql-5.6.24/mysql-test: ./mtr rpl_issue52049 Logging: ./mtr rpl_issue52049 2015-05-07 08:43:31 0 [Note] /export/umesh/server/source/mysql-5.6.24/sql/mysqld (mysqld 5.6.24-debug) starting as process 7132 ... 2015-05-07 08:43:31 7132 [Note] Plugin 'FEDERATED' is disabled. 2015-05-07 08:43:31 7132 [Note] Binlog end 2015-05-07 08:43:31 7132 [Note] Shutting down plugin 'CSV' 2015-05-07 08:43:31 7132 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.24 Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/source/mysql-5.6.24/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] create table t1(f1 int) engine=innodb; insert into t1 values(1); insert into t1 values(2); SET GLOBAL debug="d,gtid_next_bug"; insert into t1 values(1); SET GLOBAL debug=""; insert into t1 values(1); include/stop_slave.inc include/rpl_restart_server.inc [server_number=2] include/start_slave.inc insert into t1 values(1); show slave status; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1490 Relay_Log_File slave-relay-bin.000005 Relay_Log_Pos 703 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running Yes Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Skip_Counter 0 Exec_Master_Log_Pos 1490 Relay_Log_Space 2929 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master 0 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 6254fe9d-f484-11e4-82a6-0010e05f3e06 Master_Info_File /export/umesh/server/source/mysql-5.6.24/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Slave has read all relay log; waiting for the slave I/O thread to update it Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set 6254fe9d-f484-11e4-82a6-0010e05f3e06:1-3:5-6 Executed_Gtid_Set 6254fe9d-f484-11e4-82a6-0010e05f3e06:1-6 Auto_Position 1 main.rpl_issue52049 [ pass ] 6271 MTR's internal check of the test case 'main.rpl_issue52049' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/source/mysql-5.6.24/mysql-test/var/tmp/check-mysqld_2.log'. mysqltest: Results saved in '/export/umesh/server/source/mysql-5.6.24/mysql-test/var/tmp/check-mysqld_2.result'. mysqltest: Connecting to server localhost:13001 (socket /export/umesh/server/source/mysql-5.6.24/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/source/mysql-5.6.24/mysql-test/var/tmp/check-mysqld_2.result 2015-05-07 09:43:36.615050557 +0300 +++ /export/umesh/server/source/mysql-5.6.24/mysql-test/var/tmp/check-mysqld_2.reject 2015-05-07 09:43:43.243184258 +0300 @@ -1,4 +1,4 @@ -Slave_IO_State +Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port # @@ -8,8 +8,8 @@ Relay_Log_File # Relay_Log_Pos # Relay_Master_Log_File # -Slave_IO_Running No -Slave_SQL_Running No +Slave_IO_Running Yes +Slave_SQL_Running Yes Replicate_Do_DB # Replicate_Ignore_DB # Replicate_Do_Table # @@ -30,7 +30,7 @@ Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key -Seconds_Behind_Master NULL +Seconds_Behind_Master 0 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error @@ -42,7 +42,7 @@ Master_Info_File # SQL_Delay 0 SQL_Remaining_Delay NULL -Slave_SQL_Running_State +Slave_SQL_Running_State Slave has read all relay log; waiting for the slave I/O thread to update it Master_Retry_Count # Master_Bind Last_IO_Error_Timestamp @@ -51,7 +51,7 @@ Master_SSL_Crlpath Retrieved_Gtid_Set # Executed_Gtid_Set # -Auto_Position 0 +Auto_Position 1 NAME ENABLED TIMED NAME ENABLED events_stages_current YES @@ -529,6 +529,7 @@ def performance_schema utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +t1 tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok -------------------------------------------------------------------------- The servers were restarted 0 times Spent 6.271 of 15 seconds executing testcases Check of testcase failed for: main.rpl_issue52049 Completed: All 1 tests were successful.