Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 2.3.1.Final, 2.4.0.Alpha1
Affects Version/s: None
Component/s: mysql-connector
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False

SFDC Cases Counter:
SFDC Cases Open:
SFDC Cases Links:

In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

Bug report

For bug reports, provide this information, please:

What Debezium connector do you use and what version?

Debezium Mysql for Kafka connect

Version: 1.9.7.aiven

What is the connector configuration?

Sensitive info has been redacted.

----------
"name"            = "${local.connector_name}"
"connector.class" = "io.debezium.connector.mysql.MySqlConnector",
"tasks.max"       = 1,

"database.hostname"    = "",
"database.port"        = ,
"database.user"        = "",
"database.password"    = ,
"database.server.id"   = ,
"database.server.name" = "",
"database.ssl.mode"    = "",

"key.converter"                  = "org.apache.kafka.connect.json.JsonConverter",
"key.converter.schemas.enable"   = false,
"value.converter"                = "org.apache.kafka.connect.json.JsonConverter",
"value.converter.schemas.enable" = false,

"database.history.kafka.bootstrap.servers" = "${aiven_kafka.kafkacluster.service_uri}"
"database.history.kafka.topic"             = "schemahistory.cdc",
"include.schema.changes"                   = true,

"decimal.handling.mode" = "double",

"table.include.list"     = "",
"signal.data.collection" = "",

"snapshot.mode"         = "when_needed",
"snapshot.locking.mode" = "none",
"snapshot.fetch.size"   = 5000,

"provide.transaction.metadata" = true,

"topic.prefix"                              = "cdc",
"topic.creation.default.cleanup.policy"     = "compact",
"topic.creation.default.partitions"         = 3,
"topic.creation.default.replication.factor" = 2,
"topic.creation.default.compression.type"   = "lz4",
"topic.creation.groups"                     = "dbz",
"topic.creation.dbz.partitions"             = 1,
"topic.creation.dbz.include"                = "",
"topic.creation.dbz.cleanup.policy"         = "delete",
"topic.creation.dbz.delete.retention.ms"    = 7776000000,

"database.history.producer.security.protocol"       = "",
"database.history.producer.ssl.keystore.type"       = "",
"database.history.producer.ssl.keystore.location"   = "",
"database.history.producer.ssl.keystore.password"   = "",
"database.history.producer.ssl.truststore.location" = "",
"database.history.producer.ssl.truststore.password" = "",
"database.history.producer.ssl.key.password"        = "",

"database.history.consumer.security.protocol"       = "",
"database.history.consumer.ssl.keystore.type"       = "",
"database.history.consumer.ssl.keystore.location"   = "",
"database.history.consumer.ssl.keystore.password"   = "",
"database.history.consumer.ssl.truststore.location" = "",
"database.history.consumer.ssl.truststore.password" = "",
"database.history.consumer.ssl.key.password"        = "",

"database.history.store.only.captured.tables.ddl" = true
"database.history.skip.unparseable.ddl"           = true

"_aiven.restart.on.failure" = true
----------

What is the captured database version and mode of depoyment?

The source is MySQL 8.0.30 hosted in Google CloudSQL managed service.

What behaviour do you expect?

Successful parsing of Mysql statements.

What behaviour do you see?

Connector throws parsing error, advising we open a Jira here.

[2023-06-28 00:31:48,300] ERROR <REDACTED> Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask:210)
io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'ALTER USER 'test_dual_pass'@'cloudsqlproxy~%' IDENTIFIED WITH 'mysql_native_password' AS 'REDACTED' RETAIN CURRENT PASSWORD'
mismatched input 'RETAIN' expecting {<EOF>, '-'}
	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: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:972)
	at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:73)
	at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:45)
	at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:82)
	at io.debezium.relational.history.AbstractDatabaseHistory.lambda$recover$2(AbstractDatabaseHistory.java:152)
	at io.debezium.relational.history.KafkaDatabaseHistory.recoverRecords(KafkaDatabaseHistory.java:335)
	at io.debezium.relational.history.AbstractDatabaseHistory.recover(AbstractDatabaseHistory.java:112)
	at io.debezium.relational.history.DatabaseHistory.recover(DatabaseHistory.java:163)
	at io.debezium.relational.HistorizedRelationalDatabaseSchema.recover(HistorizedRelationalDatabaseSchema.java:62)
	at io.debezium.schema.HistorizedDatabaseSchema.recover(HistorizedDatabaseSchema.java:38)
	at io.debezium.connector.mysql.MySqlConnectorTask.validateAndLoadDatabaseHistory(MySqlConnectorTask.java:353)
	at io.debezium.connector.mysql.MySqlConnectorTask.start(MySqlConnectorTask.java:107)
	at io.debezium.connector.common.BaseSourceTask.start(BaseSourceTask.java:133)
	at org.apache.kafka.connect.runtime.AbstractWorkerSourceTask.initializeAndStart(AbstractWorkerSourceTask.java:274)
	at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:200)
	at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:257)
	at org.apache.kafka.connect.runtime.AbstractWorkerSourceTask.run(AbstractWorkerSourceTask.java:75)
	at org.apache.kafka.connect.runtime.isolation.Plugins.lambda$withClassLoader$1(Plugins.java:181)
	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: 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:955)
	... 22 more

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

Still have issue on latest version in the context of Aiven platform.

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

Stack trace is extent of what we have so far.

How to reproduce the issue using our tutorial deployment?

Run debezium connector on mysql and process statement that includes RETAIN CURRENT PASSWORD. This leads to a parsing error.

Current workaround is setting "database.history.skip.unparseable.ddl" = true in the config. Setting this to false will result in connector stopping when hitting these errors.

Please let us know if there are any additional needed details on this.

is duplicated by

DBZ-7486 Alter User DDL Not Parsing

Closed

links to

RHEA-2023:120698 Red Hat build of Debezium 2.3.4 release

Details

Description

Bug report

What Debezium connector do you use and what version?

What is the connector configuration?

What is the captured database version and mode of depoyment?

What behaviour do you expect?

What behaviour do you see?

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

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

How to reproduce the issue using our tutorial deployment?

Attachments

Issue Links

Easy Agile Planning Poker

Activity

People

Dates