Debezium halted at a specific mysql binlog POSITION

4 views
Skip to first unread message

srikant dalai

unread,
Jun 22, 2022, 6:11:07 AMJun 22
to debezium
Hi All,
Today i found that debezium was not moving forward from a particular binlog position. 

In DEBUG logs 
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,313] DEBUG polling records... (io.debezium.connector.base.ChangeEventQueue:234)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,313] DEBUG no records available yet, sleeping a bit... (io.debezium.connector.base.ChangeEventQueue:243)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:251)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG no records available yet, sleeping a bit... (io.debezium.connector.base.ChangeEventQueue:243)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:251)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG no records available yet, sleeping a bit... (io.debezium.connector.base.ChangeEventQueue:243)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:251)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG no records available yet, sleeping a bit... (io.debezium.connector.base.ChangeEventQueue:243)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:251)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG no records available yet, sleeping a bit... (io.debezium.connector.base.ChangeEventQueue:243)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:251)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG no records available yet, sleeping a bit... (io.debezium.connector.base.ChangeEventQueue:243)
Jun 22 11:38:06  connect-standalone.sh: [2022-06-22 11:38:06,813] DEBUG checking for more records... (io.debezium.connector.base.ChangeEventQueue:251)

 
I  had restarted debezium(1.7.1) multiple times without any success. 

we are keeping offset details in /tmp/connect.offset file at :- 
offset.storage.file.filename=/tmp/connect.offsets

Can anyone explain what is causing this issue. and how can I avoid this.

Thanks

Chris Cranford

unread,
Jun 22, 2022, 10:20:26 AMJun 22
to debe...@googlegroups.com, srikant dalai
HI

Unfortunately there isn't much to go on with what you shared.  I would look at the logs to see did you observe any WARN or ERROR messages and if so, could you share those.  You may also try to increase the connector logging to TRACE and see whether you get anymore detail as to why you may not be seeing any records.

Chris
--
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/e4b9a2ef-111e-499f-b238-d2661ad40006n%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages