[Spacewalk-list] error registering system to a group when there are multiple users with different permissions.

john miller johnmille1 at gmail.com
Fri Feb 17 20:57:49 UTC 2012 

Michael, Thanks for the reply.

I am using spacewalk 1.6 (upgraded from 1.5) on fedora 15 with postgresql
9.0. When I get my dev server back up I can work on reproducing the error
in more detail. I looked back in my prod logs and I think I may have found
the corresponding error in /var/log/tomcat6/catalina.out. This could have
been from one of the other errors though. I seemed to have a lot of group
related errors when I had multiple users with different group
restrictions.If there is a different log I should look in let me know.
Thanks for your help.

2012-02-06 09:23:44,788 [TP-Processor3] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction.
Rolling back
javax.servlet.ServletException: java.lang.RuntimeException:
org.postgresql.util.PSQLException: ERROR: function
update_perms_for_user(numeric) does not exist
  Hint: No function matches the given name and argument types. You might
need to add explicit type casts.
  Where: PL/pgSQL function "update_perms_for_server_group" line 22 at
PERFORM
SQL statement "SELECT
rhn_cache.update_perms_for_server_group(server_group_id_in)"
PL/pgSQL function "insert_into_servergroup" line 39 at PERFORM
SQL statement "SELECT rhn_server.insert_into_servergroup(sgm.server_id,
sgm.server_group_id)"
PL/pgSQL function "insert_into_servergroup_maybe" line 19 at PERFORM
        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:99)
        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:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        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:91)
        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:108)
        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:55)
        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:298)
        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:776)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:705)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:898)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
        at java.lang.Thread.run(Thread.java:679)
Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException:
ERROR: function update_perms_for_user(numeric) does not exist
  Hint: No function matches the given name and argument types. You might
need to add explicit type casts.
  Where: PL/pgSQL function "update_perms_for_server_group" line 22 at
PERFORM
SQL statement "SELECT
rhn_cache.update_perms_for_server_group(server_group_id_in)"
PL/pgSQL function "insert_into_servergroup" line 39 at PERFORM
SQL statement "SELECT rhn_server.insert_into_servergroup(sgm.server_id,
sgm.server_group_id)"
PL/pgSQL function "insert_into_servergroup_maybe" line 19 at PERFORM
        at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:3267)
        at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
        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:425)
        ... 40 more
Caused by: org.postgresql.util.PSQLException: ERROR: function
update_perms_for_user(numeric) does not exist
  Hint: No function matches the given name and argument types. You might
need to add explicit type casts.
  Where: PL/pgSQL function "update_perms_for_server_group" line 22 at
PERFORM
SQL statement "SELECT
rhn_cache.update_perms_for_server_group(server_group_id_in)"
PL/pgSQL function "insert_into_servergroup" line 39 at PERFORM
SQL statement "SELECT rhn_server.insert_into_servergroup(sgm.server_id,
sgm.server_group_id)"
PL/pgSQL function "insert_into_servergroup_maybe" line 19 at PERFORM
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)
        at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:3253)
        ... 49 more


rpm -qa | grep spacew
spacewalk-taskomatic-1.6.101-1.fc15.noarch
spacewalk-backend-libs-1.6.66-1.fc15.noarch
spacewalk-java-postgresql-1.6.101-1.fc15.noarch
spacewalk-backend-xmlrpc-1.6.66-1.fc15.noarch
spacewalk-selinux-1.6.2-1.fc15.noarch
spacewalk-backend-package-push-server-1.6.66-1.fc15.noarch
spacewalk-search-1.6.8-1.fc15.noarch
spacewalk-monitoring-1.4.1-1.fc15.noarch
spacewalk-common-1.5.1-1.fc15.noarch
spacewalk-config-1.6.4-1.fc15.noarch
spacewalk-backend-sql-1.6.66-1.fc15.noarch
spacewalk-backend-tools-1.6.66-1.fc15.noarch
spacewalk-backend-iss-export-1.6.66-1.fc15.noarch
spacewalk-postgresql-1.5.1-1.fc15.noarch
spacewalk-base-1.6.37-1.fc15.noarch
spacewalk-certs-tools-1.6.7-1.fc15.noarch
spacewalk-java-config-1.6.101-1.fc15.noarch
spacewalk-backend-sql-postgresql-1.6.66-1.fc15.noarch
spacewalk-backend-applet-1.6.66-1.fc15.noarch
spacewalk-jpp-workaround-1.0.1-1.fc15.noarch
spacewalk-backend-xml-export-libs-1.6.66-1.fc15.noarch
spacewalk-schema-1.6.42-1.fc15.noarch
spacewalk-java-1.6.101-1.fc15.noarch
spacewalk-slf4j-1.6.1-1.fc13.noarch
spacewalk-base-minimal-1.6.37-1.fc15.noarch
spacewalk-pxt-1.6.37-1.fc15.noarch
spacewalk-java-lib-1.6.101-1.fc15.noarch
spacewalk-backend-config-files-common-1.6.66-1.fc15.noarch
spacewalk-backend-xp-1.6.66-1.fc15.noarch
spacewalk-monitoring-selinux-1.6.2-1.fc15.noarch
spacewalk-grail-1.6.37-1.fc15.noarch
spacewalk-backend-app-1.6.66-1.fc15.noarch
spacewalk-setup-jabberd-1.6.5-1.fc15.noarch
spacewalk-backend-config-files-tool-1.6.66-1.fc15.noarch
spacewalk-backend-iss-1.6.66-1.fc15.noarch
spacewalk-sniglets-1.6.37-1.fc15.noarch
spacewalk-repo-1.6-1.fc15.noarch
spacewalk-admin-1.6.3-1.fc15.noarch
spacewalk-backend-1.6.66-1.fc15.noarch
spacewalk-backend-server-1.6.66-1.fc15.noarch
spacewalk-backend-config-files-1.6.66-1.fc15.noarch
spacewalk-html-1.6.37-1.fc15.noarch
spacewalk-doc-indexes-1.1.1-1.fc15.noarch
spacewalk-branding-1.6.4-1.fc15.noarch
spacewalk-setup-1.6.5-1.fc15.noarch

rpm -qa | grep postgres
spacewalk-java-postgresql-1.6.101-1.fc15.noarch
postgresql-server-9.0.6-1.fc15.x86_64
spacewalk-postgresql-1.5.1-1.fc15.noarch
spacewalk-backend-sql-postgresql-1.6.66-1.fc15.noarch
postgresql-libs-9.0.6-1.fc15.x86_64
postgresql-jdbc-9.0.801-4.fc15.x86_64
postgresql-9.0.6-1.fc15.x86_64
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120217/cbd58756/attachment.htm>

More information about the Spacewalk-list mailing list