TiDB is unable to query, some nodes are disconnected intermittently

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

Original topic: tidb用无法查询了,有些节点间断掉

| username: 点点-求助来了

[TiDB Usage Environment] Production Environment
[TiDB Version] v5.0.1
[Reproduction Path]
[Encountered Problem: Phenomenon and Impact] Unable to query, but can write
[Resource Configuration] 64 core 128 memory * 3
[Attachments: Screenshots/Logs/Monitoring]



| username: tidb狂热爱好者 | Original post link

Your entire system is down. Manually start TiKV.

| username: 点点-求助来了 | Original post link

It has already started, this is a screenshot of an exception.

| username: 点点-求助来了 | Original post link

Mainly the logs.

| username: tidb狂热爱好者 | Original post link

service tikv-10060 start

| username: tidb狂热爱好者 | Original post link

The log error indicates that it cannot connect to TiKV. I see that you haven’t started any TiKV instances, so this error is expected. Check the TiKV log to see what errors are reported.

| username: TI表弟 | Original post link

Create a diagram to show the current status of the node.

| username: 点点-求助来了 | Original post link

| username: 点点-求助来了 | Original post link

How to do it, where to get it?

| username: TI表弟 | Original post link

Display the current status.

| username: TI表弟 | Original post link

Did all the TiKV nodes go down?

| username: 点点-求助来了 | Original post link

The image you provided is not accessible. Please provide the text you need translated.

| username: 点点-求助来了 | Original post link

| username: TI表弟 | Original post link

Are you taking the TiKV offline?

| username: 点点-求助来了 | Original post link

It has been restarted.

| username: TI表弟 | Original post link

Can it be queried currently?

| username: 点点-求助来了 | Original post link

The query is very slow.

| username: TI表弟 | Original post link

Go to the dashboard to check resource usage.

| username: 点点-求助来了 | Original post link

Often can’t connect, been using the code for years, only today it’s like this.

| username: 点点-求助来了 | Original post link

Where should I click to view?