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

ANTLR parser cannot parse MariaDB Table DDL with TRANSACTIONAL attribute

XMLWordPrintable

      The following exception is thrown when doing initial snapshot from MariaDB for table with TRANSACTIONAL attribute:

      org.apache.kafka.connect.errors.ConnectException: mismatched input 'TRANSACTIONAL' expecting {<EOF>, '--'}
      at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230)
      at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:207)
      at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:839)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      at java.lang.Thread.run(Thread.java:748) Caused by: io.debezium.text.ParsingException: mismatched input 'TRANSACTIONAL' expecting {<EOF>, '--'}
      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.reportInputMismatch(DefaultErrorStrategy.java:327)
      at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:139)
      at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:848)
      at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:68)
      at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:41)
      at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)
      at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:306)
      at io.debezium.connector.mysql.SnapshotReader.lambda$readTableSchema$15(SnapshotReader.java:857)
      at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:453)
      at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:394)
      at io.debezium.connector.mysql.SnapshotReader.readTableSchema(SnapshotReader.java:855)
      at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:516) ... 3 more Caused by: org.antlr.v4.runtime.InputMismatchException
      at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:270)
      at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:833) ... 12 more
      

      https://mariadb.com/kb/en/create-table/#transactional

              jpechane Jiri Pechanec
              justinhiza Justin Hiza (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: