Bug 1225850 - Unresponsive "Schedules" tab in Satellite / old actions are not deleted from table public.rhnaction
Summary: Unresponsive "Schedules" tab in Satellite / old actions are not deleted from ...
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Other
Version: 570
Hardware: x86_64
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Jan Dobes
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: sat570-triage
TreeView+ depends on / blocked
 
Reported: 2015-05-28 10:33 UTC by Stefan Meyer
Modified: 2019-07-11 09:15 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2017-03-16 14:28:13 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

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.


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