Project

General

Profile

Actions
Copy link

Bug #8586

closed

Race condition in indexing errata

Added by Stephen Benjamin over 9 years ago. Updated almost 6 years ago.

Status:
Closed
Priority:
High
Assignee:
Justin Sherrill
Category:
Errata Management
Target version:
Katello 2.3.0
Difficulty:
medium
Triaged:
Yes
Bugzilla link:
1219054
Pull request:
https://github.com/Katello/katello/pull/5280
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Syncing two repos at the same time which may contain the same errata can result in a race condition because find_or_create_by isn't atomic (http://www.rubydoc.info/docs/rails/ActiveRecord/Relation:find_or_create_by)

ActiveRecord::RecordNotUnique

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_katello_errata_on_uuid" : INSERT INTO "katello_errata" ("created_at", "description", "errata_id", "errata_type", "issued", "reboot_suggested", "severity", "solution", "summary", "title", "updated", "updated_at", "uuid") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13) RETURNING "id"
Actions
Copy link
 #1

Updated by Justin Sherrill over 9 years ago

  • Priority changed from Normal to High
  • Target version set to 62
  • translation missing: en.field_release set to 14
  • Difficulty set to medium
  • Triaged changed from No to Yes
Actions
Copy link
 #2

Updated by Eric Helms over 9 years ago

  • Target version changed from 62 to 63
Actions
Copy link
 #3

Updated by Eric Helms over 9 years ago

  • translation missing: en.field_release changed from 14 to 23
Actions
Copy link
 #4

Updated by Eric Helms about 9 years ago

  • Target version changed from 63 to 66
Actions
Copy link
 #5

Updated by Eric Helms about 9 years ago

  • Target version deleted (66)
Actions
Copy link
 #6

Updated by Eric Helms about 9 years ago

  • Target version set to 67
Actions
Copy link
 #7

Updated by Eric Helms about 9 years ago

  • Target version changed from 67 to 68
Actions
Copy link
 #8

Updated by Eric Helms about 9 years ago

  • translation missing: en.field_release changed from 23 to 31
Actions
Copy link
 #9

Updated by Eric Helms about 9 years ago

  • Target version deleted (68)
Actions
Copy link
 #10

Updated by Walden Raines almost 9 years ago

  • Bugzilla link set to 1219054
Actions
Copy link
 #11

Updated by The Foreman Bot almost 9 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/5280 added
  • Pull request deleted ()
Actions
Copy link
 #12

Updated by Justin Sherrill almost 9 years ago

  • Assignee set to Justin Sherrill
Actions
Copy link
 #13

Updated by Justin Sherrill almost 9 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions
Copy link

Also available in: Atom PDF