the connector `Debezium MySQL connector` failed and returned "Error during binlog processing."
Issue
-
Sending a signal trigger ad hoc snapshot on
Debezium MySQL connector. The connector found the condition was wrong, so astopsignal is sent. Then the connector failed and returned "Error during binlog processing.":[2023-10-05 06:45:42,733] INFO [cdc-connector|task-0] Requested stop of 'INCREMENTAL' snapshot of data collections '[notification]' (io.debezium.connector.mysql.signal.KafkaSignalThread:194) [2023-10-05 06:45:42,733] WARN [cdc-connector|task-0] No active incremental snapshot, stop ignored (io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotChangeEventSource:543) [2023-10-05 06:45:42,944] ERROR [cdc-connector|task-0] Error during binlog processing. Last offset stored = {transaction_id=null, ts_sec=1696488341, file=binlog.000537, pos=361927025, incremental_snapshot_signal_offset=10, incremental_snapshot_maximum_key=aced0005757200135b4c6a6176612e6c616e672e4f626a6563743b90ce589f1073296c02000078700000000174002749443a66666465323137382d336163302d346135372d396230612d356131653532656534613930, gtids=67565de8-ecec-11ed-b3b1-005056810b4f:1-29158083,675664c8-ecec-11ed-b3b1-005056810b4f:1-8,6df201c9-0360-11ed-a558-005056810b4f:1-41999696:42670829-42684608,6df2055a-0360-11ed-a558-005056810b4f:1-18,cdf45b98-035f-11ed-befe-005056810b4f:1-41, server_id=98637717, event=3, incremental_snapshot_collections=[{"incremental_snapshot_collections_id":"notification","incremental_snapshot_collections_additional_condition":null}], incremental_snapshot_primary_key=aced0005757200135b4c6a6176612e6c616e672e4f626a6563743b90ce589f1073296c02000078700000000174002434373562316636382d633938612d346630642d613462662d376164613836626534353762}, binlog reader near position = binlog.000537/361927636 (io.debezium.connector.mysql.MySqlStreamingChangeEventSource:1142) [2023-10-05 06:45:42,944] ERROR [cdc-connector|task-0] Producer failure (io.debezium.pipeline.ErrorHandler:38) io.debezium.DebeziumException: Error processing binlog event at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleEvent(MySqlStreamingChangeEventSource.java:392) at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.lambda$execute$27(MySqlStreamingChangeEventSource.java:922) at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1246) at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:1072) at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:631) at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:932) at java.base/java.lang.Thread.run(Thread.java:829)
Environment
- Red Hat Debezium (Debezium) 2.1.4
- Red Hat OpenShift Container (Openshift) 4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.