[Spacewalk-list] Clear completed actions list spacewalk 1.9

[Tomas Lestach]

> I've been trying to clean up the failed, completed, and archived
> actions lists in my spacewalk server, and am having trouble with the
> completed actions list. I'm not sure how many thousands of actions
> are in the list, but clicking on the link to it, and waiting for
> quite some time yields an internal server error. The tomcat
> catalina.out log yields the following: "java.lang.OutOfMemoryError:
> GC overhead limit exceeded" and
> "com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0"
> java.lang.OutOfMemoryError: Java heap space. I've raised my timeouts
> in apache to 1200 seconds, and have reached the point where Tomcat
> cannot complete the request successfully. The Xmx is set to 2048m,
> and I've tried a couple different GC settings, to no avail. Is there
> some way of clearing out the completed actions list through database
> commands or another method that might not be so rough on Tomcat's
> memory heap?

Hmmm, do you get the same exception if you'd use the
schedule.listCompletedActions
API?

(In case not, it's possible to delete them using
schedule.archiveActions schedule.deleteActions APIs)


Regards,
Tomas
--
Tomas Lestach
RHN Satellite Engineering, Red Hat