source commons files source engines files source kubeblocks files source kubedb files CLUSTER_NAME: `kubectl get namespace | grep ns-yhvnl ` `kubectl create namespace ns-yhvnl` namespace/ns-yhvnl created create namespace ns-yhvnl done download kbcli `gh release list --repo apecloud/kbcli --limit 100 | (grep "1.0" || true)` `curl -fsSL https://kubeblocks.io/installer/install_cli.sh | bash -s v1.0.1` Your system is linux_amd64 Installing kbcli ... Downloading ... % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 33.6M 100 33.6M 0 0 81.8M 0 --:--:-- --:--:-- --:--:-- 81.8M kbcli installed successfully. Kubernetes: v1.32.6 KubeBlocks: 1.0.1 kbcli: 1.0.1 Make sure your docker service is running and begin your journey with kbcli: kbcli playground init For more information on how to get started, please visit: https://kubeblocks.io download kbcli v1.0.1 done Kubernetes: v1.32.6 KubeBlocks: 1.0.1 kbcli: 1.0.1 Kubernetes Env: v1.32.6 check snapshot controller check snapshot controller done POD_RESOURCES: aks kb-default-sc found aks default-vsc found found default storage class: default KubeBlocks version is:1.0.1 skip upgrade KubeBlocks current KubeBlocks version: 1.0.1 Error: no repositories to show helm repo add chaos-mesh https://charts.chaos-mesh.org "chaos-mesh" has been added to your repositories add helm chart repo chaos-mesh success chaos mesh already installed check component definition set component name:oceanbase set component version set component version:oceanbase-ce set service versions:4.3.0 set service versions sorted:4.3.0 set oceanbase-ce component definition set oceanbase-ce component definition oceanbase-ce-1.0.1 REPORT_COUNT 0:1 set replicas first:1,4.3.0 REPORT_COUNT 1:1 CLUSTER_TOPOLOGY:distribution topology distribution found in cluster definition oceanbase-ce set oceanbase-ce component definition set oceanbase-ce component definition oceanbase-ce-1.0.1 LIMIT_CPU:3 LIMIT_MEMORY:4 storage size: 50 CLUSTER_NAME:obce-tppsfh No resources found in ns-yhvnl namespace. pod_info: termination_policy:DoNotTerminate create 1 replica DoNotTerminate oceanbase-ce cluster check component definition set component definition by component version check cmpd by labels check cmpd by compDefs set component definition: oceanbase-ce-1.0.1 by component version:oceanbase-ce apiVersion: apps.kubeblocks.io/v1 kind: Cluster metadata: name: obce-tppsfh namespace: ns-yhvnl spec: clusterDef: oceanbase-ce topology: distribution terminationPolicy: DoNotTerminate componentSpecs: - name: oceanbase serviceVersion: 4.3.0 replicas: 1 disableExporter: false env: - name: ZONE_COUNT value: "1" - name: OB_USE_CLUSTER_IP value: "enabled" - name: OB_CLUSTER_ID value: "1" resources: requests: cpu: 3000m memory: 4Gi limits: cpu: 3000m memory: 4Gi volumeClaimTemplates: - name: data-file spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: "50Gi" - name: data-log spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: "50Gi" - name: log spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: "10Gi" - name: workdir spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: "100Mi" `kubectl apply -f test_create_obce-tppsfh.yaml` cluster.apps.kubeblocks.io/obce-tppsfh created apply test_create_obce-tppsfh.yaml Success `rm -rf test_create_obce-tppsfh.yaml` check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Creating Sep 11,2025 17:25 UTC+0800 clusterdefinition.kubeblocks.io/name=oceanbase-ce cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:50Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:50Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... check cluster connect done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check pod obce-tppsfh-oceanbase-0 container_name observer-container exist password 6p2Nr76Ix0 check pod obce-tppsfh-oceanbase-0 container_name metrics exist password 6p2Nr76Ix0 check pod obce-tppsfh-oceanbase-0 container_name config-manager exist password 6p2Nr76Ix0 No container logs contain secret password. describe cluster `kbcli cluster describe obce-tppsfh --namespace ns-yhvnl ` Name: obce-tppsfh Created Time: Sep 11,2025 17:25 UTC+0800 NAMESPACE CLUSTER-DEFINITION TOPOLOGY STATUS TERMINATION-POLICY ns-yhvnl oceanbase-ce distribution Running DoNotTerminate Endpoints: COMPONENT INTERNAL EXTERNAL oceanbase obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local:2881 obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local:2882 Topology: COMPONENT SERVICE-VERSION INSTANCE ROLE STATUS AZ NODE CREATED-TIME oceanbase 4.3.0 obce-tppsfh-oceanbase-0 Running 0 aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 Resources Allocation: COMPONENT INSTANCE-TEMPLATE CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE-SIZE STORAGE-CLASS oceanbase 3 / 3 4Gi / 4Gi data-file:50Gi default data-log:50Gi default log:10Gi default workdir:100Mi default Images: COMPONENT COMPONENT-DEFINITION IMAGE oceanbase oceanbase-ce-1.0.1 docker.io/apecloud/oceanbase:4.3.0.1-100000242024032211 docker.io/apecloud/obagent:4.2.1-100000092023101717 docker.io/apecloud/kubeblocks-tools:1.0.1 Data Protection: BACKUP-REPO AUTO-BACKUP BACKUP-SCHEDULE BACKUP-METHOD BACKUP-RETENTION RECOVERABLE-TIME Show cluster events: kbcli cluster list-events -n ns-yhvnl obce-tppsfh `kbcli cluster label obce-tppsfh app.kubernetes.io/instance- --namespace ns-yhvnl ` label "app.kubernetes.io/instance" not found. `kbcli cluster label obce-tppsfh app.kubernetes.io/instance=obce-tppsfh --namespace ns-yhvnl ` `kbcli cluster label obce-tppsfh --list --namespace ns-yhvnl ` NAME NAMESPACE LABELS obce-tppsfh ns-yhvnl app.kubernetes.io/instance=obce-tppsfh clusterdefinition.kubeblocks.io/name=oceanbase-ce label cluster app.kubernetes.io/instance=obce-tppsfh Success `kbcli cluster label case.name=kbcli.test1 -l app.kubernetes.io/instance=obce-tppsfh --namespace ns-yhvnl ` `kbcli cluster label obce-tppsfh --list --namespace ns-yhvnl ` NAME NAMESPACE LABELS obce-tppsfh ns-yhvnl app.kubernetes.io/instance=obce-tppsfh case.name=kbcli.test1 clusterdefinition.kubeblocks.io/name=oceanbase-ce label cluster case.name=kbcli.test1 Success `kbcli cluster label obce-tppsfh case.name=kbcli.test2 --overwrite --namespace ns-yhvnl ` `kbcli cluster label obce-tppsfh --list --namespace ns-yhvnl ` NAME NAMESPACE LABELS obce-tppsfh ns-yhvnl app.kubernetes.io/instance=obce-tppsfh case.name=kbcli.test2 clusterdefinition.kubeblocks.io/name=oceanbase-ce label cluster case.name=kbcli.test2 Success `kbcli cluster label obce-tppsfh case.name- --namespace ns-yhvnl ` `kbcli cluster label obce-tppsfh --list --namespace ns-yhvnl ` NAME NAMESPACE LABELS obce-tppsfh ns-yhvnl app.kubernetes.io/instance=obce-tppsfh clusterdefinition.kubeblocks.io/name=oceanbase-ce delete cluster label case.name Success cluster connect `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"SHOW PARAMETERS LIKE '%syslog_level%'\G;\" | mysql -h127.0.0.1 -uroot -P2881 -p6p2Nr76Ix0 " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash ` Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. *************************** 1. row *************************** zone: zone0 svr_type: observer svr_ip: 10.0.2.10 svr_port: 2882 name: syslog_level data_type: STRING value: WDIAG info: specifies the current level of logging. There are DEBUG, TRACE, WDIAG, EDIAG, INFO, WARN, ERROR, seven different log levels. section: OBSERVER scope: CLUSTER source: DEFAULT edit_level: DYNAMIC_EFFECTIVE connect cluster Success insert batch data by db client Error from server (NotFound): pods "test-db-client-executionloop-obce-tppsfh" not found `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-executionloop-obce-tppsfh --namespace ns-yhvnl ` Error from server (NotFound): pods "test-db-client-executionloop-obce-tppsfh" not found Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): pods "test-db-client-executionloop-obce-tppsfh" not found `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: test-db-client-executionloop-obce-tppsfh namespace: ns-yhvnl spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: docker.io/apecloud/dbclient:test args: - "--host" - "obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local" - "--user" - "root" - "--password" - "6p2Nr76Ix0" - "--port" - "2881" - "--dbtype" - "oceanbase" - "--test" - "executionloop" - "--duration" - "60" - "--interval" - "1" restartPolicy: Never `kubectl apply -f test-db-client-executionloop-obce-tppsfh.yaml` pod/test-db-client-executionloop-obce-tppsfh created apply test-db-client-executionloop-obce-tppsfh.yaml Success `rm -rf test-db-client-executionloop-obce-tppsfh.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 0/1 ContainerCreating 0 5s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 9s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 14s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 19s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 24s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 30s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 35s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 40s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 45s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 50s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 55s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 61s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 1/1 Running 0 66s check pod test-db-client-executionloop-obce-tppsfh status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-tppsfh 0/1 Completed 0 71s check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Running Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:50Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:50Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done --host obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local --user root --password 6p2Nr76Ix0 --port 2881 --dbtype oceanbase --test executionloop --duration 60 --interval 1 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] Execution loop start: create databases executions_loop CREATE DATABASE IF NOT EXISTS executions_loop; drop table executions_loop_table DROP TABLE IF EXISTS executions_loop.executions_loop_table; create table executions_loop_table CREATE TABLE IF NOT EXISTS executions_loop.executions_loop_table (id INT PRIMARY KEY AUTO_INCREMENT, value VARCHAR(255)); Execution loop start:INSERT INTO executions_loop.executions_loop_table (value) VALUES ('executions_loop_test_1'); [ 1s ] executions total: 68 successful: 68 failed: 0 disconnect: 0 [ 2s ] executions total: 163 successful: 163 failed: 0 disconnect: 0 [ 3s ] executions total: 260 successful: 260 failed: 0 disconnect: 0 [ 4s ] executions total: 356 successful: 356 failed: 0 disconnect: 0 [ 5s ] executions total: 454 successful: 454 failed: 0 disconnect: 0 [ 6s ] executions total: 551 successful: 551 failed: 0 disconnect: 0 [ 7s ] executions total: 650 successful: 650 failed: 0 disconnect: 0 [ 8s ] executions total: 748 successful: 748 failed: 0 disconnect: 0 [ 9s ] executions total: 847 successful: 847 failed: 0 disconnect: 0 [ 10s ] executions total: 944 successful: 944 failed: 0 disconnect: 0 [ 11s ] executions total: 1038 successful: 1038 failed: 0 disconnect: 0 [ 12s ] executions total: 1134 successful: 1134 failed: 0 disconnect: 0 [ 13s ] executions total: 1230 successful: 1230 failed: 0 disconnect: 0 [ 14s ] executions total: 1323 successful: 1323 failed: 0 disconnect: 0 [ 15s ] executions total: 1417 successful: 1417 failed: 0 disconnect: 0 [ 16s ] executions total: 1520 successful: 1520 failed: 0 disconnect: 0 [ 17s ] executions total: 1621 successful: 1621 failed: 0 disconnect: 0 [ 18s ] executions total: 1722 successful: 1722 failed: 0 disconnect: 0 [ 19s ] executions total: 1823 successful: 1823 failed: 0 disconnect: 0 [ 20s ] executions total: 1928 successful: 1928 failed: 0 disconnect: 0 [ 21s ] executions total: 2031 successful: 2031 failed: 0 disconnect: 0 [ 22s ] executions total: 2132 successful: 2132 failed: 0 disconnect: 0 [ 23s ] executions total: 2232 successful: 2232 failed: 0 disconnect: 0 [ 24s ] executions total: 2333 successful: 2333 failed: 0 disconnect: 0 [ 25s ] executions total: 2435 successful: 2435 failed: 0 disconnect: 0 [ 26s ] executions total: 2542 successful: 2542 failed: 0 disconnect: 0 [ 27s ] executions total: 2646 successful: 2646 failed: 0 disconnect: 0 [ 28s ] executions total: 2747 successful: 2747 failed: 0 disconnect: 0 [ 29s ] executions total: 2848 successful: 2848 failed: 0 disconnect: 0 [ 30s ] executions total: 2949 successful: 2949 failed: 0 disconnect: 0 [ 31s ] executions total: 3052 successful: 3052 failed: 0 disconnect: 0 [ 32s ] executions total: 3153 successful: 3153 failed: 0 disconnect: 0 [ 33s ] executions total: 3251 successful: 3251 failed: 0 disconnect: 0 [ 34s ] executions total: 3350 successful: 3350 failed: 0 disconnect: 0 [ 35s ] executions total: 3456 successful: 3456 failed: 0 disconnect: 0 [ 36s ] executions total: 3560 successful: 3560 failed: 0 disconnect: 0 [ 37s ] executions total: 3661 successful: 3661 failed: 0 disconnect: 0 [ 38s ] executions total: 3766 successful: 3766 failed: 0 disconnect: 0 [ 39s ] executions total: 3870 successful: 3870 failed: 0 disconnect: 0 [ 40s ] executions total: 3974 successful: 3974 failed: 0 disconnect: 0 [ 41s ] executions total: 4077 successful: 4077 failed: 0 disconnect: 0 [ 42s ] executions total: 4180 successful: 4180 failed: 0 disconnect: 0 [ 43s ] executions total: 4280 successful: 4280 failed: 0 disconnect: 0 [ 44s ] executions total: 4384 successful: 4384 failed: 0 disconnect: 0 [ 45s ] executions total: 4487 successful: 4487 failed: 0 disconnect: 0 [ 46s ] executions total: 4589 successful: 4589 failed: 0 disconnect: 0 [ 47s ] executions total: 4686 successful: 4686 failed: 0 disconnect: 0 [ 48s ] executions total: 4785 successful: 4785 failed: 0 disconnect: 0 [ 49s ] executions total: 4889 successful: 4889 failed: 0 disconnect: 0 [ 50s ] executions total: 4992 successful: 4992 failed: 0 disconnect: 0 [ 51s ] executions total: 5096 successful: 5096 failed: 0 disconnect: 0 [ 52s ] executions total: 5198 successful: 5198 failed: 0 disconnect: 0 [ 53s ] executions total: 5296 successful: 5296 failed: 0 disconnect: 0 [ 54s ] executions total: 5394 successful: 5394 failed: 0 disconnect: 0 [ 55s ] executions total: 5498 successful: 5498 failed: 0 disconnect: 0 [ 56s ] executions total: 5599 successful: 5599 failed: 0 disconnect: 0 [ 57s ] executions total: 5701 successful: 5701 failed: 0 disconnect: 0 [ 58s ] executions total: 5806 successful: 5806 failed: 0 disconnect: 0 [ 59s ] executions total: 5906 successful: 5906 failed: 0 disconnect: 0 [ 60s ] executions total: 5980 successful: 5980 failed: 0 disconnect: 0 Test Result: Total Executions: 5980 Successful Executions: 5980 Failed Executions: 0 Disconnection Counts: 0 Connection Information: Database Type: oceanbase Host: obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local Port: 2881 Database: Table: User: root Org: Access Mode: mysql Test Type: executionloop Query: Duration: 60 seconds Interval: 1 seconds DB_CLIENT_BATCH_DATA_COUNT: 5980 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-executionloop-obce-tppsfh --namespace ns-yhvnl ` pod/test-db-client-executionloop-obce-tppsfh patched (no change) Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "test-db-client-executionloop-obce-tppsfh" force deleted get oceanbase compatibility mode ob_compatibility_mode: COMPATIBILITY_MOD:mysql check tenant role CLUSTER_TOPOLOGY:distribution topology distribution found in cluster definition oceanbase-ce The distribution ob cluster does not have tenant. `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; DROP TABLE IF EXISTS tmp_table; CREATE TABLE IF NOT EXISTS tmp_table (id INT PRIMARY KEY AUTO_INCREMENT, value VARCHAR(255)); INSERT INTO tmp_table (value) VALUES ('mrczo');\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. add consistent data mrczo Success skip cluster restart: not support skip cluster vscale: not support test failover connectionstress check cluster status before cluster-failover-connectionstress check cluster status done cluster_status:Running role name is Error from server (NotFound): pods "test-db-client-connectionstress-obce-tppsfh" not found `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-connectionstress-obce-tppsfh --namespace ns-yhvnl ` Error from server (NotFound): pods "test-db-client-connectionstress-obce-tppsfh" not found Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. Error from server (NotFound): pods "test-db-client-connectionstress-obce-tppsfh" not found `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: test-db-client-connectionstress-obce-tppsfh namespace: ns-yhvnl spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: docker.io/apecloud/dbclient:test args: - "--host" - "obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local" - "--user" - "root" - "--password" - "6p2Nr76Ix0" - "--port" - "2881" - "--database" - "oceanbase" - "--dbtype" - "oceanbase" - "--test" - "connectionstress" - "--connections" - "5000" - "--duration" - "60" restartPolicy: Never `kubectl apply -f test-db-client-connectionstress-obce-tppsfh.yaml` pod/test-db-client-connectionstress-obce-tppsfh created apply test-db-client-connectionstress-obce-tppsfh.yaml Success `rm -rf test-db-client-connectionstress-obce-tppsfh.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-tppsfh 1/1 Running 0 5s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-tppsfh 1/1 Running 0 9s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-tppsfh 1/1 Running 0 14s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-tppsfh 1/1 Running 0 19s check pod test-db-client-connectionstress-obce-tppsfh status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-tppsfh 0/1 Completed 0 25s check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Running Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:50Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:50Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done --host obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local --user root --password 6p2Nr76Ix0 --port 2881 --database oceanbase --dbtype oceanbase --test connectionstress --connections 5000 --duration 60 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] Test Result: Created 5000 connections Connection Information: Database Type: oceanbase Host: obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local Port: 2881 Database: oceanbase Table: User: root Org: Access Mode: mysql Test Type: connectionstress Connection Count: 5000 Duration: 60 seconds `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge pods test-db-client-connectionstress-obce-tppsfh --namespace ns-yhvnl ` pod/test-db-client-connectionstress-obce-tppsfh patched (no change) Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "test-db-client-connectionstress-obce-tppsfh" force deleted check failover pod name role name is failover pod name:obce-tppsfh-oceanbase-0 failover connectionstress Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success `kubectl get pvc -l app.kubernetes.io/instance=obce-tppsfh,apps.kubeblocks.io/component-name=oceanbase,apps.kubeblocks.io/vct-name=data-file --namespace ns-yhvnl ` cluster volume-expand check cluster status before ops check cluster status done cluster_status:Running No resources found in obce-tppsfh namespace. `kbcli cluster volume-expand obce-tppsfh --auto-approve --force=true --components oceanbase --volume-claim-templates data-file --storage 52Gi --namespace ns-yhvnl ` OpsRequest obce-tppsfh-volumeexpansion-rbg9r created successfully, you can view the progress: kbcli cluster describe-ops obce-tppsfh-volumeexpansion-rbg9r -n ns-yhvnl check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-volumeexpansion-rbg9r ns-yhvnl VolumeExpansion obce-tppsfh oceanbase Running 0/1 Sep 11,2025 17:30 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Updating Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:50Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done No resources found in obce-tppsfh namespace. check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-volumeexpansion-rbg9r ns-yhvnl VolumeExpansion obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:30 UTC+0800 check ops status done ops_status:obce-tppsfh-volumeexpansion-rbg9r ns-yhvnl VolumeExpansion obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:30 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-volumeexpansion-rbg9r --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-volumeexpansion-rbg9r patched `kbcli cluster delete-ops --name obce-tppsfh-volumeexpansion-rbg9r --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-volumeexpansion-rbg9r deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success `kubectl get pvc -l app.kubernetes.io/instance=obce-tppsfh,apps.kubeblocks.io/component-name=oceanbase,apps.kubeblocks.io/vct-name=data-log --namespace ns-yhvnl ` cluster volume-expand check cluster status before ops check cluster status done cluster_status:Running No resources found in obce-tppsfh namespace. `kbcli cluster volume-expand obce-tppsfh --auto-approve --force=true --components oceanbase --volume-claim-templates data-log --storage 55Gi --namespace ns-yhvnl ` OpsRequest obce-tppsfh-volumeexpansion-f5rdp created successfully, you can view the progress: kbcli cluster describe-ops obce-tppsfh-volumeexpansion-f5rdp -n ns-yhvnl check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-volumeexpansion-f5rdp ns-yhvnl VolumeExpansion obce-tppsfh oceanbase Running 0/1 Sep 11,2025 17:34 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Updating Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done No resources found in obce-tppsfh namespace. check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-volumeexpansion-f5rdp ns-yhvnl VolumeExpansion obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:34 UTC+0800 check ops status done ops_status:obce-tppsfh-volumeexpansion-f5rdp ns-yhvnl VolumeExpansion obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:34 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-volumeexpansion-f5rdp --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-volumeexpansion-f5rdp patched `kbcli cluster delete-ops --name obce-tppsfh-volumeexpansion-f5rdp --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-volumeexpansion-f5rdp deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success skip cluster stop: not support cluster oceanbase scale-out cluster oceanbase scale-out replicas: 2 check cluster status before ops check cluster status done cluster_status:Running No resources found in obce-tppsfh namespace. `kbcli cluster scale-out obce-tppsfh --auto-approve --force=true --components oceanbase --replicas 1 --namespace ns-yhvnl ` OpsRequest obce-tppsfh-horizontalscaling-shbmv created successfully, you can view the progress: kbcli cluster describe-ops obce-tppsfh-horizontalscaling-shbmv -n ns-yhvnl check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-horizontalscaling-shbmv ns-yhvnl HorizontalScaling obce-tppsfh oceanbase Running 0/1 Sep 11,2025 17:40 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Updating Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi obce-tppsfh-oceanbase-1 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000001/10.224.0.6 Sep 11,2025 17:40 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done No resources found in obce-tppsfh namespace. check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-horizontalscaling-shbmv ns-yhvnl HorizontalScaling obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:40 UTC+0800 check ops status done ops_status:obce-tppsfh-horizontalscaling-shbmv ns-yhvnl HorizontalScaling obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:40 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-horizontalscaling-shbmv --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-horizontalscaling-shbmv patched `kbcli cluster delete-ops --name obce-tppsfh-horizontalscaling-shbmv --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-horizontalscaling-shbmv deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success cluster oceanbase scale-in cluster oceanbase scale-in replicas: 1 check cluster status before ops check cluster status done cluster_status:Running No resources found in obce-tppsfh namespace. `kbcli cluster scale-in obce-tppsfh --auto-approve --force=true --components oceanbase --replicas 1 --namespace ns-yhvnl ` OpsRequest obce-tppsfh-horizontalscaling-xmqj4 created successfully, you can view the progress: kbcli cluster describe-ops obce-tppsfh-horizontalscaling-xmqj4 -n ns-yhvnl check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-horizontalscaling-xmqj4 ns-yhvnl HorizontalScaling obce-tppsfh oceanbase Running -/- Sep 11,2025 17:41 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Updating Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done No resources found in obce-tppsfh namespace. check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-horizontalscaling-xmqj4 ns-yhvnl HorizontalScaling obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:41 UTC+0800 check ops status done ops_status:obce-tppsfh-horizontalscaling-xmqj4 ns-yhvnl HorizontalScaling obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:41 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-horizontalscaling-xmqj4 --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-horizontalscaling-xmqj4 patched `kbcli cluster delete-ops --name obce-tppsfh-horizontalscaling-xmqj4 --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-horizontalscaling-xmqj4 deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success cluster configure component_tmp: oceanbase apiVersion: operations.kubeblocks.io/v1alpha1 kind: OpsRequest metadata: generateName: obce-tppsfh-reconfiguring- namespace: ns-yhvnl spec: type: Reconfiguring clusterName: obce-tppsfh force: true reconfigures: - componentName: oceanbase parameters: - key: system_memory value: '2G' check cluster status before ops check cluster status done cluster_status:Running `kubectl create -f test_ops_cluster_obce-tppsfh.yaml` opsrequest.operations.kubeblocks.io/obce-tppsfh-reconfiguring-wbbnd created create test_ops_cluster_obce-tppsfh.yaml Success `rm -rf test_ops_cluster_obce-tppsfh.yaml` check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-reconfiguring-wbbnd ns-yhvnl Reconfiguring obce-tppsfh oceanbase,oceanbase Running -/- Sep 11,2025 17:42 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Running Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-reconfiguring-wbbnd ns-yhvnl Reconfiguring obce-tppsfh oceanbase,oceanbase Succeed -/- Sep 11,2025 17:42 UTC+0800 check ops status done ops_status:obce-tppsfh-reconfiguring-wbbnd ns-yhvnl Reconfiguring obce-tppsfh oceanbase,oceanbase Succeed -/- Sep 11,2025 17:42 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-reconfiguring-wbbnd --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-reconfiguring-wbbnd patched `kbcli cluster delete-ops --name obce-tppsfh-reconfiguring-wbbnd --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-reconfiguring-wbbnd deleted component_config:oceanbase check config variables `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. current value_actual: 2G configure:[system_memory] result actual:[2G] equal expected:[2G] `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success 10 skip cluster SwitchOver: not support `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: benchtest-obce-tppsfh namespace: ns-yhvnl spec: containers: - name: test-sysbench imagePullPolicy: IfNotPresent image: docker.io/apecloud/customsuites:latest env: - name: TYPE value: "2" - name: FLAG value: "0" - name: CONFIGS value: "mode:all,driver:mysql,host:obce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local,user:root,password:6p2Nr76Ix0,port:2881,db:benchtest,tables:5,threads:4,times:10,size:1000,type:oltp_read_write" restartPolicy: Never `kubectl apply -f benchtest-obce-tppsfh.yaml` pod/benchtest-obce-tppsfh created apply benchtest-obce-tppsfh.yaml Success check pod status pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 0/1 ContainerCreating 0 0s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 5s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 10s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 25s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 30s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 36s check pod benchtest-obce-tppsfh status done pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 0/1 Completed 0 41s `rm -rf benchtest-obce-tppsfh.yaml` `kubectl logs benchtest-obce-tppsfh --tail 30 --namespace ns-yhvnl ` [ 7s ] thds: 4 tps: 126.01 qps: 2511.27 (r/w/o: 1755.19/504.05/252.03) lat (ms,99%): 63.32 err/s: 0.00 reconn/s: 0.00 [ 8s ] thds: 4 tps: 122.02 qps: 2441.50 (r/w/o: 1705.35/492.10/244.05) lat (ms,99%): 57.87 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 4 tps: 123.97 qps: 2505.46 (r/w/o: 1753.62/503.89/247.95) lat (ms,99%): 52.89 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 131.02 qps: 2608.38 (r/w/o: 1830.26/516.07/262.04) lat (ms,99%): 54.83 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 17668 write: 5048 other: 2524 total: 25240 transactions: 1262 (125.66 per sec.) queries: 25240 (2513.18 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0416s total number of events: 1262 Latency (ms): min: 12.69 avg: 31.76 max: 71.71 99th percentile: 55.82 sum: 40077.41 Threads fairness: events (avg/stddev): 315.5000/2.96 execution time (avg/stddev): 10.0194/0.01 `kubectl delete pod benchtest-obce-tppsfh --force --namespace ns-yhvnl ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "benchtest-obce-tppsfh" force deleted LB_TYPE is set to: intranet cluster expose check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster expose obce-tppsfh --auto-approve --force=true --type intranet --enable true --components oceanbase --namespace ns-yhvnl ` OpsRequest obce-tppsfh-expose-bxsss created successfully, you can view the progress: kbcli cluster describe-ops obce-tppsfh-expose-bxsss -n ns-yhvnl check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-expose-bxsss ns-yhvnl Expose obce-tppsfh Running -/- Sep 11,2025 17:44 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce DoNotTerminate Running Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-expose-bxsss ns-yhvnl Expose obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:44 UTC+0800 check ops status done ops_status:obce-tppsfh-expose-bxsss ns-yhvnl Expose obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:44 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-expose-bxsss --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-expose-bxsss patched `kbcli cluster delete-ops --name obce-tppsfh-expose-bxsss --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-expose-bxsss deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success LB_TYPE is set to: intranet No resources found in ns-yhvnl namespace. `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: benchtest-obce-tppsfh namespace: ns-yhvnl spec: containers: - name: test-sysbench imagePullPolicy: IfNotPresent image: docker.io/apecloud/customsuites:latest env: - name: TYPE value: "2" - name: FLAG value: "0" - name: CONFIGS value: "mode:all,driver:mysql,host:10.224.0.9,user:root,password:6p2Nr76Ix0,port:2881,db:benchtest,tables:5,threads:4,times:10,size:1000,type:oltp_read_write" restartPolicy: Never `kubectl apply -f benchtest-obce-tppsfh.yaml` pod/benchtest-obce-tppsfh created apply benchtest-obce-tppsfh.yaml Success check pod status pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 0/1 ContainerCreating 0 0s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 5s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 10s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 25s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 1/1 Running 0 30s check pod benchtest-obce-tppsfh status done pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-tppsfh 0/1 Completed 0 36s `rm -rf benchtest-obce-tppsfh.yaml` `kubectl logs benchtest-obce-tppsfh --tail 30 --namespace ns-yhvnl ` [ 7s ] thds: 4 tps: 122.00 qps: 2446.00 (r/w/o: 1710.00/492.00/244.00) lat (ms,99%): 55.82 err/s: 0.00 reconn/s: 0.00 [ 8s ] thds: 4 tps: 127.00 qps: 2532.09 (r/w/o: 1776.06/502.02/254.01) lat (ms,99%): 57.87 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 4 tps: 122.99 qps: 2446.83 (r/w/o: 1706.88/493.97/245.98) lat (ms,99%): 50.11 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 119.00 qps: 2394.07 (r/w/o: 1680.05/476.01/238.01) lat (ms,99%): 56.84 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 18354 write: 5244 other: 2622 total: 26220 transactions: 1311 (130.66 per sec.) queries: 26220 (2613.22 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0319s total number of events: 1311 Latency (ms): min: 13.49 avg: 30.56 max: 64.84 99th percentile: 54.83 sum: 40062.84 Threads fairness: events (avg/stddev): 327.7500/5.45 execution time (avg/stddev): 10.0157/0.01 `kubectl delete pod benchtest-obce-tppsfh --force --namespace ns-yhvnl ` Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. pod "benchtest-obce-tppsfh" force deleted cluster update terminationPolicy WipeOut `kbcli cluster update obce-tppsfh --termination-policy=WipeOut --namespace ns-yhvnl ` cluster.apps.kubeblocks.io/obce-tppsfh updated check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce WipeOut Running Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done cluster list-logs `kbcli cluster list-logs obce-tppsfh --namespace ns-yhvnl ` No log files found. role name is Error from server (NotFound): pods "obce-tppsfh-oceanbase-0" not found cluster logs `kbcli cluster logs obce-tppsfh --tail 30 --namespace ns-yhvnl ` Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Wait for observer on this node to be ready observer on this node is not ready, wait for a moment... Creating readiness flag... Choose the first RS to bootstrap cluster Wait for all Rootservice to be ready Replica 10.0.2.10 is not up yet Replica 10.0.2.10 is not up yet Replica 10.0.2.10 is not up yet Replica 10.0.2.10 is up zone_server_list: ZONE 'zone0' SERVER '10.0.2.10:2882' ALTER SYSTEM BOOTSTRAP ZONE 'zone0' SERVER '10.0.2.10:2882'; *************************** 1. row *************************** SVR_IP: 10.0.2.10 SVR_PORT: 2882 ID: 1 ZONE: zone0 SQL_PORT: 2881 WITH_ROOTSERVER: YES STATUS: ACTIVE START_SERVICE_TIME: 2025-09-11 17:27:48.312506 STOP_TIME: NULL BLOCK_MIGRATE_IN_TIME: NULL CREATE_TIME: 2025-09-11 17:27:45.397058 MODIFY_TIME: 2025-09-11 17:27:48.971421 BUILD_VERSION: 4.3.0.1_100000242024032211-0193a343bc60b4699ec47792c3fc4ce166a182f9(Mar 22 2024 13:07:59) LAST_OFFLINE_TIME: NULL update root password root password has been updated Bootstrap successfully Cluster starts successfully LB_TYPE is set to: intranet cluster expose check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster expose obce-tppsfh --auto-approve --force=true --type intranet --enable false --components oceanbase --namespace ns-yhvnl ` OpsRequest obce-tppsfh-expose-czb79 created successfully, you can view the progress: kbcli cluster describe-ops obce-tppsfh-expose-czb79 -n ns-yhvnl check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-expose-czb79 ns-yhvnl Expose obce-tppsfh Running -/- Sep 11,2025 17:46 UTC+0800 check cluster status `kbcli cluster list obce-tppsfh --show-labels --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-tppsfh ns-yhvnl oceanbase-ce WipeOut Running Sep 11,2025 17:25 UTC+0800 app.kubernetes.io/instance=obce-tppsfh,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-tppsfh --namespace ns-yhvnl ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-tppsfh-oceanbase-0 ns-yhvnl obce-tppsfh oceanbase Running 0 3200m / 4 4352Mi / 5Gi data-file:52Gi aks-cicdamdpool-34679673-vmss000000/10.224.0.8 Sep 11,2025 17:25 UTC+0800 data-log:55Gi log:10Gi workdir:100Mi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check cluster connect done check ops status `kbcli cluster list-ops obce-tppsfh --status all --namespace ns-yhvnl ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-tppsfh-expose-czb79 ns-yhvnl Expose obce-tppsfh oceanbase Running 0/1 Sep 11,2025 17:46 UTC+0800 ops_status:obce-tppsfh-expose-czb79 ns-yhvnl Expose obce-tppsfh oceanbase Running 0/1 Sep 11,2025 17:46 UTC+0800 ops_status:obce-tppsfh-expose-czb79 ns-yhvnl Expose obce-tppsfh oceanbase Running 0/1 Sep 11,2025 17:46 UTC+0800 check ops status done ops_status:obce-tppsfh-expose-czb79 ns-yhvnl Expose obce-tppsfh oceanbase Succeed 1/1 Sep 11,2025 17:46 UTC+0800 `kubectl patch -p '***"metadata":***"finalizers":[]***' --type=merge opsrequests.operations obce-tppsfh-expose-czb79 --namespace ns-yhvnl ` opsrequest.operations.kubeblocks.io/obce-tppsfh-expose-czb79 patched `kbcli cluster delete-ops --name obce-tppsfh-expose-czb79 --force --auto-approve --namespace ns-yhvnl ` OpsRequest obce-tppsfh-expose-czb79 deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check data: Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) Unable to use a TTY - input is not a terminal or the right kind of file Warning: arning] Using a password on the command line interface can be insecure. value mrczo check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-tppsfh` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.username***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.password***"` `kubectl get secrets obce-tppsfh-oceanbase-account-root -o jsonpath="***.data.port***"` DB_USERNAME:root;DB_PASSWORD:6p2Nr76Ix0;DB_PORT:2881;DB_DATABASE:oceanbase role name is check db_client batch data count `echo " echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -hobce-tppsfh-oceanbase-ordinal-0.ns-yhvnl.svc.cluster.local -uroot -P2881 -p'6p2Nr76Ix0' " | kubectl exec -it obce-tppsfh-oceanbase-0 --namespace ns-yhvnl -- bash` check db_client batch data Success delete cluster obce-tppsfh `kbcli cluster delete obce-tppsfh --auto-approve --namespace ns-yhvnl ` Cluster obce-tppsfh deleted pod_info:obce-tppsfh-oceanbase-0 3/3 Running 0 21m pod_info:obce-tppsfh-oceanbase-0 3/3 Terminating 0 21m No resources found in ns-yhvnl namespace. delete cluster pod done No resources found in ns-yhvnl namespace. check cluster resource non-exist OK: pvc No resources found in ns-yhvnl namespace. delete cluster done No resources found in ns-yhvnl namespace. No resources found in ns-yhvnl namespace. No resources found in ns-yhvnl namespace. OceanBase CE Test Suite All Done! Test Engine: oceanbase-ce Test Type: 16 --------------------------------------OceanBase CE (Topology = distribution Replicas 1) Test Result-------------------------------------- [PASSED]|[Create]|[ComponentDefinition=oceanbase-ce-1.0.1;ComponentVersion=oceanbase-ce;ServiceVersion=4.3.0;]|[Description=Create a cluster with the specified component definition oceanbase-ce-1.0.1 and component version oceanbase-ce and service version 4.3.0] [PASSED]|[Connect]|[ComponentName=oceanbase]|[Description=Connect to the cluster] [PASSED]|[AddData]|[Values=mrczo]|[Description=Add data to the cluster] [PASSED]|[No-Failover]|[HA=Connection Stress;ComponentName=oceanbase]|[Description=Simulates conditions where pods experience connection stress either due to expected/undesired processes thereby testing the application's resilience to potential slowness/unavailability of some replicas due to high Connection load.] [PASSED]|[VolumeExpansion]|[ComponentName=oceanbase;ComponentVolume=data-file]|[Description=VolumeExpansion the cluster specify component oceanbase and volume data-file] [PASSED]|[VolumeExpansion]|[ComponentName=oceanbase;ComponentVolume=data-log]|[Description=VolumeExpansion the cluster specify component oceanbase and volume data-log] [PASSED]|[HorizontalScaling Out]|[ComponentName=oceanbase]|[Description=HorizontalScaling Out the cluster specify component oceanbase] [PASSED]|[HorizontalScaling In]|[ComponentName=oceanbase]|[Description=HorizontalScaling In the cluster specify component oceanbase] [PASSED]|[Reconfiguring]|[ComponentName=oceanbase;system_memory=2G]|[Description=Reconfiguring the cluster specify component oceanbase set system_memory=2G] [PASSED]|[Bench]|[ComponentName=oceanbase]|[Description=Bench the cluster service with oceanbase component] [PASSED]|[Expose]|[Enable=true;TYPE=intranet;ComponentName=oceanbase]|[Description=Expose Enable the intranet service with oceanbase component] [PASSED]|[Bench]|[HostType=LB;ComponentName=oceanbase]|[Description=Bench the cluster LB service with oceanbase component] [PASSED]|[Update]|[TerminationPolicy=WipeOut]|[Description=Update the cluster TerminationPolicy WipeOut] [PASSED]|[Expose]|[Disable=true;TYPE=intranet;ComponentName=oceanbase]|[Description=Expose Disable the intranet service with oceanbase component] [PASSED]|[Delete]|[-]|[Description=Delete the cluster] [END]