pingcap / pingcap/tidb

select from information_schema.tikv_store_status gives "invalid character"

Open
#37,749 3 comments 0 reactions 0 assignees View on GitHub
severity/moderate sig/sql-infra type/bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.