Re: "ago" times on buildfarm status page

On 8/26/19 2:55 PM, Tom Lane wrote:
> Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
>> On 8/21/19 4:16 PM, Tom Lane wrote:
>>> Andrew Dunstan <andrew.dunstan@2ndquadrant.com> writes:
>>>> Still, if we simply added the skew to the snapshot time that might be
>>>> enough to achieve what you want. That would be a one line change, I think.
>>> +1
>> Done. It's only happening prospectively, so we'll need to wait a few
>> days to see it flow through.
> Hm, doesn't seem to have done the trick.  The current dashboard page shows
> (in the v12 branch)
>
> mule            ...     01:17 ago  OK           [97205d0] Config
> loach           ...     01:32 ago  OK           [97205d0] Config
> dangomushi      ...     02:11 ago  OK           [97205d0] Config
> bowerbird       ...     02:23 ago  scriptsCheck [97205d0] Details
> snapper         ...     02:48 ago  OK           [63fc3b1] Config
> caiman          ...     03:04 ago  OK           [97205d0] Config
> nightjar        ...     03:17 ago  recoveryCheck [97205d0] Details
> chub            ...     03:29 ago  OK           [97205d0] Config
> clam            ...     03:34 ago  OK           [97205d0] Config
> demoiselle      ...     03:45 ago  OK           [97205d0] Config
>
> snapper is clearly out of line here: the commit it claims
> to have fetched 2:48 ago was obsoleted around seven hours ago.
>
> (Snapper is one of the machines that is typically inconsistent
> in this way.  I've been assuming that's because its system clock
> is a few hours off ... but maybe there's something else going on?)
>
>             




I think this is the problem:

     'scmrepo' => '/home/pgbf/pgmirror.git',

Probably this isn't updated often enough. It probably has little to do with the clock settings.

This is the kind of old-fashioned way of doing things. These days "git_keep_mirror => 1" along with the community repo
asthe base would avoid these problems.
 

cheers

andrew

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services