select from information_schema.tikv_store_status gives "invalid character"
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
I have a 2+2+1 cluster in us-east-1, us-east-2, and us-west-2, respectively. I modified the routes for us-east-1 so that it cannot communicate with us-east-2. I tried to get store status, and I got an error.
### 2. What did you expect to see? (Required)
tikv_store_status should show the current status of stores in the cluster.
### 3. What did you see instead (Required)
```
MySQL [information_schema]> select * from tikv_store_status;
ERROR 1105 (HY000): invalid character 'r' looking for beginning of value
```
```
[2022/09/09 19:13:26.822 +00:00] [INFO] [conn.go:1149] ["command dispatched failed"] [conn=8680459583338057223] [connInfo="id:8680459583338057223, addr:10.100.111.193:57766 status:10, collation:utf8_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="select label, status, store_id, is_leader from information_schema.tikv_region_status join information_schema.tikv_region_peers using (region_id) join information_schema.tikv_store_status using (store_id) where table_name='t1' order by not is_leader, label"] [txn_mode=PESSIMISTIC] [timestamp=0] [err="invalid character 'r' looking for beginning of value
github.com/pingcap/errors.AddStack
/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174
github.com/pingcap/errors.Trace
/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/juju_adaptor.go:15
github.com/pingcap/tidb/store/helper.(*Helper).requestPD
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/helper/helper.go:876
github.com/pingcap/tidb/store/helper.(*Helper).GetRegionsInfo
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/helper/helper.go:797
github.com/pingcap/tidb/executor.(*memtableRetriever).setDataForTiKVRegionStatus
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/infoschema_reader.go:1544
github.com/pingcap/tidb/executor.(*memtableRetriever).retrieve
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/infoschema_reader.go:145
github.com/pingcap/tidb/executor.(*MemTableReaderExec).Next
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/memtable_reader.go:118
github.com/pingcap/tidb/executor.Next
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:319
github.com/pingcap/tidb/executor.(*SelectionExec).Next
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:1420
github.com/pingcap/tidb/executor.Next
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:319
github.com/pingcap/tidb/executor.(*HashJoinExec).fetchProbeSideChunks
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/join.go:214
github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable.func1
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/join.go:338
github.com/pingcap/tidb/util.WithRecovery
/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/misc.go:91
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1571"]
```
### 4. What is your TiDB version? (Required)
```
tidb_Version(): Release Version: v6.1.1
Edition: Community
Git Commit Hash: 5263a0abda61f102122735049fd0dfadc7b7f8b2
Git Branch: heads/refs/tags/v6.1.1
UTC Build Time: 2022-08-25 10:42:41
GoVersion: go1.18.5
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
```
Contributor guide
Assessment
This issue has not been assessed yet.