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
- is duplicated by
-
MDEV-31534 Wrong value assigned to session_track_system_variables causes signal 11 crash
- Closed
- relates to
-
MDEV-22134 handle_fatal_signal (sig=11) in __strlen_avx2 on START SLAVE | Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init | *** buffer overflow detected *** (on optimized builds)
- Closed