Skip to content

Instantly share code, notes, and snippets.

@celikmustafa89

celikmustafa89/mysql_restart_error

Created April 22, 2016 08:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save celikmustafa89/5c219e7a1abca1dc95e50f0dcf10fd2a to your computer and use it in GitHub Desktop.
Save celikmustafa89/5c219e7a1abca1dc95e50f0dcf10fd2a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_restart_error
NOTIFIED: [galera_server | Restart mysql] *************************************
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
Result from run 1 is: {u'msg': u' * Stopping MariaDB database server mysqld\n ...done.\n * Starting MariaDB database server mysqld\n ...fail!\n', u'failed': True, 'attempts': 1}
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
Result from run 2 is: {u'msg': u' * Stopping MariaDB database server mysqld\n ...done.\n * Starting MariaDB database server mysqld\n ...fail!\n', u'failed': True, 'attempts': 2}
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
Result from run 3 is: {u'msg': u' * Stopping MariaDB database server mysqld\n ...done.\n * Starting MariaDB database server mysqld\n ...fail!\n', u'failed': True, 'attempts': 3}
changed: [ansible03_galera_container-1f508f49] => {"attempts": 3, "changed": true, "failed": false, "failed_when_result": false, "msg": "Task failed as maximum retries was encountered"}
NOTIFIED: [galera_server | Remove stale .sst] *********************************
<172.29.237.248> REMOTE_MODULE file state=absent path=/var/lib/mysql/.sst
changed: [ansible03_galera_container-1f508f49] => {"changed": true, "path": "/var/lib/mysql/.sst", "state": "absent"}
NOTIFIED: [galera_server | Restart mysql fall back] ***************************
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
Result from run 1 is: {u'msg': u' * Stopping MariaDB database server mysqld\n ...done.\n * Starting MariaDB database server mysqld\n ...fail!\n', u'failed': True, 'attempts': 1}
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
Result from run 2 is: {u'msg': u' * Stopping MariaDB database server mysqld\n ...done.\n * Starting MariaDB database server mysqld\n ...fail!\n', u'failed': True, 'attempts': 2}
<172.29.237.248> REMOTE_MODULE service name=mysql args='' state=restarted pattern=mysql
Result from run 3 is: {u'msg': u' * Stopping MariaDB database server mysqld\n ...done.\n * Starting MariaDB database server mysqld\n ...fail!\n', u'failed': True, 'attempts': 3}
failed: [ansible03_galera_container-1f508f49] => {"attempts": 3, "failed": true}
msg: Task failed as maximum retries was encountered
FATAL: all hosts have already failed -- aborting
TASK: [galera_server | Confirm service connectivity] **************************
FATAL: no hosts matched or all hosts have already failed -- aborting
PLAY RECAP ********************************************************************
to retry, use: --limit @/root/galera-install.retry
ansible01_galera_container-358094a0 : ok=77 changed=10 unreachable=0 failed=0
ansible02_galera_container-017d9f5a : ok=3 changed=1 unreachable=0 failed=0
ansible03_galera_container-1f508f49 : ok=58 changed=25 unreachable=0 failed=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment