Project

General

Profile

Bug #20946

clean_installed_packages script logs a count(*), causing slow performance

Added by Chris Duryee about 4 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
-
Target version:
Difficulty:
Triaged:
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

The clean_installed_packages.rake script prints the count of remaining records for every batch of 20,000. This query can take upwards of two hours on a busy katello system.

Additionally, the script will error out if any records are modified in between the time the "existing" list is created, and the time the batch is cleaned. This can happen if a new system is registered while the script runs.

Associated revisions

Revision cc0b15fb (diff)
Added by Chris Duryee about 4 years ago

Fixes #20946 - fix log messages for cleanup script

The cleanup script was doing a count(*) on a large table, which could
take hours on a busy system. This has been removed.

Additionally, if a deletion fails due to data changing while the script
runs, the script will log a message but continue. The bulk delete
setting will not be updated unless there is a :100:% clean run.

History

#1 Updated by The Foreman Bot about 4 years ago

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

#2 Updated by Chris Duryee about 4 years ago

  • Bugzilla link set to 1483677

#3 Updated by Chris Duryee about 4 years ago

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

#4 Updated by Justin Sherrill about 4 years ago

  • Legacy Backlogs Release (now unused) set to 250

Also available in: Atom PDF