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
