Project

General

Profile

Bug #22978

Katello Event Queue db queries need improvement

Added by Partha Aji 7 months ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Performance
Target version:
Difficulty:
Triaged:
Yes
Bugzilla link:
Team Backlog:
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

Associated revisions

Revision 1066301f (diff)
Added by Partha Aji 7 months ago

Fixes #22978 - Improve Event Queue db queries

The delete and update operations in the event queue were not quick
enough when there was a lot of data in the event queue (20K entries
with many duplicates etc.)
This commit addresses that issue by speeding up the delete and update
operations

History

#1 Updated by The Foreman Bot 7 months ago

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

#2 Updated by Partha Aji 7 months ago

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

#3 Updated by Partha Aji 7 months ago

  • Bugzilla link set to 1560740

#4 Updated by John Mitsch 7 months ago

  • Legacy Backlogs Release (now unused) set to 338

Also available in: Atom PDF