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

no viable alternative at input 'ALTER TABLE `documents` RENAME INDEX'

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.10.0.Beta2
    • 0.10.0.Beta1
    • mysql-connector
    • None

      Hi,
      after some management on our Kafka stack and restart our connector : 3 on the 4 start without issue but 1 as the following status:

        "tasks": [
          {
            "id": 0,
            "state": "FAILED",
            "worker_id": "hrxkfddc01.hrx.erp:8083",
            "trace": "org.apache.kafka.connect.errors.ConnectException: no viable alternative at input 'ALTER TABLE `documents` RENAME INDEX'\n\tat io.debezium.connector.mysql.AbstractReader.wrap(AbstractReader.java:230)\n\tat io.debezium.connector.mysql.AbstractReader.failed(AbstractReader.java:208)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:517)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.notifyEventListeners(BinaryLogClient.java:1095)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:943)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:580)\n\tat com.github.shyiko.mysql.binlog.BinaryLogClient$7.run(BinaryLogClient.java:825)\n\tat java.lang.Thread.run(Thread.java:748)\nCaused by: io.debezium.text.ParsingException: no viable alternative at input 'ALTER TABLE `documents` RENAME INDEX'\n\tat io.debezium.antlr.ParsingErrorListener.syntaxError(ParsingErrorListener.java:40)\n\tat org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)\n\tat org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportNoViableAlternative(DefaultErrorStrategy.java:282)\n\tat org.antlr.v4.runtime.DefaultErrorStrategy.reportError(DefaultErrorStrategy.java:121)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:1078)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.root(MySqlParser.java:812)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:68)\n\tat io.debezium.connector.mysql.antlr.MySqlAntlrDdlParser.parseTree(MySqlAntlrDdlParser.java:41)\n\tat io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:80)\n\tat io.debezium.connector.mysql.MySqlSchema.applyDdl(MySqlSchema.java:305)\n\tat io.debezium.connector.mysql.BinlogReader.handleQueryEvent(BinlogReader.java:703)\n\tat io.debezium.connector.mysql.BinlogReader.handleEvent(BinlogReader.java:501)\n\t... 5 more\nCaused by: org.antlr.v4.runtime.NoViableAltException\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.noViableAlt(ParserATNSimulator.java:2023)\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.execATN(ParserATNSimulator.java:467)\n\tat org.antlr.v4.runtime.atn.ParserATNSimulator.adaptivePredict(ParserATNSimulator.java:393)\n\tat io.debezium.ddl.parser.mysql.generated.MySqlParser.sqlStatements(MySqlParser.java:886)\n\t... 12 more\n"
      

      Regards,
      Eric

            [DBZ-1329] no viable alternative at input 'ALTER TABLE `documents` RENAME INDEX'

            Agile

            Thanks for reporting back. And we hadn't even announced the Beta2 release

            Gunnar Morling added a comment - Thanks for reporting back. And we hadn't even announced the Beta2 release

            Hi,

            FYI.
            Just implement the 0.10.BEta2 last release and problem solved.
            Thanks
            Regards,
            Eric

            Eric FRANCKX (Inactive) added a comment - Hi, FYI. Just implement the 0.10.BEta2 last release and problem solved. Thanks Regards, Eric

            I will try.

            Thanks

            Eric FRANCKX (Inactive) added a comment - I will try. Thanks

            Released

            Jiri Pechanec added a comment - Released

            thanks a lot

            Eric FRANCKX (Inactive) added a comment - thanks a lot

            Agh; updated the link.

            Gunnar Morling added a comment - Agh; updated the link.

            Gunnar Morling added a comment - - edited

            Next week seems likely. In the meantime, you could take the next snapshot build as described on https://debezium.io/docs/install/development/.

            Gunnar Morling added a comment - - edited Next week seems likely. In the meantime, you could take the next snapshot build as described on https://debezium.io/docs/install/development/ .

            thanks for fast reponse.

            Next release plan for ?

            thanks
            Eric

            Eric FRANCKX (Inactive) added a comment - thanks for fast reponse. Next release plan for ? thanks Eric

              jpechane Jiri Pechanec
              eric.franckx@ngahr.com Eric FRANCKX (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: