Comment 3 for bug 1755507

Sandor,

https://review.openstack.org/553083 should fix things.

For thoroughness, the fix once one is already in this error state is as follows without the new charm:

On the leader node (This should be the node in error state).

# Start mysql back up
sudo systemctl start mysql

# If root-password is not set in config
# Find the existing root password
leader-get mysql.passwd

# Set 'root-password' to the same value
leader-set root-password=$MYSQLPW

# If sst-password is not set
# Either set via config or manually
# Via config
juju config percona-cluster sst-password=$NEWPASSWD
# Manually
leader-set sst-password=$NEWPASSWORD

# Finally resolve the unit
juju resolved percona-cluster/$N

If you are upgrading to the new charm update the following will work:
On the leader node (This should be the node in error state).

# Start mysql back up
sudo systemctl start mysql

# Upgrade the charm:
juju upgrade-charm percona-cluster --force-units --switch /path/to/new/charm

# Resolve the unit
juju resolved percona-cluster/$N