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

DDL parser fails on 'CREATE FUNCTION' statements

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: