[MDEV-31723] Crash on SET SESSION gtid_seq_no= DEFAULT Created: 2023-07-17  Updated: 2023-08-25  Resolved: 2023-07-30

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.4.1
Fix Version/s: 10.4.31

Type: Bug Priority: Major
Reporter: Kristian Nielsen Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
Labels: None


 Description   

This simple statement crashes the server unconditionally, ouch

SET SESSION gtid_seq_no= DEFAULT;

I think it should instead reverse the effect of any prior SET SESSION gtid_seq_no= 42;



 Comments   
Comment by Elena Stepanova [ 2023-07-17 ]

10.4 9856bb42

#3  <signal handler called>
#4  0x000055ecb85d7363 in Item::val_uint (this=0x0) at /data/src/10.4/sql/item.h:1272
#5  0x000055ecb8c37397 in check_gtid_seq_no (self=0x55ecbc16d980 <Sys_gtid_seq_no>, thd=0x62b00005b208, var=0x62b000062498) at /data/src/10.4/sql/sys_vars.cc:1715
#6  0x000055ecb856445c in sys_var::check (this=0x55ecbc16d980 <Sys_gtid_seq_no>, thd=0x62b00005b208, var=0x62b000062498) at /data/src/10.4/sql/set_var.cc:248
#7  0x000055ecb8564d92 in sys_var::set_default (this=0x55ecbc16d980 <Sys_gtid_seq_no>, thd=0x62b00005b208, var=0x62b000062498) at /data/src/10.4/sql/set_var.cc:295
#8  0x000055ecb856841b in set_var::update (this=0x62b000062498, thd=0x62b00005b208) at /data/src/10.4/sql/set_var.cc:837
#9  0x000055ecb8567b4e in sql_set_variables (thd=0x62b00005b208, var_list=0x62b0000600d8, free=true) at /data/src/10.4/sql/set_var.cc:740
#10 0x000055ecb880e3bd in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:5045
#11 0x000055ecb8822517 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b0000623b8 "SET SESSION gtid_seq_no= DEFAULT", length=32, parser_state=0x7fdd883ca860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8008
#12 0x000055ecb87f885a in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x629000230209 "SET SESSION gtid_seq_no= DEFAULT", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#13 0x000055ecb87f53c9 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#14 0x000055ecb8bf41c6 in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#15 0x000055ecb8bf3add in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#16 0x000055ecb9861f28 in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#17 0x00007fdd901c8fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#18 0x00007fdd902495bc in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Comment by Kristian Nielsen [ 2023-07-30 ]

Pushed to 10.4

Generated at Thu Feb 08 10:25:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.