provider-sql icon indicating copy to clipboard operation
provider-sql copied to clipboard

ReconsileError due to failed Prepared statement

Open TheBigLee opened this issue 2 years ago • 2 comments

What happened?

Multiple User objects enter into ReconcileError state with the following error:

observe failed: cannot select user: Error 1615: Prepared statement needs  to be re-prepared

The affected objects are staying in this state and never seem to recover. Restarting the crossplane controller doesn't seem to work either.

How can we reproduce it?

No idea how to reproduce this issue. It happens randomly on various objects from time to time. I'm happy to provide any information required to figure out what the problem is.

What environment did it happen in?

Crossplane version: v1.1.1 Kubernetes version: v1.19 Provider-sql version: v0.2.1

We are using the bitnami-galera chart version 5.6.7 and the mariadb-galera image version: 10.5.9-debian-10-r45

TheBigLee avatar Oct 12 '21 11:10 TheBigLee