tencent cloud

select version();

mysql> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

mysql> GRANT SELECT, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'user' IDENTIFIED BY 'password'; 

mysql>FLUSH PRIVILEGES;

show variables like "log_bin"

show variables like "log_slave_updates"; 

show variables like "binlog_format";

show variables like "binlog_row_image";

show global variables like '%GTID%';

+--------------------------+-------+
| Variable_name                     | Value |
+--------------------------+-------+
| enforce_gtid_consistency  | ON    |
| gtid_mode                            | ON    |
+--------------------------+-------+

com.github.shyiko.mysql.binlog.network.ServerException: A slave with the same server_uuid/server_id as this slave has connected to the master。

Caused by: org.apache.kafka.connect.errors.ConnectException: The connector is trying to read binlog starting at GTIDs xxx and binlog file 'binlog.xxx', pos=xxx, skipping 4 events plus 1 rows, but this is no longer available on the server. Reconfigure the connector to use a snapshot when needed。

EventDataDeserializationException: Failed to deserialize data of EventHeaderV4 .... Caused by: java.net.SocketException: Connection reset。

ERROR io.debezium.connector.mysql.MySqlStreamingChangeEventSource [] - Error during binlog processing. Last offset stored = null, binlog reader near position = mysql-bin.000044/211839464.
2023-02-20 21:37:28.480 [blc-172.17.48.3:3306] ERROR io.debezium.pipeline.ErrorHandler [] - Producer failure 
io.debezium.DebeziumException: Error processing binlog event.