MySQL Issues
There are known issues that can occur with MySQL. The Verrazzano platform operator will automatically detect each of the described issues and perform actions to repair them. The operator initiates a repair within a few minutes of detecting an issue.
The following sections are provided in the event that a manual repair of an issue is required.
MySQL pod stuck Terminating
A MySQL pod may get stuck in a terminating state. This may occur while upgrading the nodes of a Kubernetes cluster.
Here is an example of what this condition looks like. All the pod containers are terminated, but the pod never finishes terminating.
$ kubectl get pods -n keycloak -l component=mysqld
NAME READY STATUS RESTARTS AGE
mysql-0 0/3 Terminating 0 60m
You can repair this issue by restarting the mysql-operator
pod.
$ kubectl delete pod -l name=mysql-operator -n mysql-operator