[DBZ-3686] MySQL Connector error after execute a "create role" statement

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 1.5-next, 1.6.1.Final, 1.7.0.Alpha1
Affects Version/s: None
Component/s: mysql-connector
Labels:
None

Blocked:
False
Ready:
False
Release Note Text:
Undefined
Target Release:

1.7.GA
Git Pull Request:
https://github.com/debezium/debezium/pull/2516
Market:

SFDC Cases Counter:
SFDC Cases Open:
SFDC Cases Links:

trace": "org.apache.kafka.connect.errors.ConnectException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE ROLE 'RL_COMPLIANCE_NSA''\nno viable alternative at input 'CREATE ROLE'\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:241)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:218)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:607)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1104)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:955)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:595)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:839)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE ROLE 'RL_COMPLIANCE_NSA''\nno viable alternative at input 'CREATE ROLE'\n\tat io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)\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:310)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1157)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:885)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:72)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:45)\n\tat io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)\n\tat io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:326)\n\tat io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:810)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:590)\n\t... 5 more\nCaused by: org.antlr.v4.runtime.NoViableAltException\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2026)\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:959)\n\t... 12 more\n"

Rafael Galina (Inactive) created issue - 2021/06/29 4:39 PM

Chris Cranford made changes - 2021/06/30 12:05 PM

Fix Version/s

New: 1.7-next [ 12354171 ]

Chris Cranford made changes - 2021/06/30 12:05 PM

Assignee

New: Chris Cranford [ ccranfor@redhat.com ]

Chris Cranford made changes - 2021/06/30 12:12 PM

Git Pull Request		New: https://github.com/debezium/debezium/pull/2516
Status	Original: Open [ 1 ]	New: Pull Request Sent [ 10011 ]

Jiri Pechanec made changes - 2021/07/01 6:46 AM

Resolution		New: Done [ 1 ]
Status	Original: Pull Request Sent [ 10011 ]	New: Resolved [ 5 ]

Jiri Pechanec made changes - 2021/07/01 6:46 AM

Description

Original: trace": "org.apache.kafka.connect.errors.ConnectException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE ROLE 'RL_COMPLIANCE_NSA''\nno viable alternative at input 'CREATE ROLE'\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:241)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:218)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:607)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1104)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:955)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:595)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:839)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE ROLE 'RL_COMPLIANCE_NSA''\nno viable alternative at input 'CREATE ROLE'\n\tat io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)\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:310)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1157)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:885)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:72)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:45)\n\tat io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)\n\tat io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:326)\n\tat io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:810)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:590)\n\t... 5 more\nCaused by: org.antlr.v4.runtime.NoViableAltException\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2026)\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:959)\n\t... 12 more\n"

New: {noformat}
trace": "org.apache.kafka.connect.errors.ConnectException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE ROLE 'RL_COMPLIANCE_NSA''\nno viable alternative at input 'CREATE ROLE'\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:241)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:218)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:607)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1104)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:955)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:595)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:839)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE ROLE 'RL_COMPLIANCE_NSA''\nno viable alternative at input 'CREATE ROLE'\n\tat io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)\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:310)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1157)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:885)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:72)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:45)\n\tat io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)\n\tat io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:326)\n\tat io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:810)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:590)\n\t... 5 more\nCaused by: org.antlr.v4.runtime.NoViableAltException\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2026)\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:959)\n\t... 12 more\n"
{noformat}

Jiri Pechanec made changes - 2021/07/01 6:48 AM

Fix Version/s		New: 1.5-next [ 12359198 ]
Fix Version/s		New: 1.6-next [ 12359005 ]

Jiri Pechanec made changes - 2021/07/23 7:09 AM

Component/s

New: mysql-connector [ 12323541 ]

Debezium Builder made changes - 2021/07/23 7:09 AM

Target Release

New: 1.6.GA [ 12354419 ]

Debezium Builder made changes - 2021/07/23 8:28 AM

Status

Original: Resolved [ 5 ]

New: Closed [ 6 ]

Jiri Pechanec made changes - 2022/01/18 7:43 AM

Resolution	Original: Done [ 1 ]
Status	Original: Closed [ 6 ]	New: Reopened [ 4 ]

Jiri Pechanec made changes - 2022/01/18 7:48 AM

Target Release

Original: 1.6.GA [ 12354419 ]

New: 1.7.GA [ 12359669 ]

Jiri Pechanec made changes - 2022/01/18 7:52 AM

Resolution		New: Fixed [ 10801 ]
Status	Original: Reopened [ 4 ]	New: Closed [ 6 ]

Assignee:: Chris Cranford

Reporter:: Rafael Galina (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 2021/06/29 4:39 PM

Updated:: 2022/01/18 7:52 AM

Resolved:: 2022/01/18 7:52 AM

Details

Description

Attachments

Easy Agile Planning Poker

Activity

People

Dates