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 starrocks-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-starrocks-ce kbcli-test-addons/starrocks-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-starrocks-ce" does not exist. Installing it now. NAME: kb-addon-starrocks-ce LAST DEPLOYED: Wed May 28 13:45:01 2025 NAMESPACE: kb-system STATUS: deployed REVISION: 1 TEST SUITE: None NOTES: 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:starrocks-ce-be-1.0.0-alpha.0 set service versions:3.3.0,3.2.2 set service versions sorted:3.2.2,3.3.0 check component definition starrocks-ce status done set component name:fe found component version set starrocks-ce component definition set starrocks-ce component definition starrocks-ce-fe-1.0.0-alpha.0 set replicas first:2,3.2.2|2,3.3.0 set replicas third:2,3.2.2 set replicas fourth:2,3.2.2 set minimum cmpv service version set minimum cmpv service version replicas:2,3.2.2 REPORT_COUNT:1 CLUSTER_TOPOLOGY: set cluster topology: shared-nothing set starrocks-ce component definition set starrocks-ce component definition starrocks-ce-fe-1.0.0-alpha.0 LIMIT_CPU:1 LIMIT_MEMORY:1 storage size: 20 No resources found in default namespace. termination_policy:Delete create 2 replica Delete starrocks-ce cluster check component definition set component definition by component version check cmpd by labels check cmpd by compDefs set component definition: starrocks-ce-be-1.0.0-alpha.0 by component version:starrocks-ce-be-1.0.0-alpha.0 apiVersion: apps.kubeblocks.io/v1 kind: Cluster metadata: name: strce-mmvnhf namespace: default spec: clusterDef: starrocks-ce topology: shared-nothing terminationPolicy: Delete componentSpecs: - name: fe serviceVersion: 3.2.2 disableExporter: true replicas: 1 resources: requests: cpu: 1000m memory: 1Gi limits: cpu: 1000m memory: 1Gi volumeClaimTemplates: - name: data spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: 20Gi - name: be serviceVersion: 3.2.2 replicas: 2 resources: requests: cpu: 1000m memory: 1Gi limits: cpu: 1000m memory: 1Gi volumeClaimTemplates: - name: data spec: storageClassName: accessModes: - ReadWriteOnce resources: requests: storage: 20Gi `kubectl apply -f test_create_strce-mmvnhf.yaml` cluster.apps.kubeblocks.io/strce-mmvnhf created apply test_create_strce-mmvnhf.yaml Success `rm -rf test_create_strce-mmvnhf.yaml` check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Creating May 28,2025 13:45 UTC+0800 clusterdefinition.kubeblocks.io/name=starrocks-ce cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating cluster_status:Creating 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 strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.20/192.168.0.20 May 28,2025 13:48 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.20/192.168.0.20 May 28,2025 13:52 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:45 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check pod strce-mmvnhf-fe-0 container_name fe exist password 19RA16sf5l No container logs contain secret password. describe cluster `kbcli cluster describe strce-mmvnhf --namespace default ` Name: strce-mmvnhf Created Time: May 28,2025 13:45 UTC+0800 NAMESPACE CLUSTER-DEFINITION TOPOLOGY STATUS TERMINATION-POLICY default starrocks-ce shared-nothing Running Delete Endpoints: COMPONENT INTERNAL EXTERNAL fe strce-mmvnhf-fe-fe.default.svc.cluster.local:8030 strce-mmvnhf-fe-fe.default.svc.cluster.local:9030 be strce-mmvnhf-be-be.default.svc.cluster.local:8040 strce-mmvnhf-be-be.default.svc.cluster.local:8080 Topology: COMPONENT SERVICE-VERSION INSTANCE ROLE STATUS AZ NODE CREATED-TIME be 3.2.2 strce-mmvnhf-be-0 Running cn-guangzhou-b 192.168.0.20/192.168.0.20 May 28,2025 13:48 UTC+0800 be 3.2.2 strce-mmvnhf-be-1 Running cn-guangzhou-b 192.168.0.20/192.168.0.20 May 28,2025 13:52 UTC+0800 fe 3.2.2 strce-mmvnhf-fe-0 Running cn-guangzhou-b 192.168.0.18/192.168.0.18 May 28,2025 13:45 UTC+0800 Resources Allocation: COMPONENT INSTANCE-TEMPLATE CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE-SIZE STORAGE-CLASS fe 1 / 1 1Gi / 1Gi data:20Gi ebs-ssd be 1 / 1 1Gi / 1Gi data:20Gi ebs-ssd Images: COMPONENT COMPONENT-DEFINITION IMAGE fe starrocks-ce-fe-1.0.0-alpha.0 apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/fe-ubuntu:3.2.2 be starrocks-ce-be-1.0.0-alpha.0 apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/be-ubuntu:3.2.2 Show cluster events: kbcli cluster list-events -n default strce-mmvnhf `kbcli cluster label strce-mmvnhf app.kubernetes.io/instance- --namespace default ` label "app.kubernetes.io/instance" not found. `kbcli cluster label strce-mmvnhf app.kubernetes.io/instance=strce-mmvnhf --namespace default ` `kbcli cluster label strce-mmvnhf --list --namespace default ` NAME NAMESPACE LABELS strce-mmvnhf default app.kubernetes.io/instance=strce-mmvnhf clusterdefinition.kubeblocks.io/name=starrocks-ce label cluster app.kubernetes.io/instance=strce-mmvnhf Success `kbcli cluster label case.name=kbcli.test1 -l app.kubernetes.io/instance=strce-mmvnhf --namespace default ` `kbcli cluster label strce-mmvnhf --list --namespace default ` NAME NAMESPACE LABELS strce-mmvnhf default app.kubernetes.io/instance=strce-mmvnhf case.name=kbcli.test1 clusterdefinition.kubeblocks.io/name=starrocks-ce label cluster case.name=kbcli.test1 Success `kbcli cluster label strce-mmvnhf case.name=kbcli.test2 --overwrite --namespace default ` `kbcli cluster label strce-mmvnhf --list --namespace default ` NAME NAMESPACE LABELS strce-mmvnhf default app.kubernetes.io/instance=strce-mmvnhf case.name=kbcli.test2 clusterdefinition.kubeblocks.io/name=starrocks-ce label cluster case.name=kbcli.test2 Success `kbcli cluster label strce-mmvnhf case.name- --namespace default ` `kbcli cluster label strce-mmvnhf --list --namespace default ` NAME NAMESPACE LABELS strce-mmvnhf default app.kubernetes.io/instance=strce-mmvnhf clusterdefinition.kubeblocks.io/name=starrocks-ce delete cluster label case.name Success cluster connect `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys `echo "echo \"SHOW PROC '/frontends'\G;SHOW PROC '/backends'\G;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt='StarRocks > '" | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` Unable to use a TTY - input is not a terminal or the right kind of file *************************** 1. row *************************** Name: strce-mmvnhf-fe-0.strce-mmvnhf-fe-headless.default.svc.cluster.local_9010_1748411295586 IP: strce-mmvnhf-fe-0.strce-mmvnhf-fe-headless.default.svc.cluster.local EditLogPort: 9010 HttpPort: 8030 QueryPort: 9030 RpcPort: 9020 Role: LEADER ClusterId: 2950515 Join: true Alive: true ReplayedJournalId: 104 LastHeartbeat: 2025-05-28 13:53:01 IsHelper: true ErrMsg: StartTime: 2025-05-28 13:48:23 Version: 3.2.2-269e832 *************************** 1. row *************************** BackendId: 10005 IP: strce-mmvnhf-be-0.strce-mmvnhf-be-headless.default.svc.cluster.local HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2025-05-28 13:52:06 LastHeartbeat: 2025-05-28 13:53:01 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 48 DataUsedCapacity: 0.000 B AvailCapacity: 19.498 GB TotalCapacity: 19.518 GB UsedPct: 0.10 % MaxDiskUsedPct: 0.10 % ErrMsg: Version: 3.2.2-269e832 Status: {"lastSuccessReportTabletsTime":"2025-05-28 13:52:07"} DataTotalCapacity: 19.498 GB DataUsedPct: 0.00 % CpuCores: 1 NumRunningQueries: 0 MemUsedPct: 12.09 % CpuUsedPct: 0.0 % *************************** 2. row *************************** BackendId: 10117 IP: strce-mmvnhf-be-1.strce-mmvnhf-be-headless.default.svc.cluster.local HeartbeatPort: 9050 BePort: 9060 HttpPort: 8040 BrpcPort: 8060 LastStartTime: 2025-05-28 13:52:36 LastHeartbeat: 2025-05-28 13:53:01 Alive: true SystemDecommissioned: false ClusterDecommissioned: false TabletNum: 0 DataUsedCapacity: 0.000 B AvailCapacity: 19.498 GB TotalCapacity: 19.518 GB UsedPct: 0.10 % MaxDiskUsedPct: 0.10 % ErrMsg: Version: 3.2.2-269e832 Status: {"lastSuccessReportTabletsTime":"2025-05-28 13:52:37"} DataTotalCapacity: 19.498 GB DataUsedPct: 0.00 % CpuCores: 1 NumRunningQueries: 0 MemUsedPct: 12.01 % CpuUsedPct: 0.0 % connect cluster Success insert batch data by db client error: error from server (NotFound): pods "test-db-client-executionloop-strce-mmvnhf" not found in namespace "default" DB_CLIENT_BATCH_DATA_COUNT: `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-executionloop-strce-mmvnhf --namespace default ` Error from server (NotFound): pods "test-db-client-executionloop-strce-mmvnhf" 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-strce-mmvnhf" not found `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys apiVersion: v1 kind: Pod metadata: name: test-db-client-executionloop-strce-mmvnhf namespace: default spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/dbclient:test args: - "--host" - "strce-mmvnhf-fe-fe.default.svc.cluster.local" - "--user" - "root" - "--password" - "19RA16sf5l" - "--port" - "9030" - "--dbtype" - "starrocks" - "--test" - "executionloop" - "--duration" - "60" - "--interval" - "1" restartPolicy: Never `kubectl apply -f test-db-client-executionloop-strce-mmvnhf.yaml` pod/test-db-client-executionloop-strce-mmvnhf created apply test-db-client-executionloop-strce-mmvnhf.yaml Success `rm -rf test-db-client-executionloop-strce-mmvnhf.yaml` check pod status pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 6s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 10s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 15s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 20s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 25s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 30s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 36s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 41s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 46s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 51s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 56s pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 1/1 Running 0 62s check pod test-db-client-executionloop-strce-mmvnhf status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-executionloop-strce-mmvnhf 0/1 Completed 0 67s check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.20/192.168.0.20 May 28,2025 13:48 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.20/192.168.0.20 May 28,2025 13:52 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:45 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done --host strce-mmvnhf-fe-fe.default.svc.cluster.local --user root --password 19RA16sf5l --port 9030 --dbtype starrocks --test executionloop --duration 60 --interval 1 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] 05:53:05.265 [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, value VARCHAR(255), tinyint_col TINYINT, smallint_col SMALLINT, int_col INT, bigint_col BIGINT, float_col FLOAT, double_col DOUBLE, decimal_col DECIMAL(10, 2), date_col DATE, datetime_col DATETIME, char_col CHAR(10), text_col TEXT, binary_col BINARY(30), varbinary_col VARBINARY(255), enum_col VARCHAR(20), set_col VARCHAR(50) ) ENGINE=OLAP DUPLICATE KEY(id) DISTRIBUTED BY HASH(id) BUCKETS 3 PROPERTIES ( 'replication_num' = '1' ); Execution loop start:INSERT INTO executions_loop.executions_loop_table (value, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, decimal_col, date_col, datetime_col, char_col, text_col, binary_col, varbinary_col, enum_col, set_col) VALUES ('executions_loop_test_1', 3, 17356, -26592664, 1416448916620124149, 0.43658727, 0.03404321368688168, 30.36786308336913, '2025-05-28', '2025-05-28 05:53:05.514', 'UG0CSobUeI', '8jXpTJNKHcXA5QNKalt9MyHbMEB7U1Zno8feVG7HWNqJXZfFirB5ol6R3iDNYXrwDw0Mtdcioz1kq41GoYjcqoFsfMtDVrsYAIz1Z2WEPlVj3f8mnry8bTZqJjUQ9Q5RdtcadM4K6NCkKp76RDd7lJK8iq9UwW6lmEu5lNw5Anpk4gCl4jl7CZZDwrfeTZZ3Ijcrrcv7gijnrs0y8eL3fdck2LayijsAco3dT3zrzCt15CudZoNPDRhGfVxuOJH', TO_BINARY('base64,q3s0ai8F+Z03rA=='), TO_BINARY('base64,86ICQCbjypTqpCm1Nfv0wi/FaGAfNkPZPdEZW1WM/PPP1BRUhHHWxHFhIeeA1qI5pYSUuU747d7QVHRCYMXap0rdqWA+nWijQ6wviDa8V19h6ZBdyRO6Fjy6Jw/qcVx0ImI9Y1D82xzVDHFXY/qSJRYgKKeT/8b3OVaLmRiRS1IfVHy8Z62dQkP3p6Hn+EQ/u8zwkqcSGntkEPw='), 'Option2', 'Value1' ); [ 1s ] executions total: 1 successful: 1 failed: 0 disconnect: 0 [ 2s ] executions total: 12 successful: 12 failed: 0 disconnect: 0 [ 3s ] executions total: 22 successful: 22 failed: 0 disconnect: 0 [ 4s ] executions total: 33 successful: 33 failed: 0 disconnect: 0 [ 5s ] executions total: 43 successful: 43 failed: 0 disconnect: 0 [ 6s ] executions total: 54 successful: 54 failed: 0 disconnect: 0 [ 7s ] executions total: 64 successful: 64 failed: 0 disconnect: 0 [ 8s ] executions total: 74 successful: 74 failed: 0 disconnect: 0 [ 9s ] executions total: 85 successful: 85 failed: 0 disconnect: 0 [ 10s ] executions total: 96 successful: 96 failed: 0 disconnect: 0 [ 11s ] executions total: 106 successful: 106 failed: 0 disconnect: 0 [ 12s ] executions total: 117 successful: 117 failed: 0 disconnect: 0 [ 13s ] executions total: 127 successful: 127 failed: 0 disconnect: 0 [ 14s ] executions total: 137 successful: 137 failed: 0 disconnect: 0 [ 15s ] executions total: 148 successful: 148 failed: 0 disconnect: 0 [ 16s ] executions total: 158 successful: 158 failed: 0 disconnect: 0 [ 17s ] executions total: 168 successful: 168 failed: 0 disconnect: 0 [ 18s ] executions total: 178 successful: 178 failed: 0 disconnect: 0 [ 19s ] executions total: 188 successful: 188 failed: 0 disconnect: 0 [ 20s ] executions total: 198 successful: 198 failed: 0 disconnect: 0 [ 21s ] executions total: 209 successful: 209 failed: 0 disconnect: 0 [ 22s ] executions total: 219 successful: 219 failed: 0 disconnect: 0 [ 23s ] executions total: 229 successful: 229 failed: 0 disconnect: 0 [ 24s ] executions total: 239 successful: 239 failed: 0 disconnect: 0 [ 25s ] executions total: 249 successful: 249 failed: 0 disconnect: 0 [ 26s ] executions total: 260 successful: 260 failed: 0 disconnect: 0 [ 27s ] executions total: 270 successful: 270 failed: 0 disconnect: 0 [ 28s ] executions total: 280 successful: 280 failed: 0 disconnect: 0 [ 29s ] executions total: 290 successful: 290 failed: 0 disconnect: 0 [ 30s ] executions total: 300 successful: 300 failed: 0 disconnect: 0 [ 31s ] executions total: 311 successful: 311 failed: 0 disconnect: 0 [ 32s ] executions total: 321 successful: 321 failed: 0 disconnect: 0 [ 33s ] executions total: 332 successful: 332 failed: 0 disconnect: 0 [ 34s ] executions total: 342 successful: 342 failed: 0 disconnect: 0 [ 35s ] executions total: 352 successful: 352 failed: 0 disconnect: 0 [ 36s ] executions total: 363 successful: 363 failed: 0 disconnect: 0 [ 37s ] executions total: 373 successful: 373 failed: 0 disconnect: 0 [ 38s ] executions total: 383 successful: 383 failed: 0 disconnect: 0 [ 39s ] executions total: 393 successful: 393 failed: 0 disconnect: 0 [ 40s ] executions total: 403 successful: 403 failed: 0 disconnect: 0 [ 41s ] executions total: 413 successful: 413 failed: 0 disconnect: 0 [ 42s ] executions total: 423 successful: 423 failed: 0 disconnect: 0 [ 43s ] executions total: 434 successful: 434 failed: 0 disconnect: 0 [ 44s ] executions total: 444 successful: 444 failed: 0 disconnect: 0 [ 45s ] executions total: 454 successful: 454 failed: 0 disconnect: 0 [ 46s ] executions total: 464 successful: 464 failed: 0 disconnect: 0 [ 47s ] executions total: 474 successful: 474 failed: 0 disconnect: 0 [ 48s ] executions total: 485 successful: 485 failed: 0 disconnect: 0 [ 49s ] executions total: 495 successful: 495 failed: 0 disconnect: 0 [ 50s ] executions total: 505 successful: 505 failed: 0 disconnect: 0 [ 51s ] executions total: 515 successful: 515 failed: 0 disconnect: 0 [ 52s ] executions total: 525 successful: 525 failed: 0 disconnect: 0 [ 53s ] executions total: 536 successful: 536 failed: 0 disconnect: 0 [ 54s ] executions total: 546 successful: 546 failed: 0 disconnect: 0 [ 55s ] executions total: 556 successful: 556 failed: 0 disconnect: 0 [ 56s ] executions total: 566 successful: 566 failed: 0 disconnect: 0 [ 57s ] executions total: 576 successful: 576 failed: 0 disconnect: 0 [ 60s ] executions total: 578 successful: 578 failed: 0 disconnect: 0 Test Result: Total Executions: 578 Successful Executions: 578 Failed Executions: 0 Disconnection Counts: 0 Connection Information: Database Type: starrocks Host: strce-mmvnhf-fe-fe.default.svc.cluster.local Port: 9030 Database: Table: User: root Org: Access Mode: mysql Test Type: executionloop Query: Duration: 60 seconds Interval: 1 seconds DB_CLIENT_BATCH_DATA_COUNT: 578 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-executionloop-strce-mmvnhf --namespace default ` pod/test-db-client-executionloop-strce-mmvnhf 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-strce-mmvnhf" force deleted cluster restart check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster restart strce-mmvnhf --auto-approve --force=true --namespace default ` OpsRequest strce-mmvnhf-restart-hqz9v created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-restart-hqz9v -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-restart-hqz9v default Restart strce-mmvnhf fe,be Running 0/3 May 28,2025 13:54 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-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 strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.20/192.168.0.20 May 28,2025 13:55 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.20/192.168.0.20 May 28,2025 13:54 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:54 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-restart-hqz9v default Restart strce-mmvnhf fe,be Succeed 3/3 May 28,2025 13:54 UTC+0800 check ops status done ops_status:strce-mmvnhf-restart-hqz9v default Restart strce-mmvnhf fe,be Succeed 3/3 May 28,2025 13:54 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-restart-hqz9v --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-restart-hqz9v patched `kbcli cluster delete-ops --name strce-mmvnhf-restart-hqz9v --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-restart-hqz9v deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check db_client batch data Success check component be exists `kubectl get components -l app.kubernetes.io/instance=strce-mmvnhf,apps.kubeblocks.io/component-name=be --namespace default | (grep "be" || true )` `kubectl get pvc -l app.kubernetes.io/instance=strce-mmvnhf,apps.kubeblocks.io/component-name=be,apps.kubeblocks.io/vct-name=data --namespace default ` cluster volume-expand check cluster status before ops check cluster status done cluster_status:Running No resources found in strce-mmvnhf namespace. `kbcli cluster volume-expand strce-mmvnhf --auto-approve --force=true --components be --volume-claim-templates data --storage 25Gi --namespace default ` OpsRequest strce-mmvnhf-volumeexpansion-6gw2c created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-volumeexpansion-6gw2c -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-volumeexpansion-6gw2c default VolumeExpansion strce-mmvnhf be Running -/- May 28,2025 13:55 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-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 check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:55 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:54 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:54 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done No resources found in strce-mmvnhf namespace. check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-volumeexpansion-6gw2c default VolumeExpansion strce-mmvnhf be Succeed 2/2 May 28,2025 13:55 UTC+0800 check ops status done ops_status:strce-mmvnhf-volumeexpansion-6gw2c default VolumeExpansion strce-mmvnhf be Succeed 2/2 May 28,2025 13:55 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-volumeexpansion-6gw2c --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-volumeexpansion-6gw2c patched `kbcli cluster delete-ops --name strce-mmvnhf-volumeexpansion-6gw2c --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-volumeexpansion-6gw2c deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check db_client batch data Success cluster stop check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster stop strce-mmvnhf --auto-approve --force=true --namespace default ` OpsRequest strce-mmvnhf-stop-ph8wn created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-stop-ph8wn -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-stop-ph8wn default Stop strce-mmvnhf be,fe Running 0/3 May 28,2025 13:56 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Stopping May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping cluster_status:Stopping check cluster status done cluster_status:Stopped check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME check pod status done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-stop-ph8wn default Stop strce-mmvnhf be,fe Succeed 3/3 May 28,2025 13:56 UTC+0800 check ops status done ops_status:strce-mmvnhf-stop-ph8wn default Stop strce-mmvnhf be,fe Succeed 3/3 May 28,2025 13:56 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-stop-ph8wn --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-stop-ph8wn patched `kbcli cluster delete-ops --name strce-mmvnhf-stop-ph8wn --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-stop-ph8wn deleted cluster start check cluster status before ops check cluster status done cluster_status:Stopped `kbcli cluster start strce-mmvnhf --force=true --namespace default ` OpsRequest strce-mmvnhf-start-qs8pd created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-start-qs8pd -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-start-qs8pd default Start strce-mmvnhf be,fe Running 0/3 May 28,2025 13:57 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce 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 strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:57 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:58 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:57 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-start-qs8pd default Start strce-mmvnhf be,fe Succeed 3/3 May 28,2025 13:57 UTC+0800 check ops status done ops_status:strce-mmvnhf-start-qs8pd default Start strce-mmvnhf be,fe Succeed 3/3 May 28,2025 13:57 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-start-qs8pd --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-start-qs8pd patched `kbcli cluster delete-ops --name strce-mmvnhf-start-qs8pd --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-start-qs8pd deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check db_client batch data Success check component be exists `kubectl get components -l app.kubernetes.io/instance=strce-mmvnhf,apps.kubeblocks.io/component-name=be --namespace default | (grep "be" || true )` cluster be scale-out check cluster status before ops check cluster status done cluster_status:Running No resources found in strce-mmvnhf namespace. `kbcli cluster scale-out strce-mmvnhf --auto-approve --force=true --components be --replicas 1 --namespace default ` OpsRequest strce-mmvnhf-horizontalscaling-l8gdt created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-horizontalscaling-l8gdt -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-horizontalscaling-l8gdt default HorizontalScaling strce-mmvnhf be Running 0/1 May 28,2025 13:58 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce cluster_status:Updating cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:57 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:58 UTC+0800 strce-mmvnhf-be-2 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:58 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:57 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done No resources found in strce-mmvnhf namespace. check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-horizontalscaling-l8gdt default HorizontalScaling strce-mmvnhf be Succeed 1/1 May 28,2025 13:58 UTC+0800 check ops status done ops_status:strce-mmvnhf-horizontalscaling-l8gdt default HorizontalScaling strce-mmvnhf be Succeed 1/1 May 28,2025 13:58 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-horizontalscaling-l8gdt --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-horizontalscaling-l8gdt patched `kbcli cluster delete-ops --name strce-mmvnhf-horizontalscaling-l8gdt --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-horizontalscaling-l8gdt deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check db_client batch data Success check component be exists `kubectl get components -l app.kubernetes.io/instance=strce-mmvnhf,apps.kubeblocks.io/component-name=be --namespace default | (grep "be" || true )` cluster be scale-in check cluster status before ops check cluster status done cluster_status:Running No resources found in strce-mmvnhf namespace. `kbcli cluster scale-in strce-mmvnhf --auto-approve --force=true --components be --replicas 1 --namespace default ` OpsRequest strce-mmvnhf-horizontalscaling-h2jln created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-horizontalscaling-h2jln -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-horizontalscaling-h2jln default HorizontalScaling strce-mmvnhf be Running 0/1 May 28,2025 13:59 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce 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 strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:57 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 13:58 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:57 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done No resources found in strce-mmvnhf namespace. check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-horizontalscaling-h2jln default HorizontalScaling strce-mmvnhf be Succeed 1/1 May 28,2025 13:59 UTC+0800 check ops status done ops_status:strce-mmvnhf-horizontalscaling-h2jln default HorizontalScaling strce-mmvnhf be Succeed 1/1 May 28,2025 13:59 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-horizontalscaling-h2jln --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-horizontalscaling-h2jln patched `kbcli cluster delete-ops --name strce-mmvnhf-horizontalscaling-h2jln --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-horizontalscaling-h2jln deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check db_client batch data Success check component be exists `kubectl get components -l app.kubernetes.io/instance=strce-mmvnhf,apps.kubeblocks.io/component-name=be --namespace default | (grep "be" || true )` cluster restart check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster restart strce-mmvnhf --auto-approve --force=true --components be --namespace default ` OpsRequest strce-mmvnhf-restart-qqxht created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-restart-qqxht -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-restart-qqxht default Restart strce-mmvnhf be Running 0/2 May 28,2025 13:59 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-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 strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 13:57 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-restart-qqxht default Restart strce-mmvnhf be Succeed 2/2 May 28,2025 13:59 UTC+0800 check ops status done ops_status:strce-mmvnhf-restart-qqxht default Restart strce-mmvnhf be Succeed 2/2 May 28,2025 13:59 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-restart-qqxht --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-restart-qqxht patched `kbcli cluster delete-ops --name strce-mmvnhf-restart-qqxht --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-restart-qqxht deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check db_client batch data Success cluster rebulid instances apiVersion: operations.kubeblocks.io/v1alpha1 kind: OpsRequest metadata: generateName: strce-mmvnhf-rebuildinstance- namespace: default spec: type: RebuildInstance clusterName: strce-mmvnhf force: true rebuildFrom: - componentName: fe instances: - name: strce-mmvnhf-fe-0 inPlace: true check cluster status before ops check cluster status done cluster_status:Running `kubectl create -f test_ops_cluster_strce-mmvnhf.yaml` opsrequest.operations.kubeblocks.io/strce-mmvnhf-rebuildinstance-fd66f created create test_ops_cluster_strce-mmvnhf.yaml Success `rm -rf test_ops_cluster_strce-mmvnhf.yaml` check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Running 0/1 May 28,2025 14:01 UTC+0800 check ops status done ops_status:strce-mmvnhf-rebuildinstance-fd66f default RebuildInstance strce-mmvnhf fe Succeed 1/1 May 28,2025 14:01 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-rebuildinstance-fd66f --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-rebuildinstance-fd66f patched `kbcli cluster delete-ops --name strce-mmvnhf-rebuildinstance-fd66f --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-rebuildinstance-fd66f deleted check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 14:01 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster vscale strce-mmvnhf --auto-approve --force=true --components fe --cpu 1100m --memory 1.1Gi --namespace default ` OpsRequest strce-mmvnhf-verticalscaling-d7cbk created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-verticalscaling-d7cbk -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-verticalscaling-d7cbk default VerticalScaling strce-mmvnhf fe Running 0/1 May 28,2025 14:02 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 14:02 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-verticalscaling-d7cbk default VerticalScaling strce-mmvnhf fe Succeed 1/1 May 28,2025 14:02 UTC+0800 check ops status done ops_status:strce-mmvnhf-verticalscaling-d7cbk default VerticalScaling strce-mmvnhf fe Succeed 1/1 May 28,2025 14:02 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-verticalscaling-d7cbk --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-verticalscaling-d7cbk patched `kbcli cluster delete-ops --name strce-mmvnhf-verticalscaling-d7cbk --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-verticalscaling-d7cbk deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` test failover connectionstress check node drain check node drain success error: error from server (NotFound): pods "test-db-client-connectionstress-strce-mmvnhf" not found in namespace "default" `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-connectionstress-strce-mmvnhf --namespace default ` Error from server (NotFound): pods "test-db-client-connectionstress-strce-mmvnhf" 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-strce-mmvnhf" not found `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys apiVersion: v1 kind: Pod metadata: name: test-db-client-connectionstress-strce-mmvnhf namespace: default spec: containers: - name: test-dbclient imagePullPolicy: IfNotPresent image: apecloud-registry.cn-zhangjiakou.cr.aliyuncs.com/apecloud/dbclient:test args: - "--host" - "strce-mmvnhf-fe-fe.default.svc.cluster.local" - "--user" - "root" - "--password" - "19RA16sf5l" - "--port" - "9030" - "--database" - "sys" - "--dbtype" - "starrocks" - "--test" - "connectionstress" - "--connections" - "200" - "--duration" - "60" restartPolicy: Never `kubectl apply -f test-db-client-connectionstress-strce-mmvnhf.yaml` pod/test-db-client-connectionstress-strce-mmvnhf created apply test-db-client-connectionstress-strce-mmvnhf.yaml Success `rm -rf test-db-client-connectionstress-strce-mmvnhf.yaml` check pod status check pod test-db-client-connectionstress-strce-mmvnhf status done pod_status:NAME READY STATUS RESTARTS AGE test-db-client-connectionstress-strce-mmvnhf 0/1 Completed 0 5s check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1 / 1 1Gi / 1Gi data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:00 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 14:02 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done --host strce-mmvnhf-fe-fe.default.svc.cluster.local --user root --password 19RA16sf5l --port 9030 --database sys --dbtype starrocks --test connectionstress --connections 200 --duration 60 SLF4J(I): Connected with provider of type [ch.qos.logback.classic.spi.LogbackServiceProvider] 06:03:02.021 [main] DEBUG com.clickhouse.jdbc.ClickHouseDriver -- ClickHouse Driver 0.0.0.0(JDBC: 0.0.0.0) registered 06:03:02.229 [main] DEBUG com.yashandb.log.LoggerFactory -- Logger type is SLF4J Logger. 06:03:02.230 [main] DEBUG com.yashandb.conf.ConnectionUrl -- JDBC URL must start with "jdbc:yasdb:" but was: jdbc:mysql://strce-mmvnhf-fe-fe.default.svc.cluster.local:9030/sys?useSSL=false&allowPublicKeyRetrieval=true Failed to connect to StarRocks database: java.sql.SQLSyntaxErrorException: Backend node not found. Check if any backend node is down.backend: Trying with database StarRocks. 06:03:02.241 [main] DEBUG com.yashandb.conf.ConnectionUrl -- JDBC URL must start with "jdbc:yasdb:" but was: jdbc:mysql://strce-mmvnhf-fe-fe.default.svc.cluster.local:9030?useSSL=false&allowPublicKeyRetrieval=true Test execution failed: Failed to connect to StarRocks database: java.io.IOException: Failed to connect to StarRocks database: at com.apecloud.dbtester.tester.StarRocksTester.connect(StarRocksTester.java:61) at com.apecloud.dbtester.tester.TestExecutor.executeTest(TestExecutor.java:30) at OneClient.executeTest(OneClient.java:105) at OneClient.main(OneClient.java:37) Caused by: java.sql.SQLSyntaxErrorException: Backend node not found. Check if any backend node is down.backend: at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:829) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:449) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:242) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at java.sql/java.sql.DriverManager.getConnection(Unknown Source) at com.apecloud.dbtester.tester.StarRocksTester.connect(StarRocksTester.java:59) ... 3 more `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge pods test-db-client-connectionstress-strce-mmvnhf --namespace default ` pod/test-db-client-connectionstress-strce-mmvnhf 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-strce-mmvnhf" force deleted check failover pod name failover pod name:strce-mmvnhf-fe-0 failover connectionstress Success `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` check component be exists `kubectl get components -l app.kubernetes.io/instance=strce-mmvnhf,apps.kubeblocks.io/component-name=be --namespace default | (grep "be" || true )` check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster vscale strce-mmvnhf --auto-approve --force=true --components be --cpu 1100m --memory 1.1Gi --namespace default ` OpsRequest strce-mmvnhf-verticalscaling-tvskb created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-verticalscaling-tvskb -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-verticalscaling-tvskb default VerticalScaling strce-mmvnhf be Running 0/2 May 28,2025 14:03 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-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 strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:04 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:03 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 14:02 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-verticalscaling-tvskb default VerticalScaling strce-mmvnhf be Succeed 2/2 May 28,2025 14:03 UTC+0800 check ops status done ops_status:strce-mmvnhf-verticalscaling-tvskb default VerticalScaling strce-mmvnhf be Succeed 2/2 May 28,2025 14:03 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-verticalscaling-tvskb --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-verticalscaling-tvskb patched `kbcli cluster delete-ops --name strce-mmvnhf-verticalscaling-tvskb --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-verticalscaling-tvskb deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` cluster restart check cluster status before ops check cluster status done cluster_status:Running `kbcli cluster restart strce-mmvnhf --auto-approve --force=true --components fe --namespace default ` OpsRequest strce-mmvnhf-restart-mrtcc created successfully, you can view the progress: kbcli cluster describe-ops strce-mmvnhf-restart-mrtcc -n default check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-restart-mrtcc default Restart strce-mmvnhf fe Running 0/1 May 28,2025 14:04 UTC+0800 check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce Delete Updating May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce cluster_status:Updating check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:04 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:03 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 14:04 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done check ops status `kbcli cluster list-ops strce-mmvnhf --status all --namespace default ` NAME NAMESPACE TYPE CLUSTER COMPONENT STATUS PROGRESS CREATED-TIME strce-mmvnhf-restart-mrtcc default Restart strce-mmvnhf fe Succeed 1/1 May 28,2025 14:04 UTC+0800 check ops status done ops_status:strce-mmvnhf-restart-mrtcc default Restart strce-mmvnhf fe Succeed 1/1 May 28,2025 14:04 UTC+0800 `kubectl patch -p '{"metadata":{"finalizers":[]}}' --type=merge opsrequests.operations strce-mmvnhf-restart-mrtcc --namespace default ` opsrequest.operations.kubeblocks.io/strce-mmvnhf-restart-mrtcc patched `kbcli cluster delete-ops --name strce-mmvnhf-restart-mrtcc --force --auto-approve --namespace default ` OpsRequest strce-mmvnhf-restart-mrtcc deleted `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check db_client batch data count `echo "echo \"select count(*) from executions_loop.executions_loop_table;\" | mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot -p'19RA16sf5l' " | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash ` cluster update terminationPolicy WipeOut `kbcli cluster update strce-mmvnhf --termination-policy=WipeOut --namespace default ` cluster.apps.kubeblocks.io/strce-mmvnhf updated check cluster status `kbcli cluster list strce-mmvnhf --show-labels --namespace default ` NAME NAMESPACE CLUSTER-DEFINITION TERMINATION-POLICY STATUS CREATED-TIME LABELS strce-mmvnhf default starrocks-ce WipeOut Running May 28,2025 13:45 UTC+0800 app.kubernetes.io/instance=strce-mmvnhf,clusterdefinition.kubeblocks.io/name=starrocks-ce check cluster status done cluster_status:Running check pod status `kbcli cluster list-instances strce-mmvnhf --namespace default ` NAME NAMESPACE CLUSTER COMPONENT STATUS ROLE ACCESSMODE AZ CPU(REQUEST/LIMIT) MEMORY(REQUEST/LIMIT) STORAGE NODE CREATED-TIME strce-mmvnhf-be-0 default strce-mmvnhf be Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:04 UTC+0800 strce-mmvnhf-be-1 default strce-mmvnhf be Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:25Gi 192.168.0.20/192.168.0.20 May 28,2025 14:03 UTC+0800 strce-mmvnhf-fe-0 default strce-mmvnhf fe Running cn-guangzhou-b 1100m / 1100m 1181116006400m / 1181116006400m data:20Gi 192.168.0.18/192.168.0.18 May 28,2025 14:04 UTC+0800 check pod status done `kubectl get secrets -l app.kubernetes.io/instance=strce-mmvnhf` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.username}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.password}"` `kubectl get secrets strce-mmvnhf-fe-account-root -o jsonpath="{.data.port}"` DB_USERNAME:root;DB_PASSWORD:19RA16sf5l;DB_PORT:9030;DB_DATABASE:sys check cluster connect `echo 'mysql -P9030 -hstrce-mmvnhf-fe-fe.default.svc.cluster.local -uroot --prompt="StarRocks > "' | kubectl exec -it strce-mmvnhf-fe-0 --namespace default -- bash` check cluster connect done cluster list-logs `kbcli cluster list-logs strce-mmvnhf --namespace default ` No log files found. cluster logs `kbcli cluster logs strce-mmvnhf --tail 30 --namespace default ` [Wed May 28 14:04:20 CST 2025] /etc/starrocks/be/conf not exist or not a directory, ignore ... [Wed May 28 14:04:20 CST 2025] Add myself (strce-mmvnhf-be-0.strce-mmvnhf-be-headless.default.svc.cluster.local:9050) into FE ... [Wed May 28 14:04:20 CST 2025] run start_be.sh delete cluster strce-mmvnhf `kbcli cluster delete strce-mmvnhf --auto-approve --namespace default ` Cluster strce-mmvnhf deleted pod_info:strce-mmvnhf-be-0 1/1 Running 0 54s strce-mmvnhf-be-1 1/1 Running 0 87s strce-mmvnhf-fe-0 1/1 Running 0 32s pod_info:strce-mmvnhf-be-0 0/1 Terminating 0 74s strce-mmvnhf-be-1 0/1 Terminating 0 107s strce-mmvnhf-fe-0 1/1 Running 0 52s 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. Starrocks CE Test Suite All Done! --------------------------------------Starrocks CE (Topology = shared-nothing Replicas 2) Test Result-------------------------------------- [PASSED]|[Create]|[ComponentDefinition=starrocks-ce-be-1.0.0-alpha.0;ComponentVersion=starrocks-ce-be-1.0.0-alpha.0;ServiceVersion=3.2.2;]|[Description=Create a cluster with the specified component definition starrocks-ce-be-1.0.0-alpha.0 and component version starrocks-ce-be-1.0.0-alpha.0 and service version 3.2.2] [PASSED]|[Connect]|[ComponentName=fe]|[Description=Connect to the cluster] [PASSED]|[Restart]|[-]|[Description=Restart the cluster] [PASSED]|[VolumeExpansion]|[ComponentName=be]|[Description=VolumeExpansion the cluster specify component be] [PASSED]|[Stop]|[-]|[Description=Stop the cluster] [PASSED]|[Start]|[-]|[Description=Start the cluster] [PASSED]|[HorizontalScaling Out]|[ComponentName=be]|[Description=HorizontalScaling Out the cluster specify component be] [PASSED]|[HorizontalScaling In]|[ComponentName=be]|[Description=HorizontalScaling In the cluster specify component be] [PASSED]|[Restart]|[ComponentName=be]|[Description=Restart the cluster specify component be] [PASSED]|[RebuildInstance]|[ComponentName=fe]|[Description=Rebuild the cluster instance specify component fe] [PASSED]|[VerticalScaling]|[ComponentName=fe]|[Description=VerticalScaling the cluster specify component fe] [PASSED]|[Failover]|[HA=Connection Stress;ComponentName=fe]|[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]|[VerticalScaling]|[ComponentName=be]|[Description=VerticalScaling the cluster specify component be] [PASSED]|[Restart]|[ComponentName=fe]|[Description=Restart the cluster specify component fe] [PASSED]|[Update]|[TerminationPolicy=WipeOut]|[Description=Update the cluster TerminationPolicy WipeOut] [PASSED]|[Delete]|[-]|[Description=Delete the cluster] [END]