Error with MySQL connector

midhunsuk...@gmail.com

unread,

Apr 12, 2021, 7:34:36 AM4/12/21

to debezium

Error trace: org.apache.kafka.connect.errors.ConnectException: Could not find first log file name in binary log index file Error code: 1236; SQLSTATE: HY000.
at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230)
at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:196)
at io.debezium.connector.mysql.BinlogReader$ReaderThreadLifecycleListener.onCommunicationFailure(BinlogReader.java:1129)
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:958)
at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:594)
at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:838)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.github.shyiko.mysql.binlog.network.ServerException: Could not find first log file name in binary log index file
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:922)

How to prevent this one?

Joel SALMERON VIVER

unread,

Apr 12, 2021, 7:36:04 AM4/12/21

to debe...@googlegroups.com

Increase binlog retention, for starters…the error indicates that debezium cannot proceed to cdc as a replica, because the master has deleted the binlog file it needs from the position stored

El 12 abr 2021, a les 13:34, midhunsuk...@gmail.com <midhunsuk...@gmail.com> va escriure:

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/4951471d-f387-4d9c-90ad-9fe92217ed12n%40googlegroups.com.

Midhun Sukumaran

unread,

Apr 13, 2021, 1:13:36 PM4/13/21

to debe...@googlegroups.com

But I was running it on schema_only. Why should it look for unavailable logs in that case ?

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/A6FB1B45-4E22-4350-BA30-EDE527733E75%40manomano.com.

--

Regards,

Midhun

Gunnar Morling

unread,

Apr 14, 2021, 11:23:34 AM4/14/21

to debezium

Also with "schema_only" snapshotting, the connector will read the actual binlog once the (schema) snapshot is complete. This mode doesn't mean "take a snapshot and stop".

--Gunnar

Midhun Sukumaran

unread,

Apr 20, 2021, 5:41:33 AM4/20/21

to debe...@googlegroups.com

But it should only check for the available logs in the server right? You meant to say the server is missing some in between logs?

You received this message because you are subscribed to a topic in the Google Groups "debezium" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/debezium/ldctrcXoSiU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/6b0b6c91-70b2-42d1-9505-03948909d79cn%40googlegroups.com.

--

Regards,

Midhun

Reply all

Reply to author

Forward