Details
-
Bug
-
Resolution: Cannot Reproduce
-
Major
-
None
-
1.0.2.Final, 1.1.0.CR1
-
None
-
We found the correct fix for this. It turns out it was not a debezium code issue.
-
Description
==Log Trace==
2020-03-12 18:28:13,230 - ERROR [blc-localhost:3306:i.d.c.m.BinlogReader@565] - Error while deserializing binlog event at offset
.
Use the mysqlbinlog tool to view the problematic event: mysqlbinlog --start-position=4730 --stop-position=4825 --verbose mysql-bin.000003
2020-03-12 18:28:14,040 - ERROR [blc-localhost:3306:i.d.c.m.BinlogReader@209] - Failed due to error: Error processing binlog event
org.apache.kafka.connect.errors.ConnectException: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4
at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230) ~[1584062427971-0/:na]
at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208) ~[1584062427971-0/:na]
at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:508) [1584062427971-0/:na]
at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1095) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:943) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:580) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:825) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_221]
Caused by: java.lang.RuntimeException: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4{timestamp=1584062341000, eventType=EXT_UPDATE_ROWS, serverId=1, headerLength=19, dataLength=76, nextPosition=4825, flags=0}
at io.debezium.connector.mysql.BinlogReader.handleServerIncident(BinlogReader.java:575) [1584062427971-0/:na]
at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:492) [1584062427971-0/:na]
... 5 common frames omitted
Caused by: com.github.shyiko.mysql.binlog.event.deserialization.EventDataDeserializationException: Failed to deserialize data of EventHeaderV4
at com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.deserializeEventData(EventDeserializer.java:300) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.nextEvent(EventDeserializer.java:223) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at io.debezium.connector.mysql.BinlogReader$1.nextEvent(BinlogReader.java:224) ~[1584062427971-0/:na]
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:922) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
... 3 common frames omitted
Caused by: com.github.shyiko.mysql.binlog.event.deserialization.MissingTableMapEventException: No TableMapEventData has been found for table id:745. Usually that means that you have started reading binary log 'within the logical event group' (e.g. from WRITE_ROWS and not proceeding TABLE_MAP
at com.github.shyiko.mysql.binlog.event.deserialization.AbstractRowsEventDataDeserializer.deserializeRow(AbstractRowsEventDataDeserializer.java:104) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.event.deserialization.UpdateRowsEventDataDeserializer.deserializeRows(UpdateRowsEventDataDeserializer.java:71) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.event.deserialization.UpdateRowsEventDataDeserializer.deserialize(UpdateRowsEventDataDeserializer.java:58) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.event.deserialization.UpdateRowsEventDataDeserializer.deserialize(UpdateRowsEventDataDeserializer.java:33) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
at com.github.shyiko.mysql.binlog.event.deserialization.EventDeserializer.deserializeEventData(EventDeserializer.java:294) ~[mysql-binlog-connector-java-0.19.1.jar:0.19.1]
... 6 common frames omitted