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

crash after setting global session_track_system_variables to an invalid value

    XMLWordPrintable

Details

    Description

      SET sql_mode='';  # Also try with ONLY_FULL_GROUP_BY
      SET 'a';
      SET collation_connection=utf6_unicode_520_ci;
      SET GLOBAL session_track_system_variables='a';
      SET GLOBAL event_scheduler=1;
      

      Leads to:

      10.6.0 cb545f11169d2425316d96feafc78ac841950e43 (Debug)

      mysqld: /data/10.6_dbg/sql/session_tracker.cc:334: void Session_sysvars_tracker::init(THD*): Assertion `global_system_variables.session_track_system_variables' failed.
      

      10.6.0 cb545f11169d2425316d96feafc78ac841950e43 (Debug)

      Core was generated by `/test/MD240321-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x1549d06ca700 (LWP 1961238))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000559464766dd1 in my_write_core (sig=sig@entry=6) at /data/10.6_dbg/mysys/stacktrace.c:424
      #2  0x0000559463f07d31 in handle_fatal_signal (sig=6) at /data/10.6_dbg/sql/signal_handler.cc:331
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00001549dbb2f859 in __GI_abort () at abort.c:79
      #6  0x00001549dbb2f729 in __assert_fail_base (fmt=0x1549dbcc5588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5594648b3758 "global_system_variables.session_track_system_variables", file=0x5594648b3498 "/data/10.6_dbg/sql/session_tracker.cc", line=334, function=<optimized out>) at assert.c:92
      #7  0x00001549dbb40f36 in __GI___assert_fail (assertion=assertion@entry=0x5594648b3758 "global_system_variables.session_track_system_variables", file=file@entry=0x5594648b3498 "/data/10.6_dbg/sql/session_tracker.cc", line=line@entry=334, function=function@entry=0x5594648b36c0 "void Session_sysvars_tracker::init(THD*)") at assert.c:101
      #8  0x0000559463b4929e in Session_sysvars_tracker::init (this=<optimized out>, thd=0x15498001df98) at /data/10.6_dbg/sql/session_tracker.cc:334
      #9  0x0000559463c53b95 in plugin_thdvar_init (thd=thd@entry=0x15498001df98) at /data/10.6_dbg/sql/sql_plugin.cc:3251
      #10 0x0000559463bd4e9a in THD::init (this=this@entry=0x15498001df98) at /data/10.6_dbg/sql/sql_class.cc:1255
      #11 0x0000559463bde05b in THD::THD (this=0x15498001df98, id=<optimized out>, is_wsrep_applier=<optimized out>) at /data/10.6_dbg/sql/sql_class.cc:858
      #12 0x000055946412c7d3 in Event_scheduler::start (this=0x5594667ddc50, err_no=err_no@entry=0x1549d06c8d7c) at /data/10.6_dbg/sql/sql_list.h:680
      #13 0x0000559463d79695 in Events::start (err_no=err_no@entry=0x1549d06c8d7c) at /data/10.6_dbg/sql/events.cc:1128
      #14 0x0000559463db8b75 in event_scheduler_update (self=<optimized out>, thd=<optimized out>, type=<optimized out>) at /data/10.6_dbg/sql/sys_vars.cc:1125
      #15 0x0000559463b4af30 in sys_var::update (this=0x559465237da0 <Sys_event_scheduler>, thd=0x154980000db8, var=0x154980013cf8) at /data/10.6_dbg/sql/set_var.cc:207
      #16 0x0000559463b4b447 in set_var::update (this=<optimized out>, thd=<optimized out>) at /data/10.6_dbg/sql/set_var.cc:859
      #17 0x0000559463b4c792 in sql_set_variables (thd=thd@entry=0x154980000db8, var_list=var_list@entry=0x154980005eb8, free=free@entry=true) at /data/10.6_dbg/sql/set_var.cc:746
      #18 0x0000559463c4aeab in mysql_execute_command (thd=thd@entry=0x154980000db8) at /data/10.6_dbg/sql/sql_parse.cc:5017
      #19 0x0000559463c34264 in mysql_parse (thd=thd@entry=0x154980000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1549d06c9410) at /data/10.6_dbg/sql/sql_parse.cc:8004
      #20 0x0000559463c42e6a in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x154980000db8, packet=packet@entry=0x15498000b359 "SET GLOBAL event_scheduler=1", packet_length=packet_length@entry=28, blocking=blocking@entry=true) at /data/10.6_dbg/sql/sql_class.h:1331
      #21 0x0000559463c46245 in do_command (thd=0x154980000db8, blocking=blocking@entry=true) at /data/10.6_dbg/sql/sql_parse.cc:1399
      #22 0x0000559463d9f466 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5594667b5888, put_in_cache=put_in_cache@entry=true) at /data/10.6_dbg/sql/sql_connect.cc:1410
      #23 0x0000559463d9fa6b in handle_one_connection (arg=arg@entry=0x5594667b5888) at /data/10.6_dbg/sql/sql_connect.cc:1312
      #24 0x0000559464249eb9 in pfs_spawn_thread (arg=0x5594666d9f28) at /data/10.6_dbg/storage/perfschema/pfs.cc:2201
      #25 0x00001549dc03d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #26 0x00001549dbc2c293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.6.0 cb545f11169d2425316d96feafc78ac841950e43 (Optimized)

      Core was generated by `/test/MD240321-mariadb-10.6.0-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x151620d52700 (LWP 2158236))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055771cb353bf in my_write_core (sig=sig@entry=11) at /data/10.6_opt/mysys/stacktrace.c:424
      #2  0x000055771c5ba830 in handle_fatal_signal (sig=11) at /data/10.6_opt/sql/signal_handler.cc:331
      #3  <signal handler called>
      #4  __strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:65
      #5  0x000055771cb31b71 in my_strdup (key=key@entry=0, from=0x0, my_flags=my_flags@entry=65552) at /data/10.6_opt/mysys/my_malloc.c:230
      #6  0x000055771c2f677a in Session_sysvars_tracker::init (this=<optimized out>, thd=0x1515d001a278) at /data/10.6_opt/sql/session_tracker.cc:335
      #7  0x000055771c35db00 in THD::init (this=this@entry=0x1515d001a278) at /data/10.6_opt/sql/sql_class.cc:1255
      #8  0x000055771c3631ec in THD::THD (this=0x1515d001a278, id=<optimized out>, is_wsrep_applier=<optimized out>) at /data/10.6_opt/sql/sql_class.cc:858
      #9  0x000055771c748f82 in Event_scheduler::start (this=0x55771f56a540, err_no=err_no@entry=0x151620d50e5c) at /data/10.6_opt/sql/sql_list.h:680
      #10 0x000055771c49a676 in Events::start (err_no=err_no@entry=0x151620d50e5c) at /data/10.6_opt/sql/events.cc:1128
      #11 0x000055771c4c6bf9 in event_scheduler_update (self=<optimized out>, thd=<optimized out>, type=<optimized out>) at /data/10.6_opt/sql/sys_vars.cc:1141
      #12 0x000055771c2f7d3a in sys_var::update (this=0x55771d4c8f60 <Sys_event_scheduler>, thd=0x1515d0000c58, var=0x1515d0010608) at /data/10.6_opt/include/mysql/psi/mysql_thread.h:795
      #13 0x000055771c2f81bb in set_var::update (this=<optimized out>, thd=<optimized out>) at /data/10.6_opt/sql/set_var.cc:859
      #14 0x000055771c2f9369 in sql_set_variables (thd=thd@entry=0x1515d0000c58, var_list=var_list@entry=0x1515d0005b98, free=free@entry=true) at /data/10.6_opt/sql/set_var.cc:746
      #15 0x000055771c3b509f in mysql_execute_command (thd=0x1515d0000c58) at /data/10.6_opt/sql/sql_parse.cc:5017
      #16 0x000055771c3a4074 in mysql_parse (thd=0x1515d0000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/10.6_opt/sql/sql_parse.cc:8004
      #17 0x000055771c3aff95 in dispatch_command (command=COM_QUERY, thd=0x1515d0000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/10.6_opt/sql/sql_class.h:1331
      #18 0x000055771c3b1fe0 in do_command (thd=0x1515d0000c58, blocking=blocking@entry=true) at /data/10.6_opt/sql/sql_parse.cc:1399
      #19 0x000055771c4b3f27 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/10.6_opt/sql/sql_connect.cc:1410
      #20 0x000055771c4b428d in handle_one_connection (arg=arg@entry=0x55771f569698) at /data/10.6_opt/sql/sql_connect.cc:1312
      #21 0x000055771c833239 in pfs_spawn_thread (arg=0x55771f4e5298) at /data/10.6_opt/storage/perfschema/pfs.cc:2201
      #22 0x000015162b68b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x000015162b27a293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.3.29 7d5ec9f1aeec1ea8d00a0aa5bfec521948cfb8be (Optimized)

      Core was generated by `/test/MD240321-mariadb-10.3.29-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGSEGV, Segmentation fault.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x147a3415c700 (LWP 2176807))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055613b70eb7f in my_write_core (sig=sig@entry=11) at /data/10.3_opt/mysys/stacktrace.c:386
      #2  0x000055613b1a7eb8 in handle_fatal_signal (sig=11) at /data/10.3_opt/sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __strlen_avx2 () at ../sysdeps/x86_64/multiarch/strlen-avx2.S:65
      #5  0x000055613b70b2bd in my_strdup (from=0x0, my_flags=my_flags@entry=65552) at /data/10.3_opt/mysys/my_malloc.c:243
      #6  0x000055613af038f8 in Session_sysvars_tracker::init (this=<optimized out>, thd=0x1479e0018f48) at /data/10.3_opt/sql/session_tracker.cc:335
      #7  0x000055613afbc683 in plugin_thdvar_init (thd=thd@entry=0x1479e0018f48) at /data/10.3_opt/sql/sql_plugin.cc:3177
      #8  0x000055613af64800 in THD::init (this=this@entry=0x1479e0018f48) at /data/10.3_opt/sql/sql_class.cc:1179
      #9  0x000055613af657cb in THD::THD (this=0x1479e0018f48, id=<optimized out>, is_wsrep_applier=<optimized out>) at /data/10.3_opt/sql/sql_class.cc:803
      #10 0x000055613b310ee0 in Event_scheduler::start (this=0x55613d997230, err_no=err_no@entry=0x147a34159bfc) at /data/10.3_opt/sql/sql_list.h:622
      #11 0x000055613b0878a6 in Events::start (err_no=err_no@entry=0x147a34159bfc) at /data/10.3_opt/sql/events.cc:1111
      #12 0x000055613b0b09b1 in event_scheduler_update (self=<optimized out>, thd=<optimized out>, type=<optimized out>) at /data/10.3_opt/sql/sys_vars.cc:1058
      #13 0x000055613af04ee2 in sys_var::update (this=0x55613bef4660 <Sys_event_scheduler>, thd=0x1479e0000c48, var=0x1479e000f7c0) at /data/10.3_opt/include/mysql/psi/mysql_thread.h:788
      #14 0x000055613af053cb in set_var::update (this=<optimized out>, thd=<optimized out>) at /data/10.3_opt/sql/set_var.cc:837
      #15 0x000055613af06649 in sql_set_variables (thd=thd@entry=0x1479e0000c48, var_list=var_list@entry=0x1479e0005778, free=free@entry=true) at /data/10.3_opt/sql/set_var.cc:740
      #16 0x000055613afae786 in mysql_execute_command (thd=<optimized out>) at /data/10.3_opt/sql/sql_parse.cc:4936
      #17 0x000055613afb2f57 in mysql_parse (thd=0x1479e0000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/10.3_opt/sql/sql_parse.cc:7871
      #18 0x000055613afb52f5 in dispatch_command (command=COM_QUERY, thd=0x1479e0000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/10.3_opt/sql/sql_class.h:1152
      #19 0x000055613afb730d in do_command (thd=0x1479e0000c48) at /data/10.3_opt/sql/sql_parse.cc:1398
      #20 0x000055613b09e986 in do_handle_one_connection (connect=connect@entry=0x55613d9c2388) at /data/10.3_opt/sql/sql_connect.cc:1403
      #21 0x000055613b09eb5f in handle_one_connection (arg=0x55613d9c2388) at /data/10.3_opt/sql/sql_connect.cc:1308
      #22 0x0000147a3e02f609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #23 0x0000147a3dc26293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.3.29 (dbg), 10.3.29 (opt), 10.4.19 (dbg), 10.4.19 (opt), 10.5.10 (dbg), 10.5.10 (opt), 10.6.0 (dbg), 10.6.0 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.38 (dbg), 10.2.38 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.33 (dbg), 5.7.33 (opt), 8.0.23 (dbg), 8.0.23 (opt)

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              Roel Roel Van de Paar
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.