[BUG] postgresql cluster has multiple primary during restart operation

[JashBook]

Describe the bug

kbcli version
Kubernetes: v1.27.9
KubeBlocks: 0.8.2-beta.29
kbcli: 0.8.2-beta.25

To Reproduce Steps to reproduce the behavior:

1. create cluster

kbcli cluster create  postgres-pielkj --termination-policy=WipeOut --cluster-definition=postgresql --cluster-version=postgresql-12.14.0 --set cpu=100m,memory=0.5Gi,replicas=2,storage=3Gi

2. restart cluster

kbcli cluster restart postgres-pielkj --auto-approve

3. See error

kbcli cluster list-instances postgres-pielkj 
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE      ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   primary   <none>       0    100m / 100m          512Mi / 512Mi                   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 17:59 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Pending   <none>    <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800   

➜  ~ kbcli cluster list-instances postgres-pielkj
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE      ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   primary   <none>       0    100m / 100m          512Mi / 512Mi                   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 17:59 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Running   <none>    <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800   

➜  ~ kbcli cluster list-instances postgres-pielkj
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE        ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   primary     <none>       0    100m / 100m          512Mi / 512Mi                   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 17:59 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Running   secondary   <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800   
➜  ~ 
➜  ~ kbcli cluster list-instances postgres-pielkj
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE      ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   primary   <none>       0    100m / 100m          512Mi / 512Mi                   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 17:59 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Running   primary   <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800  

➜  ~ kbcli cluster list-instances postgres-pielkj
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE      ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   primary   <none>       0    100m / 100m          512Mi / 512Mi                   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 17:59 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Running   primary   <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800  

  ~ kbcli cluster list-instances postgres-pielkj
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE      ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   <none>    <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:04 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Running   primary   <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800   
➜  ~ 
➜  ~ kbcli cluster list-instances postgres-pielkj
NAME                           NAMESPACE   CLUSTER           COMPONENT    STATUS    ROLE        ACCESSMODE   AZ   CPU(REQUEST/LIMIT)   MEMORY(REQUEST/LIMIT)           STORAGE    NODE                                          CREATED-TIME                 
postgres-pielkj-postgresql-0   default     postgres-pielkj   postgresql   Running   secondary   <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:04 UTC+0800   
postgres-pielkj-postgresql-1   default     postgres-pielkj   postgresql   Running   primary     <none>       0    200m / 200m          644245094400m / 644245094400m   data:3Gi   aks-testpool-55647713-vmss00001j/10.224.0.5   Mar 19,2024 18:02 UTC+0800   

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.

[github-actions[bot]]

This issue has been marked as stale because it has been open for 30 days with no activity