[MDEV-11998] [bb-10.0-monty] Server crashes in my_hash_insert / Master_info_index::add_master_info / change_master upon shutdown Created: 2017-02-05  Updated: 2021-02-15  Resolved: 2021-02-15

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Incomplete Votes: 0
Labels: None

Attachments: HTML File threads1    

 Description   

bb-10.0-monty f5a696b150df5

#3  <signal handler called>
#4  0x00000000013b5ec0 in my_hash_insert (info=0x7f9d82c14da0, record=0x7f9d58c27000 "02\262\001") at /data/src/bb-10.0-monty/mysys/hash.c:491
#5  0x000000000088f633 in Master_info_index::add_master_info (this=0x7f9d82c14a00, mi=0x7f9d58c27000, write_to_file=true) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1259
#6  0x000000000071d310 in change_master (thd=0x7f9d6ac3b070, mi=0x7f9d58c27000, master_info_added=0x7f9d8377135f) at /data/src/bb-10.0-monty/sql/sql_repl.cc:3345
#7  0x00000000006cdb98 in mysql_execute_command (thd=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2734
#8  0x00000000006dea8e in mysql_parse (thd=0x7f9d6ac3b070, rawbuf=0x7f9d58c22088 "CHANGE MASTER 'test1' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 863177 CON_ID 8 */", length=111, parser_state=0x7f9d837716a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6580
#9  0x00000000006c8170 in dispatch_command (command=COM_QUERY, thd=0x7f9d6ac3b070, packet=0x7f9d6ac41071 "CHANGE MASTER 'test1' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 863177 CON_ID 8 */ ", packet_length=112) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
#10 0x00000000006c6b61 in do_command (thd=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
#11 0x000000000089c621 in do_handle_one_connection (thd_arg=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
#12 0x000000000089c173 in handle_one_connection (arg=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
#13 0x00007f9d856a30a4 in start_thread (arg=0x7f9d83772700) at pthread_create.c:309
#14 0x00007f9d8385b87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

Version: '10.0.30-MariaDB-debug'  socket: '/data/logs/analyze80_slave/mysql.sock'  port: 19302  Source distribution
170205 20:27:36 [Note] Master 'test1': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './mysql-relay-bin-test1.00003
0' position: 4
170205 20:27:36 [ERROR] Master 'test1': Slave I/O: error connecting to master 'foo@127.0.0.1:3333' - retry-time: 60  retries: 86400  message: Can't connect to M
ySQL server on '127.0.0.1' (111 "Connection refused"), Internal MariaDB error code: 2003
170205 20:27:47 [Note] /data/src/bb-10.0-monty/sql/mysqld: Normal shutdown
 
170205 20:27:47 [Note] Event Scheduler: Purging the queue. 0 events
170205 20:27:47 [Note] Master 'test1': Error reading relay log event: slave SQL thread was killed
170205 20:27:47 [Note] Master 'test1': Slave SQL thread exiting, replication stopped in log 'FIRST' at position 0
170205 20:27:47 [Note] Master 'test1': Slave I/O thread killed while connecting to master
170205 20:27:47 [Note] Master 'test1': Slave I/O thread exiting, read up to log 'FIRST', position 4
170205 20:27:47 [Note] Master 'm1': Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 10260177; GTID position 0-1-56491
170205 20:27:47 [Note] Master 'm1': Slave SQL thread exiting, replication stopped in log 'mysql-bin.000001' at position 820966; GTID position '0-1-3727'
170205 20:27:47 [ERROR] mysqld got signal 11 ;
...
Query (0x7f9d58c22088): CHANGE MASTER 'test1' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 863177 CON_ID 8 */
Connection ID (thread ID): 7
Status: KILL_SERVER

All threads' stack trace is attached


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