Project

General

Custom queries

Profile

Actions
Copy link

Bug #13112

closed

N+1 query on hosts#index from last report object

Added by Dominic Cleal over 9 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Dominic Cleal
Category:
Database
Target version:
1.10.1
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/3055
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Since #12954, the hosts index is reporting an N+1 database lookup when retrieving the last report object to calculate the host status.

There's an optimisation in #10782 which isn't being used when calling the relevant? method (which now uses the object) as the method doesn't take options including the last report object.

Related issues 1 (0 open — 1 closed)

Related to Foreman - Bug #12954: Foreman puppet report status does not work without a puppet proxyClosedDominic Cleal12/29/2015Actions
#1

Updated by Dominic Cleal over 9 years ago

  • Related to Bug #12954: Foreman puppet report status does not work without a puppet proxy added
#2

Updated by Dominic Cleal over 9 years ago

  • Description updated (diff)
#3

Updated by Dominic Cleal over 9 years ago

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

Updated by The Foreman Bot over 9 years ago

  • Status changed from Assigned to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/3055 added
#6

Updated by Dominic Cleal over 9 years ago

  • Translation missing: en.field_release changed from 71 to 104
#7

Updated by Dominic Cleal over 9 years ago

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

Also available in: Atom PDF