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

DDL statement couldn't be parsed. PAGE_COMPRESSED

XMLWordPrintable

    • False
    • Hide

      None

      Show
      None
    • False
    • Important

      Bug report

      DDL statement couldn't be parsed. MariaDB

      What Debezium connector do you use and what version?

      quay.io/debezium/connect:3.1.0.Finalio.debezium.connector.mariadb.MariaDbConnector

      What is the connector configuration?

      {
      "name": "test1",
      "config": {
      "connector.class": "io.debezium.connector.mariadb.MariaDbConnector",
      "database.hostname": "mariadb",
      "database.port": "3306",
      "database.user": "---",
      "database.password": "---",
      "database.server.id": "1337",
      "topic.prefix": "test1",
      "schema.history.internal.kafka.bootstrap.servers": "kafka:9092",
      "include.schema.changes": false,
      "database.ssl.mode": "disable",
      "schema.history.internal.kafka.topic": "schema-changes.test",
      "event.deserialization.failure.handling.mode": "warn",
      "inconsistent.schema.handling.mode": "fail",
      "tombstones.on.delete": false,
      "event.processing.failure.handling.mode": "fail",
      "transforms": "Reroute",
      "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
      "transforms.Reroute.topic.regex": "(.*)",
      "transforms.Reroute.topic.replacement": "test.test",
      "snapshot.mode": "no_data",
      "value.converter": "org.apache.kafka.connect.json.JsonConverter",
      "value.converter.schemas.enable": false,
      "key.converter": "org.apache.kafka.connect.json.JsonConverter",
      "key.converter.schemas.enable": false
      }
      }

      What is the captured database version and mode of deployment?

      docker image mariadb:10.11.7

      What behavior do you see?

       

      io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `admin_filters` (
      2025-04-10T09:05:12.128142177Z   `id` int(11) NOT NULL AUTO_INCREMENT,
      2025-04-10T09:05:12.128143779Z   `name` varchar(50) DEFAULT NULL,
      2025-04-10T09:05:12.128145413Z   `description` mediumtext DEFAULT NULL,
      2025-04-10T09:05:12.128147138Z   `type` varchar(50) DEFAULT NULL,
      2025-04-10T09:05:12.128148773Z   `list` mediumtext DEFAULT NULL,
      2025-04-10T09:05:12.128150356Z   `sort` mediumtext DEFAULT NULL,
      2025-04-10T09:05:12.128151991Z   `global` enum('Y','N') DEFAULT 'N',
      2025-04-10T09:05:12.128153610Z   `position` int(11) DEFAULT NULL,
      2025-04-10T09:05:12.128155385Z   `id_admin` int(11) DEFAULT NULL,
      2025-04-10T09:05:12.128165243Z   `color` char(7) DEFAULT '#AAB2BD',
      2025-04-10T09:05:12.128166864Z   `favorite` enum('Y','N') DEFAULT 'N',
      2025-04-10T09:05:12.128168352Z   `default_filter` enum('Y','N') DEFAULT 'N',
      2025-04-10T09:05:12.128169755Z   `columns` mediumtext DEFAULT NULL,
      2025-04-10T09:05:12.128171388Z   PRIMARY KEY (`id`),
      2025-04-10T09:05:12.128173070Z   KEY `admin_filters_admin_id_fk` (`id_admin`),
      2025-04-10T09:05:12.128174790Z   CONSTRAINT `admin_filters_admin_id_fk` FOREIGN KEY (`id_admin`) REFERENCES `admins` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
      2025-04-10T09:05:12.128176820Z ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC `PAGE_COMPRESSED`='ON''
      2025-04-10T09:05:12.128182536Z no viable alternative at input 'CREATE TABLE `admin_filters` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `name` varchar(50) DEFAULT NULL,\n  `description` mediumtext DEFAULT NULL,\n  `type` varchar(50) DEFAULT NULL,\n  `list` mediumtext DEFAULT NULL,\n  `sort` mediumtext DEFAULT NULL,\n  `global` enum('Y','N') DEFAULT 'N',\n  `position` int(11) DEFAULT NULL,\n  `id_admin` int(11) DEFAULT NULL,\n  `color` char(7) DEFAULT '#AAB2BD',\n  `favorite` enum('Y','N') DEFAULT 'N',\n  `default_filter` enum('Y','N') DEFAULT 'N',\n  `columns` mediumtext DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `admin_filters_admin_id_fk` (`id_admin`),\n  CONSTRAINT `admin_filters_admin_id_fk` FOREIGN KEY (`id_admin`) REFERENCES `admins` (`id`) ON DELETE CASCADE ON UPDATE CASCADE\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC `PAGE_COMPRESSED`='ON''
      2025-04-10T09:05:12.128187046Z     at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:43)
      2025-04-10T09:05:12.128188979Z     at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
      2025-04-10T09:05:12.128190466Z     at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:543)
      2025-04-10T09:05:12.128192171Z     at org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:310)
      2025-04-10T09:05:12.128193919Z     at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:136)
      2025-04-10T09:05:12.128195557Z     at io.debezium.ddl.parser.mariadb.generated.MariaDBParser.sqlStatements(MariaDBParser.java:1271)
      2025-04-10T09:05:12.128197300Z     at io.debezium.ddl.parser.mariadb.generated.MariaDBParser.root(MariaDBParser.java:991)
      2025-04-10T09:05:12.128199168Z     at io.debezium.connector.mariadb.antlr.MariaDbAntlrDdlParser.parseTree(MariaDbAntlrDdlParser.java:72)
      2025-04-10T09:05:12.128200879Z     at io.debezium.connector.mariadb.antlr.MariaDbAntlrDdlParser.parseTree(MariaDbAntlrDdlParser.java:46)
      2025-04-10T09:05:12.128203087Z     at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:76)
      2025-04-10T09:05:12.128204751Z     at io.debezium.connector.binlog.BinlogDatabaseSchema.parseDdl(BinlogDatabaseSchema.java:311)
      2025-04-10T09:05:12.128206239Z     at io.debezium.connector.binlog.BinlogDatabaseSchema.parseSnapshotDdl(BinlogDatabaseSchema.java:243)
      2025-04-10T09:05:12.128207704Z     at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.addSchemaEvent(BinlogSnapshotChangeEventSource.java:287)
      2025-04-10T09:05:12.128209491Z     at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.lambda$createSchemaEventsForTables$4(BinlogSnapshotChangeEventSource.java:388)
      2025-04-10T09:05:12.128211400Z     at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:561)
      2025-04-10T09:05:12.128213132Z     at io.debezium.jdbc.JdbcConnection.query(JdbcConnection.java:501)
      2025-04-10T09:05:12.128214813Z     at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.createSchemaEventsForTables(BinlogSnapshotChangeEventSource.java:386)
      2025-04-10T09:05:12.128216779Z     at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.readTableStructure(BinlogSnapshotChangeEventSource.java:360)
      2025-04-10T09:05:12.128220397Z     at io.debezium.connector.binlog.BinlogSnapshotChangeEventSource.readTableStructure(BinlogSnapshotChangeEventSource.java:67)
      2025-04-10T09:05:12.128222516Z     at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:163)
      2025-04-10T09:05:12.128224477Z     at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:96)
      2025-04-10T09:05:12.128226130Z     at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:297)
      2025-04-10T09:05:12.128227792Z     at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:281)
      2025-04-10T09:05:12.128229393Z     at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:192)
      2025-04-10T09:05:12.128231065Z     at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:143)
      2025-04-10T09:05:12.128232651Z     at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
      2025-04-10T09:05:12.128234672Z     at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
      2025-04-10T09:05:12.128236194Z     at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
      2025-04-10T09:05:12.128237813Z     at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
      2025-04-10T09:05:12.128240746Z     at java.base/java.lang.Thread.run(Thread.java:1583)
      2025-04-10T09:05:12.128242582Z Caused by: org.antlr.v4.runtime.NoViableAltException
      2025-04-10T09:05:12.128244324Z     at org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2028)
      2025-04-10T09:05:12.128246135Z     at org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)
      2025-04-10T09:05:12.128247651Z     at org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)
      2025-04-10T09:05:12.128249356Z     at io.debezium.ddl.parser.mariadb.generated.MariaDBParser.sqlStatements(MariaDBParser.java:1067)
      2025-04-10T09:05:12.128250849Z     ... 24 more

       

      How to reproduce the issue?

      When mariadb innodb table is created with

       

      innodb_compression_default=ON

       

       

      {{so `PAGE_COMPRESSED`='ON'' is returned from }}SHOW create table

              anmohant Anisha Mohanty (Inactive)
              thepeicka1@gmail.com Leoš Tobolka (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: