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

Server crashes in THD::handle_condition or Assertion `! is_set() || m_can_overwrite_status' fails upon attempt to connect with max_session_mem_used = 8192

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1, 10.2
    • Fix Version/s: 10.1.25, 10.2.7
    • Component/s: Server
    • Labels:
      None

      Description

      In MTR:

      set global max_session_mem_used = 8192;
      --connect (con1,localhost,root,,)
      select @@max_session_mem_used;
      --disconnect con1
      set global max_session_mem_used = DEFAULT;
      

      10.1 112b21da37dad0

      #3  <signal handler called>
      #4  0x000055a11660e0f7 in THD::handle_condition (this=0x7f7232cdb070, sql_errno=1290, sqlstate=0x55a116f848c7 "HY000", level=Sql_condition::WARN_LEVEL_ERROR, msg=0x7ffe0f42c1b0 "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement", cond_hdl=0x7ffe0f42c0a0) at /data/src/10.1/sql/sql_class.cc:1120
      #5  0x000055a11660e9cb in THD::raise_condition (this=0x7f7232cdb070, sql_errno=1290, sqlstate=0x55a116f848c7 "HY000", level=Sql_condition::WARN_LEVEL_ERROR, msg=0x7ffe0f42c1b0 "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement") at /data/src/10.1/sql/sql_class.cc:1274
      #6  0x000055a116585929 in my_message_sql (error=1290, str=0x7ffe0f42c1b0 "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement", MyFlags=0) at /data/src/10.1/sql/mysqld.cc:3529
      #7  0x000055a116ed976f in my_error (nr=1290, MyFlags=0) at /data/src/10.1/mysys/my_error.c:125
      #8  0x000055a116585fca in my_malloc_size_cb_func (size=120, is_thread_specific=1 '\001') at /data/src/10.1/sql/mysqld.cc:3949
      #9  0x000055a116ee2866 in my_malloc (size=120, my_flags=65584) at /data/src/10.1/mysys/my_malloc.c:118
      #10 0x000055a11667c518 in debug_sync_init_thread (thd=0x7f7232cdb070) at /data/src/10.1/sql/debug_sync.cc:239
      #11 0x000055a11660f12d in THD::init (this=0x7f7232cdb070) at /data/src/10.1/sql/sql_class.cc:1455
      #12 0x000055a11660dd21 in THD::THD (this=0x7f7232cdb070, is_wsrep_applier=false) at /data/src/10.1/sql/sql_class.cc:1029
      #13 0x000055a11658b4ae in handle_connections_sockets () at /data/src/10.1/sql/mysqld.cc:6649
      #14 0x000055a11658a0a5 in mysqld_main (argc=130, argv=0x7f7239496ac0) at /data/src/10.1/sql/mysqld.cc:5913
      #15 0x000055a11657f350 in main (argc=6, argv=0x7ffe0f42d0b8) at /data/src/10.1/sql/main.cc:25
      

      If I do the same via a client on 10.2, I get an assertion failure:

      10.2 aad8cefd2d0

      mysqld: /data/src/10.2/sql/sql_error.cc:487: void Diagnostics_area::set_error_status(uint, const char*, const char*, const Sql_condition*): Assertion `! 
      is_set() || m_can_overwrite_status' failed.
      170606 20:55:11 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f8a72bf4ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x000055e6a1c2a0a9 in Diagnostics_area::set_error_status (this=0x7f8a04005b08, sql_errno=1290, message=0x7f8a5d447430 "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement", sqlstate=0x55e6a26d420d "HY000", error_condition=0x0) at /data/src/10.2/sql/sql_error.cc:487
      #9  0x000055e6a1c0bb6f in THD::raise_condition (this=0x7f8a04000b00, sql_errno=1290, sqlstate=0x55e6a26d420d "HY000", level=Sql_condition::WARN_LEVEL_ERROR, msg=0x7f8a5d447430 "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement") at /data/src/10.2/sql/sql_class.cc:1130
      #10 0x000055e6a1b79488 in my_message_sql (error=1290, str=0x7f8a5d447430 "The MariaDB server is running with the --max-thread-mem-used=8192 option so it cannot execute this statement", MyFlags=0) at /data/src/10.2/sql/mysqld.cc:3622
      #11 0x000055e6a261bb61 in my_error (nr=1290, MyFlags=0) at /data/src/10.2/mysys/my_error.c:125
      #12 0x000055e6a1b79b71 in my_malloc_size_cb_func (size=-64, is_thread_specific=1 '\001') at /data/src/10.2/sql/mysqld.cc:4046
      #13 0x000055e6a2625040 in my_free (ptr=0x7f8a04007f70) at /data/src/10.2/mysys/my_malloc.c:216
      #14 0x000055e6a25fc266 in delete_dynamic (array=0x7f8a04007d48) at /data/src/10.2/mysys/array.c:302
      #15 0x000055e6a2601e07 in my_hash_free (hash=0x7f8a04007d20) at /data/src/10.2/mysys/hash.c:152
      #16 0x000055e6a1b9a1c3 in Session_sysvars_tracker::vars_list::~vars_list (this=0x7f8a04007d20, __in_chrg=<optimized out>) at /data/src/10.2/sql/session_tracker.cc:128
      #17 0x000055e6a1b9a397 in Session_sysvars_tracker::~Session_sysvars_tracker (this=0x7f8a04008020, __in_chrg=<optimized out>) at /data/src/10.2/sql/session_tracker.cc:176
      #18 0x000055e6a1b9a426 in Session_sysvars_tracker::~Session_sysvars_tracker (this=0x7f8a04008020, __in_chrg=<optimized out>) at /data/src/10.2/sql/session_tracker.cc:179
      #19 0x000055e6a1b99ea0 in Session_tracker::deinit (this=0x7f8a04005e28) at /data/src/10.2/sql/session_tracker.h:147
      #20 0x000055e6a1b99a13 in Session_tracker::enable (this=0x7f8a04005e28, thd=0x7f8a04000b00) at /data/src/10.2/sql/session_tracker.cc:1627
      #21 0x000055e6a1c0c30f in THD::init (this=0x7f8a04000b00) at /data/src/10.2/sql/sql_class.cc:1318
      #22 0x000055e6a1c0c6ab in THD::change_user (this=0x7f8a04000b00) at /data/src/10.2/sql/sql_class.cc:1414
      #23 0x000055e6a1c0cb16 in THD::reset_for_reuse (this=0x7f8a04000b00) at /data/src/10.2/sql/sql_class.cc:1533
      #24 0x000055e6a1d9b944 in CONNECT::create_thd (this=0x55e6a53abf50, thd=0x7f8a04000b00) at /data/src/10.2/sql/sql_connect.cc:1450
      #25 0x000055e6a1b78194 in cache_thread (thd=0x7f8a04000b00) at /data/src/10.2/sql/mysqld.cc:2978
      #26 0x000055e6a1b78365 in one_thread_per_connection_end (thd=0x7f8a04000b00, put_in_cache=true) at /data/src/10.2/sql/mysqld.cc:3044
      #27 0x000055e6a1d9b652 in do_handle_one_connection (connect=0x55e6a543aa10) at /data/src/10.2/sql/sql_connect.cc:1373
      #28 0x000055e6a1d9b2f6 in handle_one_connection (arg=0x55e6a543aa10) at /data/src/10.2/sql/sql_connect.cc:1260
      #29 0x00007f8a74b39494 in start_thread (arg=0x7f8a5d448700) at pthread_create.c:333
      #30 0x00007f8a72cb193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

        Attachments

          Activity

            People

            Assignee:
            serg Sergei Golubchik
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: