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

Dbz crashed on parsing MySQL DDL statement (SELECT 1 + @sum:=1 AS ss;)

XMLWordPrintable

    • False
    • None
    • False
    • Important

      Dbz crashed on create proc statement. On this SELECT:

      SELECT 1 + @sum:=1 AS ss;

      What Debezium connector do you use and what version?

      2.3.2

      What is the captured database version and mode of depoyment?

      Percona (MySQL 5.7.41)

      What behaviour do you see?

      Crash on this statement:

       

      DROP PROCEDURE IF EXISTS test;
CREATE DEFINER=`peuser`@`%` PROCEDURE `test` ()
BEGIN
    SELECT 1 + @sum:=1 AS ss;
END

       

      Do you have the connector logs, ideally from start till finish?

      extraneous input 'END' expecting {<EOF>, '-'}
        at io.debezium.antlr.AntlrDdlParser.throwParsingException(AntlrDdlParser.java:366)
        at io.debezium.antlr.AntlrDdlParser.parse(AntlrDdlParser.java:91)
        at io.debezium.connector.mysql.MySqlDatabaseSchema.parseDdl(MySqlDatabaseSchema.java:213)
        at io.debezium.connector.mysql.MySqlDatabaseSchema.parseStreamingDdl(MySqlDatabaseSchema.java:199)
        at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleQueryEvent(MySqlStreamingChangeEventSource.java:591)
        at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.lambda$execute$15(MySqlStreamingChangeEventSource.java:899)
        at io.debezium.connector.mysql.MySqlStreamingChangeEventSource.handleEvent(MySqlStreamingChangeEventSource.java:373)
        ... 6 more

       

       

            [DBZ-6794] Dbz crashed on parsing MySQL DDL statement (SELECT 1 + @sum:=1 AS ss;)

            Errata Tool added a comment -

            Since the problem described in this issue should be resolved in a recent advisory, it has been closed.

            For information on the advisory (Red Hat build of Debezium 2.3.4 release), and where to find the updated files, follow the link below.

            If the solution does not work for you, open a new bug report.
            https://access.redhat.com/errata/RHEA-2023:5471

            Errata Tool added a comment - Since the problem described in this issue should be resolved in a recent advisory, it has been closed. For information on the advisory (Red Hat build of Debezium 2.3.4 release), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHEA-2023:5471

            Debezium Builder added a comment -

            Released

            Debezium Builder added a comment - Released

            Jiri Pechanec added a comment -

            Applied to 2.3 and 2.4

            Jiri Pechanec added a comment - Applied to 2.3 and 2.4

              Unassigned Unassigned
              politov.eugene Eugenius Politou (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: