[Spacewalk-list] Failed schema upgrade to 2.5

[Jan Dobes]

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