Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL)
-
None
Description
MariaDB [(none)]> show processlist;
|
+-----+------+-----------------+-------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+ |
| Id | User | Host | db | Command | Time | State | Info | Progress | |
+-----+------+-----------------+-------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+ |
| 3 | rqg | localhost:40526 | mysql | Sleep | 146 | | NULL | 0.000 | |
| 7 | root | localhost:40539 | NULL | Query | 95 | init | CHANGE MASTER 'test2' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 453 CON | 0.000 | |
| 8 | root | localhost:40540 | NULL | Query | 97 | Killing slave | STOP SLAVE /* QNO 524 CON_ID 8 */ | 0.000 | |
| 9 | root | localhost:40541 | NULL | Query | 95 | init | SHOW SLAVE STATUS /* QNO 524 CON_ID 9 */ | 0.000 | |
| 10 | root | localhost:40544 | NULL | Query | 101 | init | RESET SLAVE ALL /* QNO 428 CON_ID 10 */ | 0.000 | |
| 11 | root | localhost:40545 | NULL | Query | 97 | Killing slave | STOP SLAVE /* QNO 367 CON_ID 11 */ | 0.000 | |
| 12 | root | localhost:40546 | NULL | Query | 96 | Filling schema table | SHOW GLOBAL STATUS /* QNO 502 CON_ID 12 */ | 0.000 | |
| 13 | root | localhost:40547 | NULL | Query | 95 | Filling schema table | SHOW STATUS LIKE '%slave%' /* QNO 354 CON_ID 13 */ | 0.000 | |
| 14 | root | localhost:40548 | NULL | Query | 96 | Filling schema table | SHOW GLOBAL STATUS /* QNO 404 CON_ID 14 */ | 0.000 | |
| 15 | root | localhost:40549 | NULL | Query | 95 | init | SHOW SLAVE 'm1' STATUS /* QNO 368 CON_ID 15 */ | 0.000 | |
| 16 | root | localhost:40550 | NULL | Query | 96 | init | SHOW SLAVE STATUS /* QNO 452 CON_ID 16 */ | 0.000 | |
| 128 | root | localhost:40878 | NULL | Query | 0 | init | show processlist | 0.000 | |
+-----+------+-----------------+-------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+ |
12 rows in set (0.00 sec) |
|
bb-10.0-monty 722f4f78a9 |
Thread 2 (Thread 0x7efedd61d700 (LWP 11927)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", line=1114) at /data/src/bb-10.0-monty/mysys/thr_mutex.c:294
|
#4 0x00000000008894c2 in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", src_line=1114) at /data/src/bb-10.0-monty/include/mysql/psi/mysql_thread.h:689
|
#5 0x000000000088ea45 in get_master_info (connection_name=0x7efed6e12a18, warning=Sql_condition::WARN_LEVEL_ERROR) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1114
|
#6 0x00000000006cdebf in mysql_execute_command (thd=0x7efed6e0e070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2767
|
#7 0x00000000006deaa4 in mysql_parse (thd=0x7efed6e0e070, rawbuf=0x7efec2422088 "SHOW SLAVE STATUS /* QNO 452 CON_ID 16 */", length=41, parser_state=0x7efedd61c6a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6569
|
#8 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6e0e070, packet=0x7efed6e14071 "SHOW SLAVE STATUS /* QNO 452 CON_ID 16 */ ", packet_length=42) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
|
#9 0x00000000006c6c31 in do_command (thd=0x7efed6e0e070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#10 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6e0e070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#11 0x000000000089bf0a in handle_one_connection (arg=0x7efed6e0e070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#12 0x00007efef107e0a4 in start_thread (arg=0x7efedd61d700) at pthread_create.c:309
|
#13 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 3 (Thread 0x7efedd666700 (LWP 11925)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", line=1114) at /data/src/bb-10.0-monty/mysys/thr_mutex.c
|
:294
|
#4 0x00000000008894c2 in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", src_line=1114) at /data/src/bb-10.0-monty/include/mysql/psi/mysql_thread.h:689
|
#5 0x000000000088ea45 in get_master_info (connection_name=0x7efed6e07a18, warning=Sql_condition::WARN_LEVEL_ERROR) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1114
|
#6 0x00000000006cdebf in mysql_execute_command (thd=0x7efed6e03070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2767
|
#7 0x00000000006deaa4 in mysql_parse (thd=0x7efed6e03070, rawbuf=0x7efec2c22088 "SHOW SLAVE 'm1' STATUS /* QNO 368 CON_ID 15 */", length=46, parser_state=0x7efedd6656a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6569
|
#8 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6e03070, packet=0x7efed6e09071 "SHOW SLAVE 'm1' STATUS /* QNO 368 CON_ID 15 */ ", packet_length=47) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
|
#9 0x00000000006c6c31 in do_command (thd=0x7efed6e03070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#10 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6e03070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#11 0x000000000089bf0a in handle_one_connection (arg=0x7efed6e03070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#12 0x00007efef107e0a4 in start_thread (arg=0x7efedd666700) at pthread_create.c:309
|
#13 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 4 (Thread 0x7efedd6af700 (LWP 11924)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", line=1114) at /data/src/bb-10.0-monty/mysys/thr_mutex.c
|
:294
|
#4 0x00000000008894c2 in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", src_line=1114) at /data/src/bb-10.0-monty/include/mys
|
ql/psi/mysql_thread.h:689
|
#5 0x000000000088ea45 in get_master_info (connection_name=0x7efed6df89e0, warning=Sql_condition::WARN_LEVEL_NOTE) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1114
|
#6 0x0000000000599b87 in show_heartbeat_period (thd=0x7efed6df8070, var=0x7efedd6ac550, buff=0x7efedd6ac150 "0") at /data/src/bb-10.0-monty/sql/mysqld.cc:7298
|
#7 0x00000000007a4baf in show_status_array (thd=0x7efed6df8070, wild=0x0, variables=0x7efeee865c88, value_type=OPT_GLOBAL, status_var=0x7efedd6ac670, prefix=0x14aa1e8 "", table=0x7efec30d0088, uca
|
se_names=false, cond=0x0) at /data/src/bb-10.0-monty/sql/sql_show.cc:3057
|
#8 0x00000000007bdcdf in fill_status (thd=0x7efed6df8070, tables=0x7efec30223e8, cond=0x0) at /data/src/bb-10.0-monty/sql/sql_show.cc:7490
|
#9 0x00000000007c18d2 in get_schema_tables_result (join=0x7efec3022dd0, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/bb-10.0-monty/sql/sql_show.cc:8291
|
#10 0x000000000072e238 in JOIN::exec_inner (this=0x7efec3022dd0) at /data/src/bb-10.0-monty/sql/sql_select.cc:2543
|
#11 0x000000000072d238 in JOIN::exec (this=0x7efec3022dd0) at /data/src/bb-10.0-monty/sql/sql_select.cc:2378
|
#12 0x0000000000732370 in mysql_select (thd=0x7efed6df8070, rref_pointer_array=0x7efed6dfc370, tables=0x7efec30223e8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0,
|
proc_param=0x0, select_options=2684652288, result=0x7efec3022db0, unit=0x7efed6dfba08, select_lex=0x7efed6dfc0f8) at /data/src/bb-10.0-monty/sql/sql_select.cc:3314
|
#13 0x00000000007229f6 in handle_select (thd=0x7efed6df8070, lex=0x7efed6dfb940, result=0x7efec3022db0, setup_tables_done_option=0) at /data/src/bb-10.0-monty/sql/sql_select.cc:373
|
#14 0x00000000006da292 in execute_sqlcom_select (thd=0x7efed6df8070, all_tables=0x7efec30223e8) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5287
|
#15 0x00000000006da496 in execute_show_status (thd=0x7efed6df8070, all_tables=0x7efec30223e8) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5308
|
#16 0x00000000006ccadd in mysql_execute_command (thd=0x7efed6df8070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2493
|
#17 0x00000000006deaa4 in mysql_parse (thd=0x7efed6df8070, rawbuf=0x7efec3022088 "SHOW GLOBAL STATUS /* QNO 404 CON_ID 14 */", length=42, parser_state=0x7efedd6ae6a0) at /data/src/bb-10.0-monty/sql
|
/sql_parse.cc:6569
|
#18 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6df8070, packet=0x7efed6dfe071 "SHOW GLOBAL STATUS /* QNO 404 CON_ID 14 */ ", packet_length=43) at /data/src/bb-10.0-monty/
|
sql/sql_parse.cc:1309
|
#19 0x00000000006c6c31 in do_command (thd=0x7efed6df8070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#20 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6df8070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#21 0x000000000089bf0a in handle_one_connection (arg=0x7efed6df8070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#22 0x00007efef107e0a4 in start_thread (arg=0x7efedd6af700) at pthread_create.c:309
|
#23 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 5 (Thread 0x7efeef072700 (LWP 11923)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804b9 in _L_lock_909 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef10802e0 in __GI___pthread_mutex_lock (mutex=0x2197ee8 <LOCK_show_status+40>) at ../nptl/pthread_mutex_lock.c:79
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2197ec0 <LOCK_show_status>, my_flags=0, file=0x14abe18 "/data/src/bb-10.0-monty/sql/sql_show.cc", line=7486) at /data/src/bb-10.0-monty/mysys/thr_mut
|
ex.c:294
|
#4 0x0000000000796497 in inline_mysql_mutex_lock (that=0x2197ec0 <LOCK_show_status>, src_file=0x14abe18 "/data/src/bb-10.0-monty/sql/sql_show.cc", src_line=7486) at /data/src/bb-10.0-monty/include
|
/mysql/psi/mysql_thread.h:689
|
#5 0x00000000007bdc85 in fill_status (thd=0x7efed6ded070, tables=0x7efec2822438, cond=0x0) at /data/src/bb-10.0-monty/sql/sql_show.cc:7486
|
#6 0x00000000007c18d2 in get_schema_tables_result (join=0x7efec2822e20, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/bb-10.0-monty/sql/sql_show.cc:8291
|
#7 0x000000000072e238 in JOIN::exec_inner (this=0x7efec2822e20) at /data/src/bb-10.0-monty/sql/sql_select.cc:2543
|
#8 0x000000000072d238 in JOIN::exec (this=0x7efec2822e20) at /data/src/bb-10.0-monty/sql/sql_select.cc:2378
|
#9 0x0000000000732370 in mysql_select (thd=0x7efed6ded070, rref_pointer_array=0x7efed6df1370, tables=0x7efec2822438, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0,
|
proc_param=0x0, select_options=2684652288, result=0x7efec2822e00, unit=0x7efed6df0a08, select_lex=0x7efed6df10f8) at /data/src/bb-10.0-monty/sql/sql_select.cc:3314
|
#10 0x00000000007229f6 in handle_select (thd=0x7efed6ded070, lex=0x7efed6df0940, result=0x7efec2822e00, setup_tables_done_option=0) at /data/src/bb-10.0-monty/sql/sql_select.cc:373
|
#11 0x00000000006da292 in execute_sqlcom_select (thd=0x7efed6ded070, all_tables=0x7efec2822438) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5287
|
#12 0x00000000006da496 in execute_show_status (thd=0x7efed6ded070, all_tables=0x7efec2822438) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5308
|
#13 0x00000000006ccadd in mysql_execute_command (thd=0x7efed6ded070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2493
|
#14 0x00000000006deaa4 in mysql_parse (thd=0x7efed6ded070, rawbuf=0x7efec2822088 "SHOW STATUS LIKE '%slave%' /* QNO 354 CON_ID 13 */", length=50, parser_state=0x7efeef0716a0) at /data/src/bb-10.0-m
|
onty/sql/sql_parse.cc:6569
|
#15 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6ded070, packet=0x7efed6df3071 "SHOW STATUS LIKE '%slave%' /* QNO 354 CON_ID 13 */ ", packet_length=51) at /data/src/bb-10.
|
0-monty/sql/sql_parse.cc:1309
|
#16 0x00000000006c6c31 in do_command (thd=0x7efed6ded070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#17 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6ded070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#18 0x000000000089bf0a in handle_one_connection (arg=0x7efed6ded070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#19 0x00007efef107e0a4 in start_thread (arg=0x7efeef072700) at pthread_create.c:309
|
#20 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 6 (Thread 0x7efeef0bb700 (LWP 11922)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804b9 in _L_lock_909 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef10802e0 in __GI___pthread_mutex_lock (mutex=0x2197ee8 <LOCK_show_status+40>) at ../nptl/pthread_mutex_lock.c:79
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2197ec0 <LOCK_show_status>, my_flags=0, file=0x14abe18 "/data/src/bb-10.0-monty/sql/sql_show.cc", line=7486) at /data/src/bb-10.0-monty/mysys/thr_mut
|
ex.c:294
|
#4 0x0000000000796497 in inline_mysql_mutex_lock (that=0x2197ec0 <LOCK_show_status>, src_file=0x14abe18 "/data/src/bb-10.0-monty/sql/sql_show.cc", src_line=7486) at /data/src/bb-10.0-monty/include
|
/mysql/psi/mysql_thread.h:689
|
#5 0x00000000007bdc85 in fill_status (thd=0x7efed6de2070, tables=0x7efec38223e8, cond=0x0) at /data/src/bb-10.0-monty/sql/sql_show.cc:7486
|
#6 0x00000000007c18d2 in get_schema_tables_result (join=0x7efec3822dd0, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/bb-10.0-monty/sql/sql_show.cc:8291
|
#7 0x000000000072e238 in JOIN::exec_inner (this=0x7efec3822dd0) at /data/src/bb-10.0-monty/sql/sql_select.cc:2543
|
#8 0x000000000072d238 in JOIN::exec (this=0x7efec3822dd0) at /data/src/bb-10.0-monty/sql/sql_select.cc:2378
|
#9 0x0000000000732370 in mysql_select (thd=0x7efed6de2070, rref_pointer_array=0x7efed6de6370, tables=0x7efec38223e8, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0,
|
proc_param=0x0, select_options=2684652288, result=0x7efec3822db0, unit=0x7efed6de5a08, select_lex=0x7efed6de60f8) at /data/src/bb-10.0-monty/sql/sql_select.cc:3314
|
#10 0x00000000007229f6 in handle_select (thd=0x7efed6de2070, lex=0x7efed6de5940, result=0x7efec3822db0, setup_tables_done_option=0) at /data/src/bb-10.0-monty/sql/sql_select.cc:373
|
#11 0x00000000006da292 in execute_sqlcom_select (thd=0x7efed6de2070, all_tables=0x7efec38223e8) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5287
|
#12 0x00000000006da496 in execute_show_status (thd=0x7efed6de2070, all_tables=0x7efec38223e8) at /data/src/bb-10.0-monty/sql/sql_parse.cc:5308
|
#13 0x00000000006ccadd in mysql_execute_command (thd=0x7efed6de2070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2493
|
#14 0x00000000006deaa4 in mysql_parse (thd=0x7efed6de2070, rawbuf=0x7efec3822088 "SHOW GLOBAL STATUS /* QNO 502 CON_ID 12 */", length=42, parser_state=0x7efeef0ba6a0) at /data/src/bb-10.0-monty/sql
|
/sql_parse.cc:6569
|
#15 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6de2070, packet=0x7efed6de8071 "SHOW GLOBAL STATUS /* QNO 502 CON_ID 12 */ ", packet_length=43) at /data/src/bb-10.0-monty/
|
sql/sql_parse.cc:1309
|
#16 0x00000000006c6c31 in do_command (thd=0x7efed6de2070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#17 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6de2070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#18 0x000000000089bf0a in handle_one_connection (arg=0x7efed6de2070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#19 0x00007efef107e0a4 in start_thread (arg=0x7efeef0bb700) at pthread_create.c:309
|
#20 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 7 (Thread 0x7efeef104700 (LWP 11921)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x14a34b0 "/data/src/bb-10.0-monty/sql/sql_repl.cc", line=3054) at /data/src/bb-10.0-monty/mysys/thr_mutex
|
.c:294
|
#4 0x00000000007105c8 in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x14a34b0 "/data/src/bb-10.0-monty/sql/sql_repl.cc", src_line=3054) at /data/src/bb-10.0-monty/include/m
|
ysql/psi/mysql_thread.h:689
|
#5 0x000000000071c110 in stop_slave (thd=0x7efedc6d7070, mi=0x7efec3078000, net_report=true) at /data/src/bb-10.0-monty/sql/sql_repl.cc:3054
|
#6 0x00000000006cf5a7 in mysql_execute_command (thd=0x7efedc6d7070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:3155
|
#7 0x00000000006deaa4 in mysql_parse (thd=0x7efedc6d7070, rawbuf=0x7efec3422088 "STOP SLAVE /* QNO 367 CON_ID 11 */", length=34, parser_state=0x7efeef1036a0) at /data/src/bb-10.0-monty/sql/sql_par
|
se.cc:6569
|
#8 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efedc6d7070, packet=0x7efedc6dd071 "STOP SLAVE /* QNO 367 CON_ID 11 */ ", packet_length=35) at /data/src/bb-10.0-monty/sql/sql_
|
parse.cc:1309
|
#9 0x00000000006c6c31 in do_command (thd=0x7efedc6d7070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#10 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efedc6d7070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#11 0x000000000089bf0a in handle_one_connection (arg=0x7efedc6d7070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#12 0x00007efef107e0a4 in start_thread (arg=0x7efeef104700) at pthread_create.c:309
|
#13 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 8 (Thread 0x7efeef14d700 (LWP 11915)):
|
#0 pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
|
#1 0x00000000013fd2d1 in safe_cond_wait (cond=0x7efec3079ca8, mp=0x7efec3079aa0, file=0x14c6300 "/data/src/bb-10.0-monty/include/mysql/psi/mysql_thread.h", line=1165) at /data/src/bb-10.0-monty/my
|
sys/thr_mutex.c:493
|
#2 0x00000000008897e4 in inline_mysql_cond_wait (that=0x7efec3079ca8, mutex=0x7efec3079aa0, src_file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", src_line=103) at /data/src/bb-10.0-monty/inc
|
lude/mysql/psi/mysql_thread.h:1165
|
#3 0x000000000088a2b8 in Master_info::wait_until_free (this=0x7efec3078000) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:103
|
#4 0x000000000088a346 in Master_info::~Master_info (this=0x7efec3078000, __in_chrg=<optimized out>) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:113
|
#5 0x000000000088a604 in Master_info::~Master_info (this=0x7efec3078000, __in_chrg=<optimized out>) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:126
|
#6 0x000000000088cc20 in free_key_master_info (mi=0x7efec3078000) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:737
|
#7 0x00000000013b6870 in my_hash_delete (hash=0x7efeee814da0, record=0x7efec3078000 "02\262\001") at /data/src/bb-10.0-monty/mysys/hash.c:607
|
#8 0x000000000088f69a in Master_info_index::remove_master_info (this=0x7efeee814a00, mi=0x7efec3078000) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1281
|
#9 0x00000000008e9d7f in reload_acl_and_cache (thd=0x7efedc6cc070, options=64, tables=0x0, write_to_binlog=0x7efeef14c2dc) at /data/src/bb-10.0-monty/sql/sql_reload.cc:368
|
#10 0x00000000006d5238 in mysql_execute_command (thd=0x7efedc6cc070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:4301
|
#11 0x00000000006deaa4 in mysql_parse (thd=0x7efedc6cc070, rawbuf=0x7efec4422088 "RESET SLAVE ALL /* QNO 428 CON_ID 10 */", length=39, parser_state=0x7efeef14c6a0) at /data/src/bb-10.0-monty/sql/sq
|
l_parse.cc:6569
|
#12 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efedc6cc070, packet=0x7efedc6d2071 "RESET SLAVE ALL /* QNO 428 CON_ID 10 */ ", packet_length=40) at /data/src/bb-10.0-monty/sql
|
/sql_parse.cc:1309
|
#13 0x00000000006c6c31 in do_command (thd=0x7efedc6cc070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#14 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efedc6cc070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#15 0x000000000089bf0a in handle_one_connection (arg=0x7efedc6cc070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#16 0x00007efef107e0a4 in start_thread (arg=0x7efeef14d700) at pthread_create.c:309
|
#17 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 9 (Thread 0x7efef1300700 (LWP 11913)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", line=1114) at /data/src/bb-10.0-monty/mysys/thr_mutex.c
|
:294
|
#4 0x00000000008894c2 in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x14c6340 "/data/src/bb-10.0-monty/sql/rpl_mi.cc", src_line=1114) at /data/src/bb-10.0-monty/include/mys
|
ql/psi/mysql_thread.h:689
|
#5 0x000000000088ea45 in get_master_info (connection_name=0x7efedc6c5a18, warning=Sql_condition::WARN_LEVEL_ERROR) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1114
|
#6 0x00000000006cdebf in mysql_execute_command (thd=0x7efedc6c1070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2767
|
#7 0x00000000006deaa4 in mysql_parse (thd=0x7efedc6c1070, rawbuf=0x7efec4022088 "SHOW SLAVE STATUS /* QNO 524 CON_ID 9 */", length=40, parser_state=0x7efef12ff6a0) at /data/src/bb-10.0-monty/sql/s
|
ql_parse.cc:6569
|
#8 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efedc6c1070, packet=0x7efedc6c7071 "SHOW SLAVE STATUS /* QNO 524 CON_ID 9 */ ", packet_length=41) at /data/src/bb-10.0-monty/sq
|
l/sql_parse.cc:1309
|
#9 0x00000000006c6c31 in do_command (thd=0x7efedc6c1070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#10 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efedc6c1070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#11 0x000000000089bf0a in handle_one_connection (arg=0x7efedc6c1070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#12 0x00007efef107e0a4 in start_thread (arg=0x7efef1300700) at pthread_create.c:309
|
#13 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 10 (Thread 0x7efef1349700 (LWP 11911)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x14a34b0 "/data/src/bb-10.0-monty/sql/sql_repl.cc", line=3054) at /data/src/bb-10.0-monty/mysys/thr_mutex.c:294
|
#4 0x00000000007105c8 in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x14a34b0 "/data/src/bb-10.0-monty/sql/sql_repl.cc", src_line=3054) at /data/src/bb-10.0-monty/include/mysql/psi/mysql_thread.h:689
|
#5 0x000000000071c110 in stop_slave (thd=0x7efed6dce070, mi=0x7efec3078000, net_report=true) at /data/src/bb-10.0-monty/sql/sql_repl.cc:3054
|
#6 0x00000000006cf5a7 in mysql_execute_command (thd=0x7efed6dce070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:3155
|
#7 0x00000000006deaa4 in mysql_parse (thd=0x7efed6dce070, rawbuf=0x7efec3c22088 "STOP SLAVE /* QNO 524 CON_ID 8 */", length=33, parser_state=0x7efef13486a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6569
|
#8 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6dce070, packet=0x7efed6ddd071 "STOP SLAVE /* QNO 524 CON_ID 8 */ ", packet_length=34) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
|
#9 0x00000000006c6c31 in do_command (thd=0x7efed6dce070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#10 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6dce070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#11 0x000000000089bf0a in handle_one_connection (arg=0x7efed6dce070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#12 0x00007efef107e0a4 in start_thread (arg=0x7efef1349700) at pthread_create.c:309
|
#13 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Thread 11 (Thread 0x7efef1392700 (LWP 11909)):
|
#0 __lll_lock_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135
|
#1 0x00007efef10804ef in _L_lock_1081 () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#2 0x00007efef1080468 in __GI___pthread_mutex_lock (mutex=0x2198ba8 <LOCK_active_mi+40>) at ../nptl/pthread_mutex_lock.c:134
|
#3 0x00000000013fc56f in safe_mutex_lock (mp=0x2198b80 <LOCK_active_mi>, my_flags=0, file=0x149d100 "/data/src/bb-10.0-monty/sql/sql_parse.cc", line=2709) at /data/src/bb-10.0-monty/mysys/thr_mute
|
x.c:294
|
#4 0x00000000006c2bfb in inline_mysql_mutex_lock (that=0x2198b80 <LOCK_active_mi>, src_file=0x149d100 "/data/src/bb-10.0-monty/sql/sql_parse.cc", src_line=2709) at /data/src/bb-10.0-monty/include/mysql/psi/mysql_thread.h:689
|
#5 0x00000000006cda62 in mysql_execute_command (thd=0x7efed6dc3070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2709
|
#6 0x00000000006deaa4 in mysql_parse (thd=0x7efed6dc3070, rawbuf=0x7efec4fad088 "CHANGE MASTER 'test2' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 453 CON_ID 7 */", length=108, parser_state=0x7efef13916a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6569
|
#7 0x00000000006c8240 in dispatch_command (command=COM_QUERY, thd=0x7efed6dc3070, packet=0x7efed6dc9071 "CHANGE MASTER 'test2' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 453 CON_ID 7 */ ", packet_length=109) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
|
#8 0x00000000006c6c31 in do_command (thd=0x7efed6dc3070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
|
#9 0x000000000089c3b8 in do_handle_one_connection (thd_arg=0x7efed6dc3070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
|
#10 0x000000000089bf0a in handle_one_connection (arg=0x7efed6dc3070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
|
#11 0x00007efef107e0a4 in start_thread (arg=0x7efef1392700) at pthread_create.c:309
|
#12 0x00007efeef23687d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
All threads' stack trace is attached.
threads1a : from bb-10.0-monty 722f4f78a999893a.
threads2: from 10.0 4e82aaab2f65