Getting Error while performing galera-install.yml in OSAD "error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)'

[Chandra]

when i am running galera-install.yml i am getting error as below. i tried to start mysql manually but its not comming up.

openstack-ansible galera-install.yml
GATHERING FACTS ********************* ok: [slave01_galera_container-b9473cb6]

TASK: [Check if mysql is running] *************** failed: [slave01_galera_container-b9473cb6] => {"changed": true, "cmd": ["/usr/bin/mysqladmin", "--defaults-file=/etc/mysql/debian.cnf", "ping"], "delta": "0:00:00.005650", "end": "2015-09-13 00:24:24.529577", "rc": 1, "start": "2015-09-13 00:24:24.523927", "warnings": []} stderr: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! ...ignoring

TASK: [fail ] ********************* failed: [slave01_galera_container-b9473cb6] => {"failed": true} msg: The cluster may be broken, mysql is not running but appears to be installed. Fix it before re-running the playbook or override with 'openstack-ansible -e galera_ignore_cluster_state=true galera-install.yml'.

FATAL: all hosts have already failed -- aborting

Please help me in this. i am stuck at this point from few days.

i am using OSAD and Branch : Kilo.

Please let me know if more details are needed.

[Kevin Carter (kevin-carter)]

Have you run the command in the failure message -- 'openstack-ansible -e galera_ignore_cluster_state=true galera-install.yml' does it still fail in the same way?

[Chandra (reddydodda)]

Hi ,

Once i tear-down all setup and re-run the setup it worked. not sure what might went wrong. thanks for the help. can close the bug as invalid.