Bug 1416119 – [RFE] foreman-debug takes > 1 hour to complete at scale

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1416119 - [RFE] foreman-debug takes > 1 hour to complete at scale

Summary:	[RFE] foreman-debug takes > 1 hour to complete at scale

Status:	CLOSED ERRATA

Aliases:	None

Product:	Red Hat Satellite 6
Classification:	Red Hat
Component:	Foreman Debug (Show other bugs)
Sub Component:
Version:	6.2.6
Hardware:	Unspecified Unspecified

Priority	medium Severity medium (vote)
Target Milestone:	GA
Target Release:	Unused
Assigned To:	Lukas Zapletal
QA Contact:	Shimon Shtein
Docs Contact:

URL:	http://projects.theforeman.org/issues...
Whiteboard:
Keywords:	FutureFeature, PrioBumpPM, Triaged, UserExperience

Duplicates:	1428363 (view as bug list)
Depends On:
Blocks:	1353215
	Show dependency tree / graph

Reported:	2017-01-24 11:01 EST by Pradeep Kumar Surisetty
Modified:	2018-02-21 07:37 EST (History)
CC List:	8 users (show)

See Also:	1373095
Fixed In Version:
Doc Type:	If docs needed, set a value
Doc Text:
Story Points:	---
Clone Of:
Environment:
Last Closed:	2018-02-21 07:37:44 EST
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
Foreman Issue Tracker	18231	None	None	None	2017-01-25 04:04 EST
Foreman Issue Tracker	18348	None	None	None	2017-03-03 07:07 EST
Red Hat Product Errata	RHSA-2018:0336	normal	SHIPPED_LIVE	Important: Satellite 6.3 security, bug fix, and enhancement update	2018-02-21 17:43:42 EST

Groups: None (edit)

Description Pradeep Kumar Surisetty 2017-01-24 11:01:27 EST

Description of problem:

Forman-debug 

Version-Release number of selected component (if applicable):

With scale >6000 hosts takes > 60 mins to complete foreman-debug

 

Need light weight foreman-debug 



How reproducible:


Steps to Reproduce:
1. foreman-debug takes longer time n
2.
3.

Actual results:


Expected results:


Additional info:

Comment 4 Pradeep Kumar Surisetty 2017-01-25 11:24:39 EST

Have 150k foreman-tasks which might be taking long time to export.

Comment 5 Pavel Moravec 2017-03-02 07:20:29 EST

*** Bug 1428363 has been marked as a duplicate of this bug. ***

Comment 6 Lukas Zapletal 2017-03-03 07:07:13 EST

Please backport also this small change: Foreman Issue #18348

Comment 7 pm-sat@redhat.com 2017-03-06 08:10:03 EST

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/18348 has been resolved.

Comment 10 Lukas Zapletal 2017-06-28 06:52:15 EDT

As a workaround, I suggest you to review old tasks cleanup configuration, it was broken in 6.2

foreman-rake foreman_tasks:cleanup

See description in 

/opt/theforeman/tfm/root/usr/share/gems/gems/foreman-tasks-0.9.*/lib/foreman_tasks/tasks/cleanup.rake

By default it does not delete ANY tasks which are in error/failed/stuck state, therefore the queue can easily grow fast. In that case provide more aggressive deletion options.

Alternative workaround, delete this block 

https://github.com/Katello/katello-packaging/pull/329/files#diff-27141c04050ed31299a2296657e4769cL85

from the

/usr/share/foreman/script/foreman-debug.d/katello-debug.sh

file and foreman-debug will be fast again.

This will be fixed in Satellite 6.3 where we only dump SQL data tables which is fast.

Comment 14 errata-xmlrpc 2018-02-21 07:37:44 EST

Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2018:0336

Note You need to log in before you can comment on or make changes to this bug.