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

            Transition Time In Source Status Execution Times
            Oleksandr Byelkin made transition -
            Open In Progress
            		16d 12h 24m 1
            Oleksandr Byelkin made transition -
            In Progress Stalled
            		11m 57s 1
            Oleksandr Byelkin made transition -
            Stalled In Review
            		21d 5h 33m 1
            Alexander Barkov made transition -
            In Review Stalled
            		1d 18h 46m 1
            Oleksandr Byelkin made transition -
            Stalled In Progress
            		15d 4h 39m 1
            Oleksandr Byelkin made transition -
            In Progress Closed
            		3d 16h 48m 1

            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.