pingcap / pingcap/tidb

admin check table report [tikv:1690] BIGINT value is out of range

Open
#46,176 0 comments 0 reactions 1 assignee Claimed by @wjhuang2016 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)
1. deploy a v7.1.1 cluster with tikv
2. sysbench prepare 500w rows for each table
3. add index like `alter table sbtest1.sbtest1 add index idxc (c, pad)`;
4. upgrade the cluster to nightly
5. admin check table

### 2. What did you expect to see? (Required)
admin check table success
### 3. What did you see instead (Required)
```log
[conn.go:1082] ["command dispatched failed"] [conn=3275751430] [connInfo="id:3275751430, addr:10.233.83.148:55518 status:10, collation:utf8mb4_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="admin check table sbtest1.sbtest3"] [txn_mode=PESSIMISTIC] [timestamp=0] [err="[tikv:1690]BIGINT value is out of range in '(16 - 145)'"]
```
### 4. What is your TiDB version? (Required)
nightly
```log
-- tidb
[printer.go:47] ["Welcome to TiDB."] ["Release Version"=v7.4.0-alpha] [Edition=Community] ["Git Commit Hash"=4fc7970f216e6ff0e2c9f09d07a9545ba128243c] ["Git Branch"=heads/refs/tags/v7.4.0-alpha] ["UTC Build Time"="2023-08-16 14:33:04"] [GoVersion=go1.21.0] ["Race Enabled"=false] ["Check Table Before Drop"=false]

-- tikv
[lib.rs:93] ["Git Commit Hash: fe6fc7341edd748dd69ad64d31f4499e67039434"]
```
you can find more about log from [here](https://clinic.pingcap.com.cn/portal/#/orgs/33/clusters/7267952491136998899?from=1692197442&to=1692204642)

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.