koji

#2160 event times subject to postgres timezone setting
Closed: Fixed by tkopecek. Opened by mikem.

Closed: Fixed
Reopen Issue

Unfortunately, Koji's schema uses timezone fields rather than timezonetz fields. Most of the code generally treats these values as unix timestamps, but this is only true if the Postgres server has its default timezone set to UTC.

If the database has a different timezone setting (which seems to be the default), then various times reported by Koji can be offset, such as in #2159

kojitest4=> SET timezone = 'America/New_York';
SET
kojitest4=> select extract(epoch from clock_timestamp());
    date_part     
------------------
 1587077209.14461
(1 row)
kojitest4=> select extract(epoch from clock_timestamp()::timestamp);
    date_part    
-----------------
 1587062811.6566
(1 row)

Metadata Update from @mikem:
- Custom field Size adjusted to None

Metadata Update from @tkopecek:
- Issue set to the milestone: 1.22

PR #2237

Metadata Update from @jcupova:
- Issue tagged with: testing-ready

Metadata Update from @mfilip:
- Issue tagged with: testing-done

Commit 46752299 fixes this issue

Commit 87b8cf71 fixes this issue

This issue has been migrated to Fedora Forge:
https://forge.fedoraproject.org/koji/koji/issues/2160

Please continue any further discussion there.
Metadata
None

testing-done testing-ready

None
None
Low
None
Related Pull Requests
Static archive. pagure.io was sunset in 2026; this is a read-only snapshot.
Red Hat Logo

Fedora is sponsored by Red Hat. Learn more about the relationship between Red Hat and Fedora »

© Red Hat, Inc. and others.