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

CREATE PROCEDURE DDL throws ParsingException

XMLWordPrintable

    • False
    • False

      Hello,

      We got the a DDL parsing exception which stopped the connector (some of the names/values were changed due to sensitive information) - attached to the ticket.

       Had to change connector's config property "database.history.skip.unparseable.ddl" to "true" and restart the connector as a workaround for this issue.

      Versions details:

      Debezium MySQL connector: 1.7.0.Final
      Kafka Connect: 3.0.0
      (Percona) MySQL Server: 5.7.34-37-log

       
      Please let me know if more information is required.

       

        1. ParsingException.txt
          3 kB

            [DBZ-4229] CREATE PROCEDURE DDL throws ParsingException

            Debezium Builder added a comment -

            Released

            Debezium Builder added a comment - Released

            Rotem Adhoh (Inactive) added a comment -

            Wow thank you guys for a super quick fix!

            Much appreciated 

            Rotem Adhoh (Inactive) added a comment - Wow thank you guys for a super quick fix! Much appreciated 

            Gunnar Morling added a comment -

            Applied to main (=1.8). jpechane, added to 1.7.1 too, leaving backport to you. Thx!

            Gunnar Morling added a comment - Applied to main (=1.8). jpechane , added to 1.7.1 too, leaving backport to you. Thx!

            Harvey Yue (Inactive) added a comment - - edited

            The sp contains query statement which have select and where statements, but without from statment, cause this parser error.

            Harvey Yue (Inactive) added a comment - - edited The sp contains query statement which have select and where statements, but without from statment, cause this parser error.

            Harvey Yue (Inactive) added a comment -

            I will look into this issue.

            Harvey Yue (Inactive) added a comment - I will look into this issue.

              Unassigned Unassigned
              rotem-ad Rotem Adhoh (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: