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

DDL parser fails on 'CREATE FUNCTION' statements

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 0.3.6, 0.4
    • 0.3.5
    • mysql-connector
    • None

      The debezium connector fails after parsing a DDL statement from the MySQL DB source.
      Even when I restart the connect container, it refails instantly on the same statement.

      Failed due to error: Error processing binlog event
      ...
      java.util.NoSuchElementException: No more content
      ...
      at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:266)
      

      After looking in the corresponding binlog at the right position I found the failing statement :

      ALTER TABLE `collection` ADD `user_id` INT(10)\n NULL\n DEFAULT NULL\n AFTER `collection_id;
      

      Seems like a pretty easy statement. Previous statement were :

      CREATE TABLE `test` (id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT);
      ALTER TABLE `test` CHANGE `id` `collection_id` INT(11)\n UNSIGNED\n NOT NULL\n AUTO_INCREMENT;
      

      Do you need something more ? I'm gonna try to reproduce the issue after maybe reloading from scratch.

      Thanks

              rhauch Randall Hauch (Inactive)
              fuyar UYAR Farid (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: