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 896179 - Katello system search using lastCheckin returns invalid results
Summary: Katello system search using lastCheckin returns invalid results
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: WebUI
Version: 6.0.1
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: Unspecified
Assignee: Brad Buckingham
QA Contact: Sachin Ghai
URL:
Whiteboard:
Depends On: 1151618
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-01-16 19:30 UTC by James Laska
Modified: 2017-02-23 21:20 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-08-12 13:55:48 UTC
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)
Screenshot.png (139.61 KB, image/png)
2013-01-16 19:30 UTC, James Laska 		no flags Details
distribution.version:6.5 giving correct host (36.98 KB, image/png)
2015-03-17 12:37 UTC, Sachin Ghai 		no flags Details
distribution.version:6.6 giving correct host after upgrade (22.80 KB, image/png)
2015-03-17 12:42 UTC, Sachin Ghai 		no flags Details
View All

Description James Laska 2013-01-16 19:30:55 UTC 
Created attachment 679757 [details]
Screenshot.png

Description of problem:



Observe that

Version-Release number of selected component (if applicable):
 * candlepin-0.7.8.1-1.el6cf.src.rpm
 * katello-1.1.12-22.el6cf.src.rpm
 * katello-candlepin-cert-key-pair-1.0-1.src.rpm
 * katello-certs-tools-1.1.8-1.el6cf.src.rpm
 * katello-cli-1.1.8-12.el6cf.src.rpm
 * katello-configure-1.1.9-12.el6cf.src.rpm
 * katello-qpid-broker-key-pair-1.0-1.src.rpm
 * katello-qpid-client-key-pair-1.0-1.src.rpm
 * katello-selinux-1.1.1-2.el6cf.src.rpm

Steps to Reproduce:
1. Navigate to /katello/systems
2. Search for a subset of systems using the following search filter
   lastCheckin:[2013-01-01 TO 2013-01-15]
  
Actual results:

 * Observe that results in the search include systems with lastCheckin outside the date range specified (e.g. 2013-01-16).

Expected results:

 * Systems returned by the search should match the lastCheckin search criteria entered

Additional info:

 * While discussing with bbuckingham on IRC, he noted: 

> 14:22:48  bbuckingham-afk: btw... confirmed that for systems w/ last checkin of the 16th.. the data indexed is the 15th... (at least for a couple of them spotchecked)

 * See screenshot
Comment 2 James Laska 2013-01-18 19:09:34 UTC 
I believe I'm seeing the same problem manifest in another use case.

== Steps to reproduce ==
1) Register a RHEL-6.3 system to CFSE
2) Upgrade system to RHEL-6.4 Beta
3) Update system facts: sub-man facts --update
4) Query for 6.4 systems from the CFSE webui using query, "distribution.version:6.4"

== Actual Outcome ==

 * System with the following facts does not appear in web-ui query for "distribution.version:6.4"

> # subscription-manager facts | grep distribution
> distribution.id: Santiago
> distribution.name: Red Hat Enterprise Linux Server
> distribution.version: 6.4

 * The system does appear in a web-ui query for the old fact: distribution.version:6.3

== Expected Outcome ==

 * A system with fact distribution.version:6.4 should appear in a web-ui query for that filter
Comment 3 Brad Buckingham 2013-01-18 19:22:15 UTC 
From a quick dump of the search index on the server used in comment #2, I was able to confirm that the upgraded system still has the old value in the search index (i.e. "distribution.version":"6.3").
Comment 4 Mike McCune 2013-08-16 17:51:48 UTC 
getting rid of 6.0.0 version since that doesn't exist
Comment 7 Bryan Kearney 2014-09-04 15:49:05 UTC 
This appears to be resolved. Aligning to 6.1 for QE verification.
Comment 10 Sachin Ghai 2015-03-17 12:36:56 UTC 
Verified with:

sat6.1 beta snap6 compose2 (Satellite-6.1.0-RHEL-6-20150311.1).


I followed the steps in comment 2. I registered a rhel6.5 machine and when I tried to search the machine with 6.5 version. It was working. Search was giving me results. Please see the screenshot.
Comment 11 Sachin Ghai 2015-03-17 12:37:51 UTC 
Created attachment 1002786 [details]
distribution.version:6.5 giving correct host
Comment 12 Sachin Ghai 2015-03-17 12:39:29 UTC 
Now I upgraded the registered host to rhel6.6 and updated facts:

---
Complete!
[root@mgmt3 yum.repos.d]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.6 (Santiago)
[root@mgmt3 yum.repos.d]# subscription-manager facts --update
Successfully updated the system facts.
[root@mgmt3 yum.repos.d]# 
---


Now A system with fact distribution.version:6.6  appears in a web-ui query for that filter
Comment 13 Sachin Ghai 2015-03-17 12:42:14 UTC 
Created attachment 1002787 [details]
distribution.version:6.6 giving correct host after upgrade
Comment 14 Sachin Ghai 2015-03-17 12:43:45 UTC 
Moving to verified as per comments 10 11 12 13.
Comment 15 Bryan Kearney 2015-08-11 13:19:18 UTC 
This bug is slated to be released with Satellite 6.1.
Comment 16 Bryan Kearney 2015-08-12 13:55:48 UTC 
This bug was fixed in version 6.1.1 of Satellite which was released on 12 August, 2015.
Note You need to log in before you can comment on or make changes to this bug.