2070692 – yum check-update gives update notice as broken, or a bad duplicate, skipping.

This bug has been migrated to another issue tracking site. It has been closed here and may no longer be being monitored.

If you would like to get updates for this issue, or to participate in it, you may do so at Red Hat Issue Tracker .

Red Hat Satellite engineering is moving the tracking of its product development work on Satellite to Red Hat Jira (issues.redhat.com). If you're a Red Hat customer, please continue to file support cases via the Red Hat customer portal. If you're not, please head to the "Satellite project" in Red Hat Jira and file new tickets here. Individual Bugzilla bugs will be migrated starting at the end of May. If you cannot log in to RH Jira, please consult article #7032570. That failing, please send an e-mail to the RH Jira admins at rh-issues@redhat.com to troubleshoot your issue as a user management inquiry. The email creates a ServiceNow ticket with Red Hat. Individual Bugzilla bugs that are migrated will be moved to status "CLOSED", resolution "MIGRATED", and set with "MigratedToJIRA" in "Keywords". The link to the successor Jira issue will be found under "Links", have a little "two-footprint" icon next to it, and direct you to the "Satellite project" in Red Hat Jira (issue links are of type "https://issues.redhat.com/browse/SAT-XXXX", where "X" is a digit). This same link will be available in a blue banner at the top of the page informing you that that bug has been migrated.

Bug 2070692 - yum check-update gives update notice as broken, or a bad duplicate, skipping.

Summary: yum check-update gives update notice as broken, or a bad duplicate, skipping.

Keywords:
Status:	CLOSED MIGRATED
Alias:	None
Product:	Red Hat Satellite
Classification:	Red Hat
Component:	Pulp
Sub Component:
Version:	6.10.3
Hardware:	x86_64
OS:	Linux
Priority:	medium
Severity:	medium
Target Milestone:	Unspecified
Assignee:	satellite6-bugs
QA Contact:	Satellite QE Team
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2022-03-31 16:55 UTC by Vedashree Deshpande
Modified:	2024-06-06 12:20 UTC (History)
CC List:	10 users (show)
Fixed In Version:
Doc Type:	If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:	2024-06-06 12:20:49 UTC
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Links
System	ID	Private	Priority	Status	Summary	Last Updated
Red Hat Issue Tracker	SAT-13967	0	None	Migrated	None	2024-06-06 12:20:47 UTC

Description Vedashree Deshpande 2022-03-31 16:55:19 UTC

Description of problem:
$ yum check-update fails with 

Update notice RHBA-2015:0626 (from rhel-7-server-rpms) is broken, or a bad duplicate, skipping.
You should report this problem to the owner of the rhel-7-server-rpms repository.
To help pinpoint the issue, please attach the output of "yum updateinfo --verbose" to the report.
Update notice RHSA-2016:0043 (from rhel-7-server-rpms) is broken, or a bad duplicate, skipping.
Update notice RHBA-2015:0625 (from rhel-7-server-rpms) is broken, or a bad duplicate, skipping.
Update notice RHSA-2016:0465 (from rhel-7-server-rpms) is broken, or a bad duplicate, skipping.
Update notice RHBA-2016:1450 (from rhel-7-server-rpms) is broken, or a bad duplicate, skipping.
Uploading Enabled Repositories Report
Loaded plugins: auto-update-debuginfo, product-id, subscription-manager

Version-Release number of selected component (if applicable):
On Satellite 6.10

Actual results:
as above. 

Expected results:
should list the available updates. 

Additional info:
As mentioned in https://bugzilla.redhat.com/show_bug.cgi?id=1203963 the below workaround doesnt help. 

$rm -rf /var/cache/yum/*
$ yum clean all

Disabling and enabling the repo also has not helped.

Comment 1 Vedashree Deshpande 2022-04-01 13:53:08 UTC

Hello, 

Please notice that issues only occours when "rhel-7-server-optional-rpms" also is enabled

Comment 6 Brad Buckingham 2022-06-23 14:25:49 UTC

Closing at this is not a bug for Satellite.  It is, however, being addressed by the appropriate team with a Jira.

Comment 7 Hao Chang Yu 2022-07-13 01:59:51 UTC

Reopen this bug because I have some clues about what is going on here.

I wrote a script to download the updateinfo.xml of 'rhel-7-server-optional-rpms' repo from upstream CDN and compare the update records with the downstream repository in the Satellite (Pulp 3 database). I got 66 discrepancies as below:

-----------------
Errata Id (Content Id): old digest VS new digest, old issued date VS new issued date, old updated VS new updated date, old version VS new version
RHSA-2016:1985 (4d6f4d5a-d754-4967-92b3-7e4d46d07dcb):1d45cb4b1e6b838e487a815276f855d59bb20dd202b6dcd6815c8a083e71c09c VS 31130aec9f45e1fe69eb81b403c12475e2a452a3526de0d9f8b07812acd6f2b2, 2016-10-03 16:11:23 VS 2016-10-03 00:00:00, 2016-10-03 16:11:24 VS 2016-10-03 00:00:00, 2 VS 1
RHSA-2016:0465 (e1000a70-76bb-4f9c-b110-b105df73e68d): e8a37b2b772c1378d06ee46dec8e5718fbcfa27ad2975f2a7375f2493f32edc3 VS b87bb72fb930e5d0ae470726b94b316ff72381ad6850006103df38f87266e81e, 2016-03-21 00:00:00 VS 2016-03-21 20:03:21, 2016-03-21 20:03:22 VS 2016-03-21 20:03:22, 4 VS 4
RHSA-2016:0723 (5fd4539a-1447-4d92-a2cd-b3e436602a01): 6be2a75fcc07819516d722113444065e844c5344f0634bf3b2194f32846a0ef9 VS e635bff7234bb343afd73e7906b75d9d3b8c2d80198e2db661a8377d65f66b4e, 2016-05-09 00:00:00 VS 2016-05-09 00:00:00, 2016-05-09 13:19:47 VS 2016-05-09 00:00:00, 4 VS 1
RHBA-2014:1334 (6f723d4d-48ae-4327-992c-a6b53f6c025b): eb814ff9933181bd1c82f2660e1c8d76f884bf6ec1a70ebfca4feca4b6250185 VS e8d69208430ebf887cc5b71b7d44381ea42726cc3ae88ee612b4f42a85e07dd6, 2014-09-30 00:00:00 VS 2014-09-30 15:06:05, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 5
RHSA-2016:1392 (65f71caa-ce7b-4c8a-af7b-d9bbae530f65): adb3c5d8867cef1978e9a7530a9f27f7d71bdb25308dfafdfef9efe680c980f3 VS 853982b7d9a0d913feec4b3908a9f764f74ef154736048c1f2145a107fbe29b1, 2016-07-11 00:00:00 VS 2016-07-11 00:00:00, 2016-07-11 03:26:17 VS 2016-07-11 00:00:00, 5 VS 1
RHBA-2014:1180 (f286e6b9-c625-4994-aebd-ce8415a66880): 42cfcb0a16db00170b6daeaeec1d1e7b42a34204948144be4b7e511839eb4373 VS e488d7f7b1ce6791d7d9690e2b4782286a8f942ab307fc21b2f5db822de1a38a, 2014-09-11 00:00:00 VS 2014-09-11 09:53:10, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 3
RHBA-2015:1595 (e620c0d2-a5a0-4e2a-84dd-83a043d9216f): 05c9b0c5c9c0a149b1dacf9a20f300e5a21d7893c3f6b11e730d4481fa312707 VS 3104782318fcf0db7161a5c509c2f653215258eb7f1939c8fd9bd9cd3b85b5f9, 2015-08-12 00:00:00 VS 2015-08-12 00:00:00, 2016-05-03 09:53:04 VS 2016-05-03 00:00:00, 3 VS 1
RHBA-2015:1702 (ed69c128-8815-4ea4-8f48-f3d0e5c55a0b): abc07edb117cce152ed5387267b29db485c06a91a3520da132e5c46e62faa1df VS c4f092fbbf135bd9f07807feb14a765decfb2d7e9b91c1757010edad0451fcd6, 2015-09-02 00:00:00 VS 2015-09-02 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHBA-2015:0626 (d2b1bef6-f081-4172-bfa8-efae1673c80e): a3ba4a3edf806b983717206b31a97b94a9b49e99ee457ba6b73b1aee65ec9e2b VS f1e10744242259fea7fdd4949f2fc908032e1b62e4b3fd23776e2408656b1550, 2015-03-05 00:00:00 VS 2015-03-05 12:40:01, 2018-07-10 13:50:55 VS 2018-07-10 13:50:55, 3 VS 3
RHSA-2016:0695 (4a46336f-de05-456a-9c2a-a6b40a21b032): d1e5d0afcba200ba010902f5ea48388aae9e7add636e8317c388cb956dbb340d VS d5170b279749ce6c01b4f302118998fc9d66277673c1977b19d406ab3131989f, 2016-04-26 00:00:00 VS 2016-04-26 00:00:00, 2016-04-26 18:08:13 VS 2016-04-26 00:00:00, 5 VS 1
RHSA-2016:0460 (b93e5fdc-38cd-4786-8199-e05304a0bc5c): b21f604479b17746c5fcddf8e86f30c5577e78d6b5b033db37ef01e3ddfc480c VS a2a958576752cfc783f7d56d95f09b2331ccc64af9e94529c7c064a1228a4e25, 2016-03-16 00:00:00 VS 2016-03-16 00:00:00, 2016-03-16 17:19:54 VS 2016-03-16 00:00:00, 5 VS 1
RHBA-2015:0625 (022b3794-b48f-4d57-8602-fa28322379a1): fc69356c6e9719f2294e2f2854937f198b14967a93fc59f10586882daae8e11a VS d633bb89266d272133b8e747cd3f820c8446faabd21e9797e880e0c2e1e09f16, 2015-03-05 00:00:00 VS 2015-03-05 13:26:20, 2018-07-10 13:50:43 VS 2018-07-10 13:50:43, 7 VS 7
RHBA-2014:1960 (1bd69dbc-b114-4190-8975-ffff31a62c33): 883e21d0fbbd40fa36df450c1dab551d38303db89a8b6fe2f8ca709f902c9f1e VS 03d1e90e620f14f4206067685279bab66173d4a835eda5c347b3802c444fa7db, 2014-12-16 00:00:00 VS 2014-12-16 15:10:41, 2015-03-04 23:46:10 VS 2015-03-04 00:00:00, 1 VS 5
RHSA-2016:2946 (94e8e585-b26b-415b-b6e2-564087bd882d): 520ab7d502dbde4a6b4b8c753bced51f02489f3c526b3da9442379e0f0e16270 VS 1e84e9a7b059b460a4354da0d36651824a1ee00a2fb8a7347e874cc557720fa8, 2016-12-14 06:39:57 VS 2016-12-14 00:00:00, 2016-12-14 06:39:58 VS 2016-12-14 00:00:00, 6 VS 1
RHBA-2014:1274 (edc0cd04-c660-4689-a2ef-b8c9f5adc5f5): 4c1632ca536ba80627b4fbc6127894af2d00f2c4a408687cb66550a438293e45 VS 108fb928e0a5f5f838b3b7b19b34f48d506f88b7c39aa8c99084bae7f4fee465, 2014-09-22 00:00:00 VS 2014-09-22 13:06:48, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 9
RHBA-2015:1506 (518430e2-7f42-43b2-a810-05bea101fe50): 16fdc52d8944f7e4e3345c7bb6a68275070d495bda560b58eb24e828043480d2 VS bf30a8305e260bc0bd03eea86f64794b5c539febc8ea0c388e54fb111de75fde, 2015-07-27 00:00:00 VS 2015-07-27 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHSA-2016:2780 (68190853-dea0-41c9-a6a4-f8b44b54fe69): b098f5f39f3d5997d142cc3d0726a7042d98765fa62a6220cdaeb84febfa7390 VS 70ee32d9d75a22950cd954dea5ecec6dfb390181c414a688473f1b0b8d673c89, 2016-11-16 04:44:56 VS 2016-11-16 00:00:00, 2016-11-16 04:44:57 VS 2016-11-16 00:00:00, 3 VS 2
RHSA-2016:2843 (7c2c145f-0e6f-4bb3-9c03-1aa3e0dd6759): ef1388925388c4a4675631a289b5b455830d8e6190b368e74a9da2e93217262e VS 5fb40adb98e7771443340f51fb2e19ebf8a8e21f5a6f50e0c94e6bd428909781, 2016-12-01 15:54:17 VS 2016-12-01 00:00:00, 2016-12-01 15:54:18 VS 2016-12-01 00:00:00, 3 VS 1
RHBA-2015:1598 (abc3f41c-b8d2-4278-9ac9-2a0db8e89ee7): 1377d95a83cfd92cd26bb13284295ef51fefe64884f4b78693e830a638df71cb VS 5bc2539d94c5be279d67f396a8a3b01e64e3bac2a78faeb6229e015da9e6b3af, 2015-08-12 00:00:00 VS 2015-08-12 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHSA-2016:2779 (74b3df33-65bf-4db8-92cd-faa4bc1a800e): 3e308760b7dfb93a8fe1203d43e31281d6cb922c0384f7146bd4a554061244a7 VS f8dffa7d6b466991e7c677f2efc7dbcc47d22f10ae9990f464525011d97658e7, 2016-11-16 03:24:48 VS 2016-11-16 00:00:00, 2016-11-16 03:24:49 VS 2016-11-16 00:00:00, 10 VS 4
RHBA-2014:1990 (da38f2ad-f5a9-4f75-8a1e-321d7237b9f1): 2d391490172cc120ee9c46951dcabfc196524fb761c445635964ae380297605f VS 85759eaae54c232022b9f74fa864d7ee245a107c2aa9a0b3bb02686dcbd30b7e, 2014-12-15 00:00:00 VS 2014-12-15 10:26:54, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 4
RHSA-2016:1504 (569e3887-0ce8-4cbd-b356-037827daa692): 867d66fb9fa4e256ccb0f29ffff2c027bd91ef6c300c2c191a6f9fa1cc416a95 VS 76a33ec750e2e9b83f055aec05d57d41d6ed3b05f94f86947c04de1a47923b71, 2016-07-27 00:00:00 VS 2016-07-27 00:00:00, 2016-07-27 09:13:41 VS 2016-07-27 00:00:00, 2 VS 4
RHSA-2016:1776 (755c8915-fdce-41ba-a11c-df6f5e9ec137): e6ad4fa83f91fef8b4ee6388d08be5633721c2202f207cad874db946645ab759 VS 676674fa9edaf2b897ed03146d46e3fab7f2c87c6a37dc7154979775aa370190, 2016-08-26 08:20:55 VS 2016-08-26 00:00:00, 2016-08-26 08:20:56 VS 2016-08-26 00:00:00, 4 VS 2
RHBA-2014:1681 (c4d6a1dc-a98c-4f63-8eab-417d1673e137): a3e336fd9f928f01537387388fc803aed4bbf4ebe909771851543aad2cb2459e VS bdcf86cf1e853ea152ff404ec49131350f01360b2afd86795a85a9ea68a08f4d, 2014-10-22 00:00:00 VS 2014-10-22 12:06:11, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 6
RHSA-2016:1041 (b1472110-50db-4dba-a44b-960d60070f77): 2d0c38d3b43d7ffa4e20579cfc47731f06857743e82ec516447ded4f23df4d3f VS 8b7ba16ea408ff786e32218bc78a7cbdf9420fcef9cae3d9f400302d1fb17b4e, 2016-05-12 00:00:00 VS 2016-05-12 00:00:00, 2016-05-12 05:36:32 VS 2016-05-12 00:00:00, 3 VS 1
RHBA-2014:1182 (8e4ccbc6-1b1c-46c1-acd3-4429bdb95a07): 1e246e423003fbc5e8169ac1dbe62a6ac18d974845b3ca6960485726cf4bab0f VS a55976fea44f938ba7d1186f2289268bd9511f0247a21ae6524df9d26f3db49c, 2014-09-11 00:00:00 VS 2014-09-11 15:53:25, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 4
RHSA-2016:2825 (d99ae6c6-ecb1-420b-aede-cc9f1f7a66a7): 7f9563637f4cf0cf53ee12d052ed94c3014bd0faa5eb76d990cd465767938f95 VS 6cb797427ce37ec92d76df6451129e86ab68d1632e557e28cf6bc2fa7c6fc4ed, 2016-11-29 02:54:54 VS 2016-11-29 00:00:00, 2016-11-29 02:54:55 VS 2016-11-29 00:00:00, 2 VS 1
RHBA-2015:1131 (3296cf69-696c-4877-b639-ad2f26f55347): f72d0ace841c56e4f521d2939868ed50974ceeaf7f0a05549aa3ac460fb20118 VS 530d37bf1c4f39d9c913e9cebf6e2f0eeee7e0de6e028e6c0dd1b0c754a87e16, 2015-06-22 00:00:00 VS 2015-06-22 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHBA-2014:1901 (6cef50df-ca10-4a18-a2eb-bcace32ea7a7): bde7157554f24c62c448ac531356614b075c8e7cd5634667e0117ab2b2de7177 VS 965dd09ad408a8274e5193a5f9ce907ebe9e1cbb42a602159f1cbcaf140a36f9, 2014-11-25 00:00:00 VS 2014-11-25 13:03:18, 2015-03-04 23:46:10 VS 2015-03-04 00:00:00, 1 VS 7
RHBA-2014:1270 (c8a42ced-2c85-4c1a-a20a-de9ca7243006): b3f139fe9e154fe746db1b571a4a62b35ef43b40730b58ceb509f09bfe72d4fb VS 73dbb418c649a9f440b07f0afe105db518550f80f629feb00cc8a4100c9a0fd9, 2014-09-22 00:00:00 VS 2014-09-22 08:35:53, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 4
RHSA-2015:2088 (bba71e4b-1c6f-492b-b0c9-0277f0791560): f03410bdd28283ab48580149ee368cdd12ce78681b5247a12cf6ba8bf0e76a91 VS 811f4dec7bc2dd3d9a54bc0e6d88c22667ccc052f14d1301e74784bbf5d72c86, 2015-11-19 00:00:00 VS 2015-11-19 14:41:38, 2015-11-19 14:41:38 VS 2015-11-19 14:41:38, 14 VS 14
RHBA-2015:1504 (a6c20d54-04f8-4195-bdf4-2a44fff89154): bf59c8ba0e19a47b77362aaf2b7093793b2adc3577bef7172afe702d2df775ef VS bd8603544aab04847c520258e3ea24371cde7f827b20a74330b8c67436de41d2, 2015-07-27 00:00:00 VS 2015-07-27 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHSA-2016:1944 (2deca408-d6ae-43c5-bf34-c43cefb930b8): 209ad6726610d67d686e5bb3fe25da2d1c4d79161e2e56ed399b1b3ea7f06cb6 VS 912a51176af1204ab16c40b2fbefb28ae789e6051e11cf62e780aa8e2b189d9c, 2016-09-28 10:19:11 VS 2016-09-28 00:00:00, 2016-09-28 10:19:12 VS 2016-09-28 00:00:00, 3 VS 1
RHBA-2015:1601 (6de4b2d4-a8ce-4771-8aa9-ca0fa86dda1f): 512bb425411522dea20bdaa4d4e016a3e013f902b997a3870bc04b934940c2b9 VS 9ed3e71da32c883024bf5af025faf4647be7822807dc945e602d6b76b931beef, 2015-08-12 00:00:00 VS 2015-08-12 00:00:00, 2016-05-03 09:53:04 VS 2016-05-03 00:00:00, 2 VS 1
RHEA-2015:2264 (13a3d782-4c85-42b3-9350-887bcb2aa52d): 8e4bd4199cea6af276a2ca86d4d8fc82c58adbea88d87065a65b55958e685454 VS 377b3273beec2fb6cbef49c27509f7d48a7b80386c4cd8cc1e68a246d003b218, 2015-11-19 00:00:00 VS 2015-11-19 14:46:03, 2015-11-19 14:46:03 VS 2015-11-19 14:46:03, 7 VS 7
RHSA-2016:1809 (566658b3-4426-4f33-812f-3b8905628a5f): 2f563a85c4ce9db2dab15a57549ee6c5e9c840d074ebf8103dc03c6346ba24e7 VS a6c234741ee26feb2f45b588ac53b90dab353b1d7199d7b02125e7b4777e2d6d, 2016-09-05 11:41:31 VS 2016-09-05 00:00:00, 2016-09-05 13:05:43 VS 2016-09-05 00:00:00, 5 VS 2
RHBA-2014:1250 (f0fefb72-267d-473b-85b1-14cfa81b3bee): 525704c36fcbaec8046e41061cc41173f750b4c87bf0b9f27f7241b9efc716fc VS 95d2b21dddef3ab72bb50c22aaa77ac67203f5c1fe7a4ed5fc9728ee06dbf837, 2014-09-16 00:00:00 VS 2014-09-16 12:09:28, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 3
RHBA-2014:1045 (e3b15042-f20b-491a-8ba7-e637dc14ca16): edc3174f58d98c5734db2d5f3f8c6193d27709c0f3f77b54e7d952575e8c66b6 VS 67f3abb9fde334acba374e867ee1c4668b24fab42211f76a0e7c8cfc225a9af3, 2014-08-12 00:00:00 VS 2014-08-12 07:20:15, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 3
RHBA-2015:1547 (2f96c721-8dfd-49a7-b92c-81d5343773dc): fdc1df81d159fe1bb6d51fe9b089fe53e6e9221263ee564a92b8fde0e35a9abd VS 36aef17d477f3bac5e81e8a7d5720a9cc66402067c8724ef077dfc51b4e9e03c, 2015-08-05 00:00:00 VS 2015-08-05 00:00:00, 2016-05-03 09:53:04 VS 2016-05-03 00:00:00, 2 VS 1
RHBA-2015:1573 (b9262c56-81c2-4402-903f-2423d2501f8b): 3e5b88dbc58083184d0fbd300ad4de617cfca03d98a855841993ed043ff9d58d VS d08e991f223ab5bf876afa317e4950193f93f11f56cb751dba20327b780282c4, 2015-08-06 00:00:00 VS 2015-08-06 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHSA-2016:1217 (626db1c0-6b47-45d6-8c05-5ae39909b3cf): edec4283b9764dae37ea06d43ef6310f4b958cfac5b8bf234feced7a597322f3 VS b0341e9bd39d8025aaa45ba52fb6a83434a7e75af59a63dc032be0c2400427d3, 2016-06-08 00:00:00 VS 2016-06-08 00:00:00, 2016-06-08 15:34:28 VS 2016-06-08 00:00:00, 3 VS 1
RHSA-2017:0238 (11808094-cd88-43f0-ba93-4fcde29117a1): 3905099c76f2286eaf64ee95c7a725ec1bb207a944609336e5e5584776ba0bf3 VS 8235942ceed694e58b585a07b10fb4619192c4bda997fdd571abe081b1066242, 2017-02-02 03:34:23 VS 2017-02-02 00:00:00, 2017-02-02 03:34:25 VS 2017-02-02 00:00:00, 4 VS 1
RHSA-2016:0676 (8794f09a-b206-46ed-b42c-5266463ec74c): 0fb52a4d35e16e109b5c090bd58cde9f443aa1c4332dabfb5fa35954d7083455 VS fa5125d695ec96eeba052e9d6fad5621e708f3ef0e27b90dc2328e38b80d8dbc, 2016-04-21 00:00:00 VS 2016-04-21 00:00:00, 2016-04-21 12:23:55 VS 2016-04-21 00:00:00, 3 VS 1
RHBA-2015:1014 (632685cb-c38d-4b6d-9ea0-24caaa1912fe): efd4c7c0e61a41fea809a52227bde11a6f4989c6654540cb442f5a3ff12524ae VS 3d18e844486598c646a039e2d4d0ddbd69bd6cb1292c5d7d89081ddc373d91a1, 2015-05-18 00:00:00 VS 2015-05-18 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHBA-2014:1252 (5dc1a1f4-5d07-43c1-8d3e-5cc01b233922): 53be84b2c66fd02cc58cfd8bfbb0ae421680d4f35236f0b57d3ea0ea20f50c07 VS 6e26aaa9856d8ee7a2aaab79f580d5c5af3a1f4dabc8540337953a1f7defd733, 2014-09-16 00:00:00 VS 2014-09-16 12:09:38, 2015-03-04 23:46:13 VS 2015-03-04 00:00:00, 1 VS 3
RHBA-2015:1116 (d5548174-8cf4-46fe-a384-4f01ae35099c): d8127a30ce8d0c2f7e1d9696924b9fd214735ed3170cace7261f05a2539b0172 VS 48322d634f0c187bc7090f2719bfb26cd5a094c229129a0036a5b7c406e731b1, 2015-06-16 00:00:00 VS 2015-06-16 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHBA-2015:1690 (08d930e7-bb41-4b5b-b60c-4bd570a52c40): 6be75b3248da1d278c1b1d8117f8db4550cc84b41cc5b2cbcf3629101b3f3e31 VS d7048f3903fbd04e2cc8c00fe6b7aa4ce278f65b1f65fc0f0f93449858f2e101, 2015-08-27 00:00:00 VS 2015-08-27 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 3 VS 1
RHBA-2015:1079 (3675537e-aa14-43ed-89df-a148c104864c): 8e98d6cae14537b887c1d83f13a0e64087c3102e06c743ab3268ac5e65b50f25 VS b9e889b01b1a0514ba2e6a520e956514f9c1723a032271e09027f253b922557f, 2015-06-08 00:00:00 VS 2015-06-08 00:00:00, 2016-05-03 09:53:08 VS 2016-05-03 00:00:00, 1 VS 1
RHSA-2017:0061 (464d49c2-ff04-495b-9cb2-4307127ef59a): e02a06b8a185febdc53d2738ad2a4da1e6bac17c4c02b0ac5e92a85673b6d360 VS 1f258d6f3be237cbc7f77b232d20f731bb94555a70b69903440c3ca058867d90, 2017-01-12 11:59:44 VS 2017-01-12 00:00:00, 2017-01-12 22:43:06 VS 2017-01-12 00:00:00, 2 VS 1
RHSA-2017:0498 (30a0b874-484f-4cfe-a95b-0e14cb697744): e89938044ce9810b25c278618c10eb39bf7dcd10dfc80323339f6b836d719fea VS 1067cac5953c8df4e1a807c4081c7885a7d0edb21423f1d24a40886a08480e1e, 2017-03-14 04:45:45 VS 2017-03-14 00:00:00, 2017-03-14 04:45:45 VS 2017-03-14 00:00:00, 3 VS 1
RHSA-2017:0190 (71abf85a-e922-4d43-94a0-a15661f220b2): 66f4702ef63f4a28ba08d0c68938f91fd387982144558d5e1bcb3290362bfcb6 VS 1e736ca910374c66a818afb6a6a4648fe0037b3ac8ccd53dc2bfddc7f7f3036c, 2017-01-25 07:55:50 VS 2017-01-25 00:00:00, 2017-02-21 10:08:19 VS 2017-02-21 00:00:00, 14 VS 2
RHBA-2017:2939 (d33684ea-9367-4f39-a9dd-fceba3dac180): 81085916d6de7307b7b1eb5414fe492e81394130b8841d375b941b2a233e52b7 VS 855967c1c99229e4366f81655e4e5949edaa4c64340b658be5bca42f94ddbfc9, 2017-10-19 13:19:56 VS 2017-10-19 13:19:56, 2018-04-05 08:21:05 VS 2018-01-31 00:00:00, 5 VS 5
RHSA-2016:2658 (70509f77-776c-4c92-a970-5575edf5dbb3): 010df0d6495bcc00dead2583653474be322dba8ea9bdc83a3b48c43df97ff5a0 VS be4c97c0f60adcb8440f0fc12c748ec8e42d1c218894cad7be61307337bb8a4d, 2016-11-07 07:50:25 VS 2016-11-07 00:00:00, 2016-11-07 07:50:26 VS 2016-11-07 00:00:00, 2 VS 1
RHBA-2017:2279 (227d6251-3c52-4eb4-b346-4156ad36ac46): 98d56609ffeb14fd5e7d9126cff90a89d450964ec0fffbae4abfbe6a3d86972d VS 1836a37e0e5510f82c47c715b04232f7534f62499190cc8c81d3271e6d80b5bf, 2017-08-01 05:59:35 VS 2017-08-01 05:59:35, 2017-08-28 18:09:29 VS 2017-08-14 00:00:00, 3 VS 3
RHSA-2016:2850 (90eef2e5-a48d-4e30-ada7-989961e57d49): 0d477b4a3719cd33ac7dc9851bdd48652f65d9f152bf5f73aa68899420e4aa22 VS dddbd4f30b56e34833d8314611390201a225558dd5fe9582aa459df7f43b9fe1, 2016-12-05 06:07:27 VS 2016-12-05 00:00:00, 2016-12-05 06:07:28 VS 2016-12-05 00:00:00, 3 VS 1
RHEA-2017:1948 (180828a1-a6fc-462a-8844-abbb2c648731): c4afb01f6fcb4320e4ebd2d914f841bbdaf760581a422c348e8289cb7888b1eb VS cfff287999cf96e5c6fe822433145b93bae06c49cd0294ec8e74875b875d6105, 2017-08-01 05:56:25 VS 2017-08-01 05:56:25, 2018-02-01 13:36:31 VS 2017-08-01 05:56:25, 2 VS 2
RHSA-2018:1318 (2878fd1b-f6e5-4a96-8770-3f82e7d1bc44): 52a3802eb89f9c121c84b816137f061661f40599b8a0e3186f52e60450625e05 VS eaddfea80add61bff2963373e301fce2a7177b9a7c9a51a4fe4e7e7a8b4ba9f0, 2018-05-08 17:15:15 VS 2018-05-08 17:15:15, 2018-05-09 15:32:44 VS 2018-05-08 00:00:00, 7 VS 7
RHSA-2017:0269 (ebf190a5-05da-455e-b76d-f1fb11f98e76): f77278dc8d212c5466a06192b56f5056242c4ebc3fd2cc4ef14b125921a147b5 VS 8cd5a918ca2d8901c6c2754a3d5cd8b61a09a3ba99b92f282559385bb3d1cdd6, 2017-02-13 09:09:58 VS 2017-02-13 00:00:00, 2017-02-13 09:10:00 VS 2017-02-13 00:00:00, 2 VS 1
RHBA-2017:0397 (1d2cf2c0-1802-45d2-881b-2438a9659728): 63c655ebd338c560d54ec4ba50654cb30884d41a54a0fb60dc1e8d762f86e8ac VS 46e275921ddee2d3504030c2b8b12aa7f3109034502f59583cda731dac8af44d, 2017-03-02 15:22:54 VS 2017-03-02 15:22:54, 2017-08-28 19:43:17 VS 2017-03-02 00:00:00, 6 VS 6
RHBA-2018:0770 (31e91ba2-2200-4f99-8a4b-e400fe845667): e637ed2d637805f038b7b5912a91b63e8b94526d2ed386e00e1383c8bd80469d VS b874b0074d5d66cc0eac0bb021ba501ba2aeef802687cd6a95708a6b37213487, 2018-04-10 05:00:35 VS 2018-04-10 05:00:35, 2018-06-12 16:49:57 VS 2018-06-12 16:49:57, 6 VS 6
RHBA-2016:1450 (586e327d-675f-4084-b397-520a9769f9ee): b02a345ac78b3f3f80afaa4c7494e47d1a0cd557dc017fc764d0e91b087b67f8 VS 2e73a97336584888c658515e9e8e6d3ec1e50dec0c9f8fa894f3c64753eac44e, 2016-11-03 06:09:24 VS 2016-11-03 06:09:24, 2016-11-03 06:10:46 VS 2016-11-03 06:10:46, 3 VS 3
RHBA-2018:0868 (6a4a3473-e458-4cca-9980-3a2048e239c7): 4dde1b625b8383b83342e74fd770a0170fc7dcd1c02ade9dc98542ec7a71f840 VS 51d1c03de3b460a4daaccc7325f88d51c3f1884701b51791d10e02fae95cc1a7, 2018-04-10 05:02:48 VS 2018-04-10 05:02:48, 2018-04-10 05:07:31 VS 2018-04-10 05:07:31, 5 VS 5
RHSA-2016:2973 (1dc960dd-827e-4a14-8c0f-91772b1d7fd1): 96094f3ff4819a5971f0a2e5c7c582a1ee060d032123bd9c9bb817645c5cb553 VS f2234938f2e94299e4dfe2574470ea692058987eab696a7ad00d2526ff280417, 2016-12-21 08:30:24 VS 2016-12-21 00:00:00, 2016-12-21 08:30:25 VS 2016-12-21 00:00:00, 4 VS 1
RHSA-2020:1151 (acd1fc87-ab6d-4dca-abdc-0046060cb653): e36ea8a163d8f11e19317484af327caf1286e6e4d7421069099d2d50215d6d7c VS 52d0611f0030b7143ff0789b306aed99d4a41c6297550a17d9f9272f1760449f, 2020-03-31 09:25:19 VS 2020-03-31 09:25:19, 2020-03-31 09:25:05 VS 2020-03-31 09:25:05, 2 VS 2
RHBA-2019:2234 (d39bce2b-5b23-4fad-8feb-a0cfb8daba25): 61a5c20674af7b4102db48c47836e9c21ec9ed4b942ddda9e4b19594af524b3d VS 90d3e344be4c9952a91158aa7d8b5455dd4bc423f6c101abe3ac01a111b40a4a, 2019-08-06 08:15:43 VS 2019-08-06 08:15:43, 2019-08-06 08:15:41 VS 2019-08-06 08:15:41, 4 VS 4
RHSA-2022:5232 (6d8d3a52-8b88-41da-bbcc-52d4ebabac2b): 6e20c5007f187cc37dab0f880bf6e3926611a3b9b760f591c8ff44e947de63b8 VS 4c2e5580a97557debdc37d59dd6752b68f611691fef04d646cfb4e41c6bfe7ed, 2022-06-28 07:52:31 VS 2022-06-28 07:52:31, 2022-06-28 07:52:29 VS 2022-06-28 07:52:29, 7 VS 8
-----------------


Issues I found from the discrepancies above:
-----------------
1) Downstream has newer version and updated date than upstream.

# Could hit this condition and drop the upstream update record.
https://github.com/pulp/pulp_rpm/blob/main/pulp_rpm/app/advisory.py#L302-L306


2) Upstream repo changed the immutable issued date from 2016-10-03 16:11:23 to 2016-10-03 00:00:00 but updated date and version remain unchanged.

# Could hit this condition and drop the upstream update record.
https://github.com/pulp/pulp_rpm/blob/main/pulp_rpm/app/advisory.py#L253-L255


3) Upstream repo changed updated date backward, such as from 2016-05-03 09:53:08 to 2016-05-03 00:00:00 but version remain unchanged.

# Could hit this condition and drop the upstream update record.
https://github.com/pulp/pulp_rpm/blob/main/pulp_rpm/app/advisory.py#L302-L306
-----------------


I think these confused Pulp in the following way:
-----------------
1) Pulp 2 only stored 1 copied of an erratum in the database even it is associated to multiple repositories. When syncing those repositories, Pulp 2 will update its mutable fields according to each upstream repository. This means, the local database will have the mixed/merged errata info of the upstream repositories if their updateinfo changed over the time. For example, if user synced 'rhel-7-server-rpms' periodically but didn't sync 'rhel-7-server-optional-rpms' for some time

2) The mixed/merged errata info will then cause issue we are facing in this bugzilla after migrating to Pulp 3. Pulp 3 works differently. It stored a copy of an erratum for each repository. This means, the mixed/merged errata info in Pulp 2 are cloned (I think) and migrate to Pulp 3 for each associating repo.

3) Pulp 3 has a complicate way to handle the discrepancies between downstream and upstream but it failed to handle the above scenarios, such as the issued date and other fields changes. E.g.

Update notice RHSA-2018:1318 (from rhel-7-server-rpms) is broken, or a bad duplicate, skipping.
Duplicate of RHBA-2015:1131 differs in some fields:
<<<<<<< rhel-7-server-rpms:rights
'Copyright 2016 Red Hat Inc'
=======
'Copyright 2015 Red Hat Inc'
>>>>>>> rhel-7-server-optional-rpms:rights

Duplicate of RHSA-2016:0723 differs in some fields:
<<<<<<< rhel-7-server-rpms:release
'0'
=======
None
>>>>>>> rhel-7-server-optional-rpms:release
-----------------


What can we do better to adapt the changes of update records in upstream repository? Is it worth to have the below complicated method to handle the discrepancies? Will it be better if we just accept and adapt whatever changes in upstream repository instead of attempting to reject or merge the changes?

https://github.com/pulp/pulp_rpm/blob/main/pulp_rpm/app/advisory.py#L159-L177

Comment 12 Daniel Alley 2022-08-29 21:52:18 UTC

EXD gave a reasonable explanation for the errata with 00:00:00 in their timestamps, but some of them don't, including one from 2022.  I wonder what happened with those.

Comment 14 Daniel Alley 2022-09-30 22:28:35 UTC

> What can we do better to adapt the changes of update records in upstream repository? Is it worth to have the below complicated method to handle the discrepancies? Will it be better if we just accept and adapt whatever changes in upstream repository instead of attempting to reject or merge the changes?

The basic issue is this: Satellite allows merging repositories together into Content Views, errata between different repositories can share the same ID but have different package lists (think: Errata in a debuginfo repository may have the same ID as an Errata in the base repositories).  

To handle this you can either:

* Make one "win" against the other, which could result in incomplete metadata and malfunctions later on
* Put both into the same repository despite sharing IDs (I'm actually not sure what Yum / DNF would do in this case, it seems quite wrong on its face to have multiple errata with the same "ID" in a repository, but I don't know if they handle it OK nonetheless)
* Try to merge the errata together such that one errata encompasses the packages from both lists (e.g. both the packages from debuginfo and standard repos)

Pulp 2 (I believe) took the first path.  Pulp 3 took the third.  We should probably investigate whether clients can handle the 2nd approach properly because in truth we do keep finding more and more edge cases over time with the 3rd approach.

Comment 15 Daniel Alley 2022-10-07 18:37:27 UTC

Copying what @ttereshc wrote on Matrix here for posterity:

I can remember 2 reasons about why we could not just take all advisories in.

 * If advisories come from 2 different repos, EL6 and EL7, DNF (or Satellite 🤔) will show both sets of packages as not applied, and the "wrong" set will never go away, and will bug customers. That's the whole reason we started filtering package list in Pulp 2.
 * If we blindly combine 2 errata package lists as is (that's actually what DNF does), DNF do not care about duplicated packages but it has the logic around collection names. If collection names are the same, the first (potentially random) collection will be applied by DNF and the other collections with the same name will be ignored. We learned that only because we had painful customer cases, so it's not a theoretical problem. I do not know if a newer DNF introduced any change to this logic.

Comment 17 Daniel Alley 2022-11-21 04:43:21 UTC

Minor update, we're making slow progress on this as it involves a lot of potential moving parts.  But notably: it may not even be a Satellite specific issue.  People have been seeing this directly from EPEL without Satellite playing middleman.

https://github.com/fedora-infra/bodhi/issues/2487

That doesn't mean that Satellite isn't the cause of a specific instance of the issue, but determining that may need to happen on a case by case basis.  I'm trying to investigate as time permits.

Comment 18 Daniel Alley 2022-11-27 06:36:58 UTC

There was an issue identified (and now fixed) with Fedora / CentOS errata publishing infrastructure. Of course, since the problematic data was generated years ago, we still need to handle that somehow.

Comment 25 Eric Helms 2024-06-06 12:20:49 UTC

This BZ has been automatically migrated to the issues.redhat.com Red Hat Issue Tracker. All future work related to this report will be managed there.

Due to differences in account names between systems, some fields were not replicated.  Be sure to add yourself to Jira issue's "Watchers" field to continue receiving updates and add others to the "Need Info From" field to continue requesting information.

To find the migrated issue, look in the "Links" section for a direct link to the new issue location. The issue key will have an icon of 2 footprints next to it, and begin with "SAT-" followed by an integer.  You can also find this issue by visiting https://issues.redhat.com/issues/?jql= and searching the "Bugzilla Bug" field for this BZ's number, e.g. a search like:

"Bugzilla Bug" = 1234567

In the event you have trouble locating or viewing this issue, you can file an issue by sending mail to rh-issues. You can also visit https://access.redhat.com/articles/7032570 for general account information.

Note You need to log in before you can comment on or make changes to this bug.