tidb日志报错都是:
182830:[2026/01/26 09:21:28.901 +07:00] [WARN] [regioniter.go:123] ["failed with trying to scan regions"] [error="scan region return empty result, startKey: 7480000000000006A85F728000000003365672, endKey: 7480000000000006A85F728000000003383DB9: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [start=7480000000000006A85F728000000003365672] [end=7480000000000006A85F728000000003383DB9]
182831:[2026/01/26 09:21:28.901 +07:00] [WARN] [regioniter.go:123] ["failed with trying to scan regions"] [error="scan region return empty result, startKey: 7480000000000006A85F728000000003BD868B, endKey: 7480000000000006A85F728000000003BF6DAD: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [start=7480000000000006A85F728000000003BD868B] [end=7480000000000006A85F728000000003BF6DAD]
182832:[2026/01/26 09:21:28.901 +07:00] [WARN] [regioniter.go:123] ["failed with trying to scan regions"] [error="scan region return empty result, startKey: 748000000000000A5C5F72800000001F621262, endKey: 748000000000000A5C5F72800000001F638639: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [start=748000000000000A5C5F72800000001F621262] [end=748000000000000A5C5F72800000001F638639]
182833:[2026/01/26 09:21:28.901 +07:00] [WARN] [regioniter.go:123] ["failed with trying to scan regions"] [error="scan region return empty result, startKey: 7480000000000006A85F728000000002A5161E, endKey: 7480000000000006A85F728000000002A6F9C7: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [start=7480000000000006A85F728000000002A5161E] [end=7480000000000006A85F728000000002A6F9C7]
182834:[2026/01/26 09:21:28.901 +07:00] [WARN] [regioniter.go:123] ["failed with trying to scan regions"] [error="scan region return empty result, startKey: 7480000000000006A85F7280000000027B3166, endKey: 7480000000000006A85F7280000000027D10C0: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [start=7480000000000006A85F7280000000027B3166] [end=7480000000000006A85F7280000000027D10C0]
182835:[2026/01/26 09:21:28.901 +07:00] [WARN] [regioniter.go:123] ["failed with trying to scan regions"] [error="scan region return empty result, startKey: 748000000000000A5A5F72800000001F623525, endKey: 748000000000000A5A5F72800000001F630A83: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [start=748000000000000A5A5F72800000001F623525] [end=748000000000000A5A5F72800000001F630A83]
2026-01-26 08:00:11 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:00:21 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:00:31 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:00:41 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:00:51 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:01:01 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:01:11 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:01:21 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
2026-01-26 08:01:31 (UTC+08:00)TiKV 10.235.38.65:20160[split_observer.rs:148] ["failed to handle split req"] [err="\"no valid key found for split.\""] [region_id=467361] [thread_id=0x5]
mysql> SHOW CONFIG WHERE NAME LIKE '%pd%timeout%' OR NAME LIKE '%pd%retry%';
+---------+--------------------+------------------------------------+---------------------+
| Type | Instance | Name | Value |
+---------+--------------------+------------------------------------+---------------------+
| tidb | 10.235.38.63:4000 | pd-client.pd-server-timeout | 3 |
| tikv | 10.235.38.65:20160 | pd.retry-interval | 300ms |
| tikv | 10.235.38.65:20160 | pd.retry-log-every | 10 |
| tikv | 10.235.38.65:20160 | pd.retry-max-count | 9223372036854776000 |
| tikv | 10.235.38.64:20160 | pd.retry-interval | 300ms |
| tikv | 10.235.38.64:20160 | pd.retry-log-every | 10 |
| tikv | 10.235.38.64:20160 | pd.retry-max-count | 9223372036854776000 |
| tiflash | 10.235.38.69:3930 | raftstore-proxy.pd.retry-interval | 300ms |
| tiflash | 10.235.38.69:3930 | raftstore-proxy.pd.retry-log-every | 10 |
| tiflash | 10.235.38.69:3930 | raftstore-proxy.pd.retry-max-count | 9223372036854776000 |
| tiflash | 10.235.38.68:3930 | raftstore-proxy.pd.retry-interval | 300ms |
| tiflash | 10.235.38.68:3930 | raftstore-proxy.pd.retry-log-every | 10 |
| tiflash | 10.235.38.68:3930 | raftstore-proxy.pd.retry-max-count | 9223372036854776000 |
| tikv | 10.235.38.66:20160 | pd.retry-interval | 300ms |
| tikv | 10.235.38.66:20160 | pd.retry-log-every | 10 |
| tikv | 10.235.38.66:20160 | pd.retry-max-count | 9223372036854776000 |
+---------+--------------------+------------------------------------+---------------------+
lllzd
(时光旅行者)
24
autoanalyze在分析特定分区表时因PD请求超时失败,可能是该表数据量大或PD负载高导致,进而影响查询。
纯白镇的小智
(Ti D Ber Qm Qja01 M)
26
AutoAnalyze 任务超时:TiDB 自动触发的 ANALYZE 语句(收集表统计信息)在规定时间内没从 PD 获取到必要的 Region 元数据
Leonard
(Hacker Byb Hr4 Nu)
28
ADMIN CHECK TABLE tbl_name; check一下表呢。看看grafana的pd面板中的 region 情况,pending-region,down-region什么的