Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

import fail for "[BR:PD:ErrPDBatchScanRegion]batch scan region" #47992

Closed
seiya-annie opened this issue Oct 26, 2023 · 1 comment · Fixed by #48185
Closed

import fail for "[BR:PD:ErrPDBatchScanRegion]batch scan region" #47992

seiya-annie opened this issue Oct 26, 2023 · 1 comment · Fixed by #48185
Labels
affects-7.1 affects-7.5 component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/major type/bug The issue is confirmed as a bug.

Comments

@seiya-annie
Copy link

seiya-annie commented Oct 26, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

this bug is found during test of import-into, but affects lightning too.

  1. local sort
  2. MySQL [smalltable]> IMPORT INTO smalltable.txn_history_new FROM "ks3://qe-testing/kernel-testing/xxx-10t-csv/big.txn_history.*.csv?access-key=xxx&secret-access-key=xxx&endpoint=ksyuncs.com&force-path-style=false&region=Beijing&provider=ks" with thread=16,detached;

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

import into successfully

3. What did you see instead (Required)

| 180001 | ks3://qe-testing/kernel-testing/xxx-10t-csv/big.txn_history.*.csv?access-key=xxxxxx&endpoint=xxx&force-path-style=false&provider=ks&region=Beijing&secret-access-key=xxxxxx     | `smalltable`.`txn_history_new`  |      136 | importing | failed    | 9.917TB          |          NULL | [BR:PD:ErrPDBatchScanRegion]batch scan region                                                                                                                                                                              | 2023-10-25 20:48:08.268159 | 2023-10-25 20:48:11.623530 | 2023-10-26 03:32:56.402580 | root@%     |

4. What is your TiDB version? (Required)

af7b32c
4cd4d5f

@seiya-annie seiya-annie added type/bug The issue is confirmed as a bug. feature/developing the related feature is in development component/ddl This issue is related to DDL of TiDB. severity/major labels Oct 26, 2023
@ti-chi-bot ti-chi-bot bot added may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 may-affects-7.5 labels Oct 26, 2023
@D3Hunter
Copy link
Contributor

the real error "tikv space lower than 10%", but the real error is eaten, see #47781
and the returned error is the first error met, so we got is "ErrPDBatchScanRegion....context cancelled"
7106eeda-e604-44b2-a3ab-3f7583825afd

@D3Hunter D3Hunter added affects-7.1 and removed may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-6.1 may-affects-6.5 may-affects-7.1 labels Nov 1, 2023
@D3Hunter D3Hunter changed the title import into 10T data with local sort fail for "[BR:PD:ErrPDBatchScanRegion]batch scan region" import fail for "[BR:PD:ErrPDBatchScanRegion]batch scan region" Nov 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 affects-7.5 component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants