Project

General

Profile

Actions
Copy link

Bug #38169

open

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_operatingsystems_on_title" DETAIL: Key (title)=(RedHat 9.2) already exists.

Added by Jeremy Lenz 2 days ago. Updated 2 days ago.

Status:
Ready For Testing
Priority:
Normal
Assignee:
Jeremy Lenz
Category:
Performance
Target version:
3.14.0
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/10425
Fixed in Releases:
Found in Releases:
Red Hat JIRA:
SAT-27861

Description

While testing concurrent Katello registrations in batches we see the following error leading to some hosts (2, 3 usually) with the same OS version failing to register:

PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_operatingsystems_on_title"
DETAIL: Key (title)=(RedHat 9.2) already exists.

After these errors, the rest of registrations work without problems.

The error occurs with 50 concurrent registrations but does not occur with >120 concurrent registrations.

Actions
Copy link
 #1

Updated by The Foreman Bot 2 days ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/10425 added
Actions
Copy link

Also available in: Atom PDF