-- 5.7.32 ./mtr --debug-server --mysqld='--binlog_format=STATEMENT' bug101339 Logging: ./mtr --debug-server --mysqld=--binlog_format=STATEMENT bug101339 MySQL Version 5.7.32 Using binlog format 'STATEMENT' Checking supported features... - SSL connections supported - binaries are debug compiled Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/home/umshastr/work/binaries/ga/mysql-5.7.32/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== 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 @save_debug=@@global.debug; SET GLOBAL DEBUG='+d,before_dump_thread_acquires_current_mutex'; FLUSH LOGS; include/stop_slave.inc include/start_slave.inc 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.000002 Read_Master_Log_Pos 154 Relay_Log_File slave-relay-bin.000004 Relay_Log_Pos 369 Relay_Master_Log_File master-bin.000002 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 154 Relay_Log_Space 624 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 04c72fa6-18f5-11eb-a602-0000170120c9 Master_Info_File /home/umshastr/work/binaries/ga/mysql-5.7.32/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 more updates 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 Replicate_Rewrite_DB Channel_Name Master_TLS_Version flush binary logs; "Wait_for dump_thread_signal" SET DEBUG_SYNC='now WAIT_FOR dump_thread_signal'; SET DEBUG_SYNC='purge_logs_after_lock_index_before_thread_count SIGNAL parked2 WAIT_FOR go_parked2'; PURGE BINARY LOGS BEFORE '2038-01-19'; "Wait_for parked2" SET DEBUG_SYNC='now WAIT_FOR parked2'; "now signal go to all 2 waiting threads" SET DEBUG_SYNC='now SIGNAL go_dump_thread'; SET DEBUG_SYNC='now SIGNAL go_parked2'; Warnings: Warning 1868 file ./master-bin.000003 was not purged because it is the active log file. "Cleanup" SET DEBUG_SYNC='RESET'; SET GLOBAL DEBUG=@save_debug; include/rpl_end.inc 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 = 'server_2' ############################## server_2 ############################## **** SHOW WARNINGS on server_2 **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on server_2 **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2020-10-28 11:10:25 @@SERVER_ID 2 @@SERVER_UUID 06a442d2-18f5-11eb-a9a0-0000170120c9 @@PORT 13001 **** GTID_* on server_2 **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@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. **** SHOW SLAVE STATUS on server_2 **** SHOW SLAVE STATUS; Slave_IO_State Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000002 Read_Master_Log_Pos 154 Relay_Log_File slave-relay-bin.000004 Relay_Log_Pos 369 Relay_Master_Log_File master-bin.000002 Slave_IO_Running No 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 154 Relay_Log_Space 624 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 1236 Last_IO_Error Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' Last_SQL_Errno 0 Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 04c72fa6-18f5-11eb-a602-0000170120c9 Master_Info_File /home/umshastr/work/binaries/ga/mysql-5.7.32/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 more updates Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp 201028 11:10:25 Last_SQL_Error_Timestamp Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name Master_TLS_Version **** replication_connection_status on server_2 **** SELECT * FROM performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID 04c72fa6-18f5-11eb-a602-0000170120c9 THREAD_ID NULL SERVICE_STATE OFF COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 1236 LAST_ERROR_MESSAGE Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' LAST_ERROR_TIMESTAMP 2020-10-28 11:10:25 **** replication_applier_status on server_2 **** SELECT * FROM performance_schema.replication_applier_status; CHANNEL_NAME SERVICE_STATE ON REMAINING_DELAY NULL COUNT_TRANSACTIONS_RETRIES 0 **** replication_applier_status_by_worker on server_2 **** SELECT * FROM performance_schema.replication_applier_status_by_worker; CHANNEL_NAME WORKER_ID 0 THREAD_ID 31 SERVICE_STATE ON LAST_SEEN_TRANSACTION LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00 **** replication_applier_status_by_coordinator on server_2 **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on server_2 **** SHOW MASTER STATUS; File slave-bin.000001 Position 154 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on server_2 **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on server_2 **** SHOW PROCESSLIST; Id User Host db Command Time State Info 3 root localhost:36290 test Query 0 starting SHOW PROCESSLIST 4 root localhost:36292 test Sleep 1 NULL 7 root localhost:36304 test Sleep 0 NULL 8 root localhost:36306 test Sleep 1 NULL 10 system user NULL Connect 0 Slave has read all relay log; waiting for more updates NULL **** 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 THREAD_OS_ID 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL YES YES NULL 22812 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 22813 3 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22815 4 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22814 5 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22819 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22816 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22818 8 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22817 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22820 11 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22822 12 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22823 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22824 14 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22826 15 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22827 16 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22825 17 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22829 18 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22828 19 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22831 20 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22830 21 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 22846 23 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 3 Suspending NULL 1 NULL YES YES NULL 22848 24 thread/sql/one_connection FOREGROUND 3 root localhost test Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES TCP/IP 22849 25 thread/sql/one_connection FOREGROUND 4 root localhost test Sleep 1 NULL SELECT SUBSTRING('default,default,default,', LENGTH('default') + 2) 1 NULL YES YES TCP/IP 22858 28 thread/sql/one_connection FOREGROUND 7 root localhost test Sleep 0 NULL show slave status 1 NULL YES YES TCP/IP 22869 29 thread/sql/one_connection FOREGROUND 8 root localhost test Sleep 1 NULL SELECT SUBSTRING('server_1,server_1,default,', LENGTH('server_1') + 2) 1 NULL YES YES TCP/IP 22870 31 thread/sql/slave_sql FOREGROUND 10 root localhost NULL Connect 0 Slave has read all relay log; waiting for more updates NULL 28 NULL YES YES NULL 22875 **** SHOW BINARY LOGS on server_2 **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 154 **** SHOW BINLOG EVENTS on server_2 **** 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.32-debug-log, Binlog ver: 4 slave-bin.000001 123 Previous_gtids 2 154 **** SHOW RELAYLOG EVENTS on server_2 **** relaylog_name = 'slave-relay-bin.000004' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000004 4 Format_desc 2 123 Server ver: 5.7.32-debug-log, Binlog ver: 4 slave-relay-bin.000004 123 Previous_gtids 2 154 slave-relay-bin.000004 154 Rotate 1 0 master-bin.000002;pos=4 slave-relay-bin.000004 202 Format_desc 1 123 Server ver: 5.7.32-debug-log, Binlog ver: 4 slave-relay-bin.000004 321 Rotate 0 369 master-bin.000002;pos=154 **** slave_relay_info on server_2 **** 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 server_2 **** 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 Tls_version **** mysql.gtid_executed on server_2 **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end connection server_1; ############################## server_1 ############################## **** SHOW WARNINGS on server_1 **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on server_1 **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2020-10-28 11:10:25 @@SERVER_ID 1 @@SERVER_UUID 04c72fa6-18f5-11eb-a602-0000170120c9 @@PORT 13000 **** GTID_* on server_1 **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@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. **** SHOW SLAVE STATUS on server_1 **** SHOW SLAVE STATUS; **** replication_connection_status on server_1 **** SELECT * FROM performance_schema.replication_connection_status; **** replication_applier_status on server_1 **** SELECT * FROM performance_schema.replication_applier_status; **** replication_applier_status_by_worker on server_1 **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on server_1 **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on server_1 **** SHOW MASTER STATUS; File master-bin.000003 Position 154 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on server_1 **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on server_1 **** SHOW PROCESSLIST; Id User Host db Command Time State Info 3 root localhost test Sleep 1 NULL 4 root localhost:34806 test Query 0 starting SHOW PROCESSLIST 5 root localhost:34808 test Sleep 1 NULL 7 root localhost:34812 test Sleep 0 NULL 8 root localhost:34814 test Sleep 1 NULL **** 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 THREAD_OS_ID 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 6 NULL NULL NULL NULL YES YES NULL 22754 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 22757 3 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22767 4 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22769 5 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22770 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22768 7 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22766 8 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22771 9 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22765 11 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22776 12 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22775 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22777 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22778 15 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22781 16 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22779 17 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22780 18 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22782 19 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22783 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 22784 21 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 22797 22 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 6 Suspending NULL 1 NULL YES YES NULL 22798 24 thread/sql/one_connection FOREGROUND 3 root localhost test Sleep 1 NULL SELECT UUID() NULL NULL YES YES Socket 22844 25 thread/sql/one_connection FOREGROUND 4 root localhost test Query 0 Sending data SELECT * FROM performance_schema.threads 1 NULL YES YES TCP/IP 22859 26 thread/sql/one_connection FOREGROUND 5 root localhost test Sleep 1 NULL SELECT SUBSTRING('server_2,default,default,', LENGTH('server_2') + 2) 1 NULL YES YES TCP/IP 22860 28 thread/sql/one_connection FOREGROUND 7 root localhost test Sleep 0 NULL SET GLOBAL DEBUG=@save_debug 1 NULL YES YES TCP/IP 22867 29 thread/sql/one_connection FOREGROUND 8 root localhost test Sleep 1 NULL SELECT SUBSTRING('server_1,server_1,default,', LENGTH('server_1') + 2) 1 NULL YES YES TCP/IP 22868 **** SHOW BINARY LOGS on server_1 **** SHOW BINARY LOGS; Log_name File_size master-bin.000003 154 **** SHOW BINLOG EVENTS on server_1 **** binlog_name = 'master-bin.000003' SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000003 4 Format_desc 1 123 Server ver: 5.7.32-debug-log, Binlog ver: 4 master-bin.000003 123 Previous_gtids 1 154 **** SHOW RELAYLOG EVENTS on server_1 **** 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 server_1 **** 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 server_1 **** 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 Tls_version **** mysql.gtid_executed on server_1 **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= 1->2 rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology=1->2 connection server_2; Wrong value for Last_IO_Errno. Expected '0', got '1236' [ 50%] main.bug101339 [ fail ] Test ended at 2020-10-28 09:10:25 CURRENT_TEST: main.bug101339 mysqltest: In included file ./include/check_slave_param.inc at line 46: included from ./include/check_slave_no_error.inc at line 32: included from ./include/rpl_end.inc at line 101: included from /home/umshastr/work/binaries/ga/mysql-5.7.32/mysql-test/t/bug101339.test at line 50: At line 45: Wrong value for slave parameter safe_process[22854]: Child process: 22855, exit: 1 - the logfile can be found in '/home/umshastr/work/binaries/ga/mysql-5.7.32/mysql-test/var/log/main.bug101339/bug101339.log' [100%] shutdown_report [ pass ] -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 28 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): main.bug101339 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 - 8.0.22 ./mtr --debug-server --mysqld='--binlog_format=STATEMENT' bug101339 Logging: ./mtr --debug-server --mysqld=--binlog_format=STATEMENT bug101339 MySQL Version 8.0.22 Using binlog format 'STATEMENT' Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Removing old var directory Creating var directory '/home/umshastr/work/binaries/ga/mysql-8.0.22/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [ 50%] main.bug101339 [ fail ] Test ended at 2020-10-28 09:14:18 CURRENT_TEST: main.bug101339 mysqltest: At line 41: Wrong value for slave parameter In included file ./include/check_slave_param.inc: 42 included from ./include/check_slave_no_error.inc: 36 included from ./include/rpl_end.inc: 109 included from /home/umshastr/work/binaries/ga/mysql-8.0.22/mysql-test/t/bug101339.test: 50 safe_process[23983]: Child process: 23984, exit: 1 Mysqltest client output from logfile ----------- MYSQLTEST OUTPUT START ----------- 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 @save_debug=@@global.debug; SET GLOBAL DEBUG='+d,before_dump_thread_acquires_current_mutex'; FLUSH LOGS; include/stop_slave.inc include/start_slave.inc 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.000002 Read_Master_Log_Pos 156 Relay_Log_File slave-relay-bin.000004 Relay_Log_Pos 373 Relay_Master_Log_File master-bin.000002 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 156 Relay_Log_Space 630 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 90babf6b-18f5-11eb-aa69-0000170120c9 Master_Info_File mysql.slave_master_info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Slave has read all relay log; waiting for more updates 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 Replicate_Rewrite_DB Channel_Name Master_TLS_Version Master_public_key_path Get_master_public_key 0 Network_Namespace Warnings: Level Warning Code 1287 Message 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead flush binary logs; "Wait_for dump_thread_signal" SET DEBUG_SYNC='now WAIT_FOR dump_thread_signal'; SET DEBUG_SYNC='purge_logs_after_lock_index_before_thread_count SIGNAL parked2 WAIT_FOR go_parked2'; PURGE BINARY LOGS BEFORE '2038-01-19'; "Wait_for parked2" SET DEBUG_SYNC='now WAIT_FOR parked2'; "now signal go to all 2 waiting threads" SET DEBUG_SYNC='now SIGNAL go_dump_thread'; SET DEBUG_SYNC='now SIGNAL go_parked2'; Warnings: Warning 1868 file ./master-bin.000003 was not purged because it is the active log file. "Cleanup" SET DEBUG_SYNC='RESET'; SET GLOBAL DEBUG=@save_debug; include/rpl_end.inc 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 = 'server_2' ############################## server_2 ############################## **** SHOW WARNINGS on server_2 **** SHOW WARNINGS; Level Code Message Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead **** SELECT replication-related variables on server_2 **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2020-10-28 11:14:17 @@SERVER_ID 2 @@SERVER_UUID 91b4988a-18f5-11eb-8f34-0000170120c9 @@PORT 13002 **** GTID_* on server_2 **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on server_2 **** SHOW SLAVE STATUS; Slave_IO_State Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000002 Read_Master_Log_Pos 156 Relay_Log_File slave-relay-bin.000004 Relay_Log_Pos 373 Relay_Master_Log_File master-bin.000002 Slave_IO_Running No 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 156 Relay_Log_Space 630 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 13114 Last_IO_Error Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' Last_SQL_Errno 0 Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 90babf6b-18f5-11eb-aa69-0000170120c9 Master_Info_File mysql.slave_master_info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Slave has read all relay log; waiting for more updates Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp 201028 11:14:17 Last_SQL_Error_Timestamp Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name Master_TLS_Version Master_public_key_path Get_master_public_key 0 Network_Namespace Warnings: Level Warning Code 1287 Message 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead **** replication_connection_status on server_2 **** SELECT * FROM performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID 90babf6b-18f5-11eb-aa69-0000170120c9 THREAD_ID NULL SERVICE_STATE OFF COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 13114 LAST_ERROR_MESSAGE Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' LAST_ERROR_TIMESTAMP 2020-10-28 11:14:17.861265 LAST_QUEUED_TRANSACTION LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000 **** replication_applier_status on server_2 **** SELECT * FROM performance_schema.replication_applier_status; CHANNEL_NAME SERVICE_STATE ON REMAINING_DELAY NULL COUNT_TRANSACTIONS_RETRIES 0 **** replication_applier_status_by_worker on server_2 **** SELECT * FROM performance_schema.replication_applier_status_by_worker; CHANNEL_NAME WORKER_ID 0 THREAD_ID 51 SERVICE_STATE ON LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_APPLIED_TRANSACTION LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000 APPLYING_TRANSACTION APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000 APPLYING_TRANSACTION_RETRIES_COUNT 0 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000 **** replication_applier_status_by_coordinator on server_2 **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** replication_applier_configuration on server_2 **** SELECT * FROM performance_schema.replication_applier_configuration; CHANNEL_NAME DESIRED_DELAY 0 PRIVILEGE_CHECKS_USER NULL REQUIRE_ROW_FORMAT NO REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM **** SHOW MASTER STATUS on server_2 **** SHOW MASTER STATUS; File slave-bin.000001 Position 156 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on server_2 **** SHOW SLAVE HOSTS; Warnings: Level Warning Code 1287 Message 'SHOW SLAVE HOSTS' is deprecated and will be removed in a future release. Please use SHOW REPLICAS instead **** SHOW PROCESSLIST on server_2 **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 event_scheduler localhost NULL Daemon 2 Waiting on empty queue NULL 9 root localhost:57006 test Query 0 init SHOW PROCESSLIST 10 root localhost:57008 test Sleep 1 NULL 13 root localhost:57020 test Sleep 0 NULL 14 root localhost:57022 test Sleep 0 NULL 16 system user NULL Query 0 Slave has read all relay log; waiting for more updates NULL **** 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 THREAD_OS_ID RESOURCE_GROUP 1 thread/sql/main BACKGROUND NULL NULL NULL mysql NULL 2 NULL NULL NULL NULL YES YES NULL 23911 SYS_default 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23914 SYS_default 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23915 SYS_default 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23916 SYS_default 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23917 SYS_default 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23918 SYS_default 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23919 SYS_default 9 thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL YES YES NULL 23920 SYS_default 10 thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23921 SYS_default 11 thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23922 SYS_default 12 thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23923 SYS_default 13 thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23924 SYS_default 14 thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23925 SYS_default 15 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23935 SYS_default 16 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23936 SYS_default 17 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23937 SYS_default 18 thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23952 SYS_default 19 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL YES YES NULL 23953 SYS_default 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL YES YES NULL 23954 SYS_default 21 thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL YES YES NULL 23955 SYS_default 22 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23956 USR_default 23 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23957 USR_default 24 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23958 SYS_default 28 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23963 SYS_default 29 thread/innodb/clone_gtid_thread BACKGROUND NULL NULL NULL NULL NULL 2 waiting for handler commit NULL NULL NULL YES YES NULL 23964 SYS_default 30 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL YES YES NULL 23965 SYS_default 31 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL YES YES NULL 23966 SYS_default 32 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL YES YES NULL 23967 SYS_default 33 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL YES YES NULL 23968 SYS_default 34 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23965 SYS_default 35 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23966 SYS_default 36 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23967 SYS_default 37 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23968 SYS_default 38 thread/sql/event_scheduler FOREGROUND 5 event_scheduler localhost NULL Daemon 2 Waiting on empty queue NULL 1 NULL YES YES NULL 23976 SYS_default 39 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23977 SYS_default 40 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23978 SYS_default 41 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23979 SYS_default 42 thread/sql/compress_gtid_table FOREGROUND 7 NULL NULL NULL Daemon 2 Suspending NULL 1 NULL YES YES NULL 23980 SYS_default 44 thread/sql/one_connection FOREGROUND 9 root localhost test Query 0 executing SELECT * FROM performance_schema.threads NULL NULL YES YES TCP/IP 23981 USR_default 45 thread/sql/one_connection FOREGROUND 10 root localhost test Sleep 1 NULL NULL 1 NULL YES YES TCP/IP 23985 USR_default 48 thread/sql/one_connection FOREGROUND 13 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 23993 USR_default 49 thread/sql/one_connection FOREGROUND 14 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 23994 USR_default 51 thread/sql/slave_sql FOREGROUND 16 root localhost NULL Query 0 Slave has read all relay log; waiting for more updates NULL 48 NULL YES YES NULL 23999 SYS_default **** SHOW BINARY LOGS on server_2 **** SHOW BINARY LOGS; Log_name File_size Encrypted slave-bin.000001 156 No **** SHOW BINLOG EVENTS on server_2 **** 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 125 Server ver: 8.0.22-debug, Binlog ver: 4 slave-bin.000001 125 Previous_gtids 2 156 **** SHOW RELAYLOG EVENTS on server_2 **** relaylog_name = 'slave-relay-bin.000004' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000004'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000004 4 Format_desc 2 125 Server ver: 8.0.22-debug, Binlog ver: 4 slave-relay-bin.000004 125 Previous_gtids 2 156 slave-relay-bin.000004 156 Rotate 1 0 master-bin.000002;pos=4 slave-relay-bin.000004 204 Format_desc 1 125 Server ver: 8.0.22-debug, Binlog ver: 4 slave-relay-bin.000004 325 Rotate 0 0 master-bin.000002;pos=156 **** slave_relay_info on server_2 **** 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 Privilege_checks_username Privilege_checks_hostname Require_row_format Require_table_primary_key_check 12 ./slave-relay-bin.000004 373 master-bin.000002 156 0 0 1 NULL NULL 0 STREAM **** slave_master_info on server_2 **** 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 Tls_version Public_key_path Get_public_key Network_namespace Master_compression_algorithm Master_zstd_compression_level Tls_ciphersuites Source_connection_auto_failover 32 master-bin.000002 156 127.0.0.1 root 13000 1 0 0 30 0 90babf6b-18f5-11eb-aa69-0000170120c9 10 00uncompressed 3 NULL 0 **** mysql.gtid_executed on server_2 **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end connection server_1; ############################## server_1 ############################## **** SHOW WARNINGS on server_1 **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on server_1 **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2020-10-28 11:14:17 @@SERVER_ID 1 @@SERVER_UUID 90babf6b-18f5-11eb-aa69-0000170120c9 @@PORT 13000 **** GTID_* on server_1 **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on server_1 **** SHOW SLAVE STATUS; Warnings: Level Warning Code 1287 Message 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead **** replication_connection_status on server_1 **** SELECT * FROM performance_schema.replication_connection_status; **** replication_applier_status on server_1 **** SELECT * FROM performance_schema.replication_applier_status; **** replication_applier_status_by_worker on server_1 **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on server_1 **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** replication_applier_configuration on server_1 **** SELECT * FROM performance_schema.replication_applier_configuration; **** SHOW MASTER STATUS on server_1 **** SHOW MASTER STATUS; File master-bin.000003 Position 156 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on server_1 **** SHOW SLAVE HOSTS; Warnings: Level Warning Code 1287 Message 'SHOW SLAVE HOSTS' is deprecated and will be removed in a future release. Please use SHOW REPLICAS instead **** SHOW PROCESSLIST on server_1 **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 event_scheduler localhost NULL Daemon 4 Waiting on empty queue NULL 9 root localhost test Sleep 2 NULL 10 root localhost:34908 test Query 0 init SHOW PROCESSLIST 11 root localhost:34910 test Sleep 2 NULL 13 root localhost:34914 test Sleep 1 NULL 14 root localhost:34916 test Sleep 1 NULL **** 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 THREAD_OS_ID RESOURCE_GROUP 1 thread/sql/main BACKGROUND NULL NULL NULL mysql NULL 4 NULL NULL NULL NULL YES YES NULL 23890 SYS_default 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23894 SYS_default 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23895 SYS_default 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23896 SYS_default 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23897 SYS_default 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23898 SYS_default 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23899 SYS_default 9 thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL 8 NULL NULL NULL NULL YES YES NULL 23900 SYS_default 10 thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23901 SYS_default 11 thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23902 SYS_default 12 thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23903 SYS_default 13 thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23904 SYS_default 14 thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23905 SYS_default 15 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23907 SYS_default 16 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23908 SYS_default 17 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23909 SYS_default 18 thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23927 SYS_default 19 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL 6 NULL NULL NULL NULL YES YES NULL 23928 SYS_default 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL 6 NULL NULL NULL NULL YES YES NULL 23929 SYS_default 21 thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL 6 NULL NULL NULL NULL YES YES NULL 23930 SYS_default 22 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23931 USR_default 23 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23932 USR_default 24 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23933 SYS_default 28 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23941 SYS_default 29 thread/innodb/clone_gtid_thread BACKGROUND NULL NULL NULL NULL NULL 5 waiting for handler commit NULL NULL NULL YES YES NULL 23942 SYS_default 30 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL YES YES NULL 23943 SYS_default 31 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL YES YES NULL 23944 SYS_default 32 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL YES YES NULL 23945 SYS_default 33 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL YES YES NULL 23946 SYS_default 34 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23943 SYS_default 35 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23944 SYS_default 36 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23945 SYS_default 37 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 23946 SYS_default 38 thread/sql/event_scheduler FOREGROUND 5 event_scheduler localhost NULL Daemon 4 Waiting on empty queue NULL 1 NULL YES YES NULL 23947 SYS_default 39 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23948 SYS_default 40 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23949 SYS_default 41 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 23950 SYS_default 42 thread/sql/compress_gtid_table FOREGROUND 7 NULL NULL NULL Daemon 4 Suspending NULL 1 NULL YES YES NULL 23951 SYS_default 44 thread/sql/one_connection FOREGROUND 9 root localhost test Sleep 2 NULL NULL NULL NULL YES YES Socket 23975 USR_default 45 thread/sql/one_connection FOREGROUND 10 root localhost test Query 0 executing SELECT * FROM performance_schema.threads 1 NULL YES YES TCP/IP 23986 USR_default 46 thread/sql/one_connection FOREGROUND 11 root localhost test Sleep 2 NULL NULL 1 NULL YES YES TCP/IP 23987 USR_default 48 thread/sql/one_connection FOREGROUND 13 root localhost test Sleep 1 NULL NULL 1 NULL YES YES TCP/IP 23991 USR_default 49 thread/sql/one_connection FOREGROUND 14 root localhost test Sleep 1 NULL NULL 1 NULL YES YES TCP/IP 23992 USR_default **** SHOW BINARY LOGS on server_1 **** SHOW BINARY LOGS; Log_name File_size Encrypted master-bin.000003 156 No **** SHOW BINLOG EVENTS on server_1 **** binlog_name = 'master-bin.000003' SHOW BINLOG EVENTS IN 'master-bin.000003'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000003 4 Format_desc 1 125 Server ver: 8.0.22-debug, Binlog ver: 4 master-bin.000003 125 Previous_gtids 1 156 **** SHOW RELAYLOG EVENTS on server_1 **** 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 server_1 **** 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 Privilege_checks_username Privilege_checks_hostname Require_row_format Require_table_primary_key_check **** slave_master_info on server_1 **** 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 Tls_version Public_key_path Get_public_key Network_namespace Master_compression_algorithm Master_zstd_compression_level Tls_ciphersuites Source_connection_auto_failover **** mysql.gtid_executed on server_1 **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= 1->2 rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology=1->2 connection server_2; Wrong value for Last_IO_Errno. Expected '0', got '13114' ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/home/umshastr/work/binaries/ga/mysql-8.0.22/mysql-test/var/log/main.bug101339/bug101339.log' [100%] shutdown_report [ pass ] ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 58 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): main.bug101339 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