-
Bug
-
Resolution: Unresolved
-
Major
-
2.4.0.Final
-
None
-
False
-
None
-
False
Error while executing the following statement:
io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'alter table descriptors modify Description varchar(512) unicode' extraneous input 'unicode' expecting {<EOF>, '-'}
What Debezium connector do you use and what version?
MySQL, 2.4.0.Final
What is the connector configuration?
DEBEZIUM_SOURCE_CONNECTOR_CLASS: "io.debezium.connector.mysql.MySqlConnector"
DEBEZIUM_SOURCE_OFFSET_STORAGE_FILE_FILENAME: "/debezium/data/offsets.dat"
DEBEZIUM_SOURCE_OFFSET_FLUSH_INTERVAL_MS: "0"
DEBEZIUM_SOURCE_SCHEMA_HISTORY_INTERNAL: "io.debezium.storage.file.history.FileSchemaHistory"
DEBEZIUM_SOURCE_SCHEMA_HISTORY_INTERNAL_FILE_FILENAME: "/debezium/data/history.dat"
DEBEZIUM_SOURCE_SCHEMA_HISTORY_INTERNAL_STORE_ONLY_CAPTURED_DATABASES_DDL: "true"
DEBEZIUM_SOURCE_SCHEMA_HISTORY_INTERNAL_STORE_ONLY_CAPTURED_TABLES_DDL: "true"
DEBEZIUM_SOURCE_KEY_CONVERTER_SCHEMAS_ENABLE: "false"
DEBEZIUM_SOURCE_VALUE_CONVERTER_SCHEMAS_ENABLE: "false"
and also
DEBEZIUM_SOURCE_DATABASE_HOSTNAME
DEBEZIUM_SOURCE_DATABASE_PORT
DEBEZIUM_SOURCE_DATABASE_USER
DEBEZIUM_SOURCE_DATABASE_DBNAME
DEBEZIUM_SOURCE_DATABASE_SERVER_ID
DEBEZIUM_SOURCE_TOPIC_PREFIX
DEBEZIUM_SOURCE_DATABASE_INCLUDE_LIST
DEBEZIUM_SOURCE_TABLE_INCLUDE_LIST
What is the captured database version and mode of depoyment?
mysql Ver 14.14 Distrib 5.7.43-47, for debian-linux-gnu (x86_64) using 7.0
MySQL replicas are behind ProxySQL, and Debezium is connected to ProxySQL.
ProxySQL version 2.5.5-10-g195bd70, codename Truls
What behaviour do you expect?
No exception
What behaviour do you see?
Exception above
Do you have the connector logs, ideally from start till finish?
yes, in attachemnt
How to reproduce the issue using our tutorial deployment?
Set unicode for column definition