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

MariaDB's UUID column type cannot be parsed when scheme is loaded

    XMLWordPrintable

Details

    • False
    • None
    • False
    • Important

    Description

      io.debezium/debezium-connector-mysqlversions: 2.2.0.Alpha and 2.1.3.Final

      Connector configuration

      "connector.class" = "io.debezium.connector.mysql.MySqlConnector"
      "offset.storage" = "org.apache.kafka.connect.storage.MemoryOffsetBackingStore"
      "schema.history.internal" = "io.debezium.relational.history.MemorySchemaHistory"
      "schema.history.internal.kafka.topic" = "aa.schema"
      "database.history.skip.unparseable.ddl" = "true"
      "include.schema.changes" = "false"
      "offset.flush.interval.ms" ="60000"
      "name" = "aa-connector"
      "database.hostname" = "127.0.0.1"
      "database.port" = "3306"
      "database.server.id" = "1"
      "database.server.name" = "localhost"
      "database.history" = "io.debezium.relational.history.MemoryDatabaseHistory"
      "snapshot.mode" = "initial"
      "snapshot.locking.mode" = "none"
      "topic.prefix" = "aa"

      Database

      Local MariaDB instance, server version 10.11.2-MariaDB-log on Mac OS X

      Problem

      Schema cannot be parsed for tables containing columns of type UUID.

      Example table:

      CREATE TABLE `aaaa` (`uid` uuid NOT NULL)
      ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

      Log / stacktrace

       
      23:51:11.773 [main] ERROR io.debezium.embedded.EmbeddedEngine - Error while trying to run connector class 'io.debezium.connector.mysql.MySqlConnector'org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:53)at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:116)at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)at java.base/java.lang.Thread.run(Thread.java:833)Caused by: io.debezium.DebeziumException: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `aaaa` (  `uid` uuid NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci'no viable alternative at input 'CREATE TABLE `aaaa` (\n  `uid` uuid'at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:85)at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155)at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137)at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)... 5 common frames omitted{}Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `aaaa` (  `uid` uuid NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci'{}no viable alternative at input 'CREATE TABLE `aaaa` (\n  `uid` uuid'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.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1250)at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:972)at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:74)at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:46)at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:78)at io.debezium.connector.mysql.MySqlDatabaseSchema.parseDdl(MySqlDatabaseSchema.java:213)at io.debezium.connector.mysql.MySqlDatabaseSchema.parseSnapshotDdl(MySqlDatabaseSchema.java:193)at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.addSchemaEvent(MySqlSnapshotChangeEventSource.java:301)at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.lambda$createSchemaEventsForTables$5(MySqlSnapshotChangeEventSource.java:371)at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:540)at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:481)at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.createSchemaEventsForTables(MySqlSnapshotChangeEventSource.java:369)at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:358)at io.debezium.connector.mysql.MySqlSnapshotChangeEventSource.readTableStructure(MySqlSnapshotChangeEventSource.java:50)at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:135)at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:76)... 8 common frames omittedCaused by: org.antlr.v4.runtime.NoViableAltException: nullat 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.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1048)... 23 common frames omitted
       
       

      Attachments

        Activity

          People

            anmohant Anisha Mohanty
            siefca Paweł Wilk (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: