[MDEV-6616] Server crashes in my_hash_first if shutdown is performed when FLUSH LOGS is running Created: 2014-08-20  Updated: 2016-08-16  Resolved: 2014-09-07

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.13, 10.1.0
Fix Version/s: 10.0.14, 10.1.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-10563 Crash during shutdown in Master_info_... Closed

 Description   

# 2014-08-21T00:14:11 [18246] #2  0x000000000086461d in handle_fatal_signal (sig=11) at 10.0/sql/signal_handler.cc:262
# 2014-08-21T00:14:11 [18246] #3  <signal handler called>
# 2014-08-21T00:14:11 [18246] #4  0x0000000000e1b1c8 in my_hash_first (hash=0x3a0, key=0x7fc5e809ea40 "", length=0, current_record=0x7fc5e809e9ec) at 10.0/mysys/hash.c:252
# 2014-08-21T00:14:11 [18246] #5  0x0000000000e1b173 in my_hash_search (hash=0x3a0, key=0x7fc5e809ea40 "", length=0) at 10.0/mysys/hash.c:227
# 2014-08-21T00:14:11 [18246] #6  0x000000000078903f in Master_info_index::get_master_info (this=0x0, connection_name=0x7fc5e809eb50, warning=Sql_condition::WARN_LEVEL_ERROR) at 10.0/sql/rpl_mi.cc:1098
# 2014-08-21T00:14:11 [18246] #7  0x00000000007c3978 in reload_acl_and_cache (thd=0x7fc5cd848070, options=16130, tables=0x0, write_to_binlog=0x7fc5e809f24c) at 10.0/sql/sql_reload.cc:177
# 2014-08-21T00:14:11 [18246] #8  0x000000000067d84b in mysql_execute_command (thd=0x7fc5cd848070) at 10.0/sql/sql_parse.cc:4266
# 2014-08-21T00:14:11 [18246] #9  0x0000000000682fc3 in mysql_parse (thd=0x7fc5cd848070, rawbuf=0x7fc5bc1ed088 "FLUSH LOGS", length=10, parser_state=0x7fc5e809f660) at 10.0/sql/sql_parse.cc:6411
# 2014-08-21T00:14:11 [18246] #10 0x0000000000675e78 in dispatch_command (command=COM_QUERY, thd=0x7fc5cd848070, packet=0x7fc5cd84e071 "FLUSH LOGS", packet_length=10) at 10.0/sql/sql_parse.cc:1307
# 2014-08-21T00:14:11 [18246] #11 0x000000000067521d in do_command (thd=0x7fc5cd848070) at 10.0/sql/sql_parse.cc:1004
# 2014-08-21T00:14:11 [18246] #12 0x00000000007914d2 in do_handle_one_connection (thd_arg=0x7fc5cd848070) at 10.0/sql/sql_connect.cc:1379
# 2014-08-21T00:14:11 [18246] #13 0x0000000000791225 in handle_one_connection (arg=0x7fc5cd848070) at 10.0/sql/sql_connect.cc:1293
# 2014-08-21T00:14:11 [18246] #14 0x00007fc5e7d1cb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
# 2014-08-21T00:14:11 [18246] #15 0x00007fc5e621420d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

Stack trace from:

revision-id: knielsen@knielsen-hq.org-20140820130210-980qieck1uzi67k0
revno: 4359
branch-nick: 10.0

RQG grammar (flush-crash.yy):

thread1:
	FLUSH LOGS; 
	
thread2:
	SELECT SLEEP(5); SHUTDOWN;

RQG command line (to start server and run the test)

perl ./runall.pl --grammar=flush-crash.yy --skip-gendata --threads=2 --queries=100M --duration=100 --basedir=<your basedir> --vardir=<your vardir>

RQG command line (assuming the server is already running on 3306):

perl ./gentest.pl --grammar=flush-crash.yy --threads=2 --queries=100M --duration=100 --dsn="dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test"


Generated at Thu Feb 08 07:13:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.