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

XML

Word

Printable

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.

Attachments

Attachments

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

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

Activity

People

Assignee:: Unassigned

Reporter:: Alex (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2019-01-28 19:48

Updated:: 2020-07-07 21:53

Resolved:: 2020-07-07 21:53

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.