Job "Create Galera Cluster" continuously running

Follow

Metairie, Stephane

• December 06, 2018 15:12
• Edited

I have created a Cluster Control instance , with 3 nodes, 2 proxy sql.
It's an Openshift/kubernetes setup.

Once nodes are deployed (cluster deploy), this job is starting.
Of course that fails immediately, as nodes are not installed yet.

 [16:07:08]: 10.129.21.196: Will retry in 10 secs (3/6).
 [16:07:08]: 10.129.21.196: No route to host.
 [16:06:55]: 10.129.21.196: Will retry in 10 secs (2/6).

More, once cluster is totally finished and working well, that continuously runing, searching hosts that does not exists.

 

My questions.

how to stop this job. where is it defined? what is the purpose of this job?

 

Ty

0

• Official comment

  

  Ashraf Sharif

  • December 07, 2018 07:04

  Hi Stephane,

  The job is specifically for ClusterControl automatic deployment in Docker environment. You can simply delete the entry inside cmon.containers table and restart cc-auto-deploy using supervisorctl. For example:

  $ docker exec -it clustercontrol mysql -uroot -p -e 'DELETE FROM cmon.containers WHERE ip = "10.129.21.196"'
  $ docker exec -it clustercontrol docker exec -it clustercontrol supervisorctl restart cc-auto-deployment

   

  Regards,
  Ashraf

  Comment actions Permalink
• 

  Metairie, Stephane

  • December 07, 2018 09:10

  That sounds good. Could I shutdown this service :

   cc-auto-deployment

  I think I have to shutdown in any case when I'm building the cluster (Deploy Nodes in Cluster Control GUI)

  Thanks a lot

  0

  Comment actions Permalink
• 

  Metairie, Stephane

  • December 07, 2018 09:19

  Now I have another issue :

  I have 3 nodes 10.129.15.148, 202,204. 

  The error below is one proxysql. I don't understant this message?

   

   

   [10:15:54]: Host 10.129.15.142 is already in another cluster. See http://support.severalnines.com/entries/82995999-Host-already-in-another-Cluster for suggestions.

   

   [10:15:54]: 10.129.15.142: Checking if host already exists in another cluster.

   

   [10:15:54]: All 3 hosts are accessible by SSH.

   

   [10:15:54]: 10.129.21.202: Access with ssh/sudo granted.

   

   [10:15:53]: 10.129.21.198: Access with ssh/sudo granted.

  0

  Comment actions Permalink
• 

  Metairie, Stephane

  • December 07, 2018 09:26
  • Edited

  mysql> select hostname from hosts;

  +-----------------------------------------+
  | hostname |
  +-----------------------------------------+
  | deploymentconfig-0-galera-4-5899z |
  | deploymentconfig-0-proxysql-1-tc7kj |
  | deploymentconfig-1-galera-1-n42rb |
  | deploymentconfig-1-proxysql-1-m8nqr |
  | deploymentconfig-2-galera-1-kfh6v |
  | deploymentconfig-clustercontrol-1-bffzh |
  | localhost |
  +-----------------------------------------+
  7 rows in set (0.00 sec)

  0

  Comment actions Permalink
• 

  Metairie, Stephane

  • December 07, 2018 09:25

  mysql> select hostname from mysql_server;
  +-----------------------------------+
  | hostname |
  +-----------------------------------+
  | deploymentconfig-1-galera-1-n42rb |
  | deploymentconfig-2-galera-1-kfh6v |
  +-----------------------------------+
  2 rows in set (0.00 sec)

  0

  Comment actions Permalink
• 

  Metairie, Stephane

  • December 07, 2018 09:27

  mysql> select hostname from server_node;

  
  +-----------------------------------------+
  | hostname |
  +-----------------------------------------+
  | localhost |
  | deploymentconfig-0-galera-4-5899z |
  | deploymentconfig-clustercontrol-1-bffzh |
  | deploymentconfig-1-galera-1-n42rb |
  | deploymentconfig-2-galera-1-kfh6v |
  | deploymentconfig-0-proxysql-1-tc7kj |
  | deploymentconfig-1-proxysql-1-m8nqr |
  +-----------------------------------------+
  7 rows in set (0.00 sec)

  0

  Comment actions Permalink

Please sign in to leave a comment.