OpenStack Percona Cluster Charm

  1. Bug #1413620
  2. Comment #7

Comment 7 for bug 1413620

Revision history for this message
Ashley Lai (alai) wrote : Re: Error after reboot: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

We hit similar error in our deployment. I've attached the crashdump for investigation. The juju log from mysql/0 shows the following.

2018-01-22 21:32:57 DEBUG db-admin-relation-changed Traceback (most recent call last):
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/db-admin-relation-changed", line 780, in <module>
2018-01-22 21:32:57 DEBUG db-admin-relation-changed main()
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/db-admin-relation-changed", line 770, in main
2018-01-22 21:32:57 DEBUG db-admin-relation-changed hooks.execute(sys.argv)
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/charmhelpers/core/hookenv.py", line 800, in execute
2018-01-22 21:32:57 DEBUG db-admin-relation-changed self._hooks[hook_name]()
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/db-admin-relation-changed", line 417, in db_changed
2018-01-22 21:32:57 DEBUG db-admin-relation-changed password = db_helper.configure_db(addr, db_name, username, admin=admin)
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/charmhelpers/contrib/database/mysql.py", line 401, in configure_db
2018-01-22 21:32:57 DEBUG db-admin-relation-changed self.connect(password=self.get_mysql_root_password())
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/var/lib/juju/agents/unit-mysql-0/charm/hooks/charmhelpers/contrib/database/mysql.py", line 91, in connect
2018-01-22 21:32:57 DEBUG db-admin-relation-changed passwd=password)
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
2018-01-22 21:32:57 DEBUG db-admin-relation-changed return Connection(*args, **kwargs)
2018-01-22 21:32:57 DEBUG db-admin-relation-changed File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 204, in __init__
2018-01-22 21:32:57 DEBUG db-admin-relation-changed super(Connection, self).__init__(*args, **kwargs2)
2018-01-22 21:32:57 DEBUG db-admin-relation-changed _mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)")
2018-01-22 21:32:57 ERROR juju.worker.uniter.operation runhook.go:114 hook "db-admin-relation-changed" failed: exit status 1