Error syncing MYSQL source due to multiple connections

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is facing an error while syncing a MYSQL source due to having multiple Airbyte MySQL source-connections connected to the same MySQL DB. The error indicates a conflict with server_uuid/server_id.


Question

Hello, i am facing the error :

	at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.wrap(MySqlStreamingChangeEventSource.java:1091) ~[debezium-connector-mysql-2.5.4.Final.jar:2.5.4.Final]
	at io.debezium.connector.mysql.MySqlStreamingChangeEventSource$ReaderThreadLifecycleListener.onCommunicationFailure(MySqlStreamingChangeEventSource.java:1136) ~[debezium-connector-mysql-2.5.4.Final.jar:2.5.4.Final]
	at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:1096) ~[mysql-binlog-connector-java-0.29.0.jar:0.29.0]
	at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:648) ~[mysql-binlog-connector-java-0.29.0.jar:0.29.0]
	at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:949) ~[mysql-binlog-connector-java-0.29.0.jar:0.29.0]
	at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]
Caused by: com.github.shyiko.mysql.binlog.network.ServerException: A replica with the same server_uuid/server_id as this replica has connected to the source; the first event 'mysql-bin-changelog.000152' at 92120661, the last event read from '/rdsdbdata/log/binlog/mysql-bin-changelog.000152' at 92189748, the last byte read from '/rdsdbdata/log/binlog/mysql-bin-changelog.000152' at 92189748.
	at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:1060) ~[mysql-binlog-connector-java-0.29.0.jar:0.29.0]
	at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:648) ~[mysql-binlog-connector-java-0.29.0.jar:0.29.0]
	at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:949) ~[mysql-binlog-connector-java-0.29.0.jar:0.29.0]
	at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]```
While syncing MYSQL source. Could be it due to the fact i have connected multiple airbyte mysql source-connections (These doesn’t have any streams in common), to the same mysql DB?

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1720606105464119) if you want 
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
["error", "syncing", "mysql-source", "multiple-connections", "server-uuid", "server-id"]
</sub>