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

Assertion `thd->status_var.tmp_space_used >= track->previous_file_size' upon change user with encrypted temporary files

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.8, 12.0(EOL)
    • 11.8
    • Variables
    • None

    Description

      --source include/have_log_bin.inc
      --source include/have_sequence.inc
      --source suite/encryption/include/have_file_key_management_plugin.inc
       
      --let $restart_parameters= --encrypt-tmp-files=1
      --source include/restart_mysqld.inc
       
      CREATE TABLE t (pk INT, veccol VARCHAR(128));
      REPLACE INTO t SELECT s2.seq, GROUP_CONCAT(s2.seq) FROM seq_1_to_16 s1, seq_1_to_500 s2 GROUP BY s2.seq;
      CREATE USER foo@localhost;
      --change_user foo
      SELECT CURRENT_USER();
      

      11.8 c517f0e12d02f407d3e00703a6dfc4f75b54dbb7

      mariadbd: /data/bld/11.8-asan-ubsan/sql/mysqld.cc:3811: int temp_file_size_cb_func(tmp_file_tracking*, int): Assertion `thd->status_var.tmp_space_used >= track->previous_file_size' failed.
      250720 16:26:31 [ERROR] /share8t/bld/11.8-asan-ubsan/sql/mariadbd got signal 6 ;
       
      #9  0x00007f02d5245395 in __assert_fail_base (fmt=0x7f02d53b9a90 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55e95e45dc80 "thd->status_var.tmp_space_used >= track->previous_file_size", file=file@entry=0x55e95e459440 "/data/bld/11.8-asan-ubsan/sql/mysqld.cc", line=line@entry=3811, function=function@entry=0x55e95e45dc20 "int temp_file_size_cb_func(tmp_file_tracking*, int)") at ./assert/assert.c:92
      #10 0x00007f02d5253eb2 in __GI___assert_fail (assertion=0x55e95e45dc80 "thd->status_var.tmp_space_used >= track->previous_file_size", file=0x55e95e459440 "/data/bld/11.8-asan-ubsan/sql/mysqld.cc", line=3811, function=0x55e95e45dc20 "int temp_file_size_cb_func(tmp_file_tracking*, int)") at ./assert/assert.c:101
      #11 0x000055e95a341cfe in temp_file_size_cb_func (track=0x61b00000fda0, no_error=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/mysqld.cc:3811
      #12 0x000055e95dfdd411 in reset_tracking_io_cache (info=info@entry=0x61b00000fc98) at /data/bld/11.8-asan-ubsan/mysys/mf_iocache.c:119
      #13 0x000055e95dfe8909 in end_io_cache (info=info@entry=0x61b00000fc98) at /data/bld/11.8-asan-ubsan/mysys/mf_iocache.c:1873
      #14 0x000055e95dfdb6b9 in close_cached_file (cache=0x61b00000fc98) at /data/bld/11.8-asan-ubsan/mysys/mf_cache.c:89
      #15 0x000055e95c77cce0 in binlog_cache_data::~binlog_cache_data (this=0x61b00000fc98, __in_chrg=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/log_cache.h:67
      #16 0x000055e95c6f476c in binlog_cache_mngr::~binlog_cache_mngr (this=0x61b00000fc98, __in_chrg=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/log.cc:479
      #17 binlog_close_connection (thd=<optimized out>) at /data/bld/11.8-asan-ubsan/sql/log.cc:1842
      #18 0x000055e95be9ec46 in ha_close_connection (thd=thd@entry=0x62c0000c0218) at /data/bld/11.8-asan-ubsan/sql/handler.cc:969
      #19 0x000055e95a7fa9be in THD::free_connection (this=this@entry=0x62c0000c0218) at /data/bld/11.8-asan-ubsan/sql/sql_class.cc:1748
      #20 0x000055e95a344af9 in unlink_thd (thd=thd@entry=0x62c0000c0218) at /data/bld/11.8-asan-ubsan/sql/mysqld.cc:2881
      #21 0x000055e95b342850 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x608000003ab8, put_in_cache=put_in_cache@entry=true) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1426
      #22 0x000055e95b343363 in handle_one_connection (arg=0x608000003ab8) at /data/bld/11.8-asan-ubsan/sql/sql_connect.cc:1327
      #23 0x000055e95cdd5c2e in pfs_spawn_thread (arg=0x617000006998) at /data/bld/11.8-asan-ubsan/storage/perfschema/pfs.cc:2198
      #24 0x00007f02d52a81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #25 0x00007f02d532885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      The failure started happening after a set of commits related to MDEV-9101 in 11.5.1.

      SET SESSION AUTHORIZATION in 12.0+ is equally affected.

      No obvious immediate effect on a non-debug build.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              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.