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

DDL statement couldn't be parsed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 1.5.0.Final
    • None
    • False
    • False
    • Undefined

      Using following request : 

      ```
      RENAME TABLE permissions_roles TO permissions_roles_old, permissions_roles_2 TO permissions_roles;
      ```
       
      We crashed all our mySQL connectors with following issue :
       
      "source" : { "server" : "qv3sync.debezium.db.qos.categorization.ids" }, "position" : { "transaction_id" : null, "ts_sec" : 1619519254, "file" : "mysql-bin.001686", "pos" : 800134848, "gtids" : "52b8c0a2-703e-11eb-93fb-246e96c3657c:1-3001418816", "server_id" : 927831227 }, "databaseName" : "qosenergy_production", "ddl" : "permissions_roles TO permissions_roles_old", "tableChanges" : [ ] })' [io.debezium.relational.history.KafkaDatabaseHistory] io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'permissions_roles TO permissions_roles_old' mismatched input 'permissions_roles' expecting {<EOF>, 'ALTER', 'ANALYZE', 'CALL', 'CHANGE', 'CHECK', 'CREATE', 'DELETE', 'DESC', 'DESCRIBE', 'DROP', 'EXPLAIN', 'GET', 'GRANT', 'INSERT', 'KILL', 'LOAD', 'LOCK', 'OPTIMIZE', 'PURGE', 'RELEASE', 'RENAME', 'REPLACE', 'RESIGNAL' , 'REVOKE', 'SELECT', 'SET', 'SHOW', 'SIGNAL', 'UNLOCK', 'UPDATE', 'USE', 'BEGIN', 'BINLOG', 'CACHE', 'CHECKSUM', 'COMMIT', 'DEALLOCATE', 'DO', 'FLUSH', 'HANDLER', 'HELP', 'INSTALL', 'PREPARE', 'REPAIR', 'RESET', 'ROLLBACK', 'SAVEPOINT', 'START', 'STOP', 'TRUNCATE', 'UNINST ALL', 'XA', 'EXECUTE', 'SHUTDOWN', '--', '(', ';'}
       
      We enabled : database.history.skip.unparseable.ddl:yes to solve this issue

            Unassigned Unassigned
            ohohleo Leo Martin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: