Redpanda MySQL CDC recreating the snapshot not working with MySQL Server 8.4 and above

[rgoerner]

Deleting the topics and the checkpoints, should result in a fully resync.
This is not working with latest Redpanda Edition.

ERRO[2026-03-11T11:10:05Z] error during MySQL CDC: unable to prepare snapshot: get binlog position: Error 1064 (42000): 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 @service=redpanda-connect label="" path=root.input

You try to execute Master Status, which is not supported from MySQL 8.4 and later.

Thanks.

[josephwoodward]

Hi @rgoerner, thanks for reporting this. I'll take a look.

[rgoerner]

connect/internal/impl/mysql/snapshot.go

Line 231 in 4376b8a

row := s.snapshotConn.QueryRowContext(ctx, "SHOW MASTER STATUS")

Error is here.

[josephwoodward]

@rgoerner This has been fixed in #4094 and will be in the next release. Once again, thank you for reporting this issue!