[Spacewalk-list] Spacewalk 2.10 Released!

Thu Mar 19 13:07:58 UTC 2020

If someone would run the below, I'd be very grateful:

select name from rhnPackageProvider where id=(select provider_id from
rhnPackageKey where key_id='49fc0fd89bd837ba');

On Thu, Mar 19, 2020 at 9:00 AM Eckert, Doug <Doug.Eckert at dowjones.com>
wrote:

> I still have one key (49fc0fd89bd837ba) with a NULL provider_id. That one
> isn't inserted in the schema_upgrade. Not sure what to use for the
> 'lookup_package_provider' function.
>
> So, I checked out the code for the function (rhnschema=# \df+
> lookup_package_provider;) and saw it queries rhnPackageProvider;
>
> Anyone know which is the appropriate provided for key_id
> 49fc0fd89bd837ba?
>
> rhnschema=# select * from rhnPackageProvider;
>  id  |       name       |            created            |
> modified
>
> -----+------------------+-------------------------------+-------------------------------
>  100 | Red Hat Inc.     | 2020-02-18 10:56:43.314315-05 | 2020-02-18
> 10:56:43.314315-05
>  101 | Fedora           | 2020-02-18 10:56:43.316934-05 | 2020-02-18
> 10:56:43.316934-05
>  102 | CentOS           | 2020-02-18 10:56:43.318202-05 | 2020-02-18
> 10:56:43.318202-05
>  103 | Scientific Linux | 2020-02-18 10:56:43.319269-05 | 2020-02-18
> 10:56:43.319269-05
>  104 | SUSE             | 2020-02-18 10:56:43.320548-05 | 2020-02-18
> 10:56:43.320548-05
>  105 | Oracle Inc.      | 2020-02-18 10:56:43.321994-05 | 2020-02-18
> 10:56:43.321994-05
>  106 | Spacewalk        | 2020-02-18 10:56:43.323291-05 | 2020-02-18
> 10:56:43.323291-05
>  107 | EPEL             | 2020-02-18 10:56:43.324363-05 | 2020-02-18
> 10:56:43.324363-05
>  108 | Novell Inc.      | 2020-02-18 10:56:43.325785-05 | 2020-02-18
> 10:56:43.325785-05
> (9 rows)
>
> On Thu, Mar 19, 2020 at 8:47 AM Ree, Jan-Albert van <J.A.v.Ree at marin.nl>
> wrote:
>
>> Thanks a lot , the update works perfectly here as well
>>
>> I had 3 updates to make and now all is as it should be
>>
>> --
>>
>> Jan-Albert
>>
>>
>>
>> Jan-Albert van Ree | HPC Specialist | Digital Services
>> MARIN | T +31 317 49 35 48 | J.A.v.Ree at marin.nl | www.marin.nl
>>
>> [image: LinkedIn] <https://www.linkedin.com/company/marin> [image:
>> YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter]
>> <https://twitter.com/MARIN_nieuws> [image: Facebook]
>> <https://www.facebook.com/marin.wageningen>
>> MARIN news: Courses Hydrodynamics  Floating Offshore Structures & Ship
>> design
>> <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design>
>>
>> ------------------------------
>> *From:* spacewalk-list-bounces at redhat.com <
>> spacewalk-list-bounces at redhat.com> on behalf of Eckert, Doug <
>> Doug.Eckert at dowjones.com>
>> *Sent:* Thursday, March 19, 2020 13:28
>> *To:* spacewalk-list at redhat.com
>> *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released!
>>
>> I tried, but it wouldn't let me remove the record due to foreign key
>> reference, so I updated the existing record instead with the value it
>> would've used from the 'insert' command:
>>
>> rhnschema=# update rhnPackageKey set
>> provider_id=lookup_package_provider('CentOS') where
>> key_id='05b555b38483c65d';
>> UPDATE 1
>> rhnschema=# select * from rhnPackageKey where key_id='05b555b38483c65d';
>>  id  |      key_id      | key_type_id | provider_id |            created
>>            |           modified
>>
>> -----+------------------+-------------+-------------+-------------------------------+-------------------------------
>>  157 | 05b555b38483c65d |         100 |         102 | 2020-02-21
>> 09:06:55.782751-05 | 2020-03-19 08:26:56.268446-04
>> (1 row)
>>
>> 
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> --
> Doug Eckert
> LEAD ENGINEER, COMPUTE
> [image: NewsTech] <http://www.newscorp.com/>
> M: +1.732.666.3681 <+1+555+555+5555>    O: +1.609.520.4993
> <+1+555+555+5555>
> E: Doug.Eckert at DowJones.com <Cbergstresser at newscorp.com>
> A: PO Box 300, Princeton, NJ 08543
>

-- 
Doug Eckert
LEAD ENGINEER, COMPUTE
[image: NewsTech] <http://www.newscorp.com/>
M: +1.732.666.3681 <+1+555+555+5555>    O: +1.609.520.4993 <+1+555+555+5555>
E: Doug.Eckert at DowJones.com <Cbergstresser at newscorp.com>
A: PO Box 300, Princeton, NJ 08543
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/7e67ccf2/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image9c2be9.PNG
Type: image/png
Size: 293 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/7e67ccf2/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagecedf24.PNG
Type: image/png
Size: 331 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/7e67ccf2/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image6768af.PNG
Type: image/png
Size: 333 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/7e67ccf2/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image6cb51b.PNG
Type: image/png
Size: 253 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/7e67ccf2/attachment-0003.png>