-
Bug
-
Resolution: Done
-
Major
-
3.1.0.Final
-
False
-
-
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