search

crossplane-contrib / provider-sql

An SQL provider for @crossplane
https://crossplane.io
Apache License 2.0
104 stars 59 forks source link

ReconsileError due to failed Prepared statement #53

Closed TheBigLee closed 3 months ago

TheBigLee commented 2 years ago

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

anothertobi commented 2 years ago

Workaround: Restarting the database first and then the provider-sql solves this issue.

c4tz commented 1 year ago

We also had this bug after switching from MySQL to MariaDB. This doesn't seem to be caused by provider-sql, but rather by MariaDB itself (at least in version 10.5, which we use, too).

After increasing the table_definition_cache to 4000 (as suggested here), we did not yet see the problem happen again.

Duologic commented 3 months ago

Closing as stale. Please re-open and update if this is still valid.