-
Bug
-
Resolution: Done
-
Critical
-
1.1.0.Alpha1
-
None
Hi,
we had the issue-error:
org.apache.kafka.connect.errors.ConnectException: no viable alternative at input 'CREATE DEFINER
We were using a older Debezium, we have saw the issue already log and seems it was solved with : 1.1.aplha01 but atfer setiing this last version it still doesn't work.
kafka@hrxkfddc01:~/scripts> ./status_connector.sh z05-dev-01 { "name": "z05-dev-01", "connector": { "state": "RUNNING", "worker_id": "hrxkfddc01.hrx.erp:8083" }, "tasks": [ { "id": 0, "state": "FAILED", "worker_id": "hrxkfddc01.hrx.erp:8083", "trace": "org.apache.kafka.connect.errors.ConnectException: no viable alternative at input 'CREATE DEFINER=`z02`@`pyxrrd%.pyx.erp` PROCEDURE `sp_refresh_aggregate_tables`(IN CLEAR INT)\\n SQL SECURITY INVOKER\\n COMMENT 'v6: fcs_countries changes; ENHC0016668'\\nBEGIN\\n\\n\\nDECLARE START_TIME TIMESTAMP(3);\\nDECLARE ret_sqlstate CHAR(5) DEFAULT \"00000\";\\nDECLARE errno INT;\\nDECLARE msg TEXT;\\nDECLARE rowcount INT;\\nDECLARE result TEXT;\\n\\n\\nDECLARE GCC CHAR(3);\\n\\n\\nDECLARE CONTINUE HANDLER FOR SQLEXCEPTION\\nBEGIN\\n\\tGET DIAGNOSTICS'\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:231)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:534)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1095)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:943)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:580)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:825)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: io.debezium.text.ParsingException: no viable alternative at input 'CREATE DEFINER=`z02`@`pyxrrd%.pyx.erp` PROCEDURE `sp_refresh_aggregate_tables`(IN CLEAR INT)\\n SQL SECURITY INVOKER\\n COMMENT 'v6: fcs_countries changes; ENHC0016668'\\nBEGIN\\n\\n\\nDECLARE START_TIME TIMESTAMP(3);\\nDECLARE ret_sqlstate CHAR(5) DEFAULT \"00000\";\\nDECLARE errno INT;\\nDECLARE msg TEXT;\\nDECLARE rowcount INT;\\nDECLARE result TEXT;\\n\\n\\nDECLARE GCC CHAR(3);\\n\\n\\nDECLARE CONTINUE HANDLER FOR SQLEXCEPTION\\nBEGIN\\n\\tGET DIAGNOSTICS'\n\tat io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:41)\n\tat org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)\n\tat org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:282)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:121)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1080)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:814)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:68)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:41)\n\tat io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)\n\tat io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:306)\n\tat io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:728)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:517)\n\t... 5 more\nCaused by: org.antlr.v4.runtime.NoViableAltException\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2023)\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:888)\n\t... 12 more\n" } ], "type": "source" }
Regards,
Eric