MySQL 8.4 - "SHOW MASTER STATUS" command was removed

[Andrey Balaganskiy]

Hi 

we are trying to use debezium  2.5.4 with MySQL 8.4 as source and kafka 3.7 as destination distributed system for event streaming, and faced problem with starring replication and "SHOW MASTER STATUS" command 

In 8.4 "SHOW MASTER STATUS" has been removed

https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html

Can this be fixed?

2024-06-05 18:44:36,288 ERROR  MySQL|IN.S0181.MARKET|snapshot  Producer failure   [io.debezium.pipeline.ErrorHandler]
io.debezium.DebeziumException: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:101)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:250)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:234)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:186)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:137)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL  syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER STATUS' at line 1
        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
        at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
        at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:540)
        at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:483)
        at io.debezium.connector.mysql.strategy.mysql.MySqlConnectorAdapter.setOffsetContextBinlogPositionAndGtidDetailsForSnapshot(MySqlConnectorAdapter.java:75)
        at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.determineSnapshotOffset(MySqlSnapshotChangeEventSource.java:292)
        at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.determineSnapshotOffset(MySqlSnapshotChangeEventSource.java:59)
        at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:146)
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:92)
        ... 9 more

[jiri.p...@gmail.com]

Hi,

thanks for the question. There is a WIP about that. If you can contribute it would definitely speed thing up!

Have a nice day

Jiri

[Andrey Balaganskiy]

Hi,

With great pleasure.
How can I help speed up resolution?

среда, 5 июня 2024 г. в 18:23:48 UTC+5, jiri.p...@gmail.com:

[Andrey Balaganskiy]

Hi
We have fixed by our own, need to change "SHOW MASTER STATUS" to "SHOW BINARY LOG STATUS" in docker files
debezium-connector-mysql...Final.jar and mysql-binlog-connector-java...jar
Replication works fine

четверг, 6 июня 2024 г. в 08:46:22 UTC+5, Andrey Balaganskiy: