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

DDL parser fails on 'CREATE FUNCTION' statements

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 0.3.5
    • Fix Version/s: 0.3.6, 0.4
    • Component/s: mysql-connector
    • Labels:
      None
    • Environment:

      I'm using the "official" debezium docker images (zookeeper, kafka, kafka connect)

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rhauch Randall Hauch
                Reporter:
                fuyar UYAR Farid
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: