New MySQL Galera Cluster, the job always fails

Hi,

I have installed ClusterControl on Ubuntu 18.4 (via offline method) successfully. Now I am trying to deploy a new MySQL Galera cluster with 2 node (1 CC node and 2 DB node, all running ubuntu 18.4). I am following Caleb Curry's youtube videos tuts to deploy this cluster. Here is a list of what i did so far

installed cluster control on 1 server
setup passwordless SSH on all 3 servers
click deploy new cluster, selected MySQL Galera and fill the forms as shown in following screenshots
clicked deploy, the job starts and after sometime it fails (check job output at the bottom)

The DB servers are fresh/clean VMs, no packages have been installed and firewall (UFW) is disabled on all 3 server (CC, DB1 and DB2)

Form Step 1:

Form Step 2:

Job Output:

[14:47:21]:172.16.101.179:3306: Failed to setup MySql server.
[14:47:21]:172.16.101.179: Setup server failure, see the previous messages.
[14:47:21]:172.16.101.179:3306: failed remote (172.16.101.179) retval: 100 command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install mariadb-server mariadb-client mariadb-common mariadb-backup percona-toolkit 2>&1 output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to correct problems, you have held broken packages.
[14:47:21]: output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to correct problems, you have held broken packages.
[14:47:21]: command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install mariadb-server mariadb-client mariadb-common mariadb-backup percona-toolkit 2>&1
[14:47:21]:Failed to install package.
[14:47:20]:172.16.101.179: Installing mariadb-server mariadb-client mariadb-common mariadb-backup percona-toolkit .
[14:47:20]: output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to correct problems, you have held broken packages.
[14:47:20]: command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install mariadb-server mariadb-client mariadb-common mariadb-backup percona-toolkit 2>&1
[14:47:20]:Failed to install package.
[14:47:20]:172.16.101.179: Installing mariadb-server mariadb-client mariadb-common mariadb-backup percona-toolkit .
[14:47:20]:172.16.101.179: Installing percona-toolkit.
[14:47:20]:172.16.101.179: Installing mariadb-backup.
[14:47:20]:172.16.101.179: Installing mariadb-common.
[14:47:20]:172.16.101.179: Installing mariadb-client.
[14:47:20]:172.16.101.179: Installing mariadb-server.
[14:47:18]:172.16.101.179: Installing mariadb (galera) on debian.
[14:47:18]:172.16.101.179:3306: Proceeding.
[14:47:18]:172.16.101.179:3306: Waiting for dpkg lock.
[14:47:18]:172.16.101.179:3306: Installing the MySQL packages.
[14:47:14]:172.16.101.179:3306: Prepare MySQL environment (user/group).
[14:47:14]:172.16.101.179:3306: Cleaning old MySQL packages: successfully removed packages.
[14:47:06]:172.16.101.179:3306: Removing old MySQL packages from the host.
[14:46:55]:172.16.101.179: Using external repositories.
[14:46:55]:172.16.101.179:3306: Total disk space: 195.86 GiB.
[14:46:55]:172.16.101.179:3306: Free disk space: 179.64 GiB.
[14:46:55]:172.16.101.179:3306: Checking free-disk space of '/var/lib/mysql'.
[14:46:55]:172.16.101.179:3306: Detected memory: 7.79 GiB.
[14:46:55]:172.16.101.179:3306: Detecting total memory.
[14:46:55]:172.16.101.179:3306: mysql_server_id is not specified in the job, setting server_id=6001.
[14:46:55]:Loaded template '/usr/share/cmon/templates/my.cnf.galera'.
[14:46:55]:Using config template 'my.cnf.galera' from '/usr/share/cmon/templates'.
[14:46:55]:172.16.101.179:3306: Using template 'my.cnf.galera'.
[14:46:55]:Cluster type is 'galera'.
[14:46:55]:Using skip_name_resolve as all servers are defined by IP.
[14:46:55]:172.16.101.179: Verifying helper packages (checking 'socat').
[14:46:55]:172.16.101.179: Finished with helper packages.
[14:46:54]:172.16.101.179: remote (172.16.101.179) retval: 100 command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install augeas-tools 2>&1 output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Package 'augeas-tools' has no installation candidate.
[14:46:54]:172.16.101.179: Failed to install augeas-tools.
[14:46:54]:172.16.101.179: Installing augeas-tools.
[14:46:54]:172.16.101.179: Installing apt-transport-https.
[14:46:54]:172.16.101.179: Installing openssl.
[14:46:53]:172.16.101.179: Installing libatomic1.
[14:46:52]:172.16.101.179: Installing tar.
[14:46:52]:172.16.101.179: Installing iproute2.
[14:46:52]:172.16.101.179: Installing bzip2.
[14:46:52]:172.16.101.179: remote (172.16.101.179) retval: 100 command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install libmecab2 2>&1 output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Package 'libmecab2' has no installation candidate.
[14:46:52]:172.16.101.179: Failed to install libmecab2.
[14:46:52]:172.16.101.179: Installing libmecab2.
[14:46:51]:172.16.101.179: Installing libnuma1.
[14:46:51]:172.16.101.179: remote (172.16.101.179) retval: 100 command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install pigz 2>&1 output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to locate package pigz.
[14:46:51]:172.16.101.179: Failed to install pigz.
[14:46:51]:172.16.101.179: Installing pigz.
[14:46:51]:172.16.101.179: Installing curl.
[14:46:50]:172.16.101.179: Installing wget.
[14:46:50]:172.16.101.179: remote (172.16.101.179) retval: 100 command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install libdbd-mysql-perl 2>&1 output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Package 'libdbd-mysql-perl' has no installation candidate.
[14:46:50]:172.16.101.179: Failed to install libdbd-mysql-perl.
[14:46:50]:172.16.101.179: Installing libdbd-mysql-perl.
[14:46:50]:172.16.101.179: Installing libssl1.0.0.
[14:46:50]:172.16.101.179: Installing lsb-release.
[14:46:49]:172.16.101.179: Installing socat.
[14:46:48]:172.16.101.179: Installing netcat-openbsd.
[14:46:48]:172.16.101.179: Installing netcat.
[14:46:48]:172.16.101.179: Installing libaio1.
[14:46:48]:172.16.101.179: Installing rsync.
[14:46:47]:172.16.101.179: Installing psmisc.
[14:46:45]:172.16.101.179: Proceeding.
[14:46:45]:172.16.101.179: Waiting for dpkg lock.
[14:46:45]:172.16.101.179: Installing helper packages.
[14:46:45]:172.16.101.179: Setting vm.swappiness = 1.
[14:46:45]:172.16.101.179: Tuning OS parameters.
[14:46:45]:172.16.101.179: Flushing iptables.
[14:46:43]:172.16.101.179: Disabling ufw.
[14:46:41]:172.16.101.179: Checking firewall.
[14:46:41]:172.16.101.179: Checking SELinux status (enabled = false).
[14:46:39]:172.16.101.179: Check and disable AppArmor.
[14:46:39]:172.16.101.179: Type is 'debian'.
[14:46:39]:172.16.101.179: Release is 'bionic'.
[14:46:39]:172.16.101.179: Vendor is 'ubuntu'.
[14:46:39]:Calling job: setupServer(172.16.101.179:3306).
[14:46:39]:wsrep_cluster_address = 'gcomm://172.16.101.179,172.16.101.180'
[14:46:39]:Creating the cluster with the following:
[14:46:38]:172.16.101.180:3306: Checking if host already exists in another cluster.
[14:46:38]:172.16.101.179:3306: Checking if host already exists in another cluster.
[14:46:38]:All 2 hosts are accessible by SSH.
[14:46:38]:Using sudo password for further communication.
[14:46:38]:172.16.101.180: Access with ssh/sudo granted.
[14:46:37]:172.16.101.179: Access with ssh/sudo granted.
[14:46:36]:Checking ssh/sudo on 2 hosts.
[14:46:36]:Verifying job parameters.

Official comment

Krzysztof Ksiazek

June 23, 2019 16:24

[14:47:21]:<em style='color: #c66211;'>172.16.101.179</em>:3306: failed remote (172.16.101.179) retval: 100 command: DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install mariadb-server mariadb-client mariadb-common mariadb-backup percona-toolkit 2>&1 output: W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to correct problems, you have held broken packages.

This error means there is some sort of a package conflict which prevents ClusterControl from installing some of the required packages. What I can suggest at this time is to try and install them manually. You should have a clearer picture of what the exact issue is. Ubuntu 18.04 LTS is a supported distribution which kinda makes me think this might be a problem related to your environment. Some non-standard packages have been installed or similar. Please see if you can sort it out on your own, if not feel free to open a ticket with us and we will try to assist you with this case.

Waqar Akbar

June 25, 2019 10:15
Edited

Hi Ksiazek, thanks for your suggestions.

There was something wrong with the internet connection on DB servers and during the deployment of cluster some of the packages were getting skipped. So I followed your suggestion and installed them manually via apt-get and retried. Now everything is working fine.

Thanks again for the help, here is a screenshot of my successfully deployed and imported clusters...

New MySQL Galera Cluster, the job always fails

Comments

Didn't find what you were looking for?