[Spacewalk-list] spacewalk-repo-sync errors with SLES repos on CentOS-7
Lichtinger, Bernhard
Bernhard.Lichtinger at lrz.de
Mon Nov 14 16:57:53 UTC 2016
Hello,
I made some more progress, instead of using only id for my query:
> rhnschema=# select * from rhnPackage where id = 361804;
> 361804 | 1 | 3599 | 73216 | 119 | 14 | 4.4.2.3 | PAM (Pluggable
> Authentication Modules) is a system security tool that+| A Security Tool that Provides Authenticati
> on for Applications | 177907 | 624540 | 616636 | sheep24 | 2016-06-16 11:57:4
> 4 | 96742 | 12360858 | SUSE LINUX Products GmbH, Nuernberg, Germany | cpio |
> 0 | redhat/1/9f9/pam-32bit/1.1.5-0.17.2/x86_64/9f97a66c3d64f005af572d7de04ac161/pam-32bit-1.1.5-0
> .17.2.x86_64.rpm | | BSD 3-Clause; GPL v2 or later | | 2016-06-23 21:07:24+02 | 20
> 16-06-23 21:07:24.494433+02 | 2016-06-23 21:07:24.494433+02 | 616 | 16376
> (1 row)
I used the "full query":
rhnschema=# select * from rhnPackage where org_id = 1 and name_id = 2135 and evr_id = 73214 and package_arch_id = 119 and checksum_id = 12360895;
And got 0 rows.
I found out that the evr_id is off by 2 in this case, and off by 1 in some other cases.
Now the big question is: What is the use case of evr_id in table rhnPackage and how can I repair my entries?
Regards,
Bernhard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5128 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20161114/99d11993/attachment.p7s>
More information about the Spacewalk-list
mailing list