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

debezium Failed while parsing DDL statements.

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Blocker
    • 0.3.1, 0.4
    • 0.2.1
    • core-library
    • None

    Description

      While running connector debezium failed with following error

      (io.debezium.connector.mysql.MySqlSchema:292)
      io.debezium.text.ParsingException: Expecting ')' at line 69, column 21 but found 'NOT':   `key` varchar(64)  ===>> NOT NULL DEFAULT '',
      	at io.debezium.text.TokenStream.consume(TokenStream.java:693)
      	at io.debezium.connector.mysql.MySqlDdlParser.parseCreateDefinitionList(MySqlDdlParser.java:398)
      	at io.debezium.connector.mysql.MySqlDdlParser.parseCreateTable(MySqlDdlParser.java:224)
      	at io.debezium.connector.mysql.MySqlDdlParser.parseCreate(MySqlDdlParser.java:149)
      	at io.debezium.connector.mysql.MySqlDdlParser.parseNextStatement(MySqlDdlParser.java:130)
      	at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:275)
      	at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:256)
      	at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:290)
      	at io.debezium.connector.mysql.SnapshotReader.execute(SnapshotReader.java:270)
      	at java.lang.Thread.run(Thread.java:745)
      

      (original)

      Here is the table structure:

      `CREATE TABLE `XXXXX` (
       `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
       `YYYY` bigint(20) unsigned NOT NULL,
       `key` varchar(64) NOT NULL DEFAULT '',
       `value` text,
       `FFFFF` tinyint(4) DEFAULT '0',
       `DDDD` bigint(20) DEFAULT '0',
       `TTTT` binary(16) DEFAULT NULL,
       `BBB` text,
       PRIMARY KEY (`id`),
       KEY `TYTUT` (`risk_info_id`),
       KEY `BGFH` (`key`),
       KEY `HGJG` (`risk_info_id`,`create_time`),
       KEY `EEEEE` (`is_encrypted`),
       KEY `GGGGG` (`risk_info_id`,`context_uuid`),
       KEY `HGHGHG` (`context_uuid`),
       CONSTRAINT `GHGHGHGHG` FOREIGN KEY (`risk_info_id`) REFERENCES `HGHGHG` (`id`)
      ) ENGINE=InnoDB AUTO_INCREMENT=10851 DEFAULT CHARSET=utf8;`
      

      (original)

      Attachments

        Activity

          People

            rhauch Randall Hauch (Inactive)
            akshathpatkar Akshath Patkar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: