[Spacewalk-list] Can't delete system

[Jan Šoc]

Hi,
i cant delete system from spacewalk, i have:

The following exception occurred while executing this request:
POST /rhn/systems/details/DeleteConfirm.do

Date:1/10/12 1:10:21 PM CET
Headers:
   host: spacewalkserver.acme.com
   user-agent: Mozilla/5.0 (X11; U; Linux x86_64; cs-CZ; rv:1.9.2.24) Gecko/20111107 Ubuntu/10.04 (lucid) Firefox/3.6.24
   accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
   accept-language: cs,en-us;q=0.7,en;q=0.3
   accept-encoding: gzip,deflate
   accept-charset: windows-1250,utf-8;q=0.7,*;q=0.7
   Keep-Alive: 115
   connection: keep-alive
   referer:https://spacewalkserver.acme.com/rhn/systems/details/DeleteConfirm.do?sid=1000010062
   cookie: JSESSIONID=C5C5374F0B198B6C72FA3E704A743D5E; __utma=27782179.93297412.1323189392.1324643965.1325151856.7; __utmz=27782179.1323189392.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); owa_v=cdh%3D%3E85f6b788%7C%7C%7Cvid%3D%3E-234190141%7C%7C%7Cfsts%3D%3E1311829981%7C%7C%7Cnps%3D%3E22%7C%7C%7Cdsfs%3D%3E70; owa_s=cdh%3D%3E85f6b788%7C%7C%7Clast_req%3D%3E1317894202%7C%7C%7Csid%3D%3E1550386075%7C%7C%7Cdsps%3D%3E2%7C%7C%7Creferer%3D%3E%28none%29%7C%7C%7Cmedium%3D%3Edirect%7C%7C%7Csource%3D%3E%28none%29%7C%7C%7Csearch_terms%3D%3E%28none%29; jira.conglomerate.cookie=; pxt-session-cookie=192xea5055a9251f52f197bf6f396b9d1aa9
   content-type: application/x-www-form-urlencoded
   content-length: 67

Request:
Local Name = spacewalkserver.acme.com
Server Name = spacewalkserver.acme.com
Requested Session Id came from Cookie
Requested Session Valid = true
Session = org.apache.catalina.session.StandardSessionFacade at 72b072bd[session=StandardSession[C5C5374F0B198B6C72FA3E704A743D5E]]
Protocol = https
Request Locale = en_US
Request Character Encoding = UTF-8
Attribute Names = rhnActiveLang, sid, org.apache.struts.action.ERROR, javax.servlet.jsp.jstl.fmt.timeZone.request, submittedForm, javax.servlet.request.key_size, requestedUri, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, system, session, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, org.apache.struts.action.mapping.instance, org.apache.struts.action.MODULE,

Form Variables:
   submitted: true
   sid: 1000010062
   button: Delete Profile
   csrf_token: 2200245591428613372


User Information:
User geralt (id 1, org_id 1)

Exception:
javax.servlet.ServletException: ERROR: function update_perms_for_user(numeric) does not exist
	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:99)
	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:91)
	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:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:704)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897)
	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.db.WrappedSQLException: ERROR: function update_perms_for_user(numeric) does not exist
	at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)
	at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)
	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
	at com.redhat.rhn.domain.server.ServerFactory.delete(ServerFactory.java:373)
	at com.redhat.rhn.manager.system.SystemManager.deleteServer(SystemManager.java:290)
	at com.redhat.rhn.frontend.action.systems.sdc.SystemDeleteConfirmAction.execute(SystemDeleteConfirmAction.java:82)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
	... 40 more
Caused by: org.postgresql.util.PSQLException: ERROR: function update_perms_for_user(numeric) does not exist
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
	at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2706)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
	... 46 more



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