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

org.antlr.v4.runtime.NoViableAltException on CREATE DEFINER=`web`@`%` PROCEDURE `...

    XMLWordPrintable

Details

    Description

      "org.apache.kafka.connect.errors.ConnectException: no viable alternative at input 'CREATE DEFINER=`web`@`%` PROCEDURE `p_tables_cleanup`(IN i_preserve_days INT, OUT o_result_count INT, OUT o_tables_dropped TEXT)\\n    MODIFIES SQL DATA\\n    COMMENT 'remove ...'\\nBEGIN\\n\\n    DECLARE v_finished INT DEFAULT 0;\\n    DECLARE v_table_name_to_drop VARCHAR(100) DEFAULT \"\";\\n\\n    DECLARE tables_to_remove_cursor CURSOR FOR\\n      SELECT `table_name` FROM `information_schema`.`TABLES`\\n      WHERE `table_schema` = DATABASE'
      at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:200)
      at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:178)
      at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:451)
      at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1055)
      at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:913)
      at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:559)
      at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:793)
      at java.lang.Thread.run(Thread.java:748)
      Caused by: io.debezium.text.ParsingException: no viable alternative at input 'CREATE DEFINER=`web`@`%` PROCEDURE `p_tables_cleanup`(IN i_preserve_days INT, OUT o_result_count INT, OUT o_tables_dropped TEXT)\\n    MODIFIES SQL DATA\\n    COMMENT 'remove ...'\\nBEGIN\\n\\n    DECLARE v_finished INT DEFAULT 0;\\n    DECLARE v_table_name_to_drop VARCHAR(100) DEFAULT \"\";\\n\\n    DECLARE tables_to_remove_cursor CURSOR FOR\\n      SELECT `table_name` FROM `information_schema`.`TABLES`\\n      WHERE `table_schema` = DATABASE'
      at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:40)
      at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
      at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
      at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:282)
      at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:121)
      at io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1072)
      at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:806)
      at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:71)
      at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:44)
      at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)
      at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:303)
      at io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:636)
      at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:435)
      ... 5 more
      Caused by: org.antlr.v4.runtime.NoViableAltException
      at org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2023)
      at org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)
      at org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)
      at io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:880)
      ... 12 more\n",
      

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            pimpelsang Eero Koplimets (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: