Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Incomplete
-
Affects Version/s: 10.3.9
-
Fix Version/s: N/A
-
Component/s: Data Manipulation - Insert
-
Labels:
-
Environment:Centos 6.8 with 96GB RAM 2CPU with 12 Core each
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.