## Unless this is documented, this looks like regression to me as with same conf, same start up - 5.7.20 hangs where as no issues for 5.7.19 -- 5.7.20 binary tarball build [mysqld] basedir = /export/umesh/server/binaries/GABuilds/mysql-5.7.20 datadir = /export/umesh/server/binaries/GABuilds/mysql-5.7.20/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 -- build cat docs/INFO_SRC commit: 0441472e19e9a2e41df5d61098eb97c3e211547c date: 2017-09-13 17:44:44 +0200 build-date: 2017-09-13 17:48:35 +0200 short: 0441472 branch: mysql-5.7.20-release MySQL source 5.7.20 -- rm -rf data mkdir data bin/mysqld --defaults-file=./my.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ ### [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.20: bin/mysqld --defaults-file=./my.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ 2017-10-20T09:12:31.296660Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-10-20T09:12:31.299380Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=hod03-bin' to avoid this problem. 2017-10-20T09:12:31.575835Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-10-20T09:12:31.703117Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-10-20T09:12:31.761642Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: cd8fe0b1-b576-11e7-bdc0-0010e05f3e06. 2017-10-20T09:12:31.762194Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-10-20T09:12:31.762928Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2017-10-20T09:12:32.085933Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.085988Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.086005Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.086033Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.086069Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.086094Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.086139Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:12:32.086161Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. ^^ hangs [umshastr@hod03]~/bugs: ./pt-pmp --pid=7253 Fri Oct 20 11:17:20 CEST 2017 10 __io_getevents_0_4(libaio.so.1),LinuxAIOHandler::collect(os0file.cc:2500),LinuxAIOHandler::poll(os0file.cc:2646),os_aio_linux_handler(os0file.cc:2702),os_aio_handler(os0file.cc:2702),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 sigwaitinfo(libc.so.6),timer_notify_thread_func(posix_timers.c:77),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:3016),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),Delayed_initialization_thread::wait_for_thread_end(thr_cond.h:140),plugin_group_replication_stop(plugin.cc:802),Group_replication_handler::~Group_replication_handler(rpl_group_replication.cc:38),group_replication_cleanup(rpl_group_replication.cc:172),plugin_group_replication_deinit(plugin.cc:1027),plugin_deinitialize(sql_plugin.cc:1008),reap_plugins(sql_plugin.cc:1081),plugin_shutdown(sql_plugin.cc:1849),clean_up(mysqld.cc:1304),unireg_abort(mysqld.cc:1141),mysqld_main(mysqld.cc:4946),__libc_start_main(libc.so.6),_start 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 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),Mutex_autolock(thr_mutex.h:84),Delayed_initialization_thread::initialization_thread_handler(thr_mutex.h:84),launch_handler_thread(delayed_plugin_initialization.cc:27),start_thread(libpthread.so.0),clone(libc.so.6) [umshastr@hod03]~/bugs: -- 5.7.19 - didn't notice issue with exact conf file, exact initialization [mysqld] basedir = /export/umesh/server/binaries/GABuilds/mysql-5.7.19 datadir = /export/umesh/server/binaries/GABuilds/mysql-5.7.19/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 -- Build cat docs/INFO_SRC commit: 432d360adedd7d8976fd6254eb3f5bee0b1ac3d6 date: 2017-06-22 16:12:22 +0200 build-date: 2017-06-22 16:13:32 +0200 short: 432d360 branch: mysql-5.7.19-release MySQL source 5.7.19 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysqld --defaults-file=./my.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/data/ 2017-10-20T09:21:12.570017Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-10-20T09:21:12.572863Z 0 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=hod03-bin' to avoid this problem. 2017-10-20T09:21:12.869910Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-10-20T09:21:12.902963Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-10-20T09:21:13.050062Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 04462d83-b578-11e7-b5b9-0010e05f3e06. 2017-10-20T09:21:13.050907Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-10-20T09:21:13.051760Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2017-10-20T09:21:13.338340Z 1 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338387Z 1 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338412Z 1 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338440Z 1 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338452Z 1 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338467Z 1 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338525Z 1 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. 2017-10-20T09:21:13.338548Z 1 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: