search

stenic / sql-operator

Manage SQL databases, users and grant using kubernetes manifests
https://stenic.github.io/sql-operator/
Other
4 stars 3 forks source link

Error: commands out of sync. Did you run multiple statements at once? #27

Closed NoUseFreak closed 2 years ago

NoUseFreak commented 2 years ago 
2021-11-01T16:21:04.381Z    ERROR   controller-runtime.manager.controller.sqldatabase   Reconciler error    {"reconciler group": "stenic.io", "reconciler kind": "SqlDatabase", "name": "sqldatabase-sample", "namespace": "sql-operator-test", "error": "commands out of sync. Did you run multiple statements at once?"}
github.com/go-logr/zapr.(*zapLogger).Error
    /go/pkg/mod/github.com/go-logr/zapr@v0.2.0/zapr.go:132
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).reconcileHandler
    /go/pkg/mod/sigs.k8s.io/controller-runtime@v0.8.3/pkg/internal/controller/controller.go:302
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).processNextWorkItem
    /go/pkg/mod/sigs.k8s.io/controller-runtime@v0.8.3/pkg/internal/controller/controller.go:253
sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).Start.func1.2
    /go/pkg/mod/sigs.k8s.io/controller-runtime@v0.8.3/pkg/internal/controller/controller.go:216
k8s.io/apimachinery/pkg/util/wait.JitterUntilWithContext.func1
    /go/pkg/mod/k8s.io/apimachinery@v0.20.2/pkg/util/wait/wait.go:185
k8s.io/apimachinery/pkg/util/wait.BackoffUntil.func1
    /go/pkg/mod/k8s.io/apimachinery@v0.20.2/pkg/util/wait/wait.go:155
k8s.io/apimachinery/pkg/util/wait.BackoffUntil
    /go/pkg/mod/k8s.io/apimachinery@v0.20.2/pkg/util/wait/wait.go:156
k8s.io/apimachinery/pkg/util/wait.JitterUntil
    /go/pkg/mod/k8s.io/apimachinery@v0.20.2/pkg/util/wait/wait.go:133
k8s.io/apimachinery/pkg/util/wait.JitterUntilWithContext
    /go/pkg/mod/k8s.io/apimachinery@v0.20.2/pkg/util/wait/wait.go:185
k8s.io/apimachinery/pkg/util/wait.UntilWithContext
    /go/pkg/mod/k8s.io/apimachinery@v0.20.2/pkg/util/wait/wait.go:99
NoUseFreak commented 2 years ago

This issue seems to be MariaDB specific. I was not able to find a solution to resolve this from an application perspective, this however can be resolved by running the following on your MariaDB instance.

FLUSH HOSTS;