[Spacewalk-list] Failed schema upgrade to 2.5

[Steve Kent]

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:skent at noblesystems.com> skent at noblesystems.com 
(w) <http://www.noblesystems.com/> www.noblesystems.com

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160609/5e12beef/attachment.htm>