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

Memory leakage is detected on running the test main.ps against the server 11.1

Details

    Description

      CREATE TABLE t1 (id INT, value INT);
      		 
      CREATE TABLE t2 (id INT);
      		 
       
      		 
      PREPARE stmt FROM 'UPDATE t1 t1 SET value = (SELECT 1 FROM t2 WHERE id = t1.id)';
      		 
      execute stmt;
      		 
      insert into t1 values (1,10),(2,10),(3,10);
      		 
      insert into t2 values (1),(2);
      		 
      execute stmt;  # <<=== Memory leak happens on running this statement
      		 
      select * from t1;
      		 
      deallocate prepare stmt;
      		 
      DROP TABLE t1,t2;

      The above use case doesn't show memory leaking on 10.11.

      The similar issue could take place on running the DELETE statement with the LIMIT clause in PS/SP mode. So, this task also about fixing a memory leak in the code that processes the DELETE statement.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35249 Assertion `(mem_root->flags & 4) == 0' failed in convert_subq_to_jtbm

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-14959 Control over memory allocated for SP/PS

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33858 Assertion `(mem_root->flags & 4) == 0' fails on 2nd execution of PS with -DWITH_PROTECT_STATEMENT_MEMROOT=ON

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34757 assertion of (mem_root->flags & 4) == 0 fails in 2nd ps execution with partition pruning

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

          Activity

            Ascending order - Click to sort in descending order
            shulga Dmitry Shulga added a comment -

            The branch for review is bb-11.1-MDEV-34447

            shulga Dmitry Shulga added a comment - The branch for review is bb-11.1- MDEV-34447
            sanja Oleksandr Byelkin added a comment -

            The last comit OK to push

            sanja Oleksandr Byelkin added a comment - The last comit OK to push
            ycp Yuchen Pei added a comment -

            Backported to 10.5 as part of push of MDEV-34757

            ycp Yuchen Pei added a comment - Backported to 10.5 as part of push of MDEV-34757

            People

              shulga Dmitry Shulga
              shulga Dmitry Shulga
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.