clusterpedia-io/clusterpedia

error when use MySQL 8.0.31 in mgr pattern: Failed to storage resource

Closed this issue · 1 comments

What happened?

in clustersynchro-manager pod has error log:
E0118 08:52:35.039027 1 resource_synchro.go:409] "Failed to storage resource" err="Error 1064: prepared statements not allowed with access_mode = 'auto'" cluster="kpanda-global-cluster" action=Updated resource="/v1, Resource=configmaps" key="mcamel-system/mysql-operator-leader-election"

What did you expect to happen?

output put original error,and give the version range of supported MySQL

How can we reproduce it (as minimally and precisely as possible)?

use MySQL 8.0.31 in mgr pattern

Anything else we need to know?

No response

Clusterpedia Version

# replace the pod name of clusterpedia apiserver
$ kubectl -n clusterpedia-system exec {clusterpedia-apiserver-pod-name} -- apiserver --version=raw
version.Info{GitVersion:"v0.7.1-rc.0", GitCommit:"cbf0518f039ba8e38b41edeb6ac94460e90653eb", GitTreeState:"clean", BuildDate:"2023-11-27T11:04:51Z", GoVersion:"go1.19.5", Compiler:"gc", Platform:"linux/amd64", KubeVersion:"v1.26.3"}

# replace the pod name of clusterpedia clustersynchro-manager
$ kubectl -n clusterpedia-system exec {clustersynchro-manager-pod-name} -- clustersynchro-manager --version=raw
version.Info{GitVersion:"v0.7.1-rc.0", GitCommit:"cbf0518f039ba8e38b41edeb6ac94460e90653eb", GitTreeState:"clean", BuildDate:"2023-11-27T11:13:35Z", GoVersion:"go1.19.5", Compiler:"gc", Platform:"linux/amd64", KubeVersion:"v1.26.3"}

Host Kubernetes version

$ kubectl version
WARNING: This version information is deprecated and will be replaced with the output from kubectl version --short.  Use --output=yaml|json to get the full version.
Client Version: version.Info{Major:"1", Minor:"26", GitVersion:"v1.26.5", GitCommit:"890a139214b4de1f01543d15003b5bda71aae9c7", GitTreeState:"clean", BuildDate:"2023-05-17T14:14:46Z", GoVersion:"go1.19.9", Compiler:"gc", Platform:"linux/amd64"}
Kustomize Version: v4.5.7
Server Version: version.Info{Major:"1", Minor:"23", GitVersion:"v1.23.5", GitCommit:"c285e781331a3785a7f436042c65c5641ce8a9e9", GitTreeState:"clean", BuildDate:"2022-03-16T15:52:18Z", GoVersion:"go1.17.8", Compiler:"gc", Platform:"linux/amd64"}
WARNING: version difference between client (1.26) and server (1.23) exceeds the supported minor version skew of +/-1

Hi @usernameisnull,
Thanks for opening an issue!
We will look into it as soon as possible.

Details

Instructions for interacting with me using comments are available here.
If you have questions or suggestions related to my behavior, please file an issue against the gh-ci-bot repository.