Bug 1241607
| Summary: | invalid package install time reported | ||
|---|---|---|---|
| Product: | [Community] Spacewalk | Reporter: | Tomas Lestach <tlestach> |
| Component: | Clients | Assignee: | Jiří Dostál <jdostal> |
| Status: | CLOSED NOTABUG | QA Contact: | Red Hat Satellite QA List <satqe-list> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 2.3 | CC: | jdobes |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2015-07-10 12:18:13 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: | 1484117 | ||
Actually, my fault. Correct cmd would be: TZ='CET' date what matches with Spacewalk WebUI. Closing NOTABUG. This BZ closed some time during 2.5, 2.6 or 2.7. Adding to 2.7 tracking bug. |
Description of problem: 'Installed' time on the /rhn/systems/details/packages/PackageList.do isnt' correct. Version-Release number of selected component (if applicable): Spacewalk 2.3 rhn-check-2.0.2-6.el7.noarch yum-rhn-plugin-2.0.1-5.el7.noarch How reproducible: always Steps to Reproduce: 1. install a package on a client registered to Spacewalk # yum install -y zsh 2. check the date immediately after the installation completes # date ideally in the timezone according your Spacewalk user locale preferences # TZ='CEST' date Čt čec 9 17:13:28 CEST 2015 3. navigate to Spacewalk WebUI - <your client system> - Software - Packages - List/Remove and compare it's installed time with the 2.) Actual results: # date Čt čec 9 13:13:24 EDT 2015 # TZ='CEST' date Čt čec 9 17:13:28 CEST 2015 zsh-5.0.2-7.el7_1.1 x86_64 Today at 7:13 PM (my user has set: Display all times as (GMT+0100) Europe (Central)) The dates do not match. Expected results: Dates should match. Additional info: Value displayed on Spacewalk WebUI corresponds with the value in the DB. $ echo "select * from rhnServerPackage where installtime > to_timestamp('2015-07-01', 'YYYY-MM-DD') and server_id = 1000010004;" | spacewalk-sql -i server_id | name_id | evr_id | package_arch_id | created | installtime ------------+---------+--------+-----------------+-------------------------------+------------------------ 1000010004 | 299 | 5653 | 120 | 2015-07-09 17:13:22.036797+02 | 2015-07-09 19:13:19+02 (1 row)