[Spacewalk-list] Failed schema upgrade to 2.5

[Steve Kent]

I restored my database, tried it, and everything worked great.

Now I am back to the same issue I had from upgrading 2.3 to 2.4.

I go ahead and run "spacewalk-setup" and it fails. It fails because the
rhn.conf file is not properly created for the database settings.

I am expecting to have this in my rhn.conf file:
db_backend = postgresql
db_user = spaceuser
db_password = spacepw
db_name = spaceschema

Instead I get:
db_backend = postgresql
db_user = rhnuser
db_password = rhnpw
db_name = rhnschema

I am not sure why it's not picking up the proper spacewalk setup. Last
time I went ahead and modified the spacewalk-setup file to overwrite the
rhn.conf file after it was created. I would love to know what I am missing
or what's not configured correctly that is causing that issue. It never
happened on my upgrades prior to 2.4.

Steve

-----Original Message-----
From: Steve Kent [mailto:skent at noblesystems.com] 
Sent: Friday, June 10, 2016 8:19 AM
To: Jan Dobes <jdobes at redhat.com>; spacewalk-list at redhat.com
Subject: RE: [Spacewalk-list] Failed schema upgrade to 2.5

Thanks. I will give it a shot.

Steve

-----Original Message-----
From: Jan Dobes [mailto:jdobes at redhat.com]
Sent: Friday, June 10, 2016 8:06 AM
To: Steve Kent <skent at noblesystems.com>; spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Failed schema upgrade to 2.5

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