Thanks for the update! Steve
-----Original Message----- From: Jan Dobes [mailto:[email protected]] Sent: Thursday, June 09, 2016 1:37 PM To: Steve Kent <[email protected]>; [email protected] 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)[email protected] <mailto:[email protected]> > (w)www.noblesystems.com <http://www.noblesystems.com/> > > > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
