#3785 track update time in host table
Closed by tkopecek. Opened by mikem.
mikem/koji host-update-ts  into  master

Download 3785.patch

Store an update_time in the host table each time the host checks in, and use this instead of the session update_time.

~~WIP~~
~~I still need to fix some unit tests~~

1 new commit added

  • fix unit tests

Added https://pagure.io/koji/issue/3789

worth an index?

migration script

conflicts with session.update_time:

psycopg2.errors.AmbiguousColumn: column reference "update_time" is ambiguous
LINE 11:    AND (update_time > NOW() - '5 minutes'::interval)

1 new commit added

  • avoid ambiguous columns refs

Because in this PR is change in schema.sql, we should add it to upgrade-schema sql also, or not? Tomas mentioned it also in comments.

Added in #3819

Pull-Request has been closed by tkopecek

Metadata