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

Bytes lost or Assertion `status_var.local_memory_used == 0 after DELETE with subquery with ROLLUP

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (i INT DEFAULT 0, c VARCHAR(8192) DEFAULT '') ENGINE=InnoDB;
      INSERT INTO t1 () VALUES (),(),(),(),();
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
      INSERT INTO t1 SELECT * FROM t1;
       
      CREATE TABLE t2 (f VARCHAR(8192) DEFAULT '') ENGINE=InnoDB;
      INSERT INTO t2 VALUES ('foo'),('bar');
       
      DELETE FROM t2 WHERE f IN ( SELECT MAX(c) FROM t1 GROUP BY c WITH ROLLUP );
       
      # Cleanup
      DROP TABLE t1, t2;
      

      5.5 064ba8cc9f

      180824 14:55:09 [Note] /data/bld/5.5/bin/mysqld: Shutdown complete
       
      Warning: 254542 bytes lost, allocated at 0x8d5520, 0x8d487d, 0x65bb3c, 0x659ae0, 0x6593ae, 0x637726, 0x84c06f, 0x8445da
      Memory lost: 254542 bytes in 1 chunks
      

      10.0 bcc677bb7

      Warning: 254544 bytes lost at 0x7f8735d06070, allocated by T@3 at 0x972530, 0x971885, 0x6afcc5, 0x6adc0d, 0x6ad4e2, 0x68a141, 0x6875fe, 0x8e2875
      Memory lost: 254544 bytes in 2823 chunks
      mysqld: /data/src/10.0/sql/sql_class.cc:1547: virtual THD::~THD(): Assertion `status_var.memory_used == 0' failed.
      180824 14:57:14 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8749f20ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000000000610b00 in THD::~THD (this=0x7f873eb3d070, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_class.cc:1547
      #9  0x0000000000610c98 in THD::~THD (this=0x7f873eb3d070, __in_chrg=<optimized out>) at /data/src/10.0/sql/sql_class.cc:1552
      #10 0x000000000058f922 in unlink_thd (thd=0x7f873eb3d070) at /data/src/10.0/sql/mysqld.cc:2705
      #11 0x000000000058fc78 in one_thread_per_connection_end (thd=0x7f873eb3d070, put_in_cache=true) at /data/src/10.0/sql/mysqld.cc:2816
      #12 0x000000000076ad7e in do_handle_one_connection (thd_arg=0x7f873eb3d070) at /data/src/10.0/sql/sql_connect.cc:1388
      #13 0x000000000076aa4e in handle_one_connection (arg=0x7f873eb3d070) at /data/src/10.0/sql/sql_connect.cc:1292
      #14 0x0000000000accef0 in pfs_spawn_thread (arg=0x7f873ea801f0) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #15 0x00007f874bc24494 in start_thread (arg=0x7f874bfe7700) at pthread_create.c:333
      #16 0x00007f8749fdd93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.4 5abc79dd7ab

      ***Warnings generated in error logs during shutdown after running tests: bug.t8a
       
      mysqld: /data/src/10.4/sql/sql_class.cc:1662: virtual THD::~THD(): Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' failed.
      Attempting backtrace. You can use the following information to find out
      

      The effect seems to be sporadic, sometimes the failure doesn't happen. Run several times if it doesn't fail right away.

        Attachments

          Activity

            People

            Assignee:
            varun Varun Gupta (Inactive)
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: