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@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
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
