2016-07-18T20:42:09.840303Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-07-18T20:42:09.843624Z 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=73b1fe371681-bin' to avoid this problem. 2016-07-18T20:42:10.339958Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-07-18T20:42:10.476791Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-07-18T20:42:10.975978Z 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: 19e3a8a1-4d28-11e6-a21a-0242ac110002. 2016-07-18T20:42:11.019642Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-07-18T20:42:11.030244Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2016-07-18T21:10:45.023203Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-07-18T21:10:45.024074Z 0 [Note] mysqld (mysqld 5.7.10-log) starting as process 1 ... 2016-07-18T21:10:45.027764Z 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=7e7c648f08e8-bin' to avoid this problem. 2016-07-18T21:10:45.037479Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-07-18T21:10:45.037503Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-07-18T21:10:45.037507Z 0 [Note] InnoDB: Uses event mutexes 2016-07-18T21:10:45.037512Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-07-18T21:10:45.037516Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-07-18T21:10:45.037519Z 0 [Note] InnoDB: Using Linux native AIO 2016-07-18T21:10:45.037936Z 0 [Note] InnoDB: Number of pools: 1 2016-07-18T21:10:45.038344Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-07-18T21:10:45.043819Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-07-18T21:10:45.050895Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-07-18T21:10:45.052552Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-07-18T21:10:45.064051Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-07-18T21:10:45.157652Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-07-18T21:10:45.157731Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-07-18T21:10:45.195990Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-07-18T21:10:45.196815Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-07-18T21:10:45.196828Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-07-18T21:10:45.197236Z 0 [Note] InnoDB: Waiting for purge to start 2016-07-18T21:10:45.247455Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 2492693 2016-07-18T21:10:45.247782Z 0 [Note] InnoDB: not started 2016-07-18T21:10:45.247782Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2016-07-18T21:10:45.247979Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-07-18T21:10:45.249501Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160718 21:10:45 2016-07-18T21:10:45.636603Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-07-18T21:10:45.637020Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-07-18T21:10:45.637195Z 0 [Note] IPv6 is available. 2016-07-18T21:10:45.637202Z 0 [Note] - '::' resolves to '::'; 2016-07-18T21:10:45.637219Z 0 [Note] Server socket created on IP: '::'. 2016-07-18T21:10:45.650684Z 0 [Note] Event Scheduler: Loaded 0 events 2016-07-18T21:10:45.650891Z 0 [Note] mysqld: ready for connections. Version: '5.7.10-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2016-07-18T21:12:24.871082Z 2 [Warning] IP address '172.17.0.3' could not be resolved: Name or service not known [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configuring Xcom group: XCom Group ID=3727611955 Name=5d9dbb52-4d2a-11e6-aa82-0242ac110002 [XCOM_BINDING_DEBUG] ::initialize_peer_nodes():: Configured Peer Nodes: 172.17.0.2:13306 [XCOM_BINDING_DEBUG] ::initialize_peer_nodes():: Configured Peer Nodes: 172.17.0.4:13306 [XCOM_BINDING_DEBUG] ::initialize_peer_nodes():: Configured Peer Nodes: 172.17.0.5:13306 [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configured Total number of peers: 3 [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configured Local Node: 172.17.0.4:13306 [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configured Bootstrap: false 2016-07-18T21:13:41.792853Z 5 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=7e7c648f08e8-relay-bin' to avoid this problem. 2016-07-18T21:13:42.186065Z 5 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2016-07-18T21:13:42.945423Z 7 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './7e7c648f08e8-relay-bin-group_replication_applier.000001' position: 4 2016-07-18T21:13:42.945422Z 4 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2016-07-18T21:13:42.945762Z 4 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7' 2016-07-18T21:13:42.945774Z 4 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 10' [XCOM BINDING DEBUG] ::join() connecting to 172.17.0.4 13306 state 0 action xa_init connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 [XCOM BINDING DEBUG] ::join():: I am NOT the boot node. [XCOM BINDING DEBUG] ::join():: xcom_client_open_connection to 172.17.0.2:13306 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Skipping own address. [XCOM BINDING DEBUG] ::join():: xcom_client_open_connection to 172.17.0.5:13306 connecting to 172.17.0.5 13306 [XCOM BINDING DEBUG] ::join():: Error connecting to all peer nodes. Not adding this node [XCOM BINDING DEBUG] ::join():: GCS_NOK 2016-07-18T21:13:53.953890Z 4 [ERROR] Plugin group_replication reported: 'Error on group communication engine initialization' 2016-07-18T21:13:53.953905Z 4 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member' [XCOM BINDING DEBUG] ::leave() [XCOM BINDING DEBUG] :: leave():: Error. Leaving a group without being on one. 2016-07-18T21:13:53.953917Z 4 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1' 2016-07-18T21:13:53.953921Z 4 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1' 2016-07-18T21:13:53.954210Z 7 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed 2016-07-18T21:13:54.233133Z 5 [Note] Plugin group_replication reported: 'The group replication applier thread was killed' [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configuring Xcom group: XCom Group ID=3727611955 Name=5d9dbb52-4d2a-11e6-aa82-0242ac110002 [XCOM_BINDING_DEBUG] ::initialize_peer_nodes():: Configured Peer Nodes: 172.17.0.2:13306 [XCOM_BINDING_DEBUG] ::initialize_peer_nodes():: Configured Peer Nodes: 172.17.0.4:13306 [XCOM_BINDING_DEBUG] ::initialize_peer_nodes():: Configured Peer Nodes: 172.17.0.5:13306 [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configured Total number of peers: 3 [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configured Local Node: 172.17.0.4:13306 [XCOM_BINDING_DEBUG] ::initialize_xcom():: Configured Bootstrap: false 2016-07-18T21:14:56.492762Z 10 [Note] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2016-07-18T21:14:57.254955Z 4 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!' 2016-07-18T21:14:57.254961Z 12 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './7e7c648f08e8-relay-bin-group_replication_applier.000001' position: 4 2016-07-18T21:14:57.255141Z 4 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7' 2016-07-18T21:14:57.255152Z 4 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 10' [XCOM BINDING DEBUG] ::join() Unable to announce tcp port 13306. Port already in use?mysqld: /export/home2/pb2/build/sb_0-17587881-1452683313.64/build/BUILD/mysql-server/plugin/group_replication/gcs/src/bindings/xcom/xcom/task.c:735: add_fd: Assertion `fd >= 0' failed. connecting to 172.17.0.4 13306 state 3525 action xa_init state 3525 action xa_terminate new state x_start connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 21:14:57 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=2 max_threads=151 thread_count=4 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68185 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 connecting to 172.17.0.4 13306 connected to 172.17.0.4 13306 [XCOM BINDING DEBUG] ::join():: I am NOT the boot node. [XCOM BINDING DEBUG] ::join():: xcom_client_open_connection to 172.17.0.2:13306 connecting to 172.17.0.2 13306 [XCOM BINDING DEBUG] ::join():: Error on xcom_client_open_connection to 172.17.0.2:13306. Error= -1 mysqld(my_print_stacktrace+0x3b)[0xeb6b5b] mysqld(handle_fatal_signal+0x461)[0x788f91] /lib64/libpthread.so.0(+0xf100)[0x7efdbe304100] /lib64/libc.so.6(gsignal+0x37)[0x7efdbccf75f7] /lib64/libc.so.6(abort+0x148)[0x7efdbccf8ce8] /lib64/libc.so.6(+0x2e566)[0x7efdbccf0566] /lib64/libc.so.6(+0x2e612)[0x7efdbccf0612] /usr/lib64/mysql/plugin/group_replication.so(accept_tcp+0x302)[0x7efd66d1a752] /usr/lib64/mysql/plugin/group_replication.so(tcp_server+0x76)[0x7efd66d282c6] /usr/lib64/mysql/plugin/group_replication.so(task_loop+0x56)[0x7efd66d19a16] /usr/lib64/mysql/plugin/group_replication.so(xcom_taskmain2+0x67)[0x7efd66d20da7] /usr/lib64/mysql/plugin/group_replication.so(_ZN19Gcs_xcom_proxy_impl9xcom_initEi+0x20)[0x7efd66d12310] /usr/lib64/mysql/plugin/group_replication.so(+0x7af24)[0x7efd66d2af24] /lib64/libpthread.so.0(+0x7dc5)[0x7efdbe2fcdc5] /lib64/libc.so.6(clone+0x6d)[0x7efdbcdb8ced] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash.