import into jobs is always running after kill ddl owner

[Lily2025]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

1、tidb_enable_dist_task='on'
2、import into user_data1 from 's3://brie/mvindex-10000000-csv/test.user_data1.*.csv?access-key=minioadmin&secret-access-key=minioadmin&endpoint=http://minio.pingcap.net:9001&force-path-style=true' WITH skip_rows=1
3、after 2mins，kill ddl owner

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

import into task can finish

3. What did you see instead (Required)

import into jobs is always running
mysql> select * from mysql.tidb_import_jobs where start_time >= '2023-09-06 17:20:09';
+--------+----------------------------+----------------------------+----------------------------+----------+--------------+------------+----------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+---------+-----------+---------+---------------+
| id | create_time | start_time | update_time | end_time | table_schema | table_name | table_id | created_by | parameters | source_file_size | status | step | summary | error_message |
+--------+----------------------------+----------------------------+----------------------------+----------+--------------+------------+----------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+---------+-----------+---------+---------------+
| 270002 | 2023-09-06 17:20:10.690458 | 2023-09-06 17:20:11.245575 | 2023-09-06 17:20:11.245575 | NULL | importtest | user_data1 | 539 | root@% | {"file-location":"s3://brie/mvindex-10000000-csv/test.user_data1.*.csv?access-key=xxxxxx\u0026endpoint=http%3A%2F%2Fminio.pingcap.net%3A9001\u0026force-path-style=true\u0026secret-access-key=xxxxxx","format":"csv","options":{"skip_rows":"1"}} | 1995557384 | running | importing | NULL | NULL |
+--------+----------------------------+----------------------------+----------------------------+----------+--------------+------------+----------+------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------+---------+-----------+---------+---------------+
1 row in set (0.01 sec)

4. What is your TiDB version? (Required)

./tidb-server -V
Release Version: v7.4.0-alpha
Edition: Community
Git Commit Hash: 66fe053
Git Branch: heads/refs/tags/v7.4.0-alpha
UTC Build Time: 2023-09-05 11:43:48
GoVersion: go1.21.0
Race Enabled: false
Check Table Before Drop: false
Store: unistore

[Lily2025]

/assign D3Hunter

[D3Hunter]

currently, scheduler don't handle node fail. it's expect to be failed directly.