[Spacewalk-list] Failed schema upgrade to 2.5

[Jan Dobes]

The upgrade should be fixed now in spacewalk-schema-2.5.23-1.

Regards,
-- 
Jan Dobes
Satellite Engineering, Red Hat

On 9.6.2016 19:41 Steve Kent wrote:
> Thanks for the update!
>
> Steve
>
> -----Original Message-----
> From: Jan Dobes [mailto:jdobes at redhat.com]
> Sent: Thursday, June 09, 2016 1:37 PM
> To: Steve Kent <skent at noblesystems.com>; spacewalk-list at redhat.com
> 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)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