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 into failed when inject pdleader io delay 500ms #48065

Closed
Lily2025 opened this issue Oct 30, 2023 · 2 comments
Closed

import into failed when inject pdleader io delay 500ms #48065

Lily2025 opened this issue Oct 30, 2023 · 2 comments
Assignees
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development 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 severity/major type/bug The issue is confirmed as a bug.

Comments

@Lily2025
Copy link

Lily2025 commented Oct 30, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

tidb_enable_dist_task='on'
1、run import into
2、inject pdleader io delay 500ms
case config:

  • name: config_ha_pdleader_io_delay_500ms
    default: |
    tag: "ha-test-import-into"
    cases:
    - name: ha_pd(leader)_io_delay(500ms)
    faultType: iochaos_io_delay(volumePath:/var/lib/pd,path:/var/lib/pd/data/**/*,delay:500ms,percent:100)
    warmUpTime: 1m
    selector: pd(leader)
    period: "@every 5m"
    faultDuration: 1m
    faultTotalRunTime: 20m
    importInto:
    - db: "importtest"
    schema: "CREATE TABLE user_data1 (
    uid bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    data mediumblob NOT NULL,
    update_data blob NOT NULL,
    create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    update_time datetime DEFAULT NULL,
    PRIMARY KEY (uid) /*T![clustered_index] CLUSTERED /,
    KEY k_1 (update_time)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=5850196;"
    cmd: "import into user_data1 from 's3://brie/lightning-mhy-100G-csv/sysbench.user_data1.000001
    .csv?access-key=minioadmin\u0026secret-access-key=minioadmin\u0026endpoint=http://minio.pingcap.net:9001\u0026force-path-style=true' WITH DETACHED,skip_rows=1"
    timeout: 120m
    crc32Checksum: 3582177512

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

import into success

3. What did you see instead (Required)

import into failed when inject pdleader io delay 500ms

"the status of import job is not finished or running (now: 2023-10-29 15:10:05, jobId: 60008, step: importing, status: failed)
operatorLogs:
[2023-10-29 14:55:36] ###### start import into
import into user_data1 from 's3://brie/lightning-mhy-100G-csv/sysbench.user_data1.000001*.csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http://minio.pingcap.net:9001&force-path-style=true' WITH DETACHED,skip_rows=1
[2023-10-29 14:55:36] ###### wait for import job to finish
[2023-10-29 15:10:05] ###### wait for import job to finish failed
select id, step, status from mysql.tidb_import_jobs where start_time >= '2023-10-29 14:55:36'
jobId: 60008, step: importing, status: failed"

4. What is your TiDB version? (Required)

git hash:3682bd82cac05a75241ed9fc9f29a1d320d776a7

@Lily2025 Lily2025 added the type/bug The issue is confirmed as a bug. label Oct 30, 2023
@Lily2025 Lily2025 changed the title import into failed when inject pdleader io import into failed when inject pdleader io delay 500ms Oct 30, 2023
@jebter jebter added severity/critical component/ddl This issue is related to DDL of TiDB. labels Oct 30, 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 30, 2023
@jebter jebter added feature/developing the related feature is in development affects-7.5 This bug affects the 7.5.x(LTS) versions. labels Oct 30, 2023
@Lily2025
Copy link
Author

/assign gmhdbjd

@D3Hunter
Copy link
Contributor

D3Hunter commented Nov 2, 2023

duplicate with #48075, will close this one

@D3Hunter D3Hunter closed this as completed Nov 2, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.5 This bug affects the 7.5.x(LTS) versions. component/ddl This issue is related to DDL of TiDB. feature/developing the related feature is in development 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 severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

4 participants