Error "commit forced to quit" when executing load data

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: load data 执行时报错 err=“commit forced to quit”

| username: BigC

[TiDB Usage Environment]

[TiDB Version]

[Reproduction Path]
Using the load data statement to load a CSV file with approximately 270,000 rows.

[Encountered Issue]
Execution error, tidb.log shows err=“commit forced to quit”. The number of rows imported into the table in the database is 0.
Already checked:

  1. No restarts of any cluster components during the process, no records of statement OOM.
  2. No logs corresponding to the time in tidb_stderr.log.

Does anyone have other troubleshooting ideas?

[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]

| username: tidb菜鸟一只 | Original post link

Why not use Lightning?

| username: Jellybean | Original post link

Check the cluster monitoring for any transaction or lock conflicts.

| username: dba远航 | Original post link

This situation seems to be caused by a transaction rollback due to a failure when synchronizing to the follower. You can try multiple times or execute the data split multiple times.