[MDEV-18403] Roughly 10% of data loads fail due to duplicate entries - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.3.9
Fix Version/s: 10.3, 10.4
Component/s: Data Manipulation - Insert
Labels:
- innodb
- spider
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.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

spider variables.txt
6 kB
2019-01-28 19:22
TestTable.sql
4 kB
2019-01-28 19:47

Activity

People

Assignee:: Alex

Reporter:: Alex

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-01-28 19:48

Updated:: 2019-05-28 10:41