Description of problem: With a clean deploy of pike, i perform a minor update. After that, the controllers are failing due to mysql error. When i enter, i see mariadb is down: abr 12 06:39:28 overcloud-controller-1 mysql-check-socket[252260]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically. abr 12 06:39:28 overcloud-controller-1 mysql-prepare-db-dir[252284]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done. abr 12 06:39:28 overcloud-controller-1 mysql-prepare-db-dir[252284]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir. abr 12 06:39:28 overcloud-controller-1 mysqld[252321]: 2018-04-12 6:39:28 140595765754048 [Warning] option 'open_files_limit': unsigned value 18446744073709551615 adjusted to 4294967295 abr 12 06:39:28 overcloud-controller-1 mysqld[252321]: 2018-04-12 6:39:28 140595765754048 [Note] /usr/libexec/mysqld (mysqld 10.1.20-MariaDB) starting as process 252321 ... abr 12 06:39:28 overcloud-controller-1 mysqld[252321]: 2018-04-12 6:39:28 140595765754048 [Warning] Could not increase number of max_open_files to more than 1024 (request: 8107) abr 12 06:39:29 overcloud-controller-1 systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE abr 12 06:39:29 overcloud-controller-1 systemd[1]: Failed to start MariaDB 10.1 database server. abr 12 06:39:29 overcloud-controller-1 systemd[1]: Unit mariadb.service entered failed state. abr 12 06:39:29 overcloud-controller-1 systemd[1]: mariadb.service failed mariadb version is: mariadb-config-10.1.20-2.el7.x86_64 mariadb-10.1.20-2.el7.x86_64 mariadb-errmsg-10.1.20-2.el7.x86_64 mariadb-server-10.1.20-2.el7.x86_64 mariadb-server-galera-10.1.20-2.el7.x86_64 mariadb-libs-10.1.20-2.el7.x86_64 mariadb-common-10.1.20-2.el7.x86_64
Hola Yolanda, could it be that you actually forgot (or the undercloud/tripleo-common did not do it for you) to inject the docker-ha.yaml env file? I ask because: abr 12 06:39:29 overcloud-controller-1 systemd[1]: Failed to start MariaDB 10.1 database server. abr 12 06:39:29 overcloud-controller-1 systemd[1]: Unit mariadb.service entered failed state. abr 12 06:39:29 overcloud-controller-1 systemd[1]: mariadb.service failed Implies that we started mariadb without systemd (aka nonHA) thanks, Michele