I believe I have root caused the problem thanks to many hints from Aurelien and a subtle hint from a google search [0]
The key to the problem is the error:
"Aug 5 07:24:10 juju-1e2915-4-lxd-13 crmd[14520]: error: Failed to retrieve meta-data for ocf:percona:mysql_monitor"
This error is much different from an actual check of mysql that fails or when the file is missing.
From [0] the suggestion "Could it be as simple as [the ocf file] bit set (for the user)?"
Yes. Yes it can. Percona copies the mysql_monitor file early but does not set the execution bit [1].
Doing some more verification then a fix will be on the way.
I believe I have root caused the problem thanks to many hints from Aurelien and a subtle hint from a google search [0]
The key to the problem is the error: 4-lxd-13 crmd[14520]: error: Failed to retrieve meta-data for ocf:percona: mysql_monitor"
"Aug 5 07:24:10 juju-1e2915-
This error is much different from an actual check of mysql that fails or when the file is missing.
From [0] the suggestion "Could it be as simple as [the ocf file] bit set (for the user)?"
Yes. Yes it can. Percona copies the mysql_monitor file early but does not set the execution bit [1].
Doing some more verification then a fix will be on the way.
[0] https:/ /lists. clusterlabs. org/pipermail/ users/2018- September/ 024866. html /opendev. org/openstack/ charm-percona- cluster/ src/branch/ master/ hooks/percona_ utils.py# L441
[1] https:/