[umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25/mysql-test: cat t/rpl_bug77417.test -- source include/master-slave.inc -- source include/have_binlog_format_statement.inc --echo [On Slave] connection slave; CREATE DATABASE new_test; --echo [On Master] connection master; use test; CREATE TEMPORARY TABLE bug77417(id int); INSERT INTO bug77417 VALUES(1); SELECT * FROM bug77417; sync_slave_with_master; --echo [On Slave] connection slave; query_vertical SHOW SLAVE STATUS; --echo [On Master] connection master; use test; DROP TEMPORARY TABLE IF EXISTS bug77417; CREATE TEMPORARY TABLE bug77417(id int); INSERT INTO bug77417 VALUES(1); SELECT * FROM bug77417; sync_slave_with_master; --echo [On Master] connection slave; query_vertical SHOW SLAVE STATUS; --source include/rpl_end.inc [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25/mysql-test: cat t/rpl_bug77417-slave.opt --replicate-rewrite-db=test->new_test ########## [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25/mysql-test: ./mtr rpl_bug77417 Logging: ./mtr rpl_bug77417 2015-06-25 09:54:57 0 [Note] /export/umesh/server/binaries/mysql-5.6.25/bin/mysqld (mysqld 5.6.25) starting as process 29240 ... 2015-06-25 09:54:57 29240 [Note] Plugin 'FEDERATED' is disabled. 2015-06-25 09:54:57 29240 [Note] Binlog end 2015-06-25 09:54:57 29240 [Note] Shutting down plugin 'CSV' 2015-06-25 09:54:57 29240 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.25 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.6.25/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] [On Slave] CREATE DATABASE new_test; [On Master] use test; CREATE TEMPORARY TABLE bug77417(id int); INSERT INTO bug77417 VALUES(1); SELECT * FROM bug77417; id 1 [On Slave] 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 496 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 660 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 496 Relay_Log_Space 833 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 7a785aa9-1b0f-11e5-bdfb-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.25/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 Executed_Gtid_Set Auto_Position 0 [On Master] use test; DROP TEMPORARY TABLE IF EXISTS bug77417; CREATE TEMPORARY TABLE bug77417(id int); INSERT INTO bug77417 VALUES(1); SELECT * FROM bug77417; id 1 main.rpl_bug77417 [ fail ] Test ended at 2015-06-25 09:55:00 CURRENT_TEST: main.rpl_bug77417 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 786 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set ========================== === SHOW SLAVE STATUS === ---- 1. ---- 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 1020 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 808 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 1050 Last_Error Error 'Table 'bug77417' already exists' on query. Default database: 'new_test'. Query: 'CREATE TEMPORARY TABLE bug77417(id int)' Skip_Counter 0 Exec_Master_Log_Pos 644 Relay_Log_Space 1357 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 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1050 Last_SQL_Error Error 'Table 'bug77417' already exists' on query. Default database: 'new_test'. Query: 'CREATE TEMPORARY TABLE bug77417(id int)' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 7a785aa9-1b0f-11e5-bdfb-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.25/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 150625 10:55:00 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:56934 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:56935 db test Command Sleep Time 0 State Info ---- 3. ---- Id 4 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 6 User root Host localhost:56941 db test Command Query Time 0 State init Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:56942 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 31: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 1020, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-5.6.25/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2015-06-25 10:55:00 @@SERVER_ID 1 @@SERVER_UUID 7a785aa9-1b0f-11e5-bdfb-0010e05f3e06 @@PORT 13000 **** GTID_* on default **** SELECT @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 1140 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 Slave_UUID 7aae5a72-1b0f-11e5-bdfb-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:59217 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 8 root localhost NULL Query 0 init SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 1140 **** SHOW BINLOG EVENTS on default **** binlog_name = 'master-bin.000001' SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 120 Server ver: 5.6.25-log, Binlog ver: 4 master-bin.000001 120 Query 1 233 use `test`; CREATE TEMPORARY TABLE bug77417(id int) master-bin.000001 233 Query 1 312 BEGIN master-bin.000001 312 Query 1 416 use `test`; INSERT INTO bug77417 VALUES(1) master-bin.000001 416 Query 1 496 COMMIT master-bin.000001 496 Query 1 644 DROP TEMPORARY TABLE IF EXISTS `test`.`bug77417` /* generated by server */ master-bin.000001 644 Query 1 757 use `test`; CREATE TEMPORARY TABLE bug77417(id int) master-bin.000001 757 Query 1 836 BEGIN master-bin.000001 836 Query 1 940 use `test`; INSERT INTO bug77417 VALUES(1) master-bin.000001 940 Query 1 1020 COMMIT master-bin.000001 1020 Query 1 1140 use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `bug77417` **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position rand_seed: '' _rand_state: '' extra debug info if any: '' connection default; == /export/umesh/server/binaries/mysql-5.6.25/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2015-06-25 10:55:00 @@SERVER_ID 2 @@SERVER_UUID 7aae5a72-1b0f-11e5-bdfb-0010e05f3e06 @@PORT 13001 **** GTID_* on default **** SELECT @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on default **** 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 1140 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 808 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 1050 Last_Error Error 'Table 'bug77417' already exists' on query. Default database: 'new_test'. Query: 'CREATE TEMPORARY TABLE bug77417(id int)' Skip_Counter 0 Exec_Master_Log_Pos 644 Relay_Log_Space 1477 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 NULL Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1050 Last_SQL_Error Error 'Table 'bug77417' already exists' on query. Default database: 'new_test'. Query: 'CREATE TEMPORARY TABLE bug77417(id int)' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 7a785aa9-1b0f-11e5-bdfb-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.25/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 150625 10:55:00 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 786 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 4 system user NULL Connect 0 Waiting for master to send event NULL 8 root localhost NULL Query 0 init SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 786 **** SHOW BINLOG EVENTS on default **** binlog_name = 'slave-bin.000001' SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 120 Server ver: 5.6.25-log, Binlog ver: 4 slave-bin.000001 120 Query 2 226 CREATE DATABASE new_test slave-bin.000001 226 Query 1 347 use `new_test`; CREATE TEMPORARY TABLE bug77417(id int) slave-bin.000001 347 Query 1 434 BEGIN slave-bin.000001 434 Query 1 546 use `new_test`; INSERT INTO bug77417 VALUES(1) slave-bin.000001 546 Query 1 634 COMMIT slave-bin.000001 634 Query 1 786 DROP TEMPORARY TABLE IF EXISTS `test`.`bug77417` /* generated by server */ **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'slave-relay-bin.000002' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000002 4 Format_desc 2 120 Server ver: 5.6.25-log, Binlog ver: 4 slave-relay-bin.000002 120 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 168 Format_desc 1 120 Server ver: 5.6.25-log, Binlog ver: 4 slave-relay-bin.000002 284 Query 1 233 use `test`; CREATE TEMPORARY TABLE bug77417(id int) slave-relay-bin.000002 397 Query 1 312 BEGIN slave-relay-bin.000002 476 Query 1 416 use `test`; INSERT INTO bug77417 VALUES(1) slave-relay-bin.000002 580 Query 1 496 COMMIT slave-relay-bin.000002 660 Query 1 644 DROP TEMPORARY TABLE IF EXISTS `test`.`bug77417` /* generated by server */ slave-relay-bin.000002 808 Query 1 757 use `test`; CREATE TEMPORARY TABLE bug77417(id int) slave-relay-bin.000002 921 Query 1 836 BEGIN slave-relay-bin.000002 1000 Query 1 940 use `test`; INSERT INTO bug77417 VALUES(1) slave-relay-bin.000002 1104 Query 1 1020 COMMIT slave-relay-bin.000002 1184 Query 1 1140 use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `bug77417` **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position rand_seed: '' _rand_state: '' extra debug info if any: '' connection default; - saving '/export/umesh/server/binaries/mysql-5.6.25/mysql-test/var/log/main.rpl_bug77417/' to '/export/umesh/server/binaries/mysql-5.6.25/mysql-test/var/log/main.rpl_bug77417/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 3 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug77417 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.25/mysql-test: