Bug 1386670 - Uploaded packages aren't visible in Satellite
Summary: Uploaded packages aren't visible in Satellite
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Pulp
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: Unspecified
Assignee: David Davis
QA Contact: jcallaha
URL:
Whiteboard:
: 1383566 (view as bug list)
Depends On:
Blocks: CEE_Sat6_Top_BZs, GSS_Sat6_Top_Bugs 1394390
TreeView+ depends on / blocked
 
Reported: 2016-10-19 12:20 UTC by Tomas Strachota
Modified: 2020-04-15 14:44 UTC (History)
12 users (show)

Fixed In Version: tfm-rubygem-katello-3.0.0.86-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 1394390 (view as bug list)
Environment:
Last Closed: 2016-12-12 17:15:09 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)
verification screenshot (59.49 KB, image/png)
2016-12-01 19:56 UTC, jcallaha
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Foreman Issue Tracker 17016 0 Normal Closed Uploaded packages aren't visible in Katello 2020-03-27 19:20:55 UTC
Red Hat Product Errata RHBA-2016:2940 0 normal SHIPPED_LIVE Satellite 6.2.5 Async Bug Release 2016-12-12 22:08:21 UTC

Description Tomas Strachota 2016-10-19 12:20:22 UTC
Description of problem:

When a package is uploaded to a repository in a custom product, the upload finishes successfully but the package isn't visible in neither UI nor CLI. It gets correctly uploaded into Pulp but it's not imported into Satellite.

Workaround:
Run foreman-rake katello:reindex after the upload

How reproducible:
100% on machines with timezone other than UTC

Steps to Reproduce:
1. Create a custom product and a repository
2. Upload a package to that repository
3. Click "Manage packages" to list packages in the repo
4. The list is empty even though the upload was successful

Actual results:
Packages aren't visible in Satellite

Expected results:
Uploaded packages should be immediately visible

Additional info:
The problem seems to be in Pulp/Mongo which doesn't interpret timezones in content search queries. Satellite's FinishUpload action plans FilteredIndexContent with filter set to "created > 5.minutes.ago.iso8601" to limit indexing only to recently created packages. Filtered query into Pulp in the latter action returns empty array when the time contains timezone component other than "Z".
("2016-10-19T11:42:02Z" vs "2016-10-19T13:42:02+02:00")

Comment 1 David Davis 2016-10-19 13:44:06 UTC
Opened up Pulp issue:

https://pulp.plan.io/issues/2353

Comment 2 Bryan Kearney 2016-10-19 14:08:09 UTC
Upstream bug component is Pulp

Comment 3 David Davis 2016-10-19 14:08:52 UTC
Upstream PR:

https://github.com/Katello/katello/pull/6404

Comment 6 David Davis 2016-10-19 17:53:09 UTC
Small addendum to the original bug description: the timezone must be AHEAD of UTC (e.g. UTC+6) to reproduce this bug.

Comment 8 David Davis 2016-10-20 20:20:33 UTC
*** Bug 1383566 has been marked as a duplicate of this bug. ***

Comment 10 jcallaha 2016-12-01 19:56:12 UTC
Verified in Satellite 6.2.5

Uploaded 10 rpms to a custom repository, all were immediately counted for and visible in the UI. See attached screenshot for verification (note the el7 packages in an el6 repo).

Comment 11 jcallaha 2016-12-01 19:56:49 UTC
Created attachment 1227007 [details]
verification screenshot

Comment 12 errata-xmlrpc 2016-12-12 17:15:09 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHBA-2016:2940

Comment 13 Oleksandr Shtaier 2017-04-26 16:01:47 UTC
Basic scenario is covered properly in test automation scripts, but specific steps (non-UTC timezone) are too destructive from Jenkins CI flow (adding specific configuration just for one test case seems as not proper idea)


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