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:[email protected]] Sent: Friday, June 10, 2016 8:19 AM To: Jan Dobes <[email protected]>; [email protected] Subject: RE: [Spacewalk-list] Failed schema upgrade to 2.5 Thanks. I will give it a shot. Steve -----Original Message----- From: Jan Dobes [mailto:[email protected]] Sent: Friday, June 10, 2016 8:06 AM To: Steve Kent <[email protected]>; [email protected] 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:[email protected]] > Sent: Thursday, June 09, 2016 1:37 PM > To: Steve Kent <[email protected]>; [email protected] > 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)[email protected] <mailto:[email protected]> >> (w)www.noblesystems.com <http://www.noblesystems.com/> >> >> >> >> _______________________________________________ >> Spacewalk-list mailing list >> [email protected] >> https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
