[BUG]apecloud-mysql: ops-request-controller component mysql call switchover action and check role label failed

[tianyue86]

Describe the env
Kubernetes: v1.31.1-aliyun.1
KubeBlocks: 1.0.0-beta.22
kbcli: 1.0.0-beta.9

To Reproduce
Steps to reproduce the behavior:

1. Create apecloud-mysql cluster with yaml below
   myproxy.yaml.txt

2. Switchover

kbcli cluster promote scale-mjyogv --auto-approve --force=true                  --component mysql  --namespace default
OpsRequest scale-mjyogv-switchover-wntlq created successfully, you can view the progress:
   kbcli cluster describe-ops scale-mjyogv-switchover-wntlq -n default

3. list ops

kbcli cluster list-ops scale-mjyogv --status all  --namespace default
NAME                            NAMESPACE   TYPE         CLUSTER        COMPONENT   STATUS    PROGRESS   CREATED-TIME                 
scale-mjyogv-switchover-wntlq   default     Switchover   scale-mjyogv   mysql       Running   0/1        Jan 13,2025 15:28 UTC+0800

4. describe ops

k describe opsrequest scale-mjyogv-switchover-wntlq
Events:
  Type     Reason                    Age                From                    Message
  ----     ------                    ----               ----                    -------
  Normal   WaitForProgressing        78s (x2 over 78s)  ops-request-controller  wait for the controller to process the OpsRequest: scale-mjyogv-switchover-wntlq in Cluster: scale-mjyogv
  Normal   ValidateOpsRequestPassed  78s                ops-request-controller  OpsRequest: scale-mjyogv-switchover-wntlq is validated
  Normal   SwitchoverStarted         78s                ops-request-controller  {"mysql":{"componentName":"mysql","instanceName":"*","OldPrimary":"scale-mjyogv-mysql-1","Cluster":"scale-mjyogv"}}
  Warning  Failed                    78s                ops-request-controller  component mysql call switchover action and check role label failed: action: switchover, error: exit code: 1: failed: action failed

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Version [e.g. 22]

Additional context
Add any other context about the problem here.

[xuriwuyun]

The ops do not seem to be functioning correctly.