How can I remove old system snapshot data from Red Hat Satellite?

Solution Verified - Updated -

Issue

  • I want to purge old snapshots in order to free up some space in the Satellite database. How can I do that?

  • I get frequent database deadlocks when attempting to delete system profiles:

    In /var/log/tomcat{5,6}/catalina.out:

    2014-07-28 14:21:23,133 [TP-Processor8] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
    javax.servlet.ServletException: com.redhat.rhn.common.db.WrappedSQLException: ORA-00060: deadlock detected while waiting for resource
    ORA-06512: at "RHNSAT.DELETE_SERVER", line 213
    

Environment

  • Red Hat Satellite 5.4+

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In