[MDEV-18403] Roughly 10% of data loads fail due to duplicate entries Created: 2019-01-28  Updated: 2020-07-07  Resolved: 2020-07-07

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert
Affects Version/s: 10.3.9
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Alex (Inactive) Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: innodb, need_feedback, spider
Environment:

Centos 6.8 with 96GB RAM 2CPU with 12 Core each

Attachments: File TestTable.sql     Text File spider variables.txt    

 Description   

Facing a spider 3.3.13 with MariaDB 10.3.9 issue when loading data. The error displayed indicates there is an existing record already in the table:

*spider_auto_increment_mode (Duplicate entry '19597958616-183' for key ‘PRIMARY’) *

Roughly 10% of the data loaded to the table fails with this error.

Spider configuration variables and table DDL attached.

 Comments   
Comment by Kentoku Shiba (Inactive) [ 2019-05-28 ]

ainfanzon
How can I reproduce this issue?
Would you please add a result of "show create table"?
Would you please add the detail of "load data" command?
Would you please add the variables other than Spider?

Generated at Thu Feb 08 08:43:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.