Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1630

Error while deserializing binlog event (same as https://issues.jboss.org/browse/DBZ-1191)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Major
    • None
    • 1.0.0.Beta2
    • mysql-connector
    • None

    Description

      Hi,
      we have the following message:
      {
      "name": "zcs-qas-01",
      "connector":

      { "state": "RUNNING", "worker_id": "hrxkfqdc01.hrx.erp:8083" }

      ,
      "tasks": [
      {
      "id": 0,
      "state": "FAILED",
      "worker_id": "hrxkfqdc01.hrx.erp:8083",
      "trace": "org.apache.kafka.connect.errors.ConnectException: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4

      {timestamp=1574322020000, eventType=EXT_WRITE_ROWS, serverId=4, headerLength=19, dataLength=8118, nextPosition=87973447, flags=0}\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:231)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:534)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1095)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:943)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:580)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:825)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: java.lang.RuntimeException: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4{timestamp=1574322020000, eventType=EXT_WRITE_ROWS, serverId=4, headerLength=19, dataLength=8118, nextPosition=87973447, flags=0}

      \n\tat io.debezium.connector.mysql.BinlogReader.handleServerIncident(BinlogReader.java:603)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:517)\n\t... 5 more\nCaused by: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4

      {timestamp=1574322020000, eventType=EXT_WRITE_ROWS, serverId=4, headerLength=19, dataLength=8118, nextPosition=87973447, flags=0}

      \n\tat com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.deserializeEventData(EventDeserializer.java:300)\n\tat com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.nextEvent(EventDeserializer.java:223)\n\tat io.debezium.connector.mysql.BinlogReader$1.nextEvent(BinlogReader.java:237)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:922)\n\t... 3 more\nCaused by: java.io.EOFException\n\tat com.github.shyiko.mysql.binlog.io.ByteArrayInputStream.read(ByteArrayInputStream.java:190)\n\tat java.io.InputStream.read(InputStream.java:170)\n\tat java.io.InputStream.skip(InputStream.java:224)\n\tat com.github.shyiko.mysql.binlog.io.ByteArrayInputStream.skipToTheEndOfTheBlock(ByteArrayInputStream.java:216)\n\tat com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.deserializeEventData(EventDeserializer.java:296)\n\t... 6 more\n"
      }
      ],
      "type": "source"
      }

      Failed to deserialize data of EventHeaderV4{timestamp=1574322020000, eventType=EXT_WRITE_ROWS, serverId=4, headerLength=19, dataLength=8118, nextPosition=87973447, flags=0

      In a previous issue (DBZ-1191) I can see that it was solved to set a new ajr for the binlog:
      mysql-binlog-connector-java-0.19.1.jar

      But it is the actual version in use

      rw-rr- 1 kafka confluent 171908 Oct 24 13:40 mysql-binlog-connector-java-0.19.1.jar

      Regards,
      Eric

      Attachments

        Activity

          People

            Unassigned Unassigned
            eric.franckx@ngahr.com Eric FRANCKX (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: