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

Antlr Exception: mismatched input '.' expecting {<EOF>, '--'}

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.9.0.CR1
    • 0.9.0.Beta1, 0.9.0.Beta2
    • mysql-connector
    • None

    Description

      Error from log..
      
      [2018-12-27 13:42:51,906] ERROR Error during binlog processing. Last offset stored = null, binlog reader near position = mysql-bin.000532/99001490 (io.debezium.connector.mysql.BinlogReader:969)
      [2018-12-27 13:42:51,907] ERROR Failed due to error: Error processing binlog event (io.debezium.connector.mysql.BinlogReader:179)
      org.apache.kafka.connect.errors.ConnectException: mismatched input '.' expecting {<EOF>, '--'}
      	at io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:200)
      	at io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:178)
      	at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:451)
      	at com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1055)
      	at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:913)
      	at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:559)
      	at com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:793)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: io.debezium.text.ParsingException: mismatched input '.' expecting {<EOF>, '--'}
      	at io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:40)
      	at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
      	at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
      	at org.antlr.v4.runtime.DefaultErrorStrategy.reportInputMismatch(DefaultErrorStrategy.java:299)
      	at org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:124)
      	at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:825)
      	at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:71)
      	at io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:44)
      	at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)
      	at io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:300)
      	at io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:636)
      	at io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:435)
      	... 5 more
      Caused by: org.antlr.v4.runtime.InputMismatchException
      	at org.antlr.v4.runtime.DefaultErrorStrategy.sync(DefaultErrorStrategy.java:242)
      	at io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:810)
      	... 11 more
      
      
      Snippet from binlog...
      
      #181226 19:11:22 server id 223344  end_log_pos 99001425 CRC32 0x5caa290d 	Xid = 940392
      COMMIT/*!*/;
      # at 99001425
      #181226 19:11:32 server id 223344  end_log_pos 99001490 CRC32 0x2b0f42d3 	GTID	last_committed=22027	sequence_number=22028	rbr_only=no
      SET @@SESSION.GTID_NEXT= '51bd158d-8c20-11e7-b7dc-000c29eb3ace:293546'/*!*/;
      # at 99001490
      #181226 19:11:32 server id 223344  end_log_pos 99001636 CRC32 0x5dbc17a0 	Query	thread_id=657	exec_time=0	error_code=0
      SET TIMESTAMP=1545851492/*!*/;
      SET @@session.sql_mode=1075838976/*!*/;
      ALTER TABLE `sled1`.`new_table` 
      RENAME TO  `sled1`.`cohort_seats`
      /*!*/;
      # at 99001636
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            ekreiser_jira Eric Kreiser (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: