The upgrade should be fixed now in spacewalk-schema-2.5.23-1.
Regards, -- Jan Dobes Satellite Engineering, Red Hat On 9.6.2016 19:41 Steve Kent wrote:
Thanks for the update! Steve -----Original Message----- From: Jan Dobes [mailto:jdo...@redhat.com] Sent: Thursday, June 09, 2016 1:37 PM To: Steve Kent <sk...@noblesystems.com>; spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Failed schema upgrade to 2.5 We know about it. It's bug in upgrades scripts which occurs when there are multiple organization on Spacewalk. We will try to release fixed spacewalk-schema package as soon as possible. Sorry for inconvenience. Regards, -- Jan Dobes Satellite Engineering, Red Hat On 9.6.2016 18:47 Steve Kent wrote:I attempted to upgrade from 2.4 to 2.5 and ran into this issue: clear_log_id -------------- (1 row) psql:/var/log/spacewalk/schema-upgrade/20160609-124047-script.sql:4470: ERROR: more than one row returned by a subquery used as an expression Here is the sql statement: SELECT logging.clear_log_id(); DELETE FROM rhnOrgExtGroupMapping WHERE server_group_id = ( SELECT id FROM rhnServerGroup WHERE group_type = ( SELECT id FROM rhnServerGroupType WHERE label = 'provisioning_entitled' ) ); spaceschema=# select * from rhnOrgExtGroupMapping; id | ext_group_id | server_group_id | created | modified ----+--------------+-----------------+---------+---------- (0 rows) spaceschema=# Thanks, *Steve Kent* /Director, Platform R&D/ *Noble Systems Corporation* (o) 1.404.851.1331 x1305 (e)sk...@noblesystems.com <mailto:sk...@noblesystems.com> (w)www.noblesystems.com <http://www.noblesystems.com/> _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
