Not able to setup new cluster
Hi all,
I try to get the 3 mariadb galera test machines setup in ClusterControl but if fails every time.
All settings are correct.
But every time I get the error message that the cluster setup fails.
Any idea what can be wrong here?
Cheers
Christian
This is the job worklog:
[16:46:31]:New cluster setup failure: cluster 49 is not running.
[16:46:31]:127.0.0.1:/var/log/cmon_49.log:
----8/etc/cmon.d/cmon_49.cnf'.
[16:46:25]:Generating and writing the new configuration.
[16:46:25]:192.168.10.168:3306: Detected OS = 'debian'
[16:46:25]:192.168.10.168: Detecting the OS.
[16:46:25]:192.168.10.172:3306: The datadir is /var/lib/mysql/.
[16:46:25]:Connected succesfully: 'cmon@galeracluster01' -> '192.168.10.172:3306'.
[16:46:25]:192.168.10.171:3306: The datadir is /var/lib/mysql/.
[16:46:25]:Connected succesfully: 'cmon@galeracluster01' -> '192.168.10.171:3306'.
[16:46:25]:192.168.10.168:3306: The datadir is /var/lib/mysql/.
[16:46:25]:Connected succesfully: 'cmon@galeracluster01' -> '192.168.10.168:3306'.
[16:46:25]:Determining data directories.
[16:46:23]:192.168.10.172: Granting cmon.
[16:46:21]:192.168.10.171: Granting cmon.
[16:46:20]:192.168.10.168: Granting cmon.
[16:46:20]:192.168.10.172:3306: Node is synced.
[16:46:19]:192.168.10.171:3306: Node is synced.
[16:46:19]:192.168.10.168:3306: Node is synced.
[16:46:18]:Granting controller (galeracluster01).
[16:46:18]:Controller 'galeracluster01' could not be resolved. Probably already a valid FQDN.
[16:46:18]:Checking if resolve of 'galeracluster01' is needed, and attempting to resolve to a hostname
[16:46:17]:Detected that skip_name_resolve is not used on the target server(s).
[16:46:16]:Check SELinux statuses.
[16:46:16]:All 3 hosts are accessible by SSH.
[16:46:16]:Using sudo password for further communication.
[16:46:16]:192.168.10.172: Access with ssh/sudo granted.
[16:46:14]:192.168.10.171: Access with ssh/sudo granted.
[16:46:14]:192.168.10.168: already checked 5 seconds ago.
[16:46:13]:Checking ssh/sudo on 3 hosts.
[16:46:13]:Checking that nodes are not in another cluster.
[16:46:13]:Found in total 3 nodes.
[16:46:13]:Found node: '192.168.10.172'
[16:46:13]:Found node: '192.168.10.171'
[16:46:13]:Found node: '192.168.10.168'
[16:46:13]:192.168.10.172: wsrep_node_address=192.168.10.172
[16:46:11]:192.168.10.172: Checking wsrep_node_address.
[16:46:11]:192.168.10.171: wsrep_node_address=192.168.10.171
[16:46:10]:192.168.10.171: Checking wsrep_node_address.
[16:46:10]:192.168.10.168: wsrep_node_address=192.168.10.168
[16:46:10]:192.168.10.168: Checking wsrep_node_address.
[16:46:09]:192.168.10.168:3306: Getting node list from the MySQL server.
[16:46:09]:192.168.10.168:3306: Verifying the MySQL user/password.
[16:46:09]:Using sudo password for further communication.
[16:46:09]:192.168.10.168: Access with ssh/sudo granted.
[16:46:09]:192.168.10.168: Checking ssh/sudo.
[16:46:09]:Adding existing MySQL cluster.
[16:46:09]:Cmon user with ID 1 was not found: Error finding job owner: User id 1 is not found.
[16:46:09]:Generating configuration for cluster test_cluster.
[16:46:09]:Verifying controller host and cmon password.
[16:46:09]:Adding cluster with type 'galera', vendor 'mariadb'.
Job spec: {
"command": "add_cluster",
"job_data":
{
"api_id": 1,
"cluster_name": "test_cluster",
"cluster_type": "galera",
"config_template": "my.cnf.galera",
"datadir": "/var/lib/mysql",
"db_password": "123456789",
"db_user": "root",
"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": "192.168.10.168",
"port": "3306"
} ],
"port": "3306",
"ssh_keyfile": "/home/sysadmin/.ssh/id_rsa",
"ssh_port": "22",
"ssh_user": "sysadmin",
"sudo_password": "I=Boss!1200",
"tag": "",
"user_id": 1,
"vendor": "mariadb",
"version": "10.1"
}
}
-
Hi Christian,
That somehow looks hard to follow here without asking some reports. Can you create a Support Request ticket instead and send us an error report by going to Cluster -> Logs -> Error Logging -> Create Error Report then attached the compressed file into the ticket you're going to create/file.
We'll wait for your request there.
Thanks.
-
HI Christian,
In this very page, on the top menu, there is a "Create Support Request" button. Just click on it, fill up the form and attach the error report as well. The ticket will be assigned to a support representative and you shall get the reply soon on what to do next.
Regards,
Ashraf
Please sign in to leave a comment.
Comments
3 comments