Project

Profile

Help

Issue #6387

Updated by ttereshc over 4 years ago

GenerateApplicability performance seems to be worse in 2.18. Part of the diagnosis routine is to check the 2 collections and note if there was a significant size difference: 

 db.repo_profile_applicability 
 db.consumers 

 I've checked with an older customer 2.16 database and get the following counts: 

 ~~~ 
 > db.repo_profile_applicability.find().size() 
 61526 
 >    db.consumers.find().size() 
 54726 
 > 
 ~~~ 

 Checking with another customer with similar sized database on 2.18 shows a greater than 10x ratio which was causing performance issues in older versions: 

 ~~~ 
 > db.repo_profile_applicability.find().size() 
 863830 
 >    db.consumers.find().size() 
 66891 
 > 

 ~~~ 
 I checked and the montly maintenance is being ran and running it manually returns very quickly (5 seconds): 

 ~~~ 
  

  celery.worker.strategy:INFO: Received task: pulp.server.maintenance.monthly.queue_monthly_maintenance[5a5aefbd-dd52-42b5-8d38-2c3b65053f27] 
  celery.worker.strategy:INFO: Received task: pulp.server.maintenance.monthly.monthly_maintenance[7c4e5227-9572-439d-99e0-9ad938c9fc9c] 
  celery.app.trace:INFO: [5a5aefbd] Task pulp.server.maintenance.monthly.queue_monthly_maintenance[5a5aefbd-dd52-42b5-8d38-2c3b65053f27] succeeded in 0.0373372323811s: None 
  pulp.server.managers.consumer.applicability:INFO: [7c4e5227] Orphaned consumer profiles to process: 2253 
  pulp.server.managers.consumer.applicability:INFO: [7c4e5227] Orphaned consumer profiles processed: 2253 
  celery.app.trace:INFO: [7c4e5227] Task pulp.server.maintenance.monthly.monthly_maintenance[7c4e5227-9572-439d-99e0-9ad938c9fc9c] succeeded in 5.05477944389s: None 
 ~~~ 

 yet the size of repo_profile_applicability remains large. 

 Most of the applicability profiles are empty modular profiles.

Back