PRIMARY-MySQL> stop group_replication; mysql> show full processlist; +-----+----------------------------+--------------------+------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+----------------------------+--------------------+------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 157 | root | localhost | NULL | Query | 285 | starting | stop group_replication | | 167 | root | 192.168.0.2:58090 | test | Query | 285 | query end | insert into test values (null, now()) | | 168 | mysql.session | localhost | NULL | Query | 276 | Waiting for global read lock | PLUGIN: SET GLOBAL read_only= 1 | | 169 | mysql_router1_kg12m0n956rc | 192.168.0.2:58096 | NULL | Query | 230 | statistics | SELECT member_id, member_host, member_port, member_state, @@group_replication_single_primary_mode FROM performance_schema.replication_group_members WHERE channel_name = 'group_replication_applier' | | 170 | root | localhost | NULL | Query | 0 | starting | show full processlist | +-----+----------------------------+--------------------+------+---------+------+------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Thread 39 (Thread 0x7f3278f76700 (LWP 30389)): #0 0x00007f3289dea3da in sigwaitinfo () from /lib64/libc.so.6 #1 0x0000000000f4d06b in timer_notify_thread_func (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/mysys/posix_timers.c:77 #2 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x2e2ad70) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #3 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 38 (Thread 0x7f326dc80700 (LWP 30390)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326dc7fe10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326dc7fe10, m1=0x7f326dc7fec8, m2=0x7f326dc7fec0, request=0x7f326dc7fe90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326dc7fe90, m2=0x7f326dc7fec0, m1=0x7f326dc7fec8, global_segment=0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=0, m1=0x7f326dc7fec8, m2=0x7f326dc7fec0, request=0x7f326dc7fe90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 37 (Thread 0x7f326d47f700 (LWP 30391)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326d47ee10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326d47ee10, m1=0x7f326d47eec8, m2=0x7f326d47eec0, request=0x7f326d47ee90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326d47ee90, m2=0x7f326d47eec0, m1=0x7f326d47eec8, global_segment=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=1, m1=0x7f326d47eec8, m2=0x7f326d47eec0, request=0x7f326d47ee90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 36 (Thread 0x7f326cc7e700 (LWP 30392)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326cc7de10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326cc7de10, m1=0x7f326cc7dec8, m2=0x7f326cc7dec0, request=0x7f326cc7de90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326cc7de90, m2=0x7f326cc7dec0, m1=0x7f326cc7dec8, global_segment=2) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=2, m1=0x7f326cc7dec8, m2=0x7f326cc7dec0, request=0x7f326cc7de90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x7f326c47d700 (LWP 30393)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326c47ce10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326c47ce10, m1=0x7f326c47cec8, m2=0x7f326c47cec0, request=0x7f326c47ce90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326c47ce90, m2=0x7f326c47cec0, m1=0x7f326c47cec8, global_segment=3) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=3, m1=0x7f326c47cec8, m2=0x7f326c47cec0, request=0x7f326c47ce90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x7f326bc7c700 (LWP 30394)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326bc7be10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326bc7be10, m1=0x7f326bc7bec8, m2=0x7f326bc7bec0, request=0x7f326bc7be90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326bc7be90, m2=0x7f326bc7bec0, m1=0x7f326bc7bec8, global_segment=4) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=4, m1=0x7f326bc7bec8, m2=0x7f326bc7bec0, request=0x7f326bc7be90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x7f326b47b700 (LWP 30395)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326b47ae10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326b47ae10, m1=0x7f326b47aec8, m2=0x7f326b47aec0, request=0x7f326b47ae90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326b47ae90, m2=0x7f326b47aec0, m1=0x7f326b47aec8, global_segment=5) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=5, m1=0x7f326b47aec8, m2=0x7f326b47aec0, request=0x7f326b47ae90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x7f326ac7a700 (LWP 30396)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326ac79e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326ac79e10, m1=0x7f326ac79ec8, m2=0x7f326ac79ec0, request=0x7f326ac79e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326ac79e90, m2=0x7f326ac79ec0, m1=0x7f326ac79ec8, global_segment=6) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=6, m1=0x7f326ac79ec8, m2=0x7f326ac79ec0, request=0x7f326ac79e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=6) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7f326a479700 (LWP 30397)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f326a478e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f326a478e10, m1=0x7f326a478ec8, m2=0x7f326a478ec0, request=0x7f326a478e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f326a478e90, m2=0x7f326a478ec0, m1=0x7f326a478ec8, global_segment=7) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=7, m1=0x7f326a478ec8, m2=0x7f326a478ec0, request=0x7f326a478e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=7) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7f3269c78700 (LWP 30398)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f3269c77e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f3269c77e10, m1=0x7f3269c77ec8, m2=0x7f3269c77ec0, request=0x7f3269c77e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f3269c77e90, m2=0x7f3269c77ec0, m1=0x7f3269c77ec8, global_segment=8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=8, m1=0x7f3269c77ec8, m2=0x7f3269c77ec0, request=0x7f3269c77e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7f3269477700 (LWP 30399)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f3269476e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f3269476e10, m1=0x7f3269476ec8, m2=0x7f3269476ec0, request=0x7f3269476e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f3269476e90, m2=0x7f3269476ec0, m1=0x7f3269476ec8, global_segment=9) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=9, m1=0x7f3269476ec8, m2=0x7f3269476ec0, request=0x7f3269476e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=9) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7f3268c76700 (LWP 30400)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f3268c75e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f3268c75e10, m1=0x7f3268c75ec8, m2=0x7f3268c75ec0, request=0x7f3268c75e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f3268c75e90, m2=0x7f3268c75ec0, m1=0x7f3268c75ec8, global_segment=10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=10, m1=0x7f3268c75ec8, m2=0x7f3268c75ec0, request=0x7f3268c75e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7f3268475700 (LWP 30401)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f3268474e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f3268474e10, m1=0x7f3268474ec8, m2=0x7f3268474ec0, request=0x7f3268474e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f3268474e90, m2=0x7f3268474ec0, m1=0x7f3268474ec8, global_segment=11) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=11, m1=0x7f3268474ec8, m2=0x7f3268474ec0, request=0x7f3268474e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=11) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7f3267c74700 (LWP 30402)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f3267c73e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f3267c73e10, m1=0x7f3267c73ec8, m2=0x7f3267c73ec0, request=0x7f3267c73e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f3267c73e90, m2=0x7f3267c73ec0, m1=0x7f3267c73ec8, global_segment=12) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=12, m1=0x7f3267c73ec8, m2=0x7f3267c73ec0, request=0x7f3267c73e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=12) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7f3267473700 (LWP 30403)): #0 0x00007f328b1e5644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x00000000010ae1b4 in LinuxAIOHandler::collect (this=0x7f3267472e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2500 #2 0x00000000010af8d4 in LinuxAIOHandler::poll (this=0x7f3267472e10, m1=0x7f3267472ec8, m2=0x7f3267472ec0, request=0x7f3267472e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2646 #3 0x00000000010b12fc in os_aio_linux_handler (request=0x7f3267472e90, m2=0x7f3267472ec0, m1=0x7f3267472ec8, global_segment=13) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:2702 #4 os_aio_handler (segment=13, m1=0x7f3267472ec8, m2=0x7f3267472ec0, request=0x7f3267472e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0file.cc:6259 #5 0x000000000124618d in fil_aio_wait (segment=13) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fil/fil0fil.cc:5835 #6 0x0000000001153300 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0start.cc:311 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7f3266c72700 (LWP 30404)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b62de in os_event::timed_wait (this=, abstime=0x7f3266c719e0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:285 #2 0x00000000010b65fe in os_event::wait_time_low (this=0x2e62088, time_in_usec=, reset_sig_count=2) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:412 #3 0x00000000011f5873 in pc_sleep_if_needed (sig_count=2, next_loop_time=1501226137329) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/buf/buf0flu.cc:2690 #4 buf_flush_page_cleaner_coordinator (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/buf/buf0flu.cc:3191 #5 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7f326624b700 (LWP 30406)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b62de in os_event::timed_wait (this=, abstime=0x7f326624adf0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:285 #2 0x00000000010b65fe in os_event::wait_time_low (this=0x34533f8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:412 #3 0x000000000108d454 in lock_wait_timeout_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/lock/lock0wait.cc:501 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7f3265a4a700 (LWP 30407)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b62de in os_event::timed_wait (this=, abstime=0x7f3265a49b00) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:285 #2 0x00000000010b65fe in os_event::wait_time_low (this=0x2e61ed8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:412 #3 0x00000000011511c5 in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:1751 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7f3265249700 (LWP 30408)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b62de in os_event::timed_wait (this=, abstime=0x7f3265248e70) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:285 #2 0x00000000010b65fe in os_event::wait_time_low (this=0x2e61f68, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:412 #3 0x0000000001150255 in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:1585 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7f3264a48700 (LWP 30409)): #0 0x00007f328b3f5bdd in nanosleep () from /lib64/libpthread.so.0 #1 0x00000000010b6890 in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0thread.cc:279 #2 0x000000000115087b in srv_master_sleep () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2330 #3 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2377 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7f325ffff700 (LWP 30410)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b612b in wait (this=0x2e61c98) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x2e61c98, reset_sig_count=41) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:335 #3 0x000000000115225d in srv_purge_coordinator_suspend (rseg_history_len=71, slot=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2676 #4 srv_purge_coordinator_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2792 #5 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7f325f7fe700 (LWP 30411)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b612b in wait (this=0x2e61db8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x2e61db8, reset_sig_count=177) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:335 #3 0x000000000114fb4e in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2520 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7f325effd700 (LWP 30412)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b612b in wait (this=0x2e61e48) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x2e61e48, reset_sig_count=120) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:335 #3 0x000000000114fb4e in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2520 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7f325e7fc700 (LWP 30413)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b612b in wait (this=0x2e61d28) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x2e61d28, reset_sig_count=134) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:335 #3 0x000000000114fb4e in srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/srv/srv0srv.cc:2520 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7f325dffb700 (LWP 30414)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b612b in wait (this=0x2e61ff8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x2e61ff8, reset_sig_count=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:335 #3 0x00000000011ef11c in buf_dump_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/buf/buf0dump.cc:782 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7f325d7fa700 (LWP 30415)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b62de in os_event::timed_wait (this=, abstime=0x7f325d7f9e10) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:285 #2 0x00000000010b65fe in os_event::wait_time_low (this=0x3458fe8, time_in_usec=, reset_sig_count=27) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:412 #3 0x0000000001238247 in dict_stats_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/dict/dict0stats_bg.cc:428 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7f325cff9700 (LWP 30416)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b62de in os_event::timed_wait (this=, abstime=0x7f325cff8990) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:285 #2 0x00000000010b65fe in os_event::wait_time_low (this=0x34a5408, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:412 #3 0x00000000011a1f94 in ib_wqueue_timedwait (wq=0x34a52d8, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/ut/ut0wqueue.cc:160 #4 0x0000000001280e5a in fts_optimize_thread (arg=0x34a52d8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/fts/fts0opt.cc:3040 #5 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7f324bfff700 (LWP 30417)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000010b612b in wait (this=0x2e62118) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x2e62118, reset_sig_count=1) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/os/os0event.cc:335 #3 0x00000000011e5e3c in buf_resize_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/innobase/buf/buf0buf.cc:3016 #4 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7f326e258700 (LWP 30418)): #0 0x00007f328b3f6101 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000007c271b in signal_hand (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/mysqld.cc:2101 #2 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x35f8620) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #3 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7f324b7fe700 (LWP 30419)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000eba7a5 in native_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:140 #2 my_cond_wait (mp=, cond=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:195 #3 inline_mysql_cond_wait (src_line=852, src_file=0x15d1bc0 "/export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_gtid_persist.cc", mutex=, that=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:1184 #4 compress_gtid_table (p_thd=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_gtid_persist.cc:852 #5 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x36216d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #6 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7f326e217700 (LWP 30421)): #0 0x00007f328b3f51bd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00007f328b3f0d38 in _L_lock_975 () from /lib64/libpthread.so.0 #2 0x00007f328b3f0ce1 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000e81d92 in native_mutex_lock (mutex=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:84 #4 my_mutex_lock (mp=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:182 #5 inline_mysql_mutex_lock (src_line=306, that=, src_file=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:715 #6 get_group_replication_members_number_info () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_group_replication.cc:306 #7 0x000000000101bd09 in table_replication_group_members::get_row_count () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/table_replication_group_members.cc:163 #8 0x0000000000fbafaf in ha_perfschema::info (this=0x7f322c07b240, flag=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/ha_perfschema.cc:393 #9 0x0000000000cfedab in JOIN::init_planner_arrays (this=0x7f32381b5bc8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5183 #10 0x0000000000d05a2c in JOIN::make_join_plan (this=0x7f32381b5bc8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5005 #11 0x0000000000d0c4c6 in JOIN::optimize (this=0x7f32381b5bc8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:368 #12 0x0000000000d51a82 in st_select_lex::optimize (this=0x7f3238278f70, thd=0x7f323826dff0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:1009 #13 0x0000000000d51d1f in handle_query (thd=0x7f323826dff0, lex=0x7f3238270138, result=0x7f323827ad68, added_options=1, removed_options=0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:164 #14 0x0000000000d12b53 in execute_sqlcom_select (thd=0x7f323826dff0, all_tables=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5158 #15 0x0000000000d163ce in mysql_execute_command (thd=0x7f323826dff0, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:2795 #16 0x0000000000d18245 in mysql_parse (thd=0x7f323826dff0, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #17 0x0000000000d1945f in dispatch_command (thd=0x7f323826dff0, com_data=0x7f326e216de0, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #18 0x0000000000d1a324 in do_command (thd=0x7f323826dff0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:999 #19 0x0000000000dea0fc in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:300 #20 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x36216d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #21 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7f326e1d6700 (LWP 30480)): #0 0x00007f328b3f1e24 in pthread_rwlock_rdlock () from /lib64/libpthread.so.0 #1 0x00007f32483b0b55 in native_rw_rdlock (rwp=0x7f323837ceb8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_rwlock.h:79 #2 inline_mysql_rwlock_rdlock (src_line=471, src_file=0x7f3248412de8 "/export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_gtid.h", that=0x7f323837ceb8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:895 #3 rdlock (this=0x7f323837ceb0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_gtid.h:471 #4 grab_read_lock (this=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/include/plugin_utils.h:541 #5 group_replication_trans_before_commit (param=0x7f326e1d33d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/observer_trans.cc:296 #6 0x0000000000c807ec in Trans_delegate::before_commit (this=0x1e48f00 , thd=, all=, trx_cache_log=, stmt_cache_log=, cache_log_max_size=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_handler.cc:325 #7 0x0000000000eed5ec in MYSQL_BIN_LOG::commit (this=0x1e6b840 , thd=0x7f3230abc230, all=false) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/binlog.cc:8457 #8 0x000000000081e5ea in ha_commit_trans (thd=0x7f3230abc230, all=false, ignore_global_read_lock=false) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/handler.cc:1795 #9 0x0000000000dcdcd2 in trans_commit_stmt (thd=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/transaction.cc:458 #10 0x0000000000d13527 in mysql_execute_command (thd=0x7f3230abc230, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5006 #11 0x0000000000d18245 in mysql_parse (thd=0x7f3230abc230, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #12 0x0000000000d1945f in dispatch_command (thd=0x7f3230abc230, com_data=0x7f326e1d5de0, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #13 0x0000000000d1a324 in do_command (thd=0x7f3230abc230) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:999 #14 0x0000000000dea0fc in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:300 #15 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x36216d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #16 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f325c11a700 (LWP 30512)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f32483c8c52 in native_cond_wait (mutex=0x7f3220020cd0, cond=0x7f3220020d00) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:140 #2 my_cond_wait (mp=0x7f3220020cd0, cond=0x7f3220020d00) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:195 #3 inline_mysql_cond_wait (src_line=560, src_file=0x7f324841b660 "/export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_command.cc", mutex=0x7f3220020cd0, that=0x7f3220020d00) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:1184 #4 Session_plugin_thread::wait_for_method_execution (this=0x7f3220020c40) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_command.cc:560 #5 0x00007f32483bb34c in Read_mode_handler::reset_super_read_only_mode (this=0x7f3238554950, command_interface=0x7f3220007680, force_reset=false) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/read_mode_handler.cc:129 #6 0x00007f32483b4b58 in terminate_plugin_modules (read_mode_set=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/plugin.cc:755 #7 0x00007f32483b6de7 in plugin_group_replication_stop () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/plugin.cc:712 #8 0x0000000000e820ff in group_replication_stop () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_group_replication.cc:226 #9 0x0000000000d15420 in mysql_execute_command (thd=0x7f3220009e90, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:3395 #10 0x0000000000d18245 in mysql_parse (thd=0x7f3220009e90, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #11 0x0000000000d1945f in dispatch_command (thd=0x7f3220009e90, com_data=0x7f325c119de0, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #12 0x0000000000d1a324 in do_command (thd=0x7f3220009e90) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:999 #13 0x0000000000dea0fc in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:300 #14 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x36216d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #15 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #16 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f325c0d9700 (LWP 30515)): #0 0x00007f328b3f26d5 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000de9da8 in native_cond_wait (mutex=0x1e6b160 , cond=0x1e6b1a0 ) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:140 #2 my_cond_wait (mp=0x1e6b160 , cond=0x1e6b1a0 ) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:195 #3 inline_mysql_cond_wait (src_line=145, that=0x1e6b1a0 , mutex=, src_file=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:1184 #4 Per_thread_connection_handler::block_until_new_connection () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:145 #5 0x0000000000de9fa8 in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:329 #6 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x36216d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #7 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f3264247700 (LWP 30516)): #0 0x00007f328b3f51bd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00007f328b3f0d38 in _L_lock_975 () from /lib64/libpthread.so.0 #2 0x00007f328b3f0ce1 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000e81d92 in native_mutex_lock (mutex=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:84 #4 my_mutex_lock (mp=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:182 #5 inline_mysql_mutex_lock (src_line=306, that=, src_file=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:715 #6 get_group_replication_members_number_info () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_group_replication.cc:306 #7 0x000000000101bd09 in table_replication_group_members::get_row_count () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/table_replication_group_members.cc:163 #8 0x0000000000fbafaf in ha_perfschema::info (this=0x7f32382beaf0, flag=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/ha_perfschema.cc:393 #9 0x0000000000cfedab in JOIN::init_planner_arrays (this=0x7f322c05e7b8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5183 #10 0x0000000000d05a2c in JOIN::make_join_plan (this=0x7f322c05e7b8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5005 #11 0x0000000000d0c4c6 in JOIN::optimize (this=0x7f322c05e7b8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:368 #12 0x0000000000d51a82 in st_select_lex::optimize (this=0x7f322c0605c0, thd=0x7f322c07be80) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:1009 #13 0x0000000000d51d1f in handle_query (thd=0x7f322c07be80, lex=0x7f322c07dfc8, result=0x7f322c0623b8, added_options=1, removed_options=0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:164 #14 0x0000000000d12b53 in execute_sqlcom_select (thd=0x7f322c07be80, all_tables=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5158 #15 0x0000000000d163ce in mysql_execute_command (thd=0x7f322c07be80, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:2795 #16 0x0000000000d18245 in mysql_parse (thd=0x7f322c07be80, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #17 0x0000000000d1945f in dispatch_command (thd=0x7f322c07be80, com_data=0x7f3264246de0, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #18 0x0000000000d1a324 in do_command (thd=0x7f322c07be80) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:999 #19 0x0000000000dea0fc in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:300 #20 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x36216d0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #21 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f325c1dd700 (LWP 30783)): #0 0x00007f328b3f2a82 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000c66dd0 in native_cond_timedwait (abstime=0x7f325c1dafe0, mutex=0x7f32240076f8, cond=0x7f3224007728) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:129 #2 my_cond_timedwait (abstime=0x7f325c1dafe0, mp=0x7f32240076f8, cond=0x7f3224007728) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_cond.h:182 #3 inline_mysql_cond_timedwait (src_line=1861, src_file=0x13ffdf0 "/export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/mdl.cc", abstime=0x7f325c1dafe0, mutex=0x7f32240076f8, that=0x7f3224007728) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:1229 #4 MDL_wait::timed_wait (this=0x7f32240076f8, owner=0x7f3224007660, abs_timeout=0x7f325c1dafe0, set_status_on_timeout=true, wait_state_name=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/mdl.cc:1861 #5 0x0000000000c6936f in MDL_context::acquire_lock (this=0x7f32240076f8, mdl_request=0x7f325c1db050, lock_wait_timeout=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/mdl.cc:3667 #6 0x0000000000e4375e in Global_read_lock::lock_global_read_lock (this=0x7f32240090d8, thd=0x7f3224007660) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/lock.cc:1115 #7 0x0000000000da37ca in fix_read_only (self=, thd=, type=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sys_vars.cc:3014 #8 0x0000000000c8aed2 in sys_var::update (this=0x1e5e1e0 , thd=0x7f3224007660, var=0x7f3224011498) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/set_var.cc:184 #9 0x0000000000c8bad7 in set_var::update (this=, thd=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/set_var.cc:802 #10 0x0000000000c8b1e1 in sql_set_variables (thd=0x7f3224007660, var_list=0x7f3224009b80) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/set_var.cc:662 #11 0x0000000000d13f97 in mysql_execute_command (thd=0x7f3224007660, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:3680 #12 0x0000000000d18245 in mysql_parse (thd=0x7f3224007660, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #13 0x0000000000d1945f in dispatch_command (thd=0x7f3224007660, com_data=0x7f325c1dcc70, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #14 0x00000000007d129f in Srv_session::execute_command (this=0x7f3224007660, command=COM_QUERY, data=0x7f325c1dcc70, client_cs=, callbacks=, text_or_binary=, callbacks_context=0x7f3224010290) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/srv_session.cc:1278 #15 0x00007f32483c6322 in Sql_service_interface::execute_internal (this=0x7f322400e100, rset=0x7f325c1dcc90, cs_txt_bin=CS_TEXT_REPRESENTATION, cs_charset=0x1e351e0 , cmd=..., cmd_type=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_interface.cc:159 #16 0x00007f32483c65c9 in Sql_service_interface::execute_query (this=, sql_string=...) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_interface.cc:191 #17 0x00007f32483ca2f7 in Sql_service_commands::internal_set_read_only (this=, sql_interface=0x7f322400e100) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_command.cc:178 #18 0x00007f32483c8802 in Session_plugin_thread::session_thread_handler (this=0x7f3220020c40) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_command.cc:684 #19 0x00007f32483c8b79 in launch_handler_thread (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/rapid/plugin/group_replication/src/sql_service/sql_service_command.cc:569 #20 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x7f3220020e40) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #21 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f325c15b700 (LWP 30872)): #0 0x00007f328b3f51bd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00007f328b3f0d38 in _L_lock_975 () from /lib64/libpthread.so.0 #2 0x00007f328b3f0ce1 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000e81d92 in native_mutex_lock (mutex=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:84 #4 my_mutex_lock (mp=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:182 #5 inline_mysql_mutex_lock (src_line=306, that=, src_file=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:715 #6 get_group_replication_members_number_info () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_group_replication.cc:306 #7 0x000000000101bd09 in table_replication_group_members::get_row_count () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/table_replication_group_members.cc:163 #8 0x0000000000fbafaf in ha_perfschema::info (this=0x7f322c5411b0, flag=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/ha_perfschema.cc:393 #9 0x0000000000cfedab in JOIN::init_planner_arrays (this=0x7f322802a6a8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5183 #10 0x0000000000d05a2c in JOIN::make_join_plan (this=0x7f322802a6a8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5005 #11 0x0000000000d0c4c6 in JOIN::optimize (this=0x7f322802a6a8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:368 #12 0x0000000000d51a82 in st_select_lex::optimize (this=0x7f32280199b0, thd=0x7f3228010750) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:1009 #13 0x0000000000d51d1f in handle_query (thd=0x7f3228010750, lex=0x7f3228012898, result=0x7f322801b7a8, added_options=1, removed_options=0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:164 #14 0x0000000000d12b53 in execute_sqlcom_select (thd=0x7f3228010750, all_tables=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5158 #15 0x0000000000d163ce in mysql_execute_command (thd=0x7f3228010750, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:2795 #16 0x0000000000d18245 in mysql_parse (thd=0x7f3228010750, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #17 0x0000000000d1945f in dispatch_command (thd=0x7f3228010750, com_data=0x7f325c15ade0, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #18 0x0000000000d1a324 in do_command (thd=0x7f3228010750) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:999 #19 0x0000000000dea0fc in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:300 #20 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x359e240) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #21 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f325c19c700 (LWP 30904)): #0 0x00007f328b3f51bd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00007f328b3f0d38 in _L_lock_975 () from /lib64/libpthread.so.0 #2 0x00007f328b3f0ce1 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000e81d92 in native_mutex_lock (mutex=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:84 #4 my_mutex_lock (mp=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/thr_mutex.h:182 #5 inline_mysql_mutex_lock (src_line=306, that=, src_file=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/include/mysql/psi/mysql_thread.h:715 #6 get_group_replication_members_number_info () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/rpl_group_replication.cc:306 #7 0x000000000101bd09 in table_replication_group_members::get_row_count () at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/table_replication_group_members.cc:163 #8 0x0000000000fbafaf in ha_perfschema::info (this=0x7f32384d2220, flag=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/ha_perfschema.cc:393 #9 0x0000000000cfedab in JOIN::init_planner_arrays (this=0x7f3234011898) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5183 #10 0x0000000000d05a2c in JOIN::make_join_plan (this=0x7f3234011898) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:5005 #11 0x0000000000d0c4c6 in JOIN::optimize (this=0x7f3234011898) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_optimizer.cc:368 #12 0x0000000000d51a82 in st_select_lex::optimize (this=0x7f3234008c00, thd=0x7f3234000ba0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:1009 #13 0x0000000000d51d1f in handle_query (thd=0x7f3234000ba0, lex=0x7f3234002ce8, result=0x7f323400a9f8, added_options=1, removed_options=0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_select.cc:164 #14 0x0000000000d12b53 in execute_sqlcom_select (thd=0x7f3234000ba0, all_tables=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5158 #15 0x0000000000d163ce in mysql_execute_command (thd=0x7f3234000ba0, first_level=true) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:2795 #16 0x0000000000d18245 in mysql_parse (thd=0x7f3234000ba0, parser_state=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:5574 #17 0x0000000000d1945f in dispatch_command (thd=0x7f3234000ba0, com_data=0x7f325c19bde0, command=COM_QUERY) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:1461 #18 0x0000000000d1a324 in do_command (thd=0x7f3234000ba0) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/sql_parse.cc:999 #19 0x0000000000dea0fc in handle_connection (arg=) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_handler_per_thread.cc:300 #20 0x0000000000fbdbf4 in pfs_spawn_thread (arg=0x359e240) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/storage/perfschema/pfs.cc:2188 #21 0x00007f328b3eedc5 in start_thread () from /lib64/libpthread.so.0 #22 0x00007f3289eab76d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f328b812740 (LWP 30382)): #0 0x00007f3289ea0e2d in poll () from /lib64/libc.so.6 #1 0x0000000000deb449 in Mysqld_socket_listener::listen_for_connection_event (this=0x2e2f620) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/socket_connection.cc:852 #2 0x00000000007c7bd2 in connection_event_loop (this=0x3460750) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/conn_handler/connection_acceptor.h:66 #3 mysqld_main (argc=175, argv=0x2c7bfd8) at /export/home/pb2/build/sb_0-23948522-1498142411.21/mysql-5.7.19/sql/mysqld.cc:5045 #4 0x00007f3289dd5b35 in __libc_start_main () from /lib64/libc.so.6 #5 0x00000000007bd739 in _start ()