Project

General

Custom queries

Profile

Actions

Bug #8565

closed

report::expire is running very slowly

Added by Chuck Schweizer over 10 years ago. Updated almost 7 years ago.

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

Description

The fix included in #1592 has made report::expire very slow

Expire 5 day old reports (runs every 30 minutes)
Pre fix: 2.5 minutes
Post fix: 21 minutes

Expire 1 day old non eventful reports (runs every 30 minutes)
Pre fix: 2.5 minutes
Post fix: 21 minutes

Most of the time seems to be spent in Postgres deleting the records in the post fix report.rb. I will be working on getting more data added to this ticket.


Related issues 3 (1 open2 closed)

Related to Foreman - Bug #1592: report::expire errors with millions of recordsClosedOri Rabin04/30/2012Actions
Related to Foreman - Bug #8316: Removing a long-standing host creates huge transactionClosedDaniel Lobato Garcia11/07/2014Actions
Related to Foreman - Refactor #8798: Reports.expire uses an unnecessary join on logs New12/28/2014Actions
#2

Updated by Dominic Cleal over 10 years ago

  • Related to Bug #1592: report::expire errors with millions of records added
#3

Updated by Dominic Cleal over 10 years ago

  • Category set to Reporting
  • Translation missing: en.field_release set to 29
#5

Updated by Dominic Cleal over 10 years ago

  • Related to Bug #8316: Removing a long-standing host creates huge transaction added
#6

Updated by Dominic Cleal over 10 years ago

  • Translation missing: en.field_release deleted (29)
#9

Updated by Dominic Cleal over 10 years ago

  • Status changed from New to Assigned
  • Assignee set to Dominic Cleal
#10

Updated by The Foreman Bot over 10 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/2008 added
  • Pull request deleted ()
#12

Updated by Dominic Cleal over 10 years ago

  • Related to Refactor #8798: Reports.expire uses an unnecessary join on logs added
#14

Updated by Dominic Cleal over 10 years ago

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

Updated by Dominic Cleal over 10 years ago

  • Translation missing: en.field_release set to 32
Actions

Also available in: Atom PDF