Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3878

Support AS clause in GRANT statement

XMLWordPrintable

      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
      

            anmohant Anisha Mohanty
            agarman Andrew Garman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: