Can't import existing cluster

Hello.

I got below errors during import existing cluster:

[08:58:09]:Adding existing cluster has failed.
[08:58:09]:Couldn't determine the datadir on '178.22.168.8:3306' connect (from 82.146.48.42), failed for user 'cmon': Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno: 2013)
[08:58:06]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:57:53]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:57:40]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:57:27]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:57:13]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:57:00]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:56:47]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:56:34]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:56:21]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:56:08]:Connection failure to 178.22.168.8:3306: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 110 (errno: 2013) (errno 2013)
[08:55:58]:85.214.188.221:3306: The datadir is /var/lib/mysql/.
[08:55:58]:Connected succesfully: 'cmon@82.146.48.42' -> '85.214.188.221:3306'.
[08:55:58]:Determining data directories.
[08:55:55]:188.120.251.42: Granting cmon.
[08:55:40]:178.22.168.8: Granting cmon.
[08:55:25]:85.214.188.221: Granting cmon.
[08:55:25]:188.120.251.42:3306: Node is synced.
[08:55:24]:178.22.168.8:3306: Node is synced.
[08:55:21]:85.214.188.221:3306: Node is synced.
[08:55:17]:Granting controller (82.146.48.42,web2.callinfo.kz).
[08:55:17]:Controller '82.146.48.42' resolves to 'web2.callinfo.kz'
[08:55:17]:Checking if resolve of '82.146.48.42' is needed, and attempting to resolve to a hostname
[08:55:10]:Detected that skip_name_resolve is not used on the target server(s).
[08:55:10]:85.214.188.221:3306: skip_name_resolve=skip_name_resolve OFF
[08:55:00]:Check SELinux statuses.
[08:55:00]:All 3 hosts are accessible by SSH.
[08:54:58]:Checking ssh/sudo on 3 hosts with credentials ssh_cred_job_6656.
[08:54:58]:Checking that nodes are not in another cluster.
[08:54:58]:Found in total 3 nodes.
[08:54:58]:Found node: '188.120.251.42'
[08:54:58]:Found node: '178.22.168.8'
[08:54:58]:Found node: '85.214.188.221'
[08:54:58]:188.120.251.42: wsrep_node_address=188.120.251.42
[08:54:57]:188.120.251.42: Checking wsrep_node_address.
[08:54:57]:178.22.168.8: wsrep_node_address=178.22.168.8
[08:54:54]:178.22.168.8: Checking wsrep_node_address.
[08:54:54]:85.214.188.221: wsrep_node_address=85.214.188.221
[08:54:50]:85.214.188.221: Checking wsrep_node_address.
[08:54:46]:178.22.168.8:3306: Getting node list from the MySQL server.
[08:54:46]:178.22.168.8:3306: monitored_mysql_root_password is not set, please set it later in the generated cmon.cnf
[08:54:40]:178.22.168.8:3306: Verifying the MySQL user/password.
[08:54:34]:178.22.168.8: Checking ssh/sudo with credentials ssh_cred_job_6656.
[08:54:34]:Adding existing MySQL cluster.
[08:54:34]:Generating configuration for cluster sergey_cluster.
[08:54:34]:Adding cluster with type 'galera', vendor 'mariadb'.
Job spec: {
"command": "add_cluster",
"group_id": 1,
"group_name": "admins",
"job_data":
{
"api_id": 1,
"cluster_name": "sergey_cluster",
"cluster_type": "galera",
"company_id": "1",
"config_template": "my57.cnf.galera",
"datadir": "/var/lib/mysql",
"db_password": "Letacla@8432",
"db_user": "serge2",
"disable_firewall": true,
"disable_selinux": true,
"enable_cluster_autorecovery": false,
"enable_information_schema_queries": false,
"enable_node_autorecovery": false,
"enable_nodes_autodetect": true,
"galera_version": "2.x",
"generate_token": true,
"install_software": true,
"monitored_mysql_port": "3306",
"nodes": [
{
"hostname": "178.22.168.8",
"port": "3306"
} ],
"port": "3306",
"ssh_keyfile": "/root/.ssh/id_rsa",
"ssh_port": "22",
"ssh_user": "root",
"sudo_password": "",
"tag": "",
"user_id": 1,
"vendor": "mariadb",
"version": "10.2"
},
"user_id": 1,
"user_name": "avpco@live.ru"
}

But I can connect to 178.22.168.8 MariaDB without any problems by mysql command and establish SSL connection.

What I should do to resolve this problem?

Sebastian Insausti

June 10, 2020 16:56

Hi,

It looks like a certificate issue.

I would recommend creating a support request and adding a ClusterControl error report there.

If you don't have any cluster added into ClusterControl, you can generate an error report from the command line by running the following command:

$ s9s_error_reporter -i 0

And then, attach the generated tar file to the support ticket.

Thank you.

Regards,

Sebastian.

Can't import existing cluster

Comments

Didn't find what you were looking for?