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

[Michael Mraka]

john miller wrote:
% 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
...

Hi John,

this one has been fixed in nightly by
0e866786fd888953ab9dff1597499afb1807643b.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat