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) <mailto:[email protected]> [email protected]
(w) <http://www.noblesystems.com/> www.noblesystems.com
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
