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)