Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Data inconsistency in table after upgrade (v7.1->v7.3) cluster during add index #48830

Closed
zimulala opened this issue Nov 23, 2023 · 1 comment
Labels
affects-7.3 component/ddl This issue is related to DDL of TiDB. type/bug The issue is confirmed as a bug.

Comments

@zimulala
Copy link
Contributor

zimulala commented Nov 23, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

  1. deploy v7.1.0 cluster
  2. build tables and prepare large amounts of data
    3.1 add an index for the table like alter table db.xx add index idx1 (create_time, update_time, bill_code, order_code, assign_site_code, three_code, send_name, receive_name, send_mobile)
    3.2 during index creation, upgrade the cluster to v7.3
  3. admin check index db.xx idx1;

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

success

3. What did you see instead (Required)

 [reporter.go:291] ["admin check found data inconsistency"] [conn=3812622340] [table_name=xx] [index_name=idx1] [row_id=1224979098646354856] [index=] [row="handle: 1224979098646354856, values: [KindMysqlTime 2023-05-18 16:28:46 KindMysqlTime 2023-05-18 16:28:46 KindString 24f9537c-2448-4281-9a82-25e5f51701e3-1684398526273978778 KindString 909b17de-4305-4334-b38e-c902d6751638909b17de-4305-4334-b38 KindString 80 KindString f5f75195-d4ca-4ee2-adf7-b2852429fb7cf5f75195-d4ca-4ee2-ad KindString 2f5f650a-acde-4bb9-b773-be7be8f164512f5f650a-acd KindString fedf434f-817a-4100-948c-8305ea80c472fedf434f-8 KindString 7b27d4de-db62-4]"] [row_mvcc="{\"key\":\"74800000000000009A5F729100000000181BA8\",\"mvcc\":{\"info\":{}},\"regionID\":134}"] [stack="github.com/pingcap/tidb/util/logutil/consistency.(*Reporter).ReportAdminCheckInconsistent\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/logutil/consistency/reporter.go:290\ngit.luolix.top/pingcap/tidb/executor.(*checkIndexWorker).HandleTask\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/executor/executor.go:2666\ngit.luolix.top/pingcap/tidb/resourcemanager/pool/workerpool.(*WorkerPool[...]).handleTaskWithRecover\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/resourcemanager/pool/workerpool/workerpool.go:104\ngit.luolix.top/pingcap/tidb/resourcemanager/pool/workerpool.(*WorkerPool[...]).runAWorker.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/resourcemanager/pool/workerpool/workerpool.go:116\ngit.luolix.top/pingcap/tidb/util.(*WaitGroupWrapper).Run.func1\n\t/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/wait_group_wrapper.go:154"]

4. What is your TiDB version? (Required)

v7.3

@zimulala zimulala added type/bug The issue is confirmed as a bug. component/ddl This issue is related to DDL of TiDB. affects-7.3 labels Nov 23, 2023
@tangenta
Copy link
Contributor

Duplicated with #44619.

It is recommended to use >= v7.1.1 instead.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.3 component/ddl This issue is related to DDL of TiDB. type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

2 participants