Failed Pre-check When Migrating Data Using tidb-light

Translated
1

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

Original topic: 使用tidb-light执行数据迁入，前置校验失败

| username: TiDBer_zhw

【TiDB Usage Environment】Production\Test Environment\POC
【TiDB Version】5.4
【Encountered Problem】
Executing lighting TiKV stores (1) contains more than 1000 empty regions respectively, which will greatly affect the import speed and success rate

Checked region merge and everything is normal
image

image
image1524×284 20.1 KB

【Reproduction Path】Previously deleted data from the target database
【Problem Phenomenon and Impact】
【Attachments】

  • Relevant logs, configuration files, Grafana monitoring (https://metricstool.pingcap.com/)
  • TiUP Cluster Display information
  • TiUP Cluster Edit config information
  • TiDB-Overview monitoring
  • Corresponding module Grafana monitoring (if any, such as BR, TiDB-binlog, TiCDC, etc.)
  • Corresponding module logs (including logs one hour before and after the issue)

If the question is related to performance optimization or fault troubleshooting, please download the script and run it. Please select all and copy-paste the terminal output results and upload them.

2
| username: songxuecheng | Original post link

You can skip the check.

3
| username: TiDBer_zhw | Original post link

Won’t this affect it? What could be the reason for the region not merging?

4
| username: yilong | Original post link

You can first refer to [FAQ] 解决已经开启 region merge， empty-region-count 仍然很多问题 - TiDB 的问答社区 to see if there are many empty tables that have not been merged.

5
| username: system | Original post link

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