TiDB TiKV Node Offline

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb tikv节点offline

| username: TiDBer_ZsnVPQB4

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.2.1
[Reproduction Path] TiFlash suddenly OOM, then it keeps automatically restarting and OOMing, unable to start. Scale-in and re-scale-out don’t work either. Manually deleting the synchronized store ID and synchronization rules in PD, it prompts successful deletion, but queries still show it. TiUP cluster display shows TiFlash as normal, but all TiKV nodes are in an offline state.
[Encountered Problem: Problem Phenomenon and Impact]
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

| username: h5n1 | Original post link

  1. Before scaling TiFlash, is the TiFlash table canceled first?
  2. Which specific rule (placement?) and operation method is this deletion referring to?
  1. Use pd-ctl store to check if TiKV is offline, it might be related to the rules you deleted earlier. If Pd-ctl also shows it as offline, you can try the following command to see if it can be brought up:
    curl -X POST http://:/pd/api/v1/store/<store_id>/state?state=Up
| username: TiDBer_ZsnVPQB4 | Original post link

It should be that too many stores were deleted. Can that store be restored online?

| username: h5n1 | Original post link

Restoring with the above command always gets interrupted.

| username: TiDBer_ZsnVPQB4 | Original post link

It should be fine now. Before scaling down, the synchronization table was canceled through ALTER TABLE SET TIFLASH REPLICA 0.

According to the official documentation 使用 TiUP 扩容缩容 TiDB 集群 | PingCAP 文档中心, the deletion rules are specified there. Because the deletion of the store is not very detailed, I thought all the store IDs queried by the command needed to be deleted. Fortunately, it can be restored.

curl http://10.30.30.3:2379/pd/api/v1/config/rules/group/tiflash
curl -v -X DELETE http://10.30.30.3:2379/pd/api/v1/config/rule/tiflash/table-427133-r

Thank you, expert!

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.