Description of problem: When deleting a server profile using the either the WebUI or the API (which both use the delete_server stored procedure), related records in rhnAction table do not get deleted. Version-Release number of selected component (if applicable): spacewalk-schema 2.0.2-13 How reproducible: Delete a system (with some actions recorded) Steps to Reproduce 1. Register a system 2. Schedule some actions on this system only 3. Remove the system with either WebUI or API Actual results: Remaining items can be seen in rhnaction table, with no rhnServerAction records referencing it Expected results: Table should not contain any rows when no rhnServerAction records remain, to maintain 1:n relationship Additional info: Items in rhnactions/rhnserveractions tables: List can be constructed with select sa.action_id from rhnaction a INNER JOIN rhnserveraction sa ON a.id = sa.action_id where sa.server_id = <systemid>; After system profile is deleted, existence of rhnserveraction/rhnaction items can be checked with: select sa.action_id from rhnaction a INNER JOIN rhnserveraction sa ON a.id = sa.action_id where sa.server_id = <systemid>; (empty set, records in rhnserveraction table are deleted as expected) select * from rhnaction where id = <any of list from 1> (records still exist, but are expected to be deleted as well)
We have re-reviewed this bug, as part of an ongoing effort to improve Satellite/Proxy feature and bug updates, review and backlog. This is a low priority bug and has no currently open customer cases. While this bug may still valid, we do not see it being implemented prior to the EOL of the Satellite 5.x product. Further, this bug does not apply for Satellite 6. As such, this is being CLOSED DEFERRED. Closing now to help set customer expectations as early as possible. You are welcome to re-open this bug if needed. Xixi, Tomas
*** Bug 1116320 has been marked as a duplicate of this bug. ***