## Build [umshastr@hod04]/export/home/ushastry/mysql-5.7.22: cat docs/INFO_SRC commit: fc04cf3c6e54933e8720cd9754bef9acf9f36ccd date: 2018-03-04 14:35:40 +0100 build-date: 2018-03-04 14:40:53 +0100 short: fc04cf3 branch: mysql-5.7.22-release MySQL source 5.7.22 ============= #hod06 [mysqld] basedir = /export/home/ushastry/mysql-5.7.22 datadir = /export/home/ushastry/mysql-5.7.22/data/ plugin-load = group_replication.so port = 3306 log_bin socket = /tmp/mysql_hod06.sock disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,ARCHIVE ssl skip_name_resolve server_id = 571708 binlog_format = ROW binlog_rows_query_log_events = ON gtid_mode = ON enforce_gtid_consistency = ON log_slave_updates = ON master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON transaction_write_set_extraction = XXHASH64 binlog_checksum = NONE #group_replication = FORCE_PLUS_PERMANENT group_replication_start_on_boot = ON group_replication_group_name = 9d7f8c28-c02c-11e6-9829-08002715584a group_replication_local_address = hod06.no.oracle.com:6608 group_replication_group_seeds = hod03.no.oracle.com:6606,hod04.no.oracle.com:6607,hod06.no.oracle.com:6608 group_replication_single_primary_mode=TRUE group_replication_start_on_boot=FALSE #hod04 [mysqld] basedir = /export/home/ushastry/mysql-5.7.22 datadir = /export/home/ushastry/mysql-5.7.22/data/ plugin-load = group_replication.so port = 3306 log_bin socket = /tmp/mysql_hod04.sock disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,ARCHIVE ssl skip_name_resolve server_id = 571707 binlog_format = ROW binlog_rows_query_log_events = ON gtid_mode = ON enforce_gtid_consistency = ON log_slave_updates = ON master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON transaction_write_set_extraction = XXHASH64 binlog_checksum = NONE #group_replication = FORCE_PLUS_PERMANENT group_replication_start_on_boot = ON group_replication_group_name = 9d7f8c28-c02c-11e6-9829-08002715584a group_replication_local_address = hod04.no.oracle.com:6607 group_replication_group_seeds = hod03.no.oracle.com:6606,hod04.no.oracle.com:6607,hod06.no.oracle.com:6608 group_replication_single_primary_mode=TRUE group_replication_start_on_boot=FALSE #hod03 [mysqld] basedir = /export/umesh/server/binaries/GABuilds/mysql-5.7.22 datadir = /export/umesh/server/binaries/GABuilds/mysql-5.7.22/data/ plugin-load = group_replication.so port = 3306 socket = /tmp/mysql_hod03.sock log_bin disabled_storage_engines = MyISAM,BLACKHOLE,FEDERATED,ARCHIVE ssl skip_name_resolve server_id = 571706 binlog_format = ROW binlog_rows_query_log_events = ON gtid_mode = ON enforce_gtid_consistency = ON log_slave_updates = ON master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON transaction_write_set_extraction = XXHASH64 binlog_checksum = NONE #group_replication = FORCE_PLUS_PERMANENT group_replication_start_on_boot = ON group_replication_group_name = 9d7f8c28-c02c-11e6-9829-08002715584a group_replication_local_address = hod03.no.oracle.com:6606 group_replication_group_seeds = hod03.no.oracle.com:6606,hod04.no.oracle.com:6607,hod06.no.oracle.com:6608 group_replication_single_primary_mode=TRUE group_replication_start_on_boot=FALSE -- Setup 3 node cluster hod03 ================= rm -rf data/ mkdir data bin/mysqld --defaults-file=./91042.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ bin/mysqld --defaults-file=./91042.cnf --log-error=hod03.err --core-file 2>&1 & hod04 ================= rm -rf data/ mkdir data bin/mysqld --defaults-file=./91042.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ bin/mysqld --defaults-file=./91042.cnf --log-error=hod04.err --core-file 2>&1 & hod06 ================= rm -rf data/ mkdir data bin/mysqld --defaults-file=./91042.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ bin/mysqld --defaults-file=./91042.cnf --log-error=hod06.err --core-file 2>&1 & ################# Configure, Start GR - hod03(node 1) CREATE USER 'rpl_user'@'%' IDENTIFIED BY 'rpl_pass'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; SHOW GLOBAL VARIABLES LIKE 'group_replication%'; SET GLOBAL group_replication_bootstrap_group=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery'; START GROUP_REPLICATION; SET GLOBAL group_replication_bootstrap_group=0; SELECT * FROM performance_schema.replication_connection_status\G SELECT * FROM performance_schema.replication_group_member_stats\G SELECT * FROM performance_schema.replication_group_members; - hod04/hod06(node 2 and 3) SHOW GLOBAL VARIABLES LIKE 'group_replication%'; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery'; START GROUP_REPLICATION; SELECT * FROM performance_schema.replication_connection_status\G SELECT * FROM performance_schema.replication_group_member_stats\G SELECT * FROM performance_schema.replication_group_members; -- hod03 mysql> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | a951b11d-6249-11e8-af6c-0010e05f3e06 | hod03 | 3333 | ONLINE | | group_replication_applier | b1048785-6249-11e8-9936-0010e05f4178 | hod04 | 3333 | ONLINE | | group_replication_applier | b89b7d68-6249-11e8-b00d-0010e0734b98 | hod06 | 3333 | ONLINE | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 3 rows in set (0.00 sec) -- hod04 mysql> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | a951b11d-6249-11e8-af6c-0010e05f3e06 | hod03 | 3333 | ONLINE | | group_replication_applier | b1048785-6249-11e8-9936-0010e05f4178 | hod04 | 3333 | ONLINE | | group_replication_applier | b89b7d68-6249-11e8-b00d-0010e0734b98 | hod06 | 3333 | ONLINE | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 3 rows in set (0.00 sec) -- hod06 mysql> SELECT * FROM performance_schema.replication_group_members; +---------------------------+--------------------------------------+-------------+-------------+--------------+ | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE | +---------------------------+--------------------------------------+-------------+-------------+--------------+ | group_replication_applier | a951b11d-6249-11e8-af6c-0010e05f3e06 | hod03 | 3333 | ONLINE | | group_replication_applier | b1048785-6249-11e8-9936-0010e05f4178 | hod04 | 3333 | ONLINE | | group_replication_applier | b89b7d68-6249-11e8-b00d-0010e0734b98 | hod06 | 3333 | ONLINE | +---------------------------+--------------------------------------+-------------+-------------+--------------+ 3 rows in set (0.00 sec) ## On hod03 Terminal (1) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.22: cat k.sh #!/bin/bash while true; do bin/mysql -uroot -S /tmp/mysql_hod03.sock -Bse "select * from performance_schema.replication_connection_status;" sleep 0.5 done [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.22: ./k.sh group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 group_replication_applier 9d7f8c28-c02c-11e6-9829-08002715584a 9d7f8c28-c02c-11e6-9829-08002715584a NULL ON 0 0000-00-00 00:00:00 9d7f8c28-c02c-11e6-9829-08002715584a:1-3,\na951b11d-6249-11e8-af6c-0010e05f3e06:1-2 0 0000-00-00 00:00:00 ^^ hanging Terminal (2) stop group_replication; [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.22: bin/mysql -uroot -S /tmp/mysql_hod03.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 Server version: 5.7.22-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> stop group_replication; ^^^^ hanging ## Terminal 3 mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | 2 | root | localhost | NULL | Query | 0 | starting | show processlist | | 4 | system user | | NULL | Connect | 1430 | executing | NULL | | 7 | system user | | NULL | Connect | 1430 | Reading event from the relay log | NULL | | 20 | root | localhost | NULL | Query | 996 | starting | stop group_replication | | 52 | root | localhost | NULL | Query | 996 | Sending data | select * from performance_schema.replication_connection_status | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ 5 rows in set (0.01 sec) mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | 2 | root | localhost | NULL | Query | 0 | starting | show processlist | | 4 | system user | | NULL | Connect | 1940 | executing | NULL | | 7 | system user | | NULL | Connect | 1940 | Reading event from the relay log | NULL | | 20 | root | localhost | NULL | Query | 1506 | starting | stop group_replication | | 52 | root | localhost | NULL | Query | 1506 | Sending data | select * from performance_schema.replication_connection_status | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ 5 rows in set (0.00 sec) mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | 2 | root | localhost | NULL | Query | 0 | starting | show processlist | | 4 | system user | | NULL | Connect | 2452 | executing | NULL | | 7 | system user | | NULL | Connect | 2452 | Reading event from the relay log | NULL | | 20 | root | localhost | NULL | Query | 2018 | starting | stop group_replication | | 52 | root | localhost | NULL | Query | 2018 | Sending data | select * from performance_schema.replication_connection_status | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ 5 rows in set (0.00 sec) mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | 4 | system user | | NULL | Connect | 2933 | executing | NULL | | 7 | system user | | NULL | Connect | 2933 | Reading event from the relay log | NULL | | 20 | root | localhost | NULL | Query | 2499 | starting | stop group_replication | | 52 | root | localhost | NULL | Query | 2499 | Sending data | select * from performance_schema.replication_connection_status | | 53 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ 5 rows in set (0.00 sec) mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | 4 | system user | | NULL | Connect | 5574 | executing | NULL | | 7 | system user | | NULL | Connect | 5574 | Reading event from the relay log | NULL | | 20 | root | localhost | NULL | Query | 5140 | starting | stop group_replication | | 52 | root | localhost | NULL | Query | 5140 | Sending data | select * from performance_schema.replication_connection_status | | 54 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ 5 rows in set (0.00 sec) mysql> show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ | 4 | system user | | NULL | Connect | 6164 | executing | NULL | | 7 | system user | | NULL | Connect | 6164 | Reading event from the relay log | NULL | | 20 | root | localhost | NULL | Query | 5730 | starting | stop group_replication | | 52 | root | localhost | NULL | Query | 5730 | Sending data | select * from performance_schema.replication_connection_status | | 54 | root | localhost | NULL | Query | 0 | starting | show processlist | +----+-------------+-----------+------+---------+------+----------------------------------+----------------------------------------------------------------+ 5 rows in set (0.00 sec) ## stack traces 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2502),LinuxAIOHandler::poll(os0file.cc:2648),os_aio_linux_handler(os0file.cc:2704),os_aio_handler(os0file.cc:2704),fil_aio_wait(fil0fil.cc:5835),io_handler_thread(srv0start.cc:311),start_thread(libpthread.so.0),clone(libc.so.6) 3 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),srv_worker_thread(srv0srv.cc:2520),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwait(libpthread.so.0),signal_hand(mysqld.cc:2120),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),srv_purge_coordinator_suspend(srv0srv.cc:2676),srv_purge_coordinator_thread(srv0srv.cc:2676),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),buf_resize_thread(buf0buf.cc:3019),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,wait(os0event.cc:165),os_event::wait_low(os0event.cc:165),buf_dump_thread(buf0dump.cc:782),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_wait,native_cond_wait(thr_cond.h:140),my_cond_wait(thr_cond.h:140),inline_mysql_cond_wait(thr_cond.h:140),compress_gtid_table(thr_cond.h:140),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),srv_monitor_thread(srv0srv.cc:1585),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),srv_error_monitor_thread(srv0srv.cc:1751),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),pc_sleep_if_needed(buf0flu.cc:2690),buf_flush_page_cleaner_coordinator(buf0flu.cc:2690),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),lock_wait_timeout_thread(lock0wait.cc:501),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),ib_wqueue_timedwait(ut0wqueue.cc:160),fts_optimize_thread(fts0opt.cc:3031),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,os_event::timed_wait(os0event.cc:285),os_event::wait_time_low(os0event.cc:412),dict_stats_thread(dict0stats_bg.cc:428),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,native_cond_timedwait(thr_cond.h:129),my_cond_timedwait(thr_cond.h:129),inline_mysql_cond_timedwait(thr_cond.h:129),terminate_slave_thread(thr_cond.h:129),terminate_slave_threads(rpl_slave.cc:1661),channel_stop(rpl_channel_service_interface.cc:505),channel_stop(rpl_channel_service_interface.cc:529),Applier_handler::stop_applier_thread(applier_handler.cc:108),Applier_handler::handle_action(applier_handler.cc:174),Applier_module::applier_thread_handle(applier.cc:470),launch_handler_thread(applier.cc:29),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 pthread_cond_timedwait,native_cond_timedwait(thr_cond.h:129),my_cond_timedwait(thr_cond.h:129),inline_mysql_cond_timedwait(thr_cond.h:129),Applier_module::terminate_applier_thread(thr_cond.h:129),terminate_applier_module(plugin.cc:1247),terminate_plugin_modules(plugin.cc:908),plugin_group_replication_stop(plugin.cc:861),group_replication_stop(rpl_group_replication.cc:226),mysql_execute_command(sql_parse.cc:3392),mysql_parse(sql_parse.cc:5582),dispatch_command(sql_parse.cc:1458),do_command(sql_parse.cc:999),handle_connection(connection_handler_per_thread.cc:300),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 poll(libc.so.6),vio_io_wait(viosocket.c:786),vio_socket_io_wait(viosocket.c:77),vio_read(viosocket.c:132),net_read_raw_loop(net_serv.cc:672),net_read_packet_header(net_serv.cc:756),net_read_packet(net_serv.cc:756),my_net_read(net_serv.cc:899),Protocol_classic::read_packet(protocol_classic.cc:808),Protocol_classic::get_command(protocol_classic.cc:965),do_command(sql_parse.cc:938),handle_connection(connection_handler_per_thread.cc:300),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 poll(libc.so.6),Mysqld_socket_listener::listen_for_connection_event(socket_connection.cc:852),connection_event_loop(connection_acceptor.h:66),mysqld_main(connection_acceptor.h:66),__libc_start_main(libc.so.6),_start 1 nanosleep(libpthread.so.0),os_thread_sleep(os0thread.cc:279),srv_master_sleep(srv0srv.cc:2330),srv_master_thread(srv0srv.cc:2330),start_thread(libpthread.so.0),clone(libc.so.6) 1 __lll_lock_wait(libpthread.so.0),_L_lock_975(libpthread.so.0),pthread_mutex_lock(libpthread.so.0),native_mutex_lock(thr_mutex.h:84),my_mutex_lock(thr_mutex.h:84),inline_mysql_mutex_lock(thr_mutex.h:84),next_event(thr_mutex.h:84),exec_relay_log_event(thr_mutex.h:84),handle_slave_sql(rpl_slave.cc:7410),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) 1 __lll_lock_wait(libpthread.so.0),_L_lock_975(libpthread.so.0),pthread_mutex_lock(libpthread.so.0),native_mutex_lock(thr_mutex.h:84),my_mutex_lock(thr_mutex.h:84),inline_mysql_mutex_lock(thr_mutex.h:84),get_group_replication_connection_status_info(thr_mutex.h:84),table_replication_connection_status::make_row(table_replication_connection_status.cc:272),table_replication_connection_status::rnd_next(table_replication_connection_status.cc:205),ha_perfschema::rnd_next(ha_perfschema.cc:350),handler::ha_rnd_next(handler.cc:2947),rr_sequential(records.cc:510),sub_select(sql_executor.cc:1277),do_select(sql_executor.cc:950),JOIN::exec(sql_executor.cc:950),handle_query(sql_select.cc:184),execute_sqlcom_select(sql_parse.cc:5156),mysql_execute_command(sql_parse.cc:2792),mysql_parse(sql_parse.cc:5582),dispatch_command(sql_parse.cc:1458),do_command(sql_parse.cc:999),handle_connection(connection_handler_per_thread.cc:300),pfs_spawn_thread(pfs.cc:2190),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: