Bug 1225850

Summary: Unresponsive "Schedules" tab in Satellite / old actions are not deleted from table public.rhnaction
Product: Red Hat Satellite 5 Reporter: Stefan Meyer <stefan>
Component: OtherAssignee: Jan Dobes <jdobes>
Status: CLOSED DEFERRED QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: medium    
Version: 570CC: nshaik, tlestach, xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-03-16 14:28:13 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:
Bug Depends On:    
Bug Blocks: 1127217    

Description Stefan Meyer 2015-05-28 10:33:08 UTC 
Description of problem:
After deleting old actions via GUI or API the deleted actions are not visible anymore in the GUI, but are not deleted from the postgres table.

Version-Release number of selected component (if applicable):
Satellite 5.7 and Spacewalk 2.2.

How reproducible:
This bug was replicated on Satellite 5.7 and Spacewalk 2.2.

Steps to Reproduce:
1. Run some action on a host.
2. Connect to the spacewalk DB via "spacewalk-sql -i"
3. SELECT count(*) FROM public.rhnaction;
4. Delete the old actions via GUI or API
5. SELECT count(*) FROM public.rhnaction;
6. The actions are still there

Actual results:
Old actions are never deleted from the database. We updated from Satellite 4.x on Oracle all the way up to 5.7 with Postgres DB. We found more than 1 million entries going back to 2009 in the table. 
We experienced timeouts and failed actions via GUI and API.

Expected results:
If actions are deleted via GUI or API they should be removed from the Postgres table.

Workaround:
1. # spacewalk-sql -i
2. rhnschema=# DELETE FROM public.rhnaction;
If you need some of the action information you should be more selective in what you delete

Additional Information:
As this might only be a problem if you hit the ceiling with a lot of hosts or a lot of scheduled actions i set this Bugzilla to medium severity.