[Spacewalk-list] Can't delete system

[Jan Šoc]

Dne 16.1.2012 13:49, Michael Mraka napsal(a):
> Jan Šoc wrote:
> % Hi,
> % i cant delete system from spacewalk, i have:
> %
> % The following exception occurred while executing this request:
> % POST /rhn/systems/details/DeleteConfirm.do
> ...
> % Exception:
> % javax.servlet.ServletException: ERROR: function update_perms_for_user(numeric) does not exist
>
> Does rhn_cache.update_perms_for_user() exist in your database? Try
>
>    spaceschema=# select rhn_cache.update_perms_for_user(1);
>
> Are there any errors in /var/log/rhn/populate_db.log?
>
> Regards,
>
> --
> Michael Mráka
> Satellite Engineering, Red Hat
Hi,
yes, that function exist:
spaceschema=# select rhn_cache.update_perms_for_user(1);
  update_perms_for_user
-----------------------

(1 row)

spaceschema=#


In /var/log/rhn/populate_db.log i have no errors, just some warnings about transactions
psql:/etc/sysconfig/rhn/postgres/main.sql:49335: WARNING:  there is no transaction in progress

Jan Šoc