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

Error while parsing a MariaDB DDL

XMLWordPrintable

      Problematic DDL:

      ALTER TABLE test_table ADD PRIMARY KEY IF NOT EXISTS (id)

      Tested it without 'IF NOT EXISTS' and it got parsed successfully.

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      MariaDB source connector version 3.0.6.Final

      What is the captured database version and mode of deployment?

      Mariadb AWS RDS

      What behavior do you expect?

      The DDL to be successfully parsed.

      What behavior do you see?

       DDL statement couldn't be parsed.

      Do you see the same behaviour using the latest released Debezium version?

      yes

      Do you have the connector logs, ideally from start till finish?

       

      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 'ALTER TABLE test_table ADD PRIMARY KEY IF NOT EXISTS (id)'
no viable alternative at input 'ALTER TABLE test_table ADD PRIMARY KEY IF NOT'
    at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
    at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
    at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:543)
    at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:310)
    at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136)
    at io.debezium.ddl.parser.mariadb.generated.MariaDBParser.sqlStatements(MariaDBParser.java:1271)
    at io.debezium.ddl.parser.mariadb.generated.MariaDBParser.root(MariaDBParser.java:991)
    at io.debezium.connector.mariadb.antlr.MariaDbAntlrDdlParser.parseTree(MariaDbAntlrDdlParser.java:72)
    at io.debezium.connector.mariadb.antlr.MariaDbAntlrDdlParser.parseTree(MariaDbAntlrDdlParser.java:46)
    at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:76)
    at io.debezium.connector.binlog.BinlogDatabaseSchema.parseDdl(BinlogDatabaseSchema.java:311)
    at io.debezium.connector.binlog.BinlogDatabaseSchema.parseStreamingDdl(BinlogDatabaseSchema.java:258)
    at io.debezium.connector.binlog.BinlogStreamingChangeEventSource.handleQueryEvent(BinlogStreamingChangeEventSource.java:738)
    at io.debezium.connector.binlog.BinlogStreamingChangeEventSource.lambda$execute$5(BinlogStreamingChangeEventSource.java:179)
    at io.debezium.connector.binlog.BinlogStreamingChangeEventSource.handleEvent(BinlogStreamingChangeEventSource.java:571)
    ... 6 common frames omitted
Caused by: org.antlr.v4.runtime.NoViableAltException: null
    at org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2028)
    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.mariadb.generated.MariaDBParser.sqlStatements(MariaDBParser.java:1067)
    ... 15 common frames omitted

       

       

              rh-ee-gpanice Giovanni Panice (Inactive)
              daniel.petrov.01 Daniel Petrov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: