Bug 1428363

Summary: foreman-debug to call something faster than task export
Product: Red Hat Satellite Reporter: Pavel Moravec <pmoravec>
Component: Foreman DebugAssignee: Lukas Zapletal <lzap>
Status: CLOSED DUPLICATE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 6.2.7   
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-03-02 12:20:29 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Pavel Moravec 2017-03-02 12:19:02 UTC
Description of problem:
Please replace taking task export within foreman-debug by something much more faster. Since:

- data from task export is very important for debugging problems
- task export itself can take arbitrary long time (even few hours). That is unusable when support needs to get that data
- when calling sosreport, foreman-debug times out due to the lengthy task export, causing collected foreman-debug data are very concise / much of them missing

There has been work:

https://github.com/Katello/katello-packaging/pull/329

replacing the rake script by postgres dump with pre-agreed option. Reimport of the dumps can be done via:

https://github.com/Katello/katello-packaging/pull/329#issuecomment-278971784

Please do:
- replace task export by the pgsql dumps in katello-debug.sh
- incorporate the inecas's script into Satellite (such that any Satellite can load "task export" from another Satellite)


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


How reproducible:
100%


Steps to Reproduce:
0. have Satellite with tens of thousands of tasks
1. take foreman-debug / task export
2. calculate time it takes


Actual results:
2. many (tens of) minutes to get task export / foreman-debug


Expected results:
2. task export replacement / foreman-debug to take considerably low time
3. be able to "visualise" in human readable UI the task export (like inecas's script, not necessarily that particular)


Additional info:
http://projects.theforeman.org/issues/18231

Comment 1 Pavel Moravec 2017-03-02 12:20:29 UTC
I am blind..

*** This bug has been marked as a duplicate of bug 1416119 ***