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

Assertion `status_var.local_memory_used == 0 || !debug_assert_on_not_freed_memory' in Session_sysvars_tracker::vars_list::deinit with variable in DEFAULT

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (f DECIMAL DEFAULT (@var := 23.5));
       
      --connect (con1,localhost,root,,)
      INSERT INTO t1 () VALUES (),();
      SET @var = 0;
       
      --connection default
      INSERT INTO t1 () VALUES ();
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 900c4d69

      mariadbd: /data/src/11.0/sql/sql_class.cc:1746: 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
      mariadbd: /data/src/11.0/sql/mysqld.cc:3813: void my_malloc_size_cb_func(long long int, my_bool): Assertion `(longlong) thd->status_var.local_memory_used >= 0 || !debug_assert_on_not_freed_memory' failed.
       
      230820 20:51:28 [ERROR] mysqld got signal 6 ;
       
      #5  0x00007f32d9e53df2 in __GI___assert_fail (assertion=0x55e40924ad80 "(longlong) thd->status_var.local_memory_used >= 0 || !debug_assert_on_not_freed_memory", file=0x55e409245400 "/data/src/10.4/sql/mysqld.cc", line=3801, function=0x55e40924ac40 "void my_malloc_size_cb_func(long long int, my_bool)") at ./assert/assert.c:101
      #6  0x000055e406f5a723 in my_malloc_size_cb_func (size=-8184, is_thread_specific=1 '\001') at /data/src/10.4/sql/mysqld.cc:3801
      #7  0x000055e408df93f6 in my_free (ptr=0x6250000ff108) at /data/src/10.4/mysys/my_malloc.c:214
      #8  0x000055e408d83e8b in delete_dynamic (array=0x62b000092038) at /data/src/10.4/mysys/array.c:303
      #9  0x000055e408d9308d in my_hash_free (hash=0x62b000092010) at /data/src/10.4/mysys/hash.c:158
      #10 0x000055e406fab572 in Session_sysvars_tracker::vars_list::free_hash (this=0x62b000092010) at /data/src/10.4/sql/session_tracker.h:148
      #11 0x000055e40715a73e in Session_sysvars_tracker::vars_list::deinit (this=0x62b000092010) at /data/src/10.4/sql/session_tracker.h:168
      #12 0x000055e40715a75e in Session_sysvars_tracker::deinit (this=0x62b000092000) at /data/src/10.4/sql/session_tracker.h:211
      #13 0x000055e40712c0ba in THD::~THD (this=0x62b00008c208, __in_chrg=<optimized out>) at /data/src/10.4/sql/sql_class.cc:1728
      #14 0x000055e40712c652 in THD::~THD (this=0x62b00008c208, __in_chrg=<optimized out>) at /data/src/10.4/sql/sql_class.cc:1741
      #15 0x000055e406f56df6 in one_thread_per_connection_end (thd=0x62b00008c208, put_in_cache=true) at /data/src/10.4/sql/mysqld.cc:2785
      #16 0x000055e40763efd9 in do_handle_one_connection (connect=0x608000000aa8) at /data/src/10.4/sql/sql_connect.cc:1431
      #17 0x000055e40763e727 in handle_one_connection (arg=0x608000000aa8) at /data/src/10.4/sql/sql_connect.cc:1324
      #18 0x000055e4082aee20 in pfs_spawn_thread (arg=0x615000003c88) at /data/src/10.4/storage/perfschema/pfs.cc:1869
      #19 0x00007f32d9ea7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #20 0x00007f32d9f285bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Activity

          People

            nikitamalyavin Nikita Malyavin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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