Issues Encountered While Trying to Use TiDB

Translated
1

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

Original topic: 尝试使用 tidb 遇到的问题

| username: TiDBer_FS9IYPWq

[TiDB Usage Environment] Testing
[TiDB Version] 7.4.0
Encountered the following issues when deleting data:

  1. execute failed: Information schema is out of date: schema failed to update in 1 lease
  2. Cannot execute: TiKV server reports stale command
  3. Region is unavailable
2
| username: Jellybean | Original post link

If you put the incorrect content of the above question into the forum’s search box, you can find the solution.

Give a man a fish, and you feed him for a day. Teach a man to fish, and you feed him for a lifetime.

3
| username: 像风一样的男子 | Original post link

Compare and check.

4
| username: 有猫万事足 | Original post link

How did you delete it? Did you directly use “delete from t” on the large table?
It would be best if you could provide the steps and logs.

5
| username: dba远航 | Original post link

The regine information is outdated, it should be an issue with regine cache synchronizing PD information, right?

6
| username: zhanggame1 | Original post link

How exactly was it deleted? It’s best to send the original log of the deletion process. Also, logs at the info and warn levels generally don’t need to be addressed.

7
| username: Kongdom | Original post link

:thinking: This might be caused by deleting too much data, leading to an OOM. Please share the node logs for a look.