Project

General

Profile

Actions

Refactor #21639

closed

unique constraints should be enforced in the DB as well

Added by Tomer Brisker over 6 years ago. Updated almost 3 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

Description

ActiveRecord unique constraints might not be properly enforced when Foreman is run in multiple processes due to "Time of Check - Time of Use" errors.
All unique constraints should also be enforced by database index constraints which will prevent invalid duplicate entries.


Related issues 2 (0 open2 closed)

Blocked by Foreman - Bug #21766: Duplicate entries in taxable_taxonomies tableClosedTomer Brisker11/26/2017Actions
Blocked by Foreman - Bug #21926: Compute-resource image creation allows duplicate nameClosedTomer Brisker12/11/2017Actions
Actions #1

Updated by Tomer Brisker over 6 years ago

  • Blocked by Bug #21766: Duplicate entries in taxable_taxonomies table added
Actions #2

Updated by Tomer Brisker over 6 years ago

  • Blocked by Bug #21926: Compute-resource image creation allows duplicate name added
Actions #3

Updated by Amit Upadhye almost 3 years ago

Tomer Brisker wrote:

ActiveRecord unique constraints might not be properly enforced when Foreman is run in multiple processes due to "Time of Check - Time of Use" errors.
All unique constraints should also be enforced by database index constraints which will prevent invalid duplicate entries.

I can see both the subtasks are completed, should we close this tracker?

Actions #4

Updated by Tomer Brisker almost 3 years ago

  • Status changed from New to Resolved

good point, closing this one.

Actions

Also available in: Atom PDF