[Spacewalk-list] spacewalk-repo-sync errors with SLES repos on CentOS-7

[Lichtinger, Bernhard]

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>