Bug #22978

Katello Event Queue db queries need improvement

Added by Partha Aji about 1 month ago. Updated 24 days ago.

Status:Closed
Priority:Normal
Assigned To:Partha Aji
Category:Performance
Target version:Team Brad - Iteration 27
Difficulty: Pull request:https://github.com/Katello/katello/pull/7251
Bugzilla link:1560740
Story points-
Velocity based estimate-
ReleaseKatello 3.7.0Release relationshipAuto

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
Added by Partha Aji 26 days 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 about 1 month ago

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

#2 Updated by Partha Aji 26 days ago

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

#3 Updated by Partha Aji 26 days ago

  • Bugzilla link set to 1560740

#4 Updated by John Mitsch 24 days ago

  • Release set to Katello 3.7.0

Also available in: Atom PDF