Bug 1300621

Summary: Duplicate key with auto increment
Product: Red Hat Enterprise Linux 7 Reporter: Rupesh Patel <rupatel>
Component: mariadbAssignee: Jakub Dorňák <jdornak>
Status: CLOSED ERRATA QA Contact: qe-baseos-daemons
Severity: urgent Docs Contact:
Priority: urgent    
Version: 7.4CC: baptiste.agasse, bblaskov, databases-maint, fkrska, hhorak, jdornak, jprokes, lkuprova, mkolaja, thoger, troels
Target Milestone: rcKeywords: Patch, ZStream
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: mariadb-5.5.44-3.el7 Doc Type: Bug Fix
Doc Text:
When more than one INSERT operation was executed concurrently on a non-empty InnoDB table with an AUTO_INCREMENT column defined as a primary key immediately after starting MariaDB, a race condition could occur. As a consequence, one of the concurrent INSERT operations failed with a "Duplicate key" error message. A patch has been applied to prevent the race condition. Now, each row inserted as a result of the concurrent INSERT operations receives a unique primary key, and the operations no longer fail in this scenario.
Story Points: ---
Clone Of:
: 1303946 (view as bug list) Environment:
Last Closed: 2016-11-03 20:46:29 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1303946    

Description Rupesh Patel 2016-01-21 10:00:18 UTC
Upstream found critical bug in recent releases and they have fixed it here.
https://mariadb.atlassian.net/browse/MDEV-8827

Upstream has fixed it in 5.5.47.

Comment 16 errata-xmlrpc 2016-11-03 20:46:29 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://rhn.redhat.com/errata/RHSA-2016-2595.html