Re: "ago" times on buildfarm status page

2019-08-27 Thread Andrew Dunstan
On 8/27/19 10:15 AM, Tom Lane wrote: > "Tom Turelinckx" writes: >> On Mon, Aug 26, 2019, at 9:08 PM, Andrew Dunstan wrote: >>> 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

Re: "ago" times on buildfarm status page

2019-08-27 Thread Tom Lane
"Tom Turelinckx" writes: > On Mon, Aug 26, 2019, at 9:08 PM, Andrew Dunstan wrote: >> 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. > The configuration is

Re: "ago" times on buildfarm status page

2019-08-27 Thread Andrew Dunstan
On 8/27/19 8:45 AM, Andrew Dunstan wrote: > On 8/27/19 4:33 AM, Tom Turelinckx wrote: >> On Mon, Aug 26, 2019, at 9:08 PM, Andrew Dunstan wrote: >>> I think this is the problem: >>> >>> 'scmrepo' => '/home/pgbf/pgmirror.git', >>> >>> Probably this isn't updated often enough. It probably has

Re: "ago" times on buildfarm status page

2019-08-27 Thread Andrew Dunstan
On 8/27/19 4:33 AM, Tom Turelinckx wrote: > On Mon, Aug 26, 2019, at 9:08 PM, Andrew Dunstan wrote: >> 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

Re: "ago" times on buildfarm status page

2019-08-27 Thread Tom Turelinckx
On Mon, Aug 26, 2019, at 9:08 PM, Andrew Dunstan wrote: > 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.

Re: "ago" times on buildfarm status page

2019-08-26 Thread Andrew Dunstan
On 8/26/19 2:55 PM, Tom Lane wrote: > Andrew Dunstan writes: >> On 8/21/19 4:16 PM, Tom Lane wrote: >>> Andrew Dunstan 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 >>

Re: "ago" times on buildfarm status page

2019-08-26 Thread Tom Lane
Andrew Dunstan writes: > On 8/21/19 4:16 PM, Tom Lane wrote: >> Andrew Dunstan 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

Re: "ago" times on buildfarm status page

2019-08-24 Thread Andrew Dunstan
On 8/21/19 10:52 AM, Andrew Dunstan wrote: >> >> The Javscript could also be made to update the "ago" part every minute, >> and show the absoulte time as a tooltip, which is what pretty much every >> other website does. >> > > The code for the page is here: >

Re: "ago" times on buildfarm status page

2019-08-23 Thread Andrew Dunstan
On 8/21/19 4:16 PM, Tom Lane wrote: > Andrew Dunstan writes: >> What I have done quickly is to store a measure of the clock skew. We >> already calculated it but we didn't store it. Initial indications are >> that only a few have significant skew. > Oh, I didn't know that the server had the

Re: "ago" times on buildfarm status page

2019-08-21 Thread Tom Lane
Andrew Dunstan writes: > What I have done quickly is to store a measure of the clock skew. We > already calculated it but we didn't store it. Initial indications are > that only a few have significant skew. Oh, I didn't know that the server had the ability to measure that. (Yes, I agree that

Re: "ago" times on buildfarm status page

2019-08-21 Thread Andrew Dunstan
On 8/21/19 11:07 AM, Andrew Dunstan wrote: > On 8/21/19 9:55 AM, Tom Lane wrote: >> The real problem with that column though is that it relies on run start >> times that are self-reported by the buildfarm clients, and some of them >> have system clocks that are many hours off reality. What

Re: "ago" times on buildfarm status page

2019-08-21 Thread Andrew Dunstan
On 8/21/19 3:40 AM, Peter Eisentraut wrote: > I find the time displays like > > 01:03 ago > > on the buildfarm status page unhelpful. > > First, I can never tell whether this is hours-minutes or minutes-seconds > -- there is probably a less ambiguous format available. This is

Re: "ago" times on buildfarm status page

2019-08-21 Thread Andrew Dunstan
On 8/21/19 9:55 AM, Tom Lane wrote: > > The real problem with that column though is that it relies on run start > times that are self-reported by the buildfarm clients, and some of them > have system clocks that are many hours off reality. What *I'd* like to > see is for the column to contain

Re: "ago" times on buildfarm status page

2019-08-21 Thread Andrew Dunstan
On 8/21/19 8:32 AM, Dagfinn Ilmari Mannsåker wrote: > Magnus Hagander writes: > >> On Wed, Aug 21, 2019 at 9:40 AM Peter Eisentraut < >> peter.eisentr...@2ndquadrant.com> wrote: >> >>> I find the time displays like >>> >>> 01:03 ago >>> >>> on the buildfarm status page unhelpful. >>> >>>

Re: "ago" times on buildfarm status page

2019-08-21 Thread Tom Lane
Magnus Hagander writes: > On Wed, Aug 21, 2019 at 9:40 AM Peter Eisentraut < > peter.eisentr...@2ndquadrant.com> wrote: >> I find the time displays like >> 01:03 ago >> on the buildfarm status page unhelpful. >> >> I notice that the page source actually includes absolute times that are >> then

Re: "ago" times on buildfarm status page

2019-08-21 Thread Dagfinn Ilmari Mannsåker
Magnus Hagander writes: > On Wed, Aug 21, 2019 at 9:40 AM Peter Eisentraut < > peter.eisentr...@2ndquadrant.com> wrote: > >> I find the time displays like >> >> 01:03 ago >> >> on the buildfarm status page unhelpful. >> >> First, I can never tell whether this is hours-minutes or

Re: "ago" times on buildfarm status page

2019-08-21 Thread Magnus Hagander
On Wed, Aug 21, 2019 at 9:40 AM Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > I find the time displays like > > 01:03 ago > > on the buildfarm status page unhelpful. > > First, I can never tell whether this is hours-minutes or minutes-seconds > -- there is probably a less

"ago" times on buildfarm status page

2019-08-21 Thread Peter Eisentraut
I find the time displays like 01:03 ago on the buildfarm status page unhelpful. First, I can never tell whether this is hours-minutes or minutes-seconds -- there is probably a less ambiguous format available. But more importantly, the page doesn't say when it was generated, so a relative