Project

General

Profile

Actions

Bug #22978

closed

Katello Event Queue db queries need improvement

Added by Partha Aji about 6 years ago. Updated almost 6 years ago.

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

Description

KatelloEventQueue involves the following operations

1) Pick an event thats not in-progress and mark the rest of the duplicate events below it as "in progress"
2) Do the operation
3) Delete all the duplicates

In a large scale environment where over 10's of 1000s of events (with many duplicates) gets queued up in the EventQueue we need a quicker way to handle all 3

The last part seems to delete 1 event at a time instead of deleting the duplicates en masse

Actions #1

Updated by The Foreman Bot about 6 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/7251 added
Actions #2

Updated by Partha Aji about 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #3

Updated by Partha Aji about 6 years ago

  • Bugzilla link set to 1560740
Actions #4

Updated by John Mitsch about 6 years ago

  • translation missing: en.field_release set to 338
Actions

Also available in: Atom PDF