Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23094

Multiple calls to a Stored Procedure from another Stored Procedure crashes server

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.4.13, 10.5.4
    • 10.4.16, 10.5.7
    • Parser
    • Win64 (Windows Server 2019)

    Description

      Multiple calls to a Stored Procedure (e.g. from a loop) from another Stored Procedure crashes the database server (i.e. the MariaDB Windows Service stops running). The crash seems to occure on the second call to the inner Stored Procedure.

      This problem has been present in the latest releases of 10.4, and also in the new 10.5.4 .
      MariaDB 10.3 is Ok though.

      //Code Example
      		 
      CREATE PROCEDURE SP1
      		 
      BEGIN
      		 
        DECLARE p INT
      		 
       
      		 
        SET P = 2;
      		 
        WHILE ( p > 0 ) DO
      		 
          CALL SP2;
      		 
          SET P = P - 1;
      		 
        END WHILE;
      		 
      END

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25601 MariaDB 10.5 crash when execute query with SET

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20290 Server crash in st_select_lex::cleanup or Assertion `sl->join == 0' failed in reinit_stmt_before_use

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23914 Mariadb 10.4.15 crash on trigger update, repeatable

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22000 Server crashes in st_select_lex::inc_in_sum_expr upon DECLARE with group function

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-22039 Server crashes in MYSQLparse upon IF with double brackets

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bjomol Björn Möller created issue -
            bjomol Björn Möller made changes -
            Field Original Value New Value
            Description Multiple calls to a Stored Procedure (e.g. from a loop) from another Stored Procedure crashes the database server (i.e. the Maria DB Windows Service stops running).

            This problem has been present in the latest releases of 10.4, and also in the new 10.5.4 .
            MariaDB 10.3 is Ok though.

            {code:sql}
            //Code Example
            CREATE PROCEDURE SP1
            BEGIN
              DECLARE p INT

              SET P = 2;
              WHILE ( p > 0 ) DO
                CALL SP2;
                SET P = P - 1;
              END WHILE;
            END
            {code}

            		Multiple calls to a Stored Procedure (e.g. from a loop) from another Stored Procedure crashes the database server (i.e. the Maria DB Windows Service stops running). The crash seems to occure on the second call to the inner Stored Procedure.

            This problem has been present in the latest releases of 10.4, and also in the new 10.5.4 .
            MariaDB 10.3 is Ok though.

            {code:sql}
            //Code Example
            CREATE PROCEDURE SP1
            BEGIN
              DECLARE p INT

              SET P = 2;
              WHILE ( p > 0 ) DO
                CALL SP2;
                SET P = P - 1;
              END WHILE;
            END
            {code}

            bjomol Björn Möller made changes -
            Description Multiple calls to a Stored Procedure (e.g. from a loop) from another Stored Procedure crashes the database server (i.e. the Maria DB Windows Service stops running). The crash seems to occure on the second call to the inner Stored Procedure.

            This problem has been present in the latest releases of 10.4, and also in the new 10.5.4 .
            MariaDB 10.3 is Ok though.

            {code:sql}
            //Code Example
            CREATE PROCEDURE SP1
            BEGIN
              DECLARE p INT

              SET P = 2;
              WHILE ( p > 0 ) DO
                CALL SP2;
                SET P = P - 1;
              END WHILE;
            END
            {code}

            		Multiple calls to a Stored Procedure (e.g. from a loop) from another Stored Procedure crashes the database server (i.e. the MariaDB Windows Service stops running). The crash seems to occure on the second call to the inner Stored Procedure.

            This problem has been present in the latest releases of 10.4, and also in the new 10.5.4 .
            MariaDB 10.3 is Ok though.

            {code:sql}
            //Code Example
            CREATE PROCEDURE SP1
            BEGIN
              DECLARE p INT

              SET P = 2;
              WHILE ( p > 0 ) DO
                CALL SP2;
                SET P = P - 1;
              END WHILE;
            END
            {code}

            bjomol Björn Möller made changes -
            Attachment POLLUXPHP2.err [ 52575 ]
            bjomol Björn Möller made changes -
            Attachment POLLUXPHP2.err [ 52575 ]
            bjomol Björn Möller made changes -
            Attachment POLLUXPHP2.err [ 52576 ]
            bjomol Björn Möller made changes -
            Component/s Stored routines [ 13905 ]
            bjomol Björn Möller made changes -
            Environment Win64 Win64 (Windows Server 2019)
            bjomol Björn Möller made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            alice Alice Sherepa made changes -
            elenst Elena Stepanova made changes -
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Assignee Oleksandr Byelkin [ sanja ]
            sanja Oleksandr Byelkin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            julien.fritsch Julien Fritsch made changes -
            Labels innodb innodb need_feedback
            bjomol Björn Möller made changes -
            Labels innodb need_feedback innodb
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexander Barkov [ bar ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            bar Alexander Barkov made changes -
            Assignee Alexander Barkov [ bar ] Oleksandr Byelkin [ sanja ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sanja Oleksandr Byelkin made changes -
            Fix Version/s 10.4.15 [ 24507 ]
            Fix Version/s 10.5.6 [ 24508 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            sanja Oleksandr Byelkin made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            sanja Oleksandr Byelkin made changes -
            Component/s Parser [ 10201 ]
            Component/s Stored routines [ 13905 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.7 [ 25019 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.6 [ 24508 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4.16 [ 25020 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4.15 [ 24507 ]
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 110867 ] MariaDB v4 [ 158058 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 191933

            People

              sanja Oleksandr Byelkin
              bjomol Björn Möller
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.