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

MySQL DDL parse error caused by CREATE TRIGGER command

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 0.4
    • 0.3.6
    • mysql-connector
    • None

      Following error that killed connector task was noticed in logs :

      [2016-12-23 14:27:16,635] ERROR Error parsing DDL statement and updating tables: CREATE DEFINER=`trunk2`@`%` TRIGGER PipelineHistory_insert AFTER INSERT ON Pipeline
       FOR EACH ROW BEGIN
       INSERT INTO PipelineHistory (
       PipelineId
       , InterfaceId
       , SourceHost
       , SourceDir
       , SourcePattern
       , SinkHost
       , SinkDir
       , SinkCommand
       , Active
       , Retries
       ) VALUES (
       NEW.PipelineId
       , NEW.InterfaceId
       , NEW.SourceHost
       , NEW.SourceDir
       , NEW.SourcePattern
       , NEW.SinkHost
       , NEW.SinkDir
       , NEW.SinkCommand
       , NEW.Active
       , NEW.Retries
       );
       END (io.debezium.connector.mysql.MySqlSchema:337)
      io.debezium.text.ParsingException: No matching single quote found after line 1, column 27
      	at io.debezium.relational.ddl.DdlTokenizer.tokenize(DdlTokenizer.java:262)
      	at io.debezium.text.TokenStream.start(TokenStream.java:444)
      	at io.debezium.relational.ddl.DdlParser.parse(DdlParser.java:265)
      	at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:335)
      	at io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:443)
      	at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:311)
      

              rhauch Randall Hauch (Inactive)
              anton_nazaruk Anton Nazaruk (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: