cat t/rpl_bug106493.test # rpl_bug106493.test --source include/master-slave.inc --echo [On Master] --connection master create database test_db CHARACTER SET utf8mb4; use test_db; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */; INSERT INTO table_1 (ownerId, pageId, param1, param2) VALUES (0x93f213c750078811a5be227e832b715c, '1', 1, NULL), (0xfe218d10b6a0f75ad272ec6f76ef1e07, '1', 1, NULL) ON DUPLICATE KEY UPDATE ownerId = VALUES(ownerId), pageId = VALUES(pageId), param1 = VALUES(param1), param2 = VALUES(param2); --echo [On Slave] --connection slave query_vertical show slave status; --echo [On Master] --connection master INSERT INTO table_1 (ownerId, pageId, param1, param2) VALUES (0xfe218d10b6a0f75ad272ec6f76ef1e07, '1', 1, 'test update') ON DUPLICATE KEY UPDATE ownerId = VALUES(ownerId), pageId = VALUES(pageId), param1 = VALUES(param1), param2 = VALUES(param2); --echo [On Slave] --connection slave query_vertical show slave status; #cleanup --source include/rpl_connection_master.inc DROP DATABASE test_db; --source include/rpl_end.inc cat rpl_bug106493-master.opt --binlog_row_image=minimal --binlog_format=ROW --slave_parallel_type=DATABASE --slave_parallel_workers=0 cat rpl_bug106493-master.opt --binlog_row_image=minimal --binlog_format=ROW --slave_parallel_type=DATABASE --slave_parallel_workers=0 ### 8.0.28 -- affected ./mtr rpl_bug106493 Logging: ./mtr rpl_bug106493 MySQL Version 8.0.28 Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/mysql-commercial-8.0.28/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ [ 50%] main.rpl_bug106493 [ fail ] Test ended at 2022-02-18 06:56:59 CURRENT_TEST: main.rpl_bug106493 mysqltest: At line 158: Error in sync_with_master.inc In included file ./include/rpl_sync.inc: 158 included from ./include/rpl_end.inc: 120 included from /export/home/tmp/ushastry/mysql-commercial-8.0.28/mysql-test/t/rpl_bug106493.test: 38 safe_process[4104]: Child process: 4105, 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] [On Master] create database test_db CHARACTER SET utf8mb4; use test_db; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */; INSERT INTO table_1 (ownerId, pageId, param1, param2) VALUES (0x93f213c750078811a5be227e832b715c, '1', 1, NULL), (0xfe218d10b6a0f75ad272ec6f76ef1e07, '1', 1, NULL) ON DUPLICATE KEY UPDATE ownerId = VALUES(ownerId), pageId = VALUES(pageId), param1 = VALUES(param1), param2 = VALUES(param2); Warnings: Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead [On Slave] show slave status; Slave_IO_State Waiting for source 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 1524 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 591 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running Yes Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Skip_Counter 0 Exec_Master_Log_Pos 373 Relay_Log_Space 1952 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 95a9e087-907f-11ec-862e-020017078e24 Master_Info_File mysql.slave_master_info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State creating table 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 [On Master] INSERT INTO table_1 (ownerId, pageId, param1, param2) VALUES (0xfe218d10b6a0f75ad272ec6f76ef1e07, '1', 1, 'test update') ON DUPLICATE KEY UPDATE ownerId = VALUES(ownerId), pageId = VALUES(pageId), param1 = VALUES(param1), param2 = VALUES(param2); Warnings: Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead Warning 1287 'VALUES function' is deprecated and will be removed in a future release. Please use an alias (INSERT INTO ... VALUES (...) AS alias) and replace VALUES(col) in the ON DUPLICATE KEY UPDATE clause with alias.col instead [On Slave] show slave status; Slave_IO_State Waiting for source 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 1878 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 591 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running Yes Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Skip_Counter 0 Exec_Master_Log_Pos 373 Relay_Log_Space 2306 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 95a9e087-907f-11ec-862e-020017078e24 Master_Info_File mysql.slave_master_info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State creating table 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 [connection master] DROP DATABASE test_db; 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() 2022-02-18 08:56:59 @@SERVER_ID 2 @@SERVER_UUID 95b34054-907f-11ec-8755-020017078e24 @@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 Waiting for source 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 2068 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1742 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 1032 Last_Error Could not execute Update_rows event on table test_db.table_1; Can't find record in 'table_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1847 Skip_Counter 0 Exec_Master_Log_Pos 1524 Relay_Log_Space 2496 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 1032 Last_SQL_Error Could not execute Update_rows event on table test_db.table_1; Can't find record in 'table_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1847 Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 95a9e087-907f-11ec-862e-020017078e24 Master_Info_File mysql.slave_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 220218 08:56:59 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 95a9e087-907f-11ec-862e-020017078e24 THREAD_ID 46 SERVICE_STATE ON COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000 LAST_QUEUED_TRANSACTION ANONYMOUS LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 2022-02-18 08:56:59.655942 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 2022-02-18 08:56:59.655942 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP 2022-02-18 08:56:59.657048 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP 2022-02-18 08:56:59.657053 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 OFF 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 NULL SERVICE_STATE OFF LAST_ERROR_NUMBER 1032 LAST_ERROR_MESSAGE Could not execute Update_rows event on table test_db.table_1; Can't find record in 'table_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1847 LAST_ERROR_TIMESTAMP 2022-02-18 08:56:59.671373 LAST_APPLIED_TRANSACTION ANONYMOUS LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 2022-02-18 08:56:59.635802 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 2022-02-18 08:56:59.635802 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP 2022-02-18 08:56:59.666191 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP 2022-02-18 08:56:59.671261 APPLYING_TRANSACTION ANONYMOUS APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 2022-02-18 08:56:59.640842 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 2022-02-18 08:56:59.640842 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 2022-02-18 08:56:59.671265 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 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL **** replication_asynchronous_connection_failover on server_2 **** SELECT * FROM performance_schema.replication_asynchronous_connection_failover; **** replication_asynchronous_connection_failover_managed on server_2 **** SELECT * FROM performance_schema.replication_asynchronous_connection_failover_managed; **** SHOW MASTER STATUS on server_2 **** SHOW MASTER STATUS; File slave-bin.000001 Position 1540 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 0 Waiting on empty queue NULL 9 root localhost:40920 test Query 0 init SHOW PROCESSLIST 10 root localhost:40922 test Sleep 0 NULL 11 system user connecting host NULL Connect 0 Waiting for source to send event NULL 13 root localhost:40934 test Sleep 0 NULL 14 root localhost:40936 test Sleep 0 NULL **** SELECT * FROM performance_schema.threads on server_2 **** 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 0 NULL NULL NULL NULL YES YES NULL 4012 SYS_default 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4024 SYS_default 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4025 SYS_default 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4026 SYS_default 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4027 SYS_default 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4028 SYS_default 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4029 SYS_default 9 thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4030 SYS_default 10 thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4040 SYS_default 11 thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4041 SYS_default 12 thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4042 SYS_default 13 thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4043 SYS_default 14 thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4044 SYS_default 19 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4052 SYS_default 20 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4053 SYS_default 21 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4054 SYS_default 22 thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4063 SYS_default 23 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4064 SYS_default 24 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4065 SYS_default 25 thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4066 SYS_default 26 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4067 USR_default 27 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4068 USR_default 28 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4069 SYS_default 32 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4082 SYS_default 33 thread/innodb/clone_gtid_thread BACKGROUND NULL NULL NULL NULL NULL 0 waiting for handler commit NULL NULL NULL YES YES NULL 4083 SYS_default 34 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4084 SYS_default 35 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4085 SYS_default 36 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4086 SYS_default 37 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4087 SYS_default 38 thread/sql/event_scheduler FOREGROUND 5 event_scheduler localhost NULL Daemon 0 Waiting on empty queue NULL 1 NULL YES YES NULL 4093 SYS_default 39 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4094 SYS_default 40 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4095 SYS_default 41 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4096 SYS_default 42 thread/sql/compress_gtid_table FOREGROUND 7 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 4097 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 4103 USR_default 45 thread/sql/one_connection FOREGROUND 10 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 4106 USR_default 46 thread/sql/replica_io FOREGROUND 11 root localhost NULL Connect 0 Waiting for source to send event NULL 44 NULL YES YES NULL 4109 SYS_default 48 thread/sql/one_connection FOREGROUND 13 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 4114 USR_default 49 thread/sql/one_connection FOREGROUND 14 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 4115 USR_default **** SHOW BINARY LOGS on server_2 **** SHOW BINARY LOGS; Log_name File_size Encrypted slave-bin.000001 1540 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 126 Server ver: 8.0.28-commercial, Binlog ver: 4 slave-bin.000001 126 Previous_gtids 2 157 slave-bin.000001 157 Anonymous_Gtid 1 241 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 241 Query 1 380 create database test_db CHARACTER SET utf8mb4 /* xid=232 */ slave-bin.000001 380 Anonymous_Gtid 1 466 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 466 Query 1 1196 use `test_db`; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */ /* xid=233 */ slave-bin.000001 1196 Anonymous_Gtid 1 1282 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 1282 Query 1 1355 BEGIN slave-bin.000001 1355 Table_map 1 1423 table_id: 164 (test_db.table_1) slave-bin.000001 1423 Write_rows 1 1509 table_id: 164 flags: STMT_END_F slave-bin.000001 1509 Xid 1 1540 COMMIT /* xid=241 */ **** SHOW RELAYLOG EVENTS on server_2 **** 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 126 Server ver: 8.0.28-commercial, Binlog ver: 4 slave-relay-bin.000002 126 Previous_gtids 2 157 slave-relay-bin.000002 157 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 205 Format_desc 1 126 Server ver: 8.0.28-commercial, Binlog ver: 4 slave-relay-bin.000002 327 Rotate 0 0 master-bin.000001;pos=157 slave-relay-bin.000002 375 Anonymous_Gtid 1 234 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 452 Query 1 373 create database test_db CHARACTER SET utf8mb4 /* xid=214 */ slave-relay-bin.000002 591 Anonymous_Gtid 1 452 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 670 Query 1 1182 use `test_db`; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */ /* xid=216 */ slave-relay-bin.000002 1400 Anonymous_Gtid 1 1261 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1479 Query 1 1339 BEGIN slave-relay-bin.000002 1557 Table_map 1 1407 table_id: 164 (test_db.table_1) slave-relay-bin.000002 1625 Write_rows 1 1493 table_id: 164 flags: STMT_END_F slave-relay-bin.000002 1711 Xid 1 1524 COMMIT /* xid=217 */ slave-relay-bin.000002 1742 Anonymous_Gtid 1 1603 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1821 Query 1 1681 BEGIN slave-relay-bin.000002 1899 Table_map 1 1749 table_id: 164 (test_db.table_1) slave-relay-bin.000002 1967 Update_rows 1 1847 table_id: 164 flags: STMT_END_F slave-relay-bin.000002 2065 Xid 1 1878 COMMIT /* xid=219 */ slave-relay-bin.000002 2096 Anonymous_Gtid 1 1955 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 2173 Query 1 2068 DROP DATABASE test_db /* xid=221 */ **** 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 Assign_gtids_to_anonymous_transactions_type Assign_gtids_to_anonymous_transactions_value 14 ./slave-relay-bin.000002 1742 master-bin.000001 1524 0 0 1 NULL NULL 0 STREAM OFF **** 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 Gtid_only 33 master-bin.000001 157 127.0.0.1 root 13000 1 0 0 30 0 95a9e087-907f-11ec-862e-020017078e24 10 00uncompressed 3 NULL 0 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() 2022-02-18 08:56:59 @@SERVER_ID 1 @@SERVER_UUID 95a9e087-907f-11ec-862e-020017078e24 @@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; **** replication_asynchronous_connection_failover on server_1 **** SELECT * FROM performance_schema.replication_asynchronous_connection_failover; **** replication_asynchronous_connection_failover_managed on server_1 **** SELECT * FROM performance_schema.replication_asynchronous_connection_failover_managed; **** SHOW MASTER STATUS on server_1 **** SHOW MASTER STATUS; File master-bin.000001 Position 2068 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on server_1 **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13002 Master_id 1 Slave_UUID 95b34054-907f-11ec-8755-020017078e24 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 0 Waiting on empty queue NULL 9 root localhost test Sleep 0 NULL 10 root localhost:45636 test Query 0 init SHOW PROCESSLIST 11 root localhost:45638 test Sleep 0 NULL 12 root localhost:45640 NULL Binlog Dump 0 Source has sent all binlog to replica; waiting for more updates NULL 13 root localhost:45642 NULL Sleep 0 NULL 14 root localhost:45644 test Sleep 0 NULL **** SELECT * FROM performance_schema.threads on server_1 **** 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 0 NULL NULL NULL NULL YES YES NULL 4010 SYS_default 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4015 SYS_default 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4016 SYS_default 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4017 SYS_default 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4018 SYS_default 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4019 SYS_default 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4020 SYS_default 9 thread/innodb/page_flush_coordinator_thread BACKGROUND NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL YES YES NULL 4021 SYS_default 10 thread/innodb/log_checkpointer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4031 SYS_default 11 thread/innodb/log_flush_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4032 SYS_default 12 thread/innodb/log_flusher_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4033 SYS_default 13 thread/innodb/log_write_notifier_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4034 SYS_default 14 thread/innodb/log_writer_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4035 SYS_default 19 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4049 SYS_default 20 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4050 SYS_default 21 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4051 SYS_default 22 thread/innodb/buf_resize_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4055 SYS_default 23 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4056 SYS_default 24 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4057 SYS_default 25 thread/innodb/fts_optimize_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4058 SYS_default 26 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4059 USR_default 27 thread/mysqlx/worker BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4060 USR_default 28 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4061 SYS_default 32 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4074 SYS_default 33 thread/innodb/clone_gtid_thread BACKGROUND NULL NULL NULL NULL NULL 0 waiting for handler commit NULL NULL NULL YES YES NULL 4075 SYS_default 34 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4076 SYS_default 35 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4077 SYS_default 36 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4078 SYS_default 37 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 4079 SYS_default 38 thread/sql/event_scheduler FOREGROUND 5 event_scheduler localhost NULL Daemon 0 Waiting on empty queue NULL 1 NULL YES YES NULL 4088 SYS_default 39 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4089 SYS_default 40 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4090 SYS_default 41 thread/mysqlx/acceptor_network BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 4091 SYS_default 42 thread/sql/compress_gtid_table FOREGROUND 7 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 4092 SYS_default 44 thread/sql/one_connection FOREGROUND 9 root localhost test Sleep 0 NULL NULL NULL NULL YES YES Socket 4102 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 4107 USR_default 46 thread/sql/one_connection FOREGROUND 11 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 4108 USR_default 47 thread/sql/one_connection FOREGROUND 12 root localhost NULL Binlog Dump 0 Source has sent all binlog to replica; waiting for more updates NULL 1 NULL YES YES TCP/IP 4111 USR_default 48 thread/sql/one_connection FOREGROUND 13 root localhost NULL Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 4112 USR_default 49 thread/sql/one_connection FOREGROUND 14 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 4113 USR_default **** SHOW BINARY LOGS on server_1 **** SHOW BINARY LOGS; Log_name File_size Encrypted master-bin.000001 2068 No **** SHOW BINLOG EVENTS on server_1 **** 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 126 Server ver: 8.0.28-commercial, Binlog ver: 4 master-bin.000001 126 Previous_gtids 1 157 master-bin.000001 157 Anonymous_Gtid 1 234 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 234 Query 1 373 create database test_db CHARACTER SET utf8mb4 /* xid=214 */ master-bin.000001 373 Anonymous_Gtid 1 452 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 452 Query 1 1182 use `test_db`; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */ /* xid=216 */ master-bin.000001 1182 Anonymous_Gtid 1 1261 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1261 Query 1 1339 BEGIN master-bin.000001 1339 Table_map 1 1407 table_id: 164 (test_db.table_1) master-bin.000001 1407 Write_rows 1 1493 table_id: 164 flags: STMT_END_F master-bin.000001 1493 Xid 1 1524 COMMIT /* xid=217 */ master-bin.000001 1524 Anonymous_Gtid 1 1603 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1603 Query 1 1681 BEGIN master-bin.000001 1681 Table_map 1 1749 table_id: 164 (test_db.table_1) master-bin.000001 1749 Update_rows 1 1847 table_id: 164 flags: STMT_END_F master-bin.000001 1847 Xid 1 1878 COMMIT /* xid=219 */ master-bin.000001 1878 Anonymous_Gtid 1 1955 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1955 Query 1 2068 DROP DATABASE test_db /* xid=221 */ **** 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 Assign_gtids_to_anonymous_transactions_type Assign_gtids_to_anonymous_transactions_value **** 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 Gtid_only **** 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; ERROR: sync_slave_sql.inc failed on connection 'server_2' ERROR: use_gtids='0' ERROR: _saved_gtids='' ERROR: _saved_file='master-bin.000001' ERROR: _saved_pos='2068' ERROR: _saved_channel_name= ERROR: timeout='300' ERROR: result='-2' ERROR: error type: The slave SQL thread was not started, the slave's master information was not initialized, the arguments were incorrect, or an error occurred. ------------ MYSQLTEST OUTPUT END ----------- - the logfile can be found in '/export/home/tmp/ushastry/mysql-commercial-8.0.28/mysql-test/var/log/main.rpl_bug106493/rpl_bug106493.log' [100%] shutdown_report [ pass ] ------------------------------------------------------------------------------ The servers were restarted 0 times The servers were reinitialized 0 times Spent 0.000 of 7 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): main.rpl_bug106493 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 ############## 5.7.37 ./mtr rpl_bug106493 Logging: ./mtr rpl_bug106493 MySQL Version 5.7.37 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/home/tmp/ushastry/mysql-advanced-5.7.37/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] [On Master] create database test_db CHARACTER SET utf8mb4; use test_db; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */; INSERT INTO table_1 (ownerId, pageId, param1, param2) VALUES (0x93f213c750078811a5be227e832b715c, '1', 1, NULL), (0xfe218d10b6a0f75ad272ec6f76ef1e07, '1', 1, NULL) ON DUPLICATE KEY UPDATE ownerId = VALUES(ownerId), pageId = VALUES(pageId), param1 = VALUES(param1), param2 = VALUES(param2); [On Slave] show slave status; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1440 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 559 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running Yes Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Skip_Counter 0 Exec_Master_Log_Pos 344 Relay_Log_Space 1862 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 183b8ae3-9080-11ec-9392-020017078e24 Master_Info_File /export/home/tmp/ushastry/mysql-advanced-5.7.37/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State creating table 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 [On Master] INSERT INTO table_1 (ownerId, pageId, param1, param2) VALUES (0xfe218d10b6a0f75ad272ec6f76ef1e07, '1', 1, 'test update') ON DUPLICATE KEY UPDATE ownerId = VALUES(ownerId), pageId = VALUES(pageId), param1 = VALUES(param1), param2 = VALUES(param2); [On Slave] show slave status; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1765 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 559 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running Yes Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno 0 Last_Error Skip_Counter 0 Exec_Master_Log_Pos 344 Relay_Log_Space 2187 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 183b8ae3-9080-11ec-9392-020017078e24 Master_Info_File /export/home/tmp/ushastry/mysql-advanced-5.7.37/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State creating table 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 [connection master] DROP DATABASE test_db; 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() 2022-02-18 09:00:38 @@SERVER_ID 2 @@SERVER_UUID 18446e87-9080-11ec-935c-020017078e24 @@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 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 1931 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1655 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 1032 Last_Error Could not execute Update_rows event on table test_db.table_1; Can't find record in 'table_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1734 Skip_Counter 0 Exec_Master_Log_Pos 1440 Relay_Log_Space 2353 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 1032 Last_SQL_Error Could not execute Update_rows event on table test_db.table_1; Can't find record in 'table_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1734 Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 183b8ae3-9080-11ec-9392-020017078e24 Master_Info_File /export/home/tmp/ushastry/mysql-advanced-5.7.37/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 220218 09:00:38 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 183b8ae3-9080-11ec-9392-020017078e24 THREAD_ID 26 SERVICE_STATE ON COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00 **** replication_applier_status on server_2 **** SELECT * FROM performance_schema.replication_applier_status; CHANNEL_NAME SERVICE_STATE OFF 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 NULL SERVICE_STATE OFF LAST_SEEN_TRANSACTION ANONYMOUS LAST_ERROR_NUMBER 1032 LAST_ERROR_MESSAGE Could not execute Update_rows event on table test_db.table_1; Can't find record in 'table_1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1734 LAST_ERROR_TIMESTAMP 2022-02-18 09:00:38 **** 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 1428 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:39370 test Query 0 starting SHOW PROCESSLIST 4 root localhost:39372 test Sleep 0 NULL 5 system user NULL Connect 0 Waiting for master to send event NULL 7 root localhost:39384 test Sleep 0 NULL 8 root localhost:39386 test Sleep 0 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 1 NULL NULL NULL NULL YES YES NULL 5116 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 5127 3 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5141 4 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5140 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5142 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5143 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5145 8 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5146 9 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5144 11 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5150 12 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5151 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5152 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5153 15 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5154 16 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5155 17 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5156 18 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5157 19 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5158 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5159 21 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 5162 22 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 1 Suspending NULL 1 NULL YES YES NULL 5163 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 5169 25 thread/sql/one_connection FOREGROUND 4 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 5172 26 thread/sql/slave_io FOREGROUND 5 root localhost NULL Connect 0 Waiting for master to send event NULL 24 NULL YES YES NULL 5175 28 thread/sql/one_connection FOREGROUND 7 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 5180 29 thread/sql/one_connection FOREGROUND 8 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 5181 **** SHOW BINARY LOGS on server_2 **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 1428 **** 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.37-enterprise-commercial-advanced-log, Binlog ver: 4 slave-bin.000001 123 Previous_gtids 2 154 slave-bin.000001 154 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 219 Query 1 344 create database test_db CHARACTER SET utf8mb4 slave-bin.000001 344 Anonymous_Gtid 1 409 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 409 Query 1 1125 use `test_db`; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */ slave-bin.000001 1125 Anonymous_Gtid 1 1190 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-bin.000001 1190 Query 1 1253 BEGIN slave-bin.000001 1253 Table_map 1 1314 table_id: 222 (test_db.table_1) slave-bin.000001 1314 Write_rows 1 1397 table_id: 222 flags: STMT_END_F slave-bin.000001 1397 Xid 1 1428 COMMIT /* xid=221 */ **** SHOW RELAYLOG EVENTS on server_2 **** 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.37-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.37-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 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 434 Query 1 344 create database test_db CHARACTER SET utf8mb4 slave-relay-bin.000002 559 Anonymous_Gtid 1 409 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 624 Query 1 1125 use `test_db`; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */ slave-relay-bin.000002 1340 Anonymous_Gtid 1 1190 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1405 Query 1 1265 BEGIN slave-relay-bin.000002 1480 Table_map 1 1326 table_id: 222 (test_db.table_1) slave-relay-bin.000002 1541 Write_rows 1 1409 table_id: 222 flags: STMT_END_F slave-relay-bin.000002 1624 Xid 1 1440 COMMIT /* xid=179 */ slave-relay-bin.000002 1655 Anonymous_Gtid 1 1505 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1720 Query 1 1580 BEGIN slave-relay-bin.000002 1795 Table_map 1 1641 table_id: 222 (test_db.table_1) slave-relay-bin.000002 1856 Update_rows 1 1734 table_id: 222 flags: STMT_END_F slave-relay-bin.000002 1949 Xid 1 1765 COMMIT /* xid=180 */ slave-relay-bin.000002 1980 Anonymous_Gtid 1 1830 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 2045 Query 1 1931 DROP DATABASE test_db **** 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() 2022-02-18 09:00:38 @@SERVER_ID 1 @@SERVER_UUID 183b8ae3-9080-11ec-9392-020017078e24 @@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.000001 Position 1931 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on server_1 **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 Slave_UUID 18446e87-9080-11ec-935c-020017078e24 **** SHOW PROCESSLIST on server_1 **** SHOW PROCESSLIST; Id User Host db Command Time State Info 3 root localhost test Sleep 0 NULL 4 root localhost:45694 test Query 0 starting SHOW PROCESSLIST 5 root localhost:45696 test Sleep 0 NULL 6 root localhost:45698 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 7 root localhost:45700 NULL Sleep 0 NULL 8 root localhost:45702 test Sleep 0 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 1 NULL NULL NULL NULL YES YES NULL 5114 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 5118 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5119 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5120 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5121 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5122 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5123 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5124 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5125 11 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5128 12 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5129 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5130 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5131 15 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5132 16 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5133 17 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5134 18 thread/innodb/srv_worker_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5135 19 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5136 20 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5137 21 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 5147 22 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 1 Suspending NULL 1 NULL YES YES NULL 5148 24 thread/sql/one_connection FOREGROUND 3 root localhost test Sleep 0 NULL NULL NULL NULL YES YES Socket 5168 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 5173 26 thread/sql/one_connection FOREGROUND 5 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 5174 27 thread/sql/one_connection FOREGROUND 6 root localhost NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 1 NULL YES YES TCP/IP 5177 28 thread/sql/one_connection FOREGROUND 7 root localhost test_db Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 5178 29 thread/sql/one_connection FOREGROUND 8 root localhost test Sleep 0 NULL NULL 1 NULL YES YES TCP/IP 5179 **** SHOW BINARY LOGS on server_1 **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 1931 **** SHOW BINLOG EVENTS on server_1 **** 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.37-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 123 Previous_gtids 1 154 master-bin.000001 154 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 219 Query 1 344 create database test_db CHARACTER SET utf8mb4 master-bin.000001 344 Anonymous_Gtid 1 409 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 409 Query 1 1125 use `test_db`; CREATE TABLE table_1 ( ownerId binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', pageId tinyint unsigned NOT NULL DEFAULT '1', param1 int unsigned DEFAULT NULL, param2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, needToRemove tinyint unsigned GENERATED ALWAYS AS ((param1 is null) and (param2 is null)) STORED NOT NULL, PRIMARY KEY (ownerId,pageId,needToRemove) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='test table' /*!50100 PARTITION BY LIST (needToRemove) (PARTITION forRemove VALUES IN (1) ENGINE = InnoDB,PARTITION main VALUES IN (0) ENGINE = InnoDB) */ master-bin.000001 1125 Anonymous_Gtid 1 1190 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1190 Query 1 1265 BEGIN master-bin.000001 1265 Table_map 1 1326 table_id: 222 (test_db.table_1) master-bin.000001 1326 Write_rows 1 1409 table_id: 222 flags: STMT_END_F master-bin.000001 1409 Xid 1 1440 COMMIT /* xid=179 */ master-bin.000001 1440 Anonymous_Gtid 1 1505 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1505 Query 1 1580 BEGIN master-bin.000001 1580 Table_map 1 1641 table_id: 222 (test_db.table_1) master-bin.000001 1641 Update_rows 1 1734 table_id: 222 flags: STMT_END_F master-bin.000001 1734 Xid 1 1765 COMMIT /* xid=180 */ master-bin.000001 1765 Anonymous_Gtid 1 1830 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1830 Query 1 1931 DROP DATABASE test_db **** 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; ERROR: sync_slave_sql.inc failed on connection 'server_2' ERROR: use_gtids='0' ERROR: _saved_gtids='' ERROR: _saved_file='master-bin.000001' ERROR: _saved_pos='1931' ERROR: timeout='300' ERROR: result='-2' ERROR: error type: The slave SQL thread was not started, the slave's master information was not initialized, the arguments were incorrect, or an error occurred. [ 50%] main.rpl_bug106493 [ fail ] Test ended at 2022-02-18 07:00:38 CURRENT_TEST: main.rpl_bug106493 mysqltest: In included file ./include/rpl_sync.inc at line 158: included from ./include/rpl_end.inc at line 109: included from /export/home/tmp/ushastry/mysql-advanced-5.7.37/mysql-test/t/rpl_bug106493.test at line 38: At line 158: Error in sync_with_master.inc safe_process[5170]: Child process: 5171, exit: 1 - the logfile can be found in '/export/home/tmp/ushastry/mysql-advanced-5.7.37/mysql-test/var/log/main.rpl_bug106493/rpl_bug106493.log' [100%] shutdown_report [ pass ] -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 3 seconds executing testcases Completed: Failed 1/2 tests, 50.00% were successful. Failing test(s): main.rpl_bug106493 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