# [FAQ]load data ... replace into 与 MySQL 行为不一致，报错 ERROR 8141 (HY000)  assertion failed

## Key Words

replace into, load data, assertion failed

## Description

使用 LOAD DATA REPLACE INTO 语法向 TiDB 集群导入数据，遇到报错 ERROR 8141 (HY000): assertion failed。示例：

```sql
| CREATE TABLE `account` (   `id` int(11) NOT NULL,   `name` varchar(20) DEFAULT NULL,   PRIMARY KEY (`id`) /\*T![clustered_index] CLUSTERED \*/ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;   insert into account values (123456789,'aaa'); insert into account values (12345678,'bbb'); insert into account values (1234567,'ccc'); insert into account values (123456,'ddd'); insert into account values (12345,'eee');   SELECT \* FROM account INTO OUTFILE '/home/tidb/mysql57/runoob3.txt' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; mysql> truncate table test.account ; Query OK, 0 rows affected (0.09 sec)   mysql> LOAD DATA local INFILE '/home/tidb/mysql57/runoob3.txt' replace INTO TABLE test.account  FIELDS TERMINATED BY ',' ENCLOSED BY  '"' ; Query OK, 5 rows affected (0.00 sec) Records: 5  Deleted: 0  Skipped: 0  Warnings: 0   mysql> LOAD DATA local INFILE '/home/tidb/mysql57/runoob3.txt' replace INTO TABLE test.account  FIELDS TERMINATED BY ',' ENCLOSED BY  '"' ; ERROR 8141 (HY000): assertion failed: key: 74800000000000007b5f728000000000003039, assertion: NotExist, start_ts: 435485041765122052, existing start ts: 435485040415080450, existing commit ts: 435485040415080451 | 
```

## Content

产品 BUG，暂未有 Workaround，跟踪[issue](https://github.com/pingcap/tidb/issues/37311)。

## Affected Versions

v6.1, v6.3