[Spacewalk-list] Problem adding a server to a group
James Fillman
jfillman at central1.com
Wed Feb 8 19:54:06 UTC 2012
Has anyone seen this problem:
Spacewalk 1.6
I have a CentOS 5 system profile that I can't join to certain system groups. Some groups work, some don't. I can't see what the difference is.
Here's a TRACEBACK email:
The following exception occurred while executing this request:
POST /rhn/systems/details/groups/Add.do
Date:2/8/12 11:47:23 AM PST
Headers:
host: spacewalk.cucbc.com
user-agent: Mozilla/5.0 (X11; Linux x86_64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
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
connection: keep-alive
referer: https://spacewalk.cucbc.com/rhn/systems/details/groups/Add.do?sid=1000013123
cookie: JSESSIONID=C7861FB86EB15A500EF4FEED5B4BF84C; pxt-session-cookie=434641x38daaae3f405b5594fd186052e8fa00c
content-type: application/x-www-form-urlencoded
content-length: 722
Request:
Local Name = spacewalk.cucbc.com
Server Name = spacewalk.cucbc.com
Requested Session Id came from Cookie
Requested Session Valid = true
Session = org.apache.catalina.session.StandardSessionFacade at 8ce6014[session=StandardSession[C7861FB86EB15A500EF4FEED5B4BF84C<mailto:org.apache.catalina.session.StandardSessionFacade at 8ce6014[session=StandardSession[C7861FB86EB15A500EF4FEED5B4BF84C>]]
Protocol = https
Request Locale = en_US
Request Character Encoding = UTF-8
Attribute Names = rhnActiveLang, javax.servlet.jsp.jstl.fmt.timeZone.request, javax.servlet.error.status_code, javax.servlet.error.servlet_name, javax.servlet.request.key_size, requestedUri, list_1154021400_selected_amt, javax.servlet.request.ssl_session, org.apache.struts.action.MESSAGE, system, javax.servlet.error.message, session, __sitemesh__filterapplied, javax.servlet.request.cipher_suite, javax.servlet.error.exception, javax.servlet.error.request_uri, org.apache.struts.action.mapping.instance, all, org.apache.struts.action.MODULE,
Form Variables:
csrf_token: 6791022838737766610
1154021400_PAGE_SIZE_LABEL_SELECTED: null
list_1154021400_parent_is_an_element: true
1154021400_PAGE_SIZE_LABEL: 25
list_1154021400_all: false
list_1154021400_filterby: Group Name
sid: 1000013123
list_1154021400_filterclass: com.redhat.rhn.frontend.taglibs.list.ColumnFilter
list_1154021400_sortdir:
list_1154021400_sortby:
list_1154021400_search_child: false
list_1154021400_filterval: web
list_1154021400_filterattr: name
list_1154021400_items: 41
submitted: true
list_1154021400_sel: 41
list_1154021400_sel_all: on
list_1154021400_none: false
list_1154021400_oldfilterval: web
dispatch: Join Selected Groups
list_1154021400_search_parent: true
User Information:
User jfillman (id 321, org_id 3)
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.addServerToGroup(ServerFactory.java:185)
at com.redhat.rhn.manager.system.SystemManager.addServerToServerGroup(SystemManager.java:300)
at com.redhat.rhn.manager.system.ServerGroupManager.addServers(ServerGroupManager.java:336)
at com.redhat.rhn.frontend.action.systems.groups.AddGroupsAction.commitAction(AddGroupsAction.java:71)
at com.redhat.rhn.frontend.action.DispatchedAction.execute(DispatchedAction.java:48)
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)
... 48 more
Cheers,
--james
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120208/1a522739/attachment.htm>
More information about the Spacewalk-list
mailing list