Not the answer you need?
Register and ask your own question!

how to restart node about docker version

finleymafinleyma EntrantInactive User Role Beginner
I used the below commands to create 3 nodes cluster
```
docker pull percona/percona-xtradb-cluster:5.7
docker tag percona/percona-xtradb-cluster:5.7 pxc
docker network create --subnet=172.18.0.0./24 net1
docker run -d -p 33010:3306 -e MYSQL_ROOT_PASSWORD=root -e CLUSTER_NAME=pxc_cluster --name=pxc_node1 --net=pxc-network pxc
docker run -d -p 33011:3306 -e MYSQL_ROOT_PASSWORD=root -e CLUSTER_NAME=pxc_cluster -e CLUSTER_JOIN=pxc_node1 --name=pxc_node2 --net=pxc-network pxc
docker run -d -p 33012:3306 -e MYSQL_ROOT_PASSWORD=root -e CLUSTER_NAME=pxc_cluster -e CLUSTER_JOIN=pxc_node1 --name=pxc_node3 --net=pxc-network pxc
```
it success running.
but, when I stop one node container, `docker stop pxc_node1`
after I `docker start pex_node1`
it can't start again success.
the logs below:

2018-08-26T03:37:50.980926Z 0 [Warning] WSREP: last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT3.50266S), skipping check
2018-08-26T03:38:20.494172Z 0 [Note] WSREP: Current view of cluster as seen by this node
view ((empty))
2018-08-26T03:38:20.495190Z 0 [ERROR] WSREP: failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout): 110 (Connection timed out)
at gcomm/src/pc.cpp:connect():159
2018-08-26T03:38:20.495304Z 0 [ERROR] WSREP: gcs/src/gcs_core.cpp:gcs_core_open():208: Failed to open backend connection: -110 (Connection timed out)
2018-08-26T03:38:20.495463Z 0 [ERROR] WSREP: gcs/src/gcs.cpp:gcs_open():1514: Failed to open channel 'cluster1' at 'gcomm://pxc_node1': -110 (Connection timed out)
2018-08-26T03:38:20.495561Z 0 [ERROR] WSREP: gcs connect failed: Connection timed out
2018-08-26T03:38:20.495621Z 0 [ERROR] WSREP: Provider/Node (gcomm://pxc_node1) failed to establish connection with cluster (reason: 7)
2018-08-26T03:38:20.495701Z 0 [ERROR] Aborting

2018-08-26T03:38:20.495795Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-08-26T03:38:20.495871Z 0 [Note] WSREP: Waiting for active wsrep applier to exit
2018-08-26T03:38:20.495972Z 0 [Note] WSREP: Service disconnected.
2018-08-26T03:38:20.496274Z 0 [Note] WSREP: Waiting to close threads......
2018-08-26T03:38:25.496469Z 0 [Note] WSREP: Some threads may fail to exit.
2018-08-26T03:38:25.496619Z 0 [Note] Binlog end


can anybody help me ? thanks in advance!

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    First of all, the commands above do not look like exact copy/paste of real session, as there are typos and mismatches. For instance:
    docker network create --subnet=172.18.0.0./24 net1
    
    has an extra dot, making the address wrong.
    And docker run commands use another network name then created before:
    --net=pxc-network
    

    Anyway, as the bootstrapped node has this line without addresses:
    wsrep_cluster_address=gcomm://
    
    you can't just restart it as if it was normal service on a non-docker instance.

    So, as you stop the first node but two other keep running, instead of restarting it (docker start does not accept needed variables), you may actually remove and re-run the first one like this:
    # docker rm pxc_node1
    pxc_node1
    
    # docker run -d -p 33010:3306 -e MYSQL_ROOT_PASSWORD=root -e CLUSTER_NAME=pxc_cluster -e CLUSTER_JOIN=pxc_node2 --name=pxc_node1 --net=net1 pxc
    eae9c08c96634c576d9b37343555bc0a9430480801dfb1a2c320d5141944a97e
    
    # docker exec -it pxc_node1 mysql -uroot -proot -e "show status like 'wsrep_cluster_size'"
    mysql: [Warning] Using a password on the command line interface can be insecure.
    +--------------------+-------+
    | Variable_name      | Value |
    +--------------------+-------+
    | wsrep_cluster_size | 3     |
    +--------------------+-------+
    

    Hope that helps.
  • finleymafinleyma Entrant Inactive User Role Beginner
    thanks przemek, it works! i typed the wrong network name. thank you very much.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.