Kubectl get pxc cluster1 shows error due to not being able to resize the pv

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

Description:

Hi, when I do a kubectl get pxc cluster1 it shows status: error

Steps to Reproduce:

Conditions:
kc describe pxc cluster1 snippet:

Last Transition Time:  2024-05-18T14:40:02Z
Status:                True
Type:                  initializing
Last Transition Time:  2024-05-18T14:40:02Z
Message:               update persistentvolumeclaim/datadir-cluster1-pxc-0: persistentvolumeclaims "datadir-cluster1-pxc-0" is forbidden: only dynamically provisioned pvc can be resized and the storageclass that provisions the pvc must support resize
Reason:                ErrorReconcile
Status:                True
Type:                  error

Version:

1.14.0

It shows it cannot resize de pv. That’s right because I use local-path-provisioner. I’ve tried reconstructing the cluster with 100G pvc’s and copying the data back in the new directories but that didn’t work.

Is there any way I can get rid of this error? I simply don’t have resizable volumes at my disposal and now I can’t get the backups to run. I’ve figured out a mysldump strategy with turning pxc-strict mode to disabled, but I really like the error to go away.

Hope anyone can help me on this one

Thx,

Bram

2

@bram

You should refer to this blog post - Percona Operator Volume Expansion Without Downtime which discussing the steps for the volume expansion and also covers the details when PVC volume expansion not possible and have to copy the data over a new PVC. Let us know if that helps!

Moreover, please share the below details from your environment for a quick looking.

kubectl get pvc <your-pvc-name> -o yaml
kubectl describe pvc <your-pvc-name>

kubectl get pv <your-volume-name>

kubectl get storageclass
kubectl get storageclass <your-storage-class> -o yaml
kubectl describe storageclass <your-storage-class>

Regards,
Anil