"import into" fail for "[tikv:9005]Region is unavailable "

[seiya-annie]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

IMPORT INTO big.items FROM "s3://tmp/9T-csv/*.csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http%3a%2f%2f10.2.12.100%3a32762&force-path-style=true" with thread=16,detached;

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

import successfully

3. What did you see instead (Required)

| 1 | s3://tmp/9T-csv/*.csv?access-key=xxxxxx&endpoint=http%3A%2F%2F10.2.12.100%3A32762&force-path-style=true&secret-access-key=xxxxxx | big.items | 102 | importing | failed | 9.672TB | NULL | [tikv:9005]Region is unavailable | 2023-06-27 04:14:38.790453 | 2023-06-27 04:14:39.004909 | 2023-06-27 04:22:27.405844 | root@% |

2023-06-27 12:22:28 (UTC+08:00)TiDB upstream-tidb-1.upstream-tidb-peer.import-into-20t-tps-1812649-1-327.svc:4000[local.go:1218] ["scan region failed"] [error="scan regions from start-key:7480000000000000FF665F72016E6F6465FF314B7771FF477077FF6845674131FF526EFF457261393159FF47FF696B34554E704EFFFF736E586130354661FFFF734136424D6C63FF57FF6E374F565334FF5274FF5759517643FF444C70FF4C454D65FF584E7339FF4F6964FF3364416A78FF5A6DFF373071515454FF61FF46316658416259FFFF3466563559576C78FFFF63434766314270FF51FF4B32394D6343FF3961FF30614D4268FF435A34FF687A7939FF686F594BFF367471FF41434A4A4FFF304DFF55395239314EFF4EFF4342726F396A48FFFF697A675645665170FFFF663077384C577AFF47FF764F5879704DFF644DFF3354526C4FFF794154FF39625247FF37367139FF683344FF5755765058FF7734FF4F30746F386FFF70FF58617248384E30FFFF6D00000000000000FFF800000000000000F8, err: rpc error: code = Canceled desc = context canceled: [BR:PD:ErrPDBatchScanRegion]batch scan region"] [region_len=0]

4. What is your TiDB version? (Required)

sh-5.1# ./tidb-server -V
Release Version: v7.2.0
Edition: Community
Git Commit Hash: 7e48b88
Git Branch: heads/refs/tags/v7.2.0
UTC Build Time: 2023-06-27 01:47:28
GoVersion: go1.20.5
Race Enabled: false
Check Table Before Drop: false
Store: unistore
sh-5.1#

[seiya-annie]

tidb.log.gz

[D3Hunter]

might be fixed by this cp pr #45000