// 5.7.8 - not affected [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8-rc/mysql-test: ./mtr k Logging: ./mtr k MySQL Version 5.7.8 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.7.8-rc/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] set names gbk; create table test.`t_?????china`(id int); use test; show tables; Tables_in_test t_?????china drop table test.`t_?????china`; use test; show tables; Tables_in_test include/rpl_end.inc main.k [ pass ] 207 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.207 of 14 seconds executing testcases Completed: All 1 tests were successful. // 5.6.26, 5.6.27 - affected [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8-rc/mysql-test: cd ../../mysql-5.6.26/ [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26: cd mysql-test/ [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26/mysql-test: vi t/k.test [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.26/mysql-test: ./mtr k Logging: ./mtr k 2015-08-12 11:25:35 0 [Note] /export/umesh/server/binaries/mysql-5.6.26/bin/mysqld (mysqld 5.6.26) starting as process 13628 ... 2015-08-12 11:25:35 13628 [Note] Plugin 'FEDERATED' is disabled. 2015-08-12 11:25:35 13628 [Note] Binlog end 2015-08-12 11:25:35 13628 [Note] Shutting down plugin 'MyISAM' 2015-08-12 11:25:35 13628 [Note] Shutting down plugin 'CSV' MySQL Version 5.6.26 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.26/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] set names gbk; create table test.`t_?????china`(id int); use test; show tables; Tables_in_test t_?????china drop table test.`t_?????china`; main.k [ fail ] Test ended at 2015-08-12 11:25:38 CURRENT_TEST: main.k === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 244 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 387 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 408 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 1051 Last_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 244 Relay_Log_Space 724 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 1051 Last_SQL_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 179dbd7f-40d4-11e5-b442-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.26/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 150812 12:25:38 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:46847 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:46848 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:46854 db test Command Query Time 0 State init Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:46855 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 15: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 387, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-5.6.26/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-08-12 12:25:38 @@SERVER_ID 1 @@SERVER_UUID 179dbd7f-40d4-11e5-b442-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 387 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 17d35efe-40d4-11e5-b442-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:49130 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 387 **** 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.26-log, Binlog ver: 4 master-bin.000001 120 Query 1 244 use `test`; create table test.`t_?????china`(id int) master-bin.000001 244 Query 1 387 use `test`; DROP TABLE `t_????????hina` /* generated by server */ **** 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.26/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-08-12 12:25:38 @@SERVER_ID 2 @@SERVER_UUID 17d35efe-40d4-11e5-b442-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 387 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 408 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 1051 Last_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 244 Relay_Log_Space 724 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 1051 Last_SQL_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 179dbd7f-40d4-11e5-b442-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.26/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 150812 12:25:38 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 244 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 244 **** 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.26-log, Binlog ver: 4 slave-bin.000001 120 Query 1 244 use `test`; create table test.`t_?????china`(id int) **** 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.26-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.26-log, Binlog ver: 4 slave-relay-bin.000002 284 Query 1 244 use `test`; create table test.`t_?????china`(id int) slave-relay-bin.000002 408 Query 1 387 use `test`; DROP TABLE `t_????????hina` /* generated by server */ **** 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.26/mysql-test/var/log/main.k/' to '/export/umesh/server/binaries/mysql-5.6.26/mysql-test/var/log/main.k/' -------------------------------------------------------------------------- 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.k 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.26/mysql-test: // 5.6.27 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.27/mysql-test: ./mtr k Logging: ./mtr k 2015-08-12 13:04:50 0 [Note] /export/umesh/server/binaries/mysql-advanced-5.6.27/bin/mysqld (mysqld 5.6.27-enterprise-commercial-advanced) starting as process 20825 ... 2015-08-12 13:04:50 20825 [Note] Plugin 'FEDERATED' is disabled. 2015-08-12 13:04:50 20825 [Note] Binlog end 2015-08-12 13:04:50 20825 [Note] Shutting down plugin 'MyISAM' 2015-08-12 13:04:50 20825 [Note] Shutting down plugin 'CSV' MySQL Version 5.6.27 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-advanced-5.6.27/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] set names gbk; create table test.`t_?????china`(id int); use test; show tables; Tables_in_test t_?????china drop table test.`t_?????china`; main.k [ fail ] Test ended at 2015-08-12 13:04:53 CURRENT_TEST: main.k === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 244 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 387 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 408 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 1051 Last_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 244 Relay_Log_Space 724 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 1051 Last_SQL_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID f5129525-40e1-11e5-b49c-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-advanced-5.6.27/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 150812 14:04:53 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:46893 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:46894 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:46900 db test Command Query Time 0 State init Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:46901 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 15: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 387, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-advanced-5.6.27/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-08-12 14:04:53 @@SERVER_ID 1 @@SERVER_UUID f5129525-40e1-11e5-b49c-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 387 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 f548e86b-40e1-11e5-b49d-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:49176 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 387 **** 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.27-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 120 Query 1 244 use `test`; create table test.`t_?????china`(id int) master-bin.000001 244 Query 1 387 use `test`; DROP TABLE `t_????????hina` /* generated by server */ **** 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-advanced-5.6.27/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-08-12 14:04:53 @@SERVER_ID 2 @@SERVER_UUID f548e86b-40e1-11e5-b49d-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 387 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 408 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 1051 Last_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 244 Relay_Log_Space 724 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 1051 Last_SQL_Error Error 'Unknown table 'test.t_????????????hina'' on query. Default database: 'test'. Query: 'DROP TABLE `t_????????hina` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID f5129525-40e1-11e5-b49c-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-advanced-5.6.27/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 150812 14:04:53 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 244 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 244 **** 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.27-enterprise-commercial-advanced-log, Binlog ver: 4 slave-bin.000001 120 Query 1 244 use `test`; create table test.`t_?????china`(id int) **** 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.27-enterprise-commercial-advanced-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.27-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 284 Query 1 244 use `test`; create table test.`t_?????china`(id int) slave-relay-bin.000002 408 Query 1 387 use `test`; DROP TABLE `t_????????hina` /* generated by server */ **** 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-advanced-5.6.27/mysql-test/var/log/main.k/' to '/export/umesh/server/binaries/mysql-advanced-5.6.27/mysql-test/var/log/main.k/' -------------------------------------------------------------------------- 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.k 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