"show table ** regions;" ERROR 1105 (HY000): json: cannot unmarshal number 18446744073709354954 into Go struct field RegionInfo.written_bytes of type int64

[alex-quan-001]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

During the data import process, i used "show table ** regions;" comand.

2. What did you expect to see? (Required)

Return normal value

3. What did you see instead (Required)

It return "ERROR 1105 (HY000): json: cannot unmarshal number 18446744073709354954 into Go struct field RegionInfo.written_bytes of type int64"

here is the tidb logs:
[2021/02/18 15:58:22.356 +08:00] [INFO] [conn.go:809] ["command dispatched failed"] [conn=59] [connInfo="id:59, addr:192.168.190.9:50610 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="show table lineitem regions"] [txn_mode=PESSIMISTIC] [err="json: cannot unmarshal number 18446744073709354954 into Go struct field RegionInfo.written_bytes of type int64
github.com/pingcap/errors.AddStack
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/errors.go:174
github.com/pingcap/errors.Trace
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/pkg/mod/github.com/pingcap/errors@v0.11.5-0.20201126102027-b0a155152ca3/juju_adaptor.go:15
github.com/pingcap/tidb/store/helper.(*Helper).requestPD
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/helper/helper.go:672
github.com/pingcap/tidb/store/helper.(*Helper).GetRegionInfoByID
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/store/helper/helper.go:636
github.com/pingcap/tidb/executor.getRegionInfo
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/split.go:820
github.com/pingcap/tidb/executor.getRegionMeta
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/split.go:794
github.com/pingcap/tidb/executor.getPhysicalTableRegions
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/split.go:644
github.com/pingcap/tidb/executor.getTableRegions
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/show.go:1591
github.com/pingcap/tidb/executor.(*ShowExec).fetchShowTableRegions
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/show.go:1577
github.com/pingcap/tidb/executor.(*ShowExec).fetchAll
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/show.go:205
github.com/pingcap/tidb/executor.(*ShowExec).Next
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/show.go:100
github.com/pingcap/tidb/executor.Next
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/executor.go:278
github.com/pingcap/tidb/executor.(*recordSet).Next
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/executor/adapter.go:129
github.com/pingcap/tidb/server.(*tidbResultSet).Next
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/driver_tidb.go:298
github.com/pingcap/tidb/server.(*clientConn).writeChunks
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1732
github.com/pingcap/tidb/server.(*clientConn).writeResultset
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1692
github.com/pingcap/tidb/server.(*clientConn).handleStmt
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1589
github.com/pingcap/tidb/server.(*clientConn).handleQuery
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1455
github.com/pingcap/tidb/server.(*clientConn).dispatch
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:1029
github.com/pingcap/tidb/server.(*clientConn).Run
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/conn.go:792
github.com/pingcap/tidb/server.(*Server).onConn
/home/jenkins/agent/workspace/optimization-build-tidb-linux-amd/go/src/github.com/pingcap/tidb/server/server.go:461
runtime.goexit
/usr/local/go/src/runtime/asm_amd64.s:1357"]

4. What is your TiDB version? (Required)

Release Version: v5.0.0-rc
Edition: Community
Git Commit Hash: fd4437d
Git Branch: heads/refs/tags/v5.0.0-rc
UTC Build Time: 2021-01-12 06:00:03
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

[HunDunDM]

direct cause: pd: /region in the API may return a huge written_keys

[bb7133]

The RegionInfo in PD uses uint64 for WrittenKeys: https://github.com/tikv/pd/blob/master/server/api/region.go#L53

However the RegionInfo in TiDB uses int64: https://github.com/pingcap/tidb/blob/master/store/helper/helper.go#L454

Which caused the 'overflow' error.

[xiongjiwei]

seems it has been fixed

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions