The Debezium MySQL connector fails to start "org.apache.kafka.connect.errors.ConnectException: A slave with the same server_uuid/server_id as this slave has connected to the master;"

Solution Verified - Updated -

Issue

  • After deploying my Debezium MySQL connector. The connector fails to start with the following error:

    {
      "name": "inventory-connector-mysql",
      "connector": {
        "state": "RUNNING",
        "worker_id": "10.131.0.11:8083"
      },
      "tasks": [
        {
          "id": 0,
          "state": "FAILED",
          "worker_id": "10.131.0.11:8083",
          "trace": "org.apache.kafka.connect.errors.ConnectException: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.000004' at 1088, the last event read from './mysql-bin.000004' at 1310, the last byte read from './mysql-bin.000004' at 1310. Error code: 1236; SQLSTATE: HY000.\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:196)\n\tat io.debezium.connector.mysql.BinlogReader$ReaderThreadLifecycleListener.onCommunicationFailure(BinlogReader.java:1125)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:985)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:581)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:860)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: com.github.shyiko.mysql.binlog.network.ServerException: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event 'mysql-bin.000004' at 1088, the last event read from './mysql-bin.000004' at 1310, the last byte read from './mysql-bin.000004' at 1310.\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:949)\n\t... 3 more\n"
        }
      ],
      "type": "source"
    }
    

Environment

  • Debezium 1.0.0
  • AMQ Streams 1.4.0
  • OpenShift Container 3.11

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content