Anyone can help my with removing the obsolete packages? I can not remove them and manually remove the rpms (18,540) is not option ;)
Kind regards, Michiel Michiel van Es wrote: > Hi, > > I want to remove a channel and its packages but I can not remove the > packages. > I can remove them one by one but it is about 18,545 packages that have > to be removed ;) > > The error I got when selecting all packages or 15 packages, I get an > internal server error and the traceback shows: > > The following exception occurred while executing this request: > POST /rhn/software/manage/packages/ConfirmPackageRemove.do > > Date:2/12/09 4:28:26 PM CET > Headers: > host: devmx01.buro.info.nl > user-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.0.6) > Gecko/2009020911 Ubuntu/8.10 (intrepid) Firefox/3.0.6 > accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 > accept-language: en-us,en;q=0.5 > accept-encoding: gzip,deflate > accept-charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 > Keep-Alive: 300 > connection: keep-alive > referer: > https://devmx01.buro.info.nl/rhn/software/manage/packages/ConfirmPackageRemove.do > cookie: JSESSIONID=7D8A54C83F20DF6A33B2122D81CE6E4F; > pxt-session-cookie=17168x161382c6c7a797a99b8a0c907b9b08f0 > content-type: application/x-www-form-urlencoded > content-length: 389 > Max-Forwards: 10 > > Request: > Local Name = devmx01.buro.info.nl > Server Name = devmx01.buro.info.nl > Requested Session Id came from Cookie > Requested Session Valid = true > Session = > org.apache.catalina.session.standardsessionfac...@80e434[session=standardsession[7d8a54c83f20df6a33b2122d81ce6e4f]] > Protocol = https > Request Locale = en_US > Request Character Encoding = UTF-8 > Attribute Names = rhnActiveLang, javax.servlet.request.ssl_session, > pageList, org.apache.struts.action.MESSAGE, > javax.servlet.jsp.jstl.fmt.timeZone.request, session, > javax.servlet.request.key_size, __sitemesh__filterapplied, > javax.servlet.request.cipher_suite, parentUrl, requestedUri, > org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE, > > Form Variables: > confirm: Delete Package(s) > list_4021519721_filterby: Package Name > list_4021519721_oldfilterval: > list_4021519721_filterval: > list_4021519721_page_next: 1 > list_4021519721_sortby: nvrea > 4021519721_PAGE_SIZE_LABEL_SELECTED: null > 4021519721_PAGE_SIZE_LABEL: 5 > cid: > list_4021519721_page_last: last > list_4021519721_sortdir: asc > submitted: true > > > User Information: > User admin (id 1, org_id 1) > > Exception: > javax.servlet.ServletException: HibernateException executing CachedStatement > at > org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237) > at > com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:73) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) > at > com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) > at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200) > at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283) > at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773) > at > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703) > at > org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) > at java.lang.Thread.run(Thread.java:636) > Caused by: com.redhat.rhn.common.hibernate.HibernateRuntimeException: > HibernateException executing CachedStatement > at > com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:463) > at > com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:425) > at > com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:269) > at > com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:32) > at > com.redhat.rhn.manager.rhnpackage.PackageManager.clearNeededPackageCache(PackageManager.java:1004) > at > com.redhat.rhn.manager.rhnpackage.PackageManager.deletePackages(PackageManager.java:1020) > at > com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.deletePackages(CustomPackagesDeleteConfirmAction.java:103) > at > com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.execute(CustomPackagesDeleteConfirmAction.java:80) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > ... 40 more > Caused by: org.hibernate.StaleStateException: Batch update returned > unexpected row count from update [0]; actual row count: 0; expected: 1 > at > org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61) > at > org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46) > at > org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24) > at > org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2520) > at > org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2697) > at > org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:74) > at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) > at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) > at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:146) > at > org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) > at > org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) > at > com.redhat.rhn.common.db.datasource.CachedStatement.stealConnection(CachedStatement.java:847) > at > com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:435) > ... 48 more > > > > Can anyone help me to remove the packahes to recover disk space? > > Kind regards, > > Michiel > >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
