Task [mariadb : Start MariaDB Service] fails on Centos7 vm

[Sebbenbear]

States the control process exits with an error code, and suggests running "systemctl status mariadb.service" and "journalctl -xe". However, there are no entries in journalctl and systemctl just has (Result: exit-code) instead of a way to debug the issue.

[jpollardRH]

Had a quick look, this is because the install for mariadb uses the old log file location which SELinux labelling doesn't like. Will update config file to use mariadb default log location (/var/log/mariadb/mariadb.log)

[sumitsu25]

I have tried changing the log file location but still the issue is not resolved, mariadb is not able to start

[sumitsu25]

TASK [mariadb : Start MariaDB Service] *****************************************************************************************************
fatal: [node1]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to start service mariadb: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.\n"}
to retry, use: --limit @/root/github/ansible-examples/wordpress-nginx_rhel7/site.retry

[jpollardRH]

@sumitsu25 did you try from a new VM? If retrying on the same instance, you may need to remove mariadb/mysql packages to try again.

[scheerchrs]

Good concise answer JP. Recreate to node from scratch and if duplicated, examine GIT or SubV json files for change dates and who. Back one code revision and see if all good. Then smack the developer on the forhead. :-)

[MegandM]

Hi everyone!

This worked for me.

First, make sure the following variables are set (my.cnf):

[mysqld_safe]
log-error                      = /var/log/mariadb/mariadb.log
pid-file                       = /var/run/mariadb/mariadb.pid

[mysqld]
socket                         = /var/lib/mysql/mysql.sock
datadir                        = /var/lib/mysql

Before re-starting MariaDB Server and after modifying datadir, make sure datadir is empty.

Steps for unistalling and re-starting MariaDB Server are the followings (you'll need to be root user):

1. yum remove mariadb mariadb-server
2. rm -rf <datadir> (for the example above: /var/lib/mysql)
3. rm /etc/my.cnf
4. yum install mariadb mariadb-server
5. service mariadb start