[MDEV-25237] crash after setting global session_track_system_variables to an invalid value - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
Fix Version/s: 10.4.31, 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2, 11.2.1
Component/s: Variables
Labels:
- affects-tests

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

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2021-03-24 09:32

Roel Van de Paar made changes - 2021-03-24 09:32

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-22134~~ [ ~~MDEV-22134~~ ]

Roel Van de Paar made changes - 2021-03-24 09:34

Description

{noformat}
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;
{noformat}

Leads to:

{noformat:title=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.
{noformat}

{noformat:title=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
{noformat}
{noformat:title=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
{noformat}
{noformat:title=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
{noformat}

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)

Roel Van de Paar made changes - 2021-03-24 09:35

Summary

Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init

Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init | SIGSEGV in __strlen_avx2

Roel Van de Paar made changes - 2021-03-24 09:35

Summary

Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init | SIGSEGV in __strlen_avx2

Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init | SIGSEGV's in __strlen_avx2

Roel Van de Paar made changes - 2021-07-10 06:25

Fix Version/s

10.6 [ 24028 ]

Roel Van de Paar made changes - 2021-11-13 07:53

Labels

not-10.2

Roel Van de Paar made changes - 2021-11-13 07:53

Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.7 [ 24805 ]
Affects Version/s		10.8 [ 26121 ]

Roel Van de Paar made changes - 2021-11-13 07:53

Fix Version/s

10.2 [ 14601 ]

Sergei Golubchik made changes - 2021-12-06 21:35

Workflow

MariaDB v3 [ 120430 ]

MariaDB v4 [ 142712 ]

Roel Van de Paar made changes - 2022-01-29 02:33

Fix Version/s

10.7 [ 24805 ]

Roel Van de Paar made changes - 2022-04-22 06:22

Component/s		Variables [ 13903 ]
Component/s	OTHER [ 10125 ]

Roel Van de Paar made changes - 2022-04-22 06:23

Affects Version/s

10.9 [ 26905 ]

Roel Van de Paar made changes - 2022-04-22 06:23

Labels

affects-tests

Roel Van de Paar made changes - 2022-04-22 06:23

Priority

Major [ 3 ]

Critical [ 2 ]

Roel Van de Paar made changes - 2022-04-22 06:34

Summary

Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init | SIGSEGV's in __strlen_avx2

Assertion `global_system_variables.session_track_system_variables' failed in Session_sysvars_tracker::init | SIGSEGV's in __strlen_avx2 | UBSAN: runtime error: null pointer passed as argument 1, which is declared to never be null in

Roel Van de Paar made changes - 2022-04-22 06:34

Summary

Oleksandr Byelkin made changes - 2022-06-23 10:36

Assignee

Oleksandr Byelkin [ sanja ]

Roel Van de Paar [ roel ]

Roel Van de Paar made changes - 2022-06-24 11:32

Affects Version/s		10.10 [ 27530 ]
Affects Version/s	10.2 [ 14601 ]

Roel Van de Paar made changes - 2022-06-24 11:32

Fix Version/s		10.8 [ 26121 ]
Fix Version/s	10.2 [ 14601 ]

Roel Van de Paar made changes - 2022-06-24 11:33

Assignee

Roel Van de Paar [ roel ]

Oleksandr Byelkin [ sanja ]

Roel Van de Paar made changes - 2022-06-24 11:33

Status

Open [ 1 ]

Confirmed [ 10101 ]

Roel Van de Paar made changes - 2022-06-24 11:33

Component/s

Character Sets [ 10801 ]

Roel Van de Paar made changes - 2022-06-24 11:33

Assignee

Oleksandr Byelkin [ sanja ]

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2022-08-18 07:04

Assignee

Alexander Barkov [ bar ]

Oleksandr Byelkin [ sanja ]

Roel Van de Paar made changes - 2023-01-10 07:39

Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]

Roel Van de Paar made changes - 2023-01-10 07:39

Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]

Julien Fritsch made changes - 2023-03-03 17:35

Fix Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 13:58

Fix Version/s

10.3 [ 22126 ]

Julien Fritsch made changes - 2023-04-27 14:53

Fix Version/s

10.8 [ 26121 ]

Alice Sherepa made changes - 2023-06-26 07:49

Fix Version/s

11.0 [ 28320 ]

Alice Sherepa made changes - 2023-06-26 07:50

Link

This issue is duplicated by ~~MDEV-31534~~ [ ~~MDEV-31534~~ ]

Sergei Golubchik made changes - 2023-06-26 15:15

Priority

Critical [ 2 ]

Blocker [ 1 ]

Oleksandr Byelkin made changes - 2023-06-27 06:42

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Oleksandr Byelkin made changes - 2023-06-27 06:54

Assignee

Oleksandr Byelkin [ sanja ]

Roel Van de Paar [ roel ]

Oleksandr Byelkin made changes - 2023-06-27 06:57

Assignee

Roel Van de Paar [ roel ]

Oleksandr Byelkin [ sanja ]

Oleksandr Byelkin made changes - 2023-06-27 07:23

Assignee

Oleksandr Byelkin [ sanja ]

Roel Van de Paar [ roel ]

Oleksandr Byelkin made changes - 2023-06-27 08:11

Assignee

Roel Van de Paar [ roel ]

Oleksandr Byelkin [ sanja ]

Oleksandr Byelkin made changes - 2023-06-27 10:32

Assignee	Oleksandr Byelkin [ sanja ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Roel Van de Paar made changes - 2023-06-28 01:14

Assignee

Sergei Golubchik [ serg ]

Oleksandr Byelkin [ sanja ]

Roel Van de Paar made changes - 2023-06-28 21:45

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.0 [ 28320 ]
Resolution		Fixed [ 1 ]
Status	In Review [ 10002 ]	Closed [ 6 ]

Roel Van de Paar made changes - 2023-06-28 21:46

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Roel Van de Paar made changes - 2023-06-28 21:46

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.1 [ 28549 ]
Fix Version/s	N/A [ 14700 ]

Roel Van de Paar made changes - 2023-06-28 21:47

Affects Version/s

11.1 [ 28549 ]

Oleksandr Byelkin made changes - 2023-07-03 14:30

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Oleksandr Byelkin made changes - 2023-07-03 14:31

Assignee	Oleksandr Byelkin [ sanja ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2023-07-07 15:11

Assignee	Sergei Golubchik [ serg ]	Oleksandr Byelkin [ sanja ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Oleksandr Byelkin made changes - 2023-07-10 12:40

Assignee	Oleksandr Byelkin [ sanja ]	Sergei Golubchik [ serg ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2023-07-15 08:57

Assignee	Sergei Golubchik [ serg ]	Oleksandr Byelkin [ sanja ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Oleksandr Byelkin made changes - 2023-07-20 08:33

Summary

Unknown variable in global session_track_system_variables lead to crash

Oleksandr Byelkin made changes - 2023-07-20 08:34

Summary

Unknown variable in global session_track_system_variables lead to crash

Oleksandr Byelkin made changes - 2023-07-20 08:36

Summary

Unknown variable in global session_track_system_variables lead to crash

crash after setting global session_track_system_variables to an invalid value

Oleksandr Byelkin made changes - 2023-07-20 09:24

Component/s	Character Sets [ 10801 ]
Fix Version/s		10.4.31 [ 29010 ]
Fix Version/s		10.5.22 [ 29011 ]
Fix Version/s		10.6.15 [ 29013 ]
Fix Version/s		10.9.8 [ 29015 ]
Fix Version/s		10.10.6 [ 29017 ]
Fix Version/s		10.11.5 [ 29019 ]
Fix Version/s		11.0.3 [ 28920 ]
Fix Version/s		11.1.2 [ 28921 ]
Fix Version/s		11.2.1 [ 29034 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.0 [ 28320 ]
Fix Version/s	11.1 [ 28549 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Oleksandr Byelkin

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2021-03-24 09:32

Updated:: 2023-07-20 09:24

Resolved:: 2023-07-20 09:24

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration