[Spacewalk-list] Error deleting package (Internal Server error)

[Stehle, Christian]

Hi there,

I have one package in my repo that I cannot delete.
Maybe it has something to do with the naming? It is an Ubuntu-Package.

Spacewalk 2.6

Package: xvfb-2:1.11.4-0ubuntu10.17.amd64-deb<https://spacewalk.hs-neu-ulm.de/rhn/software/packages/Details.do?pid=86752>

Maybe someone can help? It seems there's a constraint conflict with errata, but there is none connected with this package.
- Christian


Exception:

javax.servlet.ServletException: com.redhat.rhn.common.db.WrappedSQLException: FEHLER: Aktualisieren oder Löschen in Tabelle »rhnpackage« verletzt Fremdschlüssel-Constraint »rhn_err_pkgtmp_pid_fk« von Tabelle »rhnerratapackagetmp«

  Detail: Auf Schlüssel (id)=(86752) wird noch aus Tabelle »rhnerratapackagetmp« verwiesen.

                at org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)

                at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)

                at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)

                at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105)

                at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

                at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:107)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)

                at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:101)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:299)

                at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

                at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)

                at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)

                at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)

                at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)

                at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

                at java.lang.Thread.run(Thread.java:748)

Caused by: com.redhat.rhn.common.db.WrappedSQLException: FEHLER: Aktualisieren oder Löschen in Tabelle »rhnpackage« verletzt Fremdschlüssel-Constraint »rhn_err_pkgtmp_pid_fk« von Tabelle »rhnerratapackagetmp«

  Detail: Auf Schlüssel (id)=(86752) wird noch aus Tabelle »rhnerratapackagetmp« verwiesen.

                at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:54)

                at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:44)

                at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:143)

                at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:414)

                at com.redhat.rhn.common.db.datasource.CachedStatement.internalExecute(CachedStatement.java:293)

                at com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:227)

                at com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:223)

                at com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:37)

                at com.redhat.rhn.manager.rhnpackage.PackageManager.deletePackages(PackageManager.java:1247)

                at com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.deletePackages(CustomPackagesDeleteConfirmAction.java:118)

                at com.redhat.rhn.frontend.action.rhnpackage.CustomPackagesDeleteConfirmAction.execute(CustomPackagesDeleteConfirmAction.java:95)

                at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

                ... 40 more

Caused by: org.postgresql.util.PSQLException: FEHLER: Aktualisieren oder Löschen in Tabelle »rhnpackage« verletzt Fremdschlüssel-Constraint »rhn_err_pkgtmp_pid_fk« von Tabelle »rhnerratapackagetmp«

  Detail: Auf Schlüssel (id)=(86752) wird noch aus Tabelle »rhnerratapackagetmp« verwiesen.

                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2094)

                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1827)

                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:508)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:384)

                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:377)

                at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:362)

                at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)

                ... 49 more


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20171211/8d34fc1f/attachment.htm>