[Spacewalk-list] removing channels and packages
Michiel van Es
michiele at info.nl
Mon Feb 16 10:55:44 UTC 2009
Some more info:
2009-02-16 11:52:07,199 [TP-Processor6] ERROR
org.hibernate.event.def.AbstractFlushingEventListener - Could not sy
nchronize database state with session
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.j
ava: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)
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(CustomPackag
esDeleteConfirmAction.java:103)
at
com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.execute(CustomPackagesDelet
eConfirmAction.java:80)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:237)
:
Michiel van Es wrote:
> Anyone please? :)
>
>
> Michiel van Es wrote:
>> 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.StandardSessionFacade at 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
>>>
>>>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 260 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090216/a1d5aaf9/attachment.sig>
More information about the Spacewalk-list
mailing list