[umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test: ./mtr rpl_bug77354 Logging: ./mtr rpl_bug77354 MySQL Version 5.7.8 Checking supported features... - SSL connections supported Collecting tests... mysql-test-run: *** ERROR: Could not find 'rpl_bug77354' in 'main,sys_vars,binlog,federated,gis,rpl,innodb,innodb_gis,innodb_fts,innodb_zip,innodb_undo,perfschema,funcs_1,opt_trace,parts,auth_sec,query_rewrite_plugins,gcol,sysschema' suite(s) [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test: cd t [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test/t: ls -l rpl* -rw-r--r-- 1 umshastr common 1084 Jun 12 18:02 rpl_mysqldump_slave.test [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test/t: pwd /export/umesh/server/binaries/mysql-5.7.8/mysql-test/t [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test/t: cd .. [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test: [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test: ./mtr rpl_bug77354 Logging: ./mtr rpl_bug77354 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/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 [connection master] CREATE FUNCTION `test_func` () RETURNS varchar(30) CHARSET utf8 BEGIN DROP TEMPORARY TABLE IF EXISTS test_func_1; DROP TEMPORARY TABLE IF EXISTS test_func_2; DROP TEMPORARY TABLE IF EXISTS test_func_3; DROP TEMPORARY TABLE IF EXISTS test_func_4; RETURN "hello"; END// SELECT test_func(); test_func() hello DROP FUNCTION test_func; main.rpl_bug77354 [ fail ] Test ended at 2015-06-15 09:20:00 CURRENT_TEST: main.rpl_bug77354 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 816 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-2 ========================== === 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 1431 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1031 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 1837 Last_Error Error 'When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'eead7765-132e-11e5-8347-0010e05f3e06:2'.' on query. Default database: 'test'. Query: 'DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 816 Relay_Log_Space 1853 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 1837 Last_SQL_Error Error 'When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'eead7765-132e-11e5-8347-0010e05f3e06:2'.' on query. Default database: 'test'. Query: 'DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID eead7765-132e-11e5-8347-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8/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 150615 10:20:00 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-3 Executed_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-2 Auto_Position 1 Replicate_Rewrite_DB Channel_Name ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 3 User root Host localhost:52613 db test Command Sleep Time 0 State Info ---- 2. ---- Id 4 User root Host localhost:52614 db test Command Sleep Time 0 State Info ---- 3. ---- Id 5 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 7 User root Host localhost:52620 db test Command Query Time 0 State starting Info SHOW PROCESSLIST ---- 5. ---- Id 8 User root Host localhost:52621 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 32: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 1431, 300)' returned NULL indicating slave SQL thread failure safe_process[23398]: Child process: 23399, exit: 1 == /export/umesh/server/binaries/mysql-5.7.8/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-15 10:20:00 @@SERVER_ID 2 @@SERVER_UUID eee2f740-132e-11e5-8347-0010e05f3e06 @@PORT 13001 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE ON @@GLOBAL.GTID_EXECUTED eead7765-132e-11e5-8347-0010e05f3e06:1-2 @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED Warnings: Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. **** 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 1431 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1031 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 1837 Last_Error Error 'When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'eead7765-132e-11e5-8347-0010e05f3e06:2'.' on query. Default database: 'test'. Query: 'DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 816 Relay_Log_Space 1853 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 1837 Last_SQL_Error Error 'When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'eead7765-132e-11e5-8347-0010e05f3e06:2'.' on query. Default database: 'test'. Query: 'DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID eead7765-132e-11e5-8347-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8/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 150615 10:20:00 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-3 Executed_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-2 Auto_Position 1 Replicate_Rewrite_DB Channel_Name **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID eead7765-132e-11e5-8347-0010e05f3e06 THREAD_ID 23 SERVICE_STATE ON COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET eead7765-132e-11e5-8347-0010e05f3e06:1-3 LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00 **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; CHANNEL_NAME THREAD_ID NULL SERVICE_STATE OFF LAST_ERROR_NUMBER 1837 LAST_ERROR_MESSAGE Error 'When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is 'eead7765-132e-11e5-8347-0010e05f3e06:2'.' on query. Default database: 'test'. Query: 'DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */' LAST_ERROR_TIMESTAMP 2015-06-15 10:20:00 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 816 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-2 **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 system user NULL Connect 0 Waiting for master to send event NULL 9 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 11 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 12 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 15 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 16 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 17 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 18 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 19 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 23 thread/sql/slave_io FOREGROUND 5 root localhost NULL Connect 0 Waiting for master to send event NULL 21 NULL YES YES NULL 27 thread/sql/one_connection FOREGROUND 9 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 816 **** 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 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 slave-bin.000001 123 Previous_gtids 2 154 slave-bin.000001 154 Gtid 1 219 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:1' slave-bin.000001 219 Query 1 600 use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `test_func`() RETURNS varchar(30) CHARSET utf8 BEGIN DROP TEMPORARY TABLE IF EXISTS test_func_1; DROP TEMPORARY TABLE IF EXISTS test_func_2; DROP TEMPORARY TABLE IF EXISTS test_func_3; DROP TEMPORARY TABLE IF EXISTS test_func_4; RETURN "hello"; END slave-bin.000001 600 Gtid 1 665 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:2' slave-bin.000001 665 Query 1 816 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_1` /* 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 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 123 Previous_gtids 2 154 slave-relay-bin.000002 154 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 202 Format_desc 1 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 321 Rotate 0 369 master-bin.000001;pos=154 slave-relay-bin.000002 369 Gtid 1 219 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:1' slave-relay-bin.000002 434 Query 1 600 use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `test_func`() RETURNS varchar(30) CHARSET utf8 BEGIN DROP TEMPORARY TABLE IF EXISTS test_func_1; DROP TEMPORARY TABLE IF EXISTS test_func_2; DROP TEMPORARY TABLE IF EXISTS test_func_3; DROP TEMPORARY TABLE IF EXISTS test_func_4; RETURN "hello"; END slave-relay-bin.000002 815 Gtid 1 665 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:2' slave-relay-bin.000002 880 Query 1 816 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_1` /* generated by server */ slave-relay-bin.000002 1031 Query 1 967 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */ slave-relay-bin.000002 1182 Query 1 1118 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_3` /* generated by server */ slave-relay-bin.000002 1333 Query 1 1269 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_4` /* generated by server */ slave-relay-bin.000002 1484 Gtid 1 1334 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:3' slave-relay-bin.000002 1549 Query 1 1431 use `test`; DROP FUNCTION test_func **** 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 Channel_name **** 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 Channel_name **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; == /export/umesh/server/binaries/mysql-5.7.8/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-15 10:20:00 @@SERVER_ID 1 @@SERVER_UUID eead7765-132e-11e5-8347-0010e05f3e06 @@PORT 13000 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE ON @@GLOBAL.GTID_EXECUTED eead7765-132e-11e5-8347-0010e05f3e06:1-3 @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED Warnings: Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 1431 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set eead7765-132e-11e5-8347-0010e05f3e06:1-3 **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 Slave_UUID eee2f740-132e-11e5-8347-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 6 root localhost:54896 NULL Binlog Dump GTID 0 Master has sent all binlog to slave; waiting for more updates NULL 9 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 3 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 11 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 12 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 15 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 16 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 17 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 18 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 19 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 1 Suspending NULL 1 NULL YES YES NULL 24 thread/sql/one_connection FOREGROUND 6 root localhost NULL Binlog Dump GTID 0 Master has sent all binlog to slave; waiting for more updates NULL 1 NULL YES YES TCP/IP 27 thread/sql/one_connection FOREGROUND 9 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 1431 **** 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 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 123 Previous_gtids 1 154 master-bin.000001 154 Gtid 1 219 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:1' master-bin.000001 219 Query 1 600 use `test`; CREATE DEFINER=`root`@`localhost` FUNCTION `test_func`() RETURNS varchar(30) CHARSET utf8 BEGIN DROP TEMPORARY TABLE IF EXISTS test_func_1; DROP TEMPORARY TABLE IF EXISTS test_func_2; DROP TEMPORARY TABLE IF EXISTS test_func_3; DROP TEMPORARY TABLE IF EXISTS test_func_4; RETURN "hello"; END master-bin.000001 600 Gtid 1 665 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:2' master-bin.000001 665 Query 1 816 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_1` /* generated by server */ master-bin.000001 816 Query 1 967 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_2` /* generated by server */ master-bin.000001 967 Query 1 1118 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_3` /* generated by server */ master-bin.000001 1118 Query 1 1269 DROP TEMPORARY TABLE IF EXISTS `test`.`test_func_4` /* generated by server */ master-bin.000001 1269 Gtid 1 1334 SET @@SESSION.GTID_NEXT= 'eead7765-132e-11e5-8347-0010e05f3e06:3' master-bin.000001 1334 Query 1 1431 use `test`; DROP FUNCTION test_func **** 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 Channel_name **** 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 Channel_name **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; - the logfile can be found in '/export/umesh/server/binaries/mysql-5.7.8/mysql-test/var/log/main.rpl_bug77354/rpl_bug77354.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 6 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug77354 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.7.8/mysql-test: