Project

General

Profile

Actions

Bug #38169

closed

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 about 1 month ago. Updated 11 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Performance
Target version:
Difficulty:
Triaged:
Yes
Fixed in Releases:
Found in Releases:

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 #1

Updated by The Foreman Bot about 1 month ago

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

Updated by The Foreman Bot 27 days ago

  • Fixed in Releases 3.14.0 added
Actions #3

Updated by Jeremy Lenz 27 days ago

  • Status changed from Ready For Testing to Closed
Actions #4

Updated by Ewoud Kohl van Wijngaarden 11 days ago

  • Triaged changed from No to Yes
Actions

Also available in: Atom PDF