ADMIN CHECK INDEX Error

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: ADMIN CHECK INDEX 报错

| username: Holland

[TiDB Usage Environment] Production Environment
[TiDB Version]
6.1.1
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Problem Phenomenon and Impact]
Found that the query results are inaccurate

image
image1380×316 25.8 KB

So executed ADMIN CHECK INDEX xxx xxx
Error reported
ERROR 8003 (HY000): table count 30670636 != index(idx_status) count 30675180
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

2
| username: WalterWj | Original post link

You can consider index rebuilding…

3
| username: Holland | Original post link

Rebuilding the index worked, but why?

4
| username: WalterWj | Original post link

For example, using features like Lightning and batch insert has caused data index inconsistencies.

5
| username: WalterWj | Original post link

If the import fails in lightning local mode, it will cause such issues.

6
| username: Holland | Original post link

If the br restore fails, will this happen?

7
| username: WalterWj | Original post link

Not sure, maybe :thinking:

8
| username: Holland | Original post link

Does that mean all indexes need to be checked?

9
| username: WalterWj | Original post link

Just use “admin check table”. No need to check one by one.

10
| username: Holland | Original post link

Okay, thank you.

11
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.