Bug 1241607 - invalid package install time reported
Summary: invalid package install time reported
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Spacewalk
Classification: Community
Component: Clients
Version: 2.3
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Jiří Dostál
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space27
TreeView+ depends on / blocked
 
Reported: 2015-07-09 15:23 UTC by Tomas Lestach
Modified: 2017-09-28 18:08 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-07-10 12:18:13 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1042909 0 unspecified CLOSED System -> Requiring Reboot will list systems, that do not require a reboot due to timezone handling problems 2021-02-22 00:41:40 UTC

Internal Links: 1042909

Description Tomas Lestach 2015-07-09 15:23:37 UTC
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)

Comment 1 Tomas Lestach 2015-07-10 12:18:13 UTC
Actually, my fault.
Correct cmd would be:
TZ='CET' date
what matches with Spacewalk WebUI.
Closing NOTABUG.

Comment 2 Eric Herget 2017-09-28 18:08:07 UTC
This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.


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