[BUG] mysql orchestrator reconfigure binlog_expire_logs_seconds not effective

[JashBook]

Describe the bug
A clear and concise description of what the bug is.

kbcli version 
Kubernetes: v1.30.4-vke.4
KubeBlocks: 1.0.2-beta.22
kbcli: 1.0.2-beta.0
➜  ~ 
➜  ~ helm get notes -n kb-system kb-addon-orchestrator
NOTES:
1. Get the application URL by running these commands:


Release Information:
  Commit ID: "9d6703e8c53e9eb1823052bbecc2cb623ca28ccf"
  Commit Time: "2025-12-30 17:29:35 +0800"
  Release Branch: "release-1.0"
  Release Time:  "2025-12-30 17:30:17 +0800"
  Enterprise: "false"

➜  ~ 
➜  ~ helm get notes -n kb-system kb-addon-mysql       
NOTES:
1. Get the application URL by running these commands:


Release Information:
  Commit ID: "4dd61d950baaf84f8a7045418fae81eeacb7a518"
  Commit Time: "2025-12-26 14:48:12 +0800"
  Release Branch: "v1.0.2-beta.22"
  Release Time:  "2025-12-30 14:19:05 +0800"
  Enterprise: "false"

To Reproduce
Steps to reproduce the behavior:

1. create cluster

apiVersion: apps.kubeblocks.io/v1
kind: Cluster
metadata:
  name: orcm-txpdnb
  namespace: default
spec:
  clusterDef: orchestrator
  topology: raft
  terminationPolicy: WipeOut
  services:
    - name: orchestrator
      componentSelector: orchestrator
      spec:
        ports:
          - name: orc-http
            port: 80
  componentSpecs:
    - name: orchestrator
      serviceVersion: 3.2.6
      replicas: 3
      resources:
        requests:
          cpu: 500m
          memory: 0.5Gi
        limits:
          cpu: 500m
          memory: 0.5Gi
      volumeClaimTemplates:
        - name: data
          spec:
            storageClassName: 
            accessModes:
              - ReadWriteOnce
            resources:
              requests:
                storage: 20Gi

apiVersion: apps.kubeblocks.io/v1
kind: Cluster
metadata:
  name: mysql-txpdnb
  namespace: default
spec:
  clusterDef: mysql
  topology: orc
  terminationPolicy: WipeOut
  componentSpecs:
    - name: mysql
      serviceVersion: 8.0.33
      
      disableExporter: true
      replicas: 2
      resources:
        limits:
          cpu: 500m
          memory: 0.5Gi
        requests:
          cpu: 500m
          memory: 0.5Gi
      volumeClaimTemplates:
        - name: data
          spec:
            storageClassName: 
            accessModes:
              - ReadWriteOnce
            resources:
              requests:
                storage: 20Gi
      serviceRefs:
      - name: orchestrator
        namespace: default
        clusterServiceSelector:
          cluster: orcm-txpdnb
          service:
            component: orchestrator
            service: orchestrator
            port: orc-http
          credential:
            component: orchestrator
            name: orchestrator

2. reconfigure

kubectl create -f -<<EOF
apiVersion: operations.kubeblocks.io/v1alpha1
kind: OpsRequest
metadata:
  generateName: mysql-txpdnb-reconfiguring-
  namespace: default
spec:
  type: Reconfiguring
  clusterName: mysql-txpdnb
  force: true
  reconfigures:
  - componentName: mysql
    parameters:
        - key: binlog_expire_logs_seconds
          value: '691200'
EOF

 `kbcli cluster list-ops mysql-txpdnb --status all  --namespace default `
    
NAME                               NAMESPACE   TYPE            CLUSTER        COMPONENT     STATUS    PROGRESS   CREATED-TIME                 
mysql-txpdnb-reconfiguring-tv8nk   default     Reconfiguring   mysql-txpdnb   mysql,mysql   Succeed   -/-        Dec 30,2025 17:39 UTC+0800   

get cm

kubectl get cm mysql-txpdnb-mysql-mysql-replication-config -oyaml|grep binlog_expire_logs_seconds
    binlog_expire_logs_seconds=691200
    config.kubeblocks.io/config-applied-version: '{"name":"mysql-replication-config","payload":{"componentResource":{"limits":{"cpu":"500m","memory":"512Mi"},"requests":{"cpu":"500m","memory":"512Mi"}}},"configSpec":{"name":"mysql-replication-config","template":"mysql-8.0-config-template","namespace":"kb-system","volumeName":"mysql-config","externalManaged":true},"configFileParams":{"my.cnf":{"content":null,"parameters":{"binlog_expire_logs_seconds":"691200"}}}}'

3. See error

kubectl exec -it mysql-txpdnb-mysql-1 --namespace default -- bash

bash-4.4# mysql -P3306 -hmysql-txpdnb-mysql-server -uroot -p'0kax42W1g4'

mysql> show variables like 'binlog_expire_logs_seconds';
+----------------------------+--------+
| Variable_name              | Value  |
+----------------------------+--------+
| binlog_expire_logs_seconds | 604800 |
+----------------------------+--------+
1 row in set (0.00 sec)

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.

[shanshanying]

admin password and username used to log in are invalid. will check how to set the variables.