sysbench report "Information schema is out of date"，TiKV log show "Region is unavailable"

[Lily2025]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1. run sysbench work load
   tableNum = 128
   tableSize = 10000000000
   threads=128

run_type = 'oltp_write_only'
2. About after 20 minutes，report some error

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

The workload is running normally

3. What did you see instead (Required)

About after 20 minutes，report some error

4. What is your TiDB version? (Required)

| Release Version: v5.1.1
Edition: Community
Git Commit Hash: fb0eaf7
Git Branch: heads/refs/tags/v5.1.1
UTC Build Time: 2021-07-23 13:18:59
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[sticnarf]

I encountered the same problem before when I was testing high write pressure on TiDB. The root cause is probably tikv/tikv#10169. The issue makes the region containing the schema data cannot serve read requests, so TiDB cannot update its schema in time.

This issue is expected to be solved after tikv/tikv#10249 remove the write stall from TiKV.

[cfzjywxk]

@sticnarf
Should we close this issue by now?

[sticnarf]

@sticnarf
Should we close this issue by now?

I think so. After write stall is removed, this issue should not happen.

@Lily2025 If you encounter the same problem after TiKV 5.2, free free to reopen this issue.

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'backport-x.y.z',
and then remove 'needs-more-info' label.