2021-08-18 10:01:31,992 ERROR 1 --- [cp-debezium] io.debezium.embedded.EmbeddedEngine : [,,,,,,,,,,,] : Error while trying to run connector class 'io.debezium.connector.mysql.MySqlConnector'
org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:42) ~[debezium-core-1.6.0.Final.jar!/:1.6.0.Final]
at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleEvent(MySqlStreamingChangeEventSource.java:366) ~[debezium-connector-mysql-1.6.0.Final.jar!/:1.6.0.Final]
at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.lambda$execute$25(MySqlStreamingChangeEventSource.java:842) ~[debezium-connector-mysql-1.6.0.Final.jar!/:1.6.0.Final]
at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1118) ~[mysql-binlog-connector-java-0.25.1.jar!/:0.25.1]
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:966) ~[mysql-binlog-connector-java-0.25.1.jar!/:0.25.1]
at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:606) ~[mysql-binlog-connector-java-0.25.1.jar!/:0.25.1]
at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:850) ~[mysql-binlog-connector-java-0.25.1.jar!/:0.25.1]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_292]
Caused by: io.debezium.DebeziumException: Error processing binlog event
... 7 common frames omitted
Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'GRANT SELECT, RELOAD, REPLICATION SLAVE, REPLICATION CLIENT, SHOW VIEW, EVENT, TRIGGER ON *.* TO 'xuser1'@'%','xuser2'@'%' AS 'root'@'%' WITH ROLE 'cloudsqlsuperuser'@'%''
mismatched input 'AS' expecting {<EOF>, '--'}
Caused by: org.antlr.v4.runtime.InputMismatchException: null