Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.
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 1386670

Summary: Uploaded packages aren't visible in Satellite
Product: Red Hat Satellite Reporter: Tomas Strachota <tstrachota>
Component: PulpAssignee: David Davis <daviddavis>
Status: CLOSED ERRATA QA Contact: jcallaha
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: bbuckingham, bkearney, daviddavis, dhawke, fgarciad, jcallaha, mjahangi, molasaga, oshtaier, rdixon, xdmoon, zhunting
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: tfm-rubygem-katello-3.0.0.86-1 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of:
: 1394390 (view as bug list) Environment:
Last Closed: 2016-12-12 17:15:09 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1385841, 1394390    
Attachments:
Description Flags
verification screenshot none

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)