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

       

       

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

                Created:
                Updated:
                Resolved: