source commons files source engines files source kubeblocks files kbcli is detected: /usr/local/bin/kbcli Kubernetes Env: v1.30.4-vke.4 check snapshot controller check snapshot controller done vke kb-default-sc found vke default-vsc found POD_RESOURCES: No resources found found default storage class: ebs-ssd KubeBlocks version is:1.0.0 skip upgrade KubeBlocks current KubeBlocks version: 1.0.0 check component definition No resources found KUBEBLOCKS NAMESPACE:kb-system get kubeblocks namespace done annotate oceanbase-ce cmpd apps.kubeblocks.io/skip-immutable-check=true No resources found get helm repo list success found helm repo kbcli-test-addons `helm repo update kbcli-test-addons ` Hang tight while we grab the latest from your chart repositories... ...Successfully got an update from the "kbcli-test-addons" chart repository Update Complete. ⎈Happy Helming!⎈ KUBEBLOCKS NAMESPACE:kb-system get kubeblocks namespace done current KubeBlocks version: 1.0.0 `helm upgrade --install --namespace kb-system kb-addon-oceanbase-ce kbcli-test-addons/oceanbase-ce --version 1.0.0-alpha.0 --set image.registry=apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com --set images.registry=apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com ` Release "kb-addon-oceanbase-ce" does not exist. Installing it now. NAME: kb-addon-oceanbase-ce LAST DEPLOYED: Wed May 28 13:45:10 2025 NAMESPACE: kb-system STATUS: deployed REVISION: 1 TEST SUITE: None NOTES: /** * Copyright (c) 2021 OceanBase * OceanBase CE is licensed under Mulan PubL v2. * You can use this software according to the terms and conditions of the Mulan PubL v2. * You may obtain a copy of Mulan PubL v2 at: * http://license.coscl.org.cn/MulanPubL-2.0 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. * See the Mulan PubL v2 for more details. */ Unlimited scalable distributed database for data-intensive transactional and real-time operational analytics workloads, with ultra-fast performance that has once achieved world records in the TPC-C benchmark test. OceanBase has served over 400 customers across the globe and has been supporting all mission critical systems in Alipay. Release Information: Commit ID: "d1ae752edd3ca95c1146924952edf8becaadeb0f" Commit Time: "2025-04-23 20:33:54 +0800" Release Branch: "v1.0.0" Release Time: "2025-05-28 10:53:50 +0800" Enterprise: "false" set component version set component version:oceanbase-ce set service versions:4.3.0 set service versions sorted:4.3.0 check component definition oceanbase-ce status done set component name:oceanbase found component version set oceanbase-ce component definition set oceanbase-ce component definition oceanbase-ce-1.0.0-alpha.0 set replicas first:3,4.3.0 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.0-alpha.0 LIMIT_CPU:3 LIMIT_MEMORY:4 storage size: 50 No resources found in default namespace. termination_policy:WipeOut create 3 replica WipeOut 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.0-alpha.0 by component version:oceanbase-ce apiVersion: apps.kubeblocks.io/v1 kind: Cluster metadata: name: obce-atxzpc namespace: default spec: clusterDef: oceanbase-ce topology: distribution terminationPolicy: WipeOut componentSpecs: - name: oceanbase serviceVersion: 4.3.0 replicas: 3 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: "20Gi" - name: workdir spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: "20Gi" `kubectl apply -f test_create_obce-atxzpc.yaml` cluster.apps.kubeblocks.io/obce-atxzpc created apply test_create_obce-atxzpc.yaml Success `rm -rf test_create_obce-atxzpc.yaml` check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Creating May 28,2025 13:45 UTC+0800 clusterdefinition.kubeblocks.io/name=oceanbase-ce cluster_status:Creating cluster_status:Creating cluster_status:Creating 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-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:50Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:50Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:50Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... connect checking... check cluster connect done role name is `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase check pod obce-atxzpc-oceanbase-2 container_name observer-container exist password 64ye4r0r6Q check pod obce-atxzpc-oceanbase-2 container_name metrics exist password 64ye4r0r6Q check pod obce-atxzpc-oceanbase-2 container_name config-manager exist password 64ye4r0r6Q No container logs contain secret password. describe cluster `kbcli cluster describe obce-atxzpc --namespace default ` Name: obce-atxzpc Created Time: May 28,2025 13:45 UTC+0800 NAMESPACE CLUSTER-DEFINITION TOPOLOGY STATUS TERMINATION-POLICY default oceanbase-ce distribution Running WipeOut Endpoints: COMPONENT INTERNAL EXTERNAL oceanbase obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local:2881 obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local:2882 obce-atxzpc-oceanbase-ordinal-1.default.svc.cluster.local:2881 obce-atxzpc-oceanbase-ordinal-1.default.svc.cluster.local:2882 obce-atxzpc-oceanbase-ordinal-2.default.svc.cluster.local:2881 obce-atxzpc-oceanbase-ordinal-2.default.svc.cluster.local:2882 Topology: COMPONENT SERVICE-VERSION INSTANCE ROLE STATUS AZ NODE CREATED-TIME oceanbase 4.3.0 obce-atxzpc-oceanbase-0 Running cn-guangzhou-b 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 oceanbase 4.3.0 obce-atxzpc-oceanbase-1 Running cn-guangzhou-b 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 oceanbase 4.3.0 obce-atxzpc-oceanbase-2 Running cn-guangzhou-b 192.168.0.21/192.168.0.21 May 28,2025 13:45 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 ebs-ssd data-log:50Gi ebs-ssd log:20Gi ebs-ssd workdir:20Gi ebs-ssd Images: COMPONENT COMPONENT-DEFINITION IMAGE oceanbase oceanbase-ce-1.0.0-alpha.0 apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/oceanbase:4.3.0.1-100000242024032211 apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/obagent:4.2.1-100000092023101717 apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/kubeblocks-tools:1.0.0 Data Protection: BACKUP-REPO AUTO-BACKUP BACKUP-SCHEDULE BACKUP-METHOD BACKUP-RETENTION RECOVERABLE-TIME Show cluster events: kbcli cluster list-events -n default obce-atxzpc `kbcli cluster label obce-atxzpc app.kubernetes.io/instance- --namespace default ` label "app.kubernetes.io/instance" not found. `kbcli cluster label obce-atxzpc app.kubernetes.io/instance=obce-atxzpc --namespace default ` `kbcli cluster label obce-atxzpc --list --namespace default ` NAME NAMESPACE LABELS obce-atxzpc default app.kubernetes.io/instance=obce-atxzpc clusterdefinition.kubeblocks.io/name=oceanbase-ce label cluster app.kubernetes.io/instance=obce-atxzpc Success `kbcli cluster label case.name=kbcli.test1 -l app.kubernetes.io/instance=obce-atxzpc --namespace default ` `kbcli cluster label obce-atxzpc --list --namespace default ` NAME NAMESPACE LABELS obce-atxzpc default app.kubernetes.io/instance=obce-atxzpc case.name=kbcli.test1 clusterdefinition.kubeblocks.io/name=oceanbase-ce label cluster case.name=kbcli.test1 Success `kbcli cluster label obce-atxzpc case.name=kbcli.test2 --overwrite --namespace default ` `kbcli cluster label obce-atxzpc --list --namespace default ` NAME NAMESPACE LABELS obce-atxzpc default app.kubernetes.io/instance=obce-atxzpc case.name=kbcli.test2 clusterdefinition.kubeblocks.io/name=oceanbase-ce label cluster case.name=kbcli.test2 Success `kbcli cluster label obce-atxzpc case.name- --namespace default ` `kbcli cluster label obce-atxzpc --list --namespace default ` NAME NAMESPACE LABELS obce-atxzpc default app.kubernetes.io/instance=obce-atxzpc clusterdefinition.kubeblocks.io/name=oceanbase-ce delete cluster label case.name Success cluster connect `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"SHOW PARAMETERS LIKE '%syslog_level%'\G;\" | mysql -h127.0.0.1 -uroot -P2881 -p64ye4r0r6Q " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (42000): Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES) command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 8001 (08004): Server is initializing command terminated with exit code 1 check connect cluster... 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 mysql: [Warning] Using a password on the command line interface can be insecure. *************************** 1. row *************************** zone: zone0 svr_type: observer svr_ip: 172.16.255.143 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 *************************** 2. row *************************** zone: zone0 svr_type: observer svr_ip: 172.16.252.135 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 *************************** 3. row *************************** zone: zone0 svr_type: observer svr_ip: 172.16.236.220 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: error from server (NotFound): pods "test-db-client-executionloop-obce-atxzpc" not found in namespace "default" DB_CLIENT_BATCH_DATA_COUNT: `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-executionloop-obce-atxzpc --namespace default ` Error from server (NotFound): pods "test-db-client-executionloop-obce-atxzpc" 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-atxzpc" not found `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: test-db-client-executionloop-obce-atxzpc namespace: default spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/dbclient:test args: - "--host" - "obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local" - "--user" - "root" - "--password" - "64ye4r0r6Q" - "--port" - "2881" - "--dbtype" - "oceanbase" - "--test" - "executionloop" - "--duration" - "60" - "--interval" - "1" restartPolicy: Never `kubectl apply -f test-db-client-executionloop-obce-atxzpc.yaml` pod/test-db-client-executionloop-obce-atxzpc created apply test-db-client-executionloop-obce-atxzpc.yaml Success `rm -rf test-db-client-executionloop-obce-atxzpc.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 5s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 9s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 15s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 20s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 25s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 30s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 35s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 41s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 46s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 51s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 56s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 62s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 67s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 ContainerCreating 0 72s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 77s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 82s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 88s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 93s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 98s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 103s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 108s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 114s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 119s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 2m4s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 2m9s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 2m14s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 1/1 Running 0 2m19s check pod test-db-client-executionloop-obce-atxzpc status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-obce-atxzpc 0/1 Completed 0 2m25s check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:50Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:50Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:50Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done --host obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local --user root --password 64ye4r0r6Q --port 2881 --dbtype oceanbase --test executionloop --duration 60 --interval 1 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] 05:51:42.239 [main] DEBUG com.clickhouse.jdbc.ClickHouseDriver -- ClickHouse Driver 0.0.0.0(JDBC: 0.0.0.0) registered 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: 760 successful: 760 failed: 0 disconnect: 0 [ 2s ] executions total: 1694 successful: 1694 failed: 0 disconnect: 0 [ 3s ] executions total: 2716 successful: 2716 failed: 0 disconnect: 0 [ 4s ] executions total: 4223 successful: 4223 failed: 0 disconnect: 0 [ 5s ] executions total: 5192 successful: 5192 failed: 0 disconnect: 0 [ 6s ] executions total: 6131 successful: 6131 failed: 0 disconnect: 0 [ 7s ] executions total: 7070 successful: 7070 failed: 0 disconnect: 0 [ 8s ] executions total: 8028 successful: 8028 failed: 0 disconnect: 0 [ 9s ] executions total: 8949 successful: 8949 failed: 0 disconnect: 0 [ 10s ] executions total: 9906 successful: 9906 failed: 0 disconnect: 0 [ 11s ] executions total: 10848 successful: 10848 failed: 0 disconnect: 0 [ 12s ] executions total: 11796 successful: 11796 failed: 0 disconnect: 0 [ 13s ] executions total: 12782 successful: 12782 failed: 0 disconnect: 0 [ 14s ] executions total: 13750 successful: 13750 failed: 0 disconnect: 0 [ 15s ] executions total: 14736 successful: 14736 failed: 0 disconnect: 0 [ 16s ] executions total: 15709 successful: 15709 failed: 0 disconnect: 0 [ 17s ] executions total: 16676 successful: 16676 failed: 0 disconnect: 0 [ 18s ] executions total: 17634 successful: 17634 failed: 0 disconnect: 0 [ 19s ] executions total: 18588 successful: 18588 failed: 0 disconnect: 0 [ 20s ] executions total: 19514 successful: 19514 failed: 0 disconnect: 0 [ 21s ] executions total: 20464 successful: 20464 failed: 0 disconnect: 0 [ 22s ] executions total: 21405 successful: 21405 failed: 0 disconnect: 0 [ 23s ] executions total: 22368 successful: 22368 failed: 0 disconnect: 0 [ 24s ] executions total: 23338 successful: 23338 failed: 0 disconnect: 0 [ 25s ] executions total: 24315 successful: 24315 failed: 0 disconnect: 0 [ 26s ] executions total: 25264 successful: 25264 failed: 0 disconnect: 0 [ 27s ] executions total: 26172 successful: 26172 failed: 0 disconnect: 0 [ 28s ] executions total: 27150 successful: 27150 failed: 0 disconnect: 0 [ 29s ] executions total: 28109 successful: 28109 failed: 0 disconnect: 0 [ 30s ] executions total: 29088 successful: 29088 failed: 0 disconnect: 0 [ 31s ] executions total: 30049 successful: 30049 failed: 0 disconnect: 0 [ 32s ] executions total: 31042 successful: 31042 failed: 0 disconnect: 0 [ 33s ] executions total: 32032 successful: 32032 failed: 0 disconnect: 0 [ 34s ] executions total: 33098 successful: 33098 failed: 0 disconnect: 0 [ 35s ] executions total: 34173 successful: 34173 failed: 0 disconnect: 0 [ 36s ] executions total: 35276 successful: 35276 failed: 0 disconnect: 0 [ 37s ] executions total: 36266 successful: 36266 failed: 0 disconnect: 0 [ 38s ] executions total: 37240 successful: 37240 failed: 0 disconnect: 0 [ 39s ] executions total: 38196 successful: 38196 failed: 0 disconnect: 0 [ 40s ] executions total: 39184 successful: 39184 failed: 0 disconnect: 0 [ 41s ] executions total: 40168 successful: 40168 failed: 0 disconnect: 0 [ 42s ] executions total: 41168 successful: 41168 failed: 0 disconnect: 0 [ 43s ] executions total: 42131 successful: 42131 failed: 0 disconnect: 0 [ 44s ] executions total: 43101 successful: 43101 failed: 0 disconnect: 0 [ 45s ] executions total: 44073 successful: 44073 failed: 0 disconnect: 0 [ 46s ] executions total: 45030 successful: 45030 failed: 0 disconnect: 0 [ 47s ] executions total: 45956 successful: 45956 failed: 0 disconnect: 0 [ 48s ] executions total: 46906 successful: 46906 failed: 0 disconnect: 0 [ 49s ] executions total: 47847 successful: 47847 failed: 0 disconnect: 0 [ 50s ] executions total: 48828 successful: 48828 failed: 0 disconnect: 0 [ 51s ] executions total: 49782 successful: 49782 failed: 0 disconnect: 0 [ 52s ] executions total: 50765 successful: 50765 failed: 0 disconnect: 0 [ 53s ] executions total: 51703 successful: 51703 failed: 0 disconnect: 0 [ 54s ] executions total: 52668 successful: 52668 failed: 0 disconnect: 0 [ 55s ] executions total: 53650 successful: 53650 failed: 0 disconnect: 0 [ 56s ] executions total: 54610 successful: 54610 failed: 0 disconnect: 0 [ 57s ] executions total: 55575 successful: 55575 failed: 0 disconnect: 0 [ 58s ] executions total: 56568 successful: 56568 failed: 0 disconnect: 0 [ 59s ] executions total: 57540 successful: 57540 failed: 0 disconnect: 0 [ 60s ] executions total: 58439 successful: 58439 failed: 0 disconnect: 0 Test Result: Total Executions: 58439 Successful Executions: 58439 Failed Executions: 0 Disconnection Counts: 0 Connection Information: Database Type: oceanbase Host: obce-atxzpc-oceanbase-ordinal-0.default.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: 58439 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-executionloop-obce-atxzpc --namespace default ` pod/test-db-client-executionloop-obce-atxzpc 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-atxzpc" force deleted get oceanbase 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-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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 ('cstqx');\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. add consistent data cstqx Success skip cluster vscale: not support `kubectl get pvc -l app.kubernetes.io/instance=obce-atxzpc,apps.kubeblocks.io/component-name=oceanbase,apps.kubeblocks.io/vct-name=data-log --namespace default ` cluster volume-expand check cluster status before ops check cluster status done cluster_status:Running No resources found in obce-atxzpc namespace. `kbcli cluster volume-expand obce-atxzpc --auto-approve --force=true --components oceanbase --volume-claim-templates data-log --storage 51Gi --namespace default ` OpsRequest obce-atxzpc-volumeexpansion-chn8k created successfully, you can view the progress: kbcli cluster describe-ops obce-atxzpc-volumeexpansion-chn8k -n default check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-volumeexpansion-chn8k default VolumeExpansion obce-atxzpc oceanbase Running 0/3 May 28,2025 13:53 UTC+0800 check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce 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-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done No resources found in obce-atxzpc namespace. check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-volumeexpansion-chn8k default VolumeExpansion obce-atxzpc oceanbase Succeed 3/3 May 28,2025 13:53 UTC+0800 check ops status done ops_status:obce-atxzpc-volumeexpansion-chn8k default VolumeExpansion obce-atxzpc oceanbase Succeed 3/3 May 28,2025 13:53 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations obce-atxzpc-volumeexpansion-chn8k --namespace default ` opsrequest.operations.kubeblocks.io/obce-atxzpc-volumeexpansion-chn8k patched `kbcli cluster delete-ops --name obce-atxzpc-volumeexpansion-chn8k --force --auto-approve --namespace default ` OpsRequest obce-atxzpc-volumeexpansion-chn8k deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. value cstqx check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check db_client batch data Success test failover connectionstress check node drain check node drain success role name is error: error from server (NotFound): pods "test-db-client-connectionstress-obce-atxzpc" not found in namespace "default" `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-connectionstress-obce-atxzpc --namespace default ` Error from server (NotFound): pods "test-db-client-connectionstress-obce-atxzpc" 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-atxzpc" not found `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: test-db-client-connectionstress-obce-atxzpc namespace: default spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/dbclient:test args: - "--host" - "obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local" - "--user" - "root" - "--password" - "64ye4r0r6Q" - "--port" - "2881" - "--database" - "oceanbase" - "--dbtype" - "oceanbase" - "--test" - "connectionstress" - "--connections" - "5000" - "--duration" - "60" restartPolicy: Never `kubectl apply -f test-db-client-connectionstress-obce-atxzpc.yaml` pod/test-db-client-connectionstress-obce-atxzpc created apply test-db-client-connectionstress-obce-atxzpc.yaml Success `rm -rf test-db-client-connectionstress-obce-atxzpc.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-atxzpc 1/1 Running 0 5s check pod test-db-client-connectionstress-obce-atxzpc status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-obce-atxzpc 0/1 Completed 0 9s check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done --host obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local --user root --password 64ye4r0r6Q --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] 05:54:00.923 [main] DEBUG com.clickhouse.jdbc.ClickHouseDriver -- ClickHouse Driver 0.0.0.0(JDBC: 0.0.0.0) registered Test Result: Created 5000 connections Connection Information: Database Type: oceanbase Host: obce-atxzpc-oceanbase-ordinal-0.default.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-atxzpc --namespace default ` pod/test-db-client-connectionstress-obce-atxzpc 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-atxzpc" force deleted check failover pod name role name is failover pod name:obce-atxzpc-oceanbase-2 failover connectionstress Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. value cstqx check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check db_client batch data Success skip cluster restart: not support skip cluster SwitchOver: not support `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: benchtest-obce-atxzpc namespace: default spec: containers: - name: test-sysbench imagePullPolicy: IfNotPresent image: apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/customsuites:latest env: - name: TYPE value: "2" - name: FLAG value: "0" - name: CONFIGS value: "mode:all,driver:mysql,host:obce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local,user:root,password:64ye4r0r6Q,port:2881,db:benchtest,tables:5,threads:4,times:10,size:1000,type:oltp_read_write" restartPolicy: Never `kubectl apply -f benchtest-obce-atxzpc.yaml` pod/benchtest-obce-atxzpc created apply benchtest-obce-atxzpc.yaml Success `rm -rf benchtest-obce-atxzpc.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 Pending 0 0s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 4s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 10s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 25s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 30s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 36s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 41s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 46s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 51s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 56s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 62s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 67s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 72s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 77s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 83s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 88s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 93s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 98s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 103s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 109s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 114s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 119s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m4s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m9s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m25s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m30s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m36s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m41s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m46s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m51s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m56s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m2s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m7s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m12s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m17s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m22s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m28s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m33s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m38s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m43s check pod benchtest-obce-atxzpc status done pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 Completed 0 3m49s `kubectl logs benchtest-obce-atxzpc --tail 30 --namespace default ` [ 7s ] thds: 4 tps: 977.00 qps: 19547.95 (r/w/o: 13683.97/3909.99/1954.00) lat (ms,99%): 6.79 err/s: 0.00 reconn/s: 0.00 [ 8s ] thds: 4 tps: 947.02 qps: 18929.35 (r/w/o: 13252.24/3783.07/1894.03) lat (ms,99%): 10.46 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 4 tps: 900.01 qps: 18007.16 (r/w/o: 12600.11/3607.03/1800.02) lat (ms,99%): 10.65 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 921.95 qps: 18428.04 (r/w/o: 12902.32/3681.81/1843.90) lat (ms,99%): 10.46 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 141456 write: 40416 other: 20208 total: 202080 transactions: 10104 (1009.98 per sec.) queries: 202080 (20199.69 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0038s total number of events: 10104 Latency (ms): min: 2.31 avg: 3.96 max: 42.04 99th percentile: 8.90 sum: 39999.50 Threads fairness: events (avg/stddev): 2526.0000/4.00 execution time (avg/stddev): 9.9999/0.00 `kubectl delete pod benchtest-obce-atxzpc --force --namespace default ` 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-atxzpc" force deleted LB_TYPE is set to: internet cluster expose check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster expose obce-atxzpc --auto-approve --force=true --type internet --enable true --components oceanbase --namespace default ` OpsRequest obce-atxzpc-expose-48rkv created successfully, you can view the progress: kbcli cluster describe-ops obce-atxzpc-expose-48rkv -n default check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-expose-48rkv default Expose obce-atxzpc oceanbase Running 0/1 May 28,2025 13:59 UTC+0800 check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-expose-48rkv default Expose obce-atxzpc oceanbase Running 0/1 May 28,2025 13:59 UTC+0800 ops_status:obce-atxzpc-expose-48rkv default Expose obce-atxzpc oceanbase Running 0/1 May 28,2025 13:59 UTC+0800 check ops status done ops_status:obce-atxzpc-expose-48rkv default Expose obce-atxzpc oceanbase Succeed 1/1 May 28,2025 13:59 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations obce-atxzpc-expose-48rkv --namespace default ` opsrequest.operations.kubeblocks.io/obce-atxzpc-expose-48rkv patched `kbcli cluster delete-ops --name obce-atxzpc-expose-48rkv --force --auto-approve --namespace default ` OpsRequest obce-atxzpc-expose-48rkv deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. value cstqx check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check db_client batch data Success LB_TYPE is set to: internet No resources found in default namespace. `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase apiVersion: v1 kind: Pod metadata: name: benchtest-obce-atxzpc namespace: default spec: containers: - name: test-sysbench imagePullPolicy: IfNotPresent image: apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/customsuites:latest env: - name: TYPE value: "2" - name: FLAG value: "0" - name: CONFIGS value: "mode:all,driver:mysql,host:118.145.202.187,user:root,password:64ye4r0r6Q,port:2881,db:benchtest,tables:5,threads:4,times:10,size:1000,type:oltp_read_write" restartPolicy: Never `kubectl apply -f benchtest-obce-atxzpc.yaml` pod/benchtest-obce-atxzpc created apply benchtest-obce-atxzpc.yaml Success `rm -rf benchtest-obce-atxzpc.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 ContainerCreating 0 0s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 5s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 10s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 26s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 31s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 36s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 41s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 46s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 51s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 57s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 62s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 67s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 72s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 77s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 83s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 88s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 93s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 98s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 103s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 109s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 114s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 119s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m4s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m9s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m15s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m20s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m25s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m30s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m35s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m41s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m46s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m51s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 2m56s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m1s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m7s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m12s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m17s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m22s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m28s pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 1/1 Running 0 3m33s check pod benchtest-obce-atxzpc status done pod_status:NAME READY STATUS RESTARTS AGE benchtest-obce-atxzpc 0/1 Completed 0 3m38s `kubectl logs benchtest-obce-atxzpc --tail 30 --namespace default ` [ 7s ] thds: 4 tps: 395.99 qps: 7945.80 (r/w/o: 5568.86/1584.96/791.98) lat (ms,99%): 13.70 err/s: 0.00 reconn/s: 0.00 [ 8s ] thds: 4 tps: 383.02 qps: 7649.32 (r/w/o: 5352.23/1531.06/766.03) lat (ms,99%): 13.46 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 4 tps: 392.00 qps: 7851.97 (r/w/o: 5495.98/1571.99/784.00) lat (ms,99%): 12.98 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 391.00 qps: 7830.98 (r/w/o: 5480.98/1568.00/782.00) lat (ms,99%): 12.52 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 55006 write: 15716 other: 7858 total: 78580 transactions: 3929 (392.61 per sec.) queries: 78580 (7852.15 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0071s total number of events: 3929 Latency (ms): min: 8.75 avg: 10.18 max: 26.63 99th percentile: 13.46 sum: 40009.17 Threads fairness: events (avg/stddev): 982.2500/5.85 execution time (avg/stddev): 10.0023/0.00 `kubectl delete pod benchtest-obce-atxzpc --force --namespace default ` 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-atxzpc" force deleted cluster configure component_tmp: oceanbase apiVersion: operations.kubeblocks.io/v1alpha1 kind: OpsRequest metadata: generateName: obce-atxzpc-reconfiguring- namespace: default spec: type: Reconfiguring clusterName: obce-atxzpc 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-atxzpc.yaml` opsrequest.operations.kubeblocks.io/obce-atxzpc-reconfiguring-rthlb created create test_ops_cluster_obce-atxzpc.yaml Success `rm -rf test_ops_cluster_obce-atxzpc.yaml` check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-reconfiguring-rthlb default Reconfiguring obce-atxzpc oceanbase,oceanbase Running -/- May 28,2025 14:04 UTC+0800 check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:50Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-reconfiguring-rthlb default Reconfiguring obce-atxzpc oceanbase,oceanbase Succeed -/- May 28,2025 14:04 UTC+0800 check ops status done ops_status:obce-atxzpc-reconfiguring-rthlb default Reconfiguring obce-atxzpc oceanbase,oceanbase Succeed -/- May 28,2025 14:04 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations obce-atxzpc-reconfiguring-rthlb --namespace default ` opsrequest.operations.kubeblocks.io/obce-atxzpc-reconfiguring-rthlb patched `kbcli cluster delete-ops --name obce-atxzpc-reconfiguring-rthlb --force --auto-approve --namespace default ` OpsRequest obce-atxzpc-reconfiguring-rthlb deleted component_config:oceanbase check config variables `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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 mysql: [Warning] 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-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. value cstqx check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check db_client batch data Success skip cluster hscale skip cluster stop: not support 10 `kubectl get pvc -l app.kubernetes.io/instance=obce-atxzpc,apps.kubeblocks.io/component-name=oceanbase,apps.kubeblocks.io/vct-name=data-file --namespace default ` cluster volume-expand check cluster status before ops check cluster status done cluster_status:Running No resources found in obce-atxzpc namespace. `kbcli cluster volume-expand obce-atxzpc --auto-approve --force=true --components oceanbase --volume-claim-templates data-file --storage 54Gi --namespace default ` OpsRequest obce-atxzpc-volumeexpansion-5fpxl created successfully, you can view the progress: kbcli cluster describe-ops obce-atxzpc-volumeexpansion-5fpxl -n default check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-volumeexpansion-5fpxl default VolumeExpansion obce-atxzpc oceanbase Running 0/3 May 28,2025 14:04 UTC+0800 check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,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-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done No resources found in obce-atxzpc namespace. check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-volumeexpansion-5fpxl default VolumeExpansion obce-atxzpc oceanbase Succeed 3/3 May 28,2025 14:04 UTC+0800 check ops status done ops_status:obce-atxzpc-volumeexpansion-5fpxl default VolumeExpansion obce-atxzpc oceanbase Succeed 3/3 May 28,2025 14:04 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations obce-atxzpc-volumeexpansion-5fpxl --namespace default ` opsrequest.operations.kubeblocks.io/obce-atxzpc-volumeexpansion-5fpxl patched `kbcli cluster delete-ops --name obce-atxzpc-volumeexpansion-5fpxl --force --auto-approve --namespace default ` OpsRequest obce-atxzpc-volumeexpansion-5fpxl deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. value cstqx check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check db_client batch data Success cluster update terminationPolicy WipeOut `kbcli cluster update obce-atxzpc --termination-policy=WipeOut --namespace default ` cluster.apps.kubeblocks.io/obce-atxzpc updated (no change) check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done cluster list-logs `kbcli cluster list-logs obce-atxzpc --namespace default ` No log files found. role name is cluster logs `kbcli cluster logs obce-atxzpc --tail 30 --namespace default ` Defaulted container "observer-container" out of: observer-container, metrics, config-manager, kb-tools (init) optstr: config_additional_dir=/home/admin/workdir/store/etc,cpu_count=3,memory_limit=4G,system_memory=1G,__min_full_resource_pool_memory=1073741824,datafile_size=43G,log_disk_size=43G,net_thread_count=2,stack_size=512K,cache_wash_threshold=1G,schema_history_expire_time=1d 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 172.16.252.135 is not up yet Replica 172.16.252.135 is not up yet Replica 172.16.252.135 is up zone_server_list: ZONE 'zone0' SERVER '172.16.252.135:2882' ALTER SYSTEM BOOTSTRAP ZONE 'zone0' SERVER '172.16.252.135:2882'; *************************** 1. row *************************** SVR_IP: 172.16.252.135 SVR_PORT: 2882 ID: 1 ZONE: zone0 SQL_PORT: 2881 WITH_ROOTSERVER: YES STATUS: ACTIVE START_SERVICE_TIME: 2025-05-28 13:49:16.362390 STOP_TIME: NULL BLOCK_MIGRATE_IN_TIME: NULL CREATE_TIME: 2025-05-28 13:49:15.024808 MODIFY_TIME: 2025-05-28 13:49:17.788707 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 cluster logs specify instance and container `kbcli cluster logs obce-atxzpc --tail 30 --instance obce-atxzpc-oceanbase-2 -c config-manager --namespace default ` ts=2025-05-28T05:48:13.387 level=info logger=grpcProxy msg="container killer is disabled." ts=2025-05-28T05:48:13.387 level=info msg="starting reconfigure service: 0.0.0.0:9901" ts=2025-05-28T05:48:13.387 level=info msg="reconfigure service started." ts=2025-05-28T05:48:13.387 level=info msg="config manager started." ts=2025-05-28T06:04:08.325 level=info logger=configmap_volume_watcher msg="updated parameters: map[system_memory:2G]" ts=2025-05-28T06:04:08.343 level=info logger=configmap_volume_watcher msg="do reload action" command="/opt/kb-tools/reload/oceanbase-sysvars/update-parameters.sh system_memory 2G" stdout="exec sql: ALTER SYSTEM SET system_memory = '2G' SCOPE = BOTH\n\n" err=null LB_TYPE is set to: internet cluster expose check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster expose obce-atxzpc --auto-approve --force=true --type internet --enable false --components oceanbase --namespace default ` OpsRequest obce-atxzpc-expose-vqsfg created successfully, you can view the progress: kbcli cluster describe-ops obce-atxzpc-expose-vqsfg -n default check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-expose-vqsfg default Expose obce-atxzpc Creating -/- May 28,2025 14:05 UTC+0800 check cluster status `kbcli cluster list obce-atxzpc --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS obce-atxzpc default oceanbase-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=obce-atxzpc,clusterdefinition.kubeblocks.io/name=oceanbase-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances obce-atxzpc --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME obce-atxzpc-oceanbase-0 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-1 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.20/192.168.0.20 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi obce-atxzpc-oceanbase-2 default obce-atxzpc oceanbase Running cn-guangzhou-b 3200m / 4 4352Mi / 5Gi data-file:54Gi 192.168.0.21/192.168.0.21 May 28,2025 13:45 UTC+0800 data-log:51Gi log:20Gi workdir:20Gi check pod status done `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is check cluster connect `echo " echo \"\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops obce-atxzpc --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME obce-atxzpc-expose-vqsfg default Expose obce-atxzpc oceanbase Succeed 1/1 May 28,2025 14:05 UTC+0800 check ops status done ops_status:obce-atxzpc-expose-vqsfg default Expose obce-atxzpc oceanbase Succeed 1/1 May 28,2025 14:05 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations obce-atxzpc-expose-vqsfg --namespace default ` opsrequest.operations.kubeblocks.io/obce-atxzpc-expose-vqsfg patched `kbcli cluster delete-ops --name obce-atxzpc-expose-vqsfg --force --auto-approve --namespace default ` OpsRequest obce-atxzpc-expose-vqsfg deleted `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;DB_PORT:2881;DB_DATABASE:oceanbase role name is `echo " echo \"use test; SELECT value FROM tmp_table WHERE id = 1;\" | mysql -hobce-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- 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 mysql: [Warning] Using a password on the command line interface can be insecure. value cstqx check cluster data consistent Success `kubectl get secrets -l app.kubernetes.io/instance=obce-atxzpc` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.username}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.password}"` `kubectl get secrets obce-atxzpc-oceanbase-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:64ye4r0r6Q;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-atxzpc-oceanbase-ordinal-0.default.svc.cluster.local -uroot -P2881 -p'64ye4r0r6Q' " | kubectl exec -it obce-atxzpc-oceanbase-2 --namespace default -- bash` check db_client batch data Success delete cluster obce-atxzpc `kbcli cluster delete obce-atxzpc --auto-approve --namespace default ` Cluster obce-atxzpc deleted pod_info:obce-atxzpc-oceanbase-0 3/3 Running 0 20m obce-atxzpc-oceanbase-1 3/3 Running 0 20m obce-atxzpc-oceanbase-2 3/3 Running 0 20m pod_info:obce-atxzpc-oceanbase-0 3/3 Terminating 0 20m obce-atxzpc-oceanbase-1 3/3 Terminating 0 20m obce-atxzpc-oceanbase-2 3/3 Terminating 0 20m No resources found in default namespace. delete cluster pod done No resources found in default namespace. check cluster resource non-exist OK: pvc No resources found in default namespace. delete cluster done No resources found in default namespace. No resources found in default namespace. No resources found in default namespace. OceanBase CE Test Suite All Done! --------------------------------------OceanBase CE (Topology = distribution Replicas 3) Test Result-------------------------------------- [PASSED]|[Create]|[ComponentDefinition=oceanbase-ce-1.0.0-alpha.0;ComponentVersion=oceanbase-ce;ServiceVersion=4.3.0;]|[Description=Create a cluster with the specified component definition oceanbase-ce-1.0.0-alpha.0 and component version oceanbase-ce and service version 4.3.0] [PASSED]|[Connect]|[ComponentName=oceanbase]|[Description=Connect to the cluster] [PASSED]|[AddData]|[Values=cstqx]|[Description=Add data to the cluster] [PASSED]|[VolumeExpansion]|[ComponentName=oceanbase;ComponentVolume=data-log]|[Description=VolumeExpansion the cluster specify component oceanbase and volume data-log] [PASSED]|[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]|[Bench]|[ComponentName=oceanbase]|[Description=Bench the cluster service with oceanbase component] [PASSED]|[Expose]|[Enable=true;TYPE=internet;ComponentName=oceanbase]|[Description=Expose Enable the internet service with oceanbase component] [PASSED]|[Bench]|[HostType=LB;ComponentName=oceanbase]|[Description=Bench the cluster LB service with oceanbase component] [PASSED]|[Reconfiguring]|[ComponentName=oceanbase;system_memory=2G]|[Description=Reconfiguring the cluster specify component oceanbase set system_memory=2G] [PASSED]|[VolumeExpansion]|[ComponentName=oceanbase;ComponentVolume=data-file]|[Description=VolumeExpansion the cluster specify component oceanbase and volume data-file] [PASSED]|[Update]|[TerminationPolicy=WipeOut]|[Description=Update the cluster TerminationPolicy WipeOut] [PASSED]|[Expose]|[Disable=true;TYPE=internet;ComponentName=oceanbase]|[Description=Expose Disable the internet service with oceanbase component] [PASSED]|[Delete]|[-]|[Description=Delete the cluster] [END]