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

Unicode charset can not be parsed

XMLWordPrintable

    • 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

       

            Unassigned Unassigned
            aglisic Aleksandar Glišić
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: