From: Wei Liu <wei.liu2@citrix.com>
To: Ian Jackson <ian.jackson@eu.citrix.com>
Cc: xen-devel@lists.xenproject.org, Wei Liu <wei.liu2@citrix.com>
Subject: Re: [OSSTEST PATCH 0/7] Apropos of XTF: Improve failed step selection
Date: Tue, 6 Sep 2016 10:46:25 +0100 [thread overview]
Message-ID: <20160906094625.GL18255@citrix.com> (raw)
In-Reply-To: <22478.36900.667902.134843@mariner.uk.xensource.com>
On Tue, Sep 06, 2016 at 10:45:08AM +0100, Ian Jackson wrote:
> Wei Liu writes ("Re: [OSSTEST PATCH 0/7] Apropos of XTF: Improve failed step selection"):
> > > On Thu, Aug 11, 2016 at 05:17:56PM +0100, Ian Jackson wrote:
> > > - SELECT sum(finished-started)
> > > + SELECT sum(max(finished)-min(started))
> ...
> > resourcecall DBD::Pg::st execute failed: ERROR: aggregate function calls cannot be nested
>
> I am a total idiot. I didn't spot you had botched the merge. The new
> code should be
>
> max(finished)-min(started)
>
> without the sum().
OK. I will fix that. Thanks.
Wei.
>
> Ian.
_______________________________________________
Xen-devel mailing list
Xen-devel@lists.xen.org
https://lists.xen.org/xen-devel
prev parent reply other threads:[~2016-09-06 9:46 UTC|newest]
Thread overview: 15+ messages / expand[flat|nested] mbox.gz Atom feed top
2016-08-11 16:17 [OSSTEST PATCH 0/7] Apropos of XTF: Improve failed step selection Ian Jackson
2016-08-11 16:17 ` [OSSTEST PATCH 1/7] duration_estimator: Introduce $duration_duration_qtxt and @d_d_args Ian Jackson
2016-08-11 16:17 ` [OSSTEST PATCH 2/7] duration_estimator: Reformat inner SQL query with more newlines Ian Jackson
2016-08-11 16:17 ` [OSSTEST PATCH 3/7] duration_estimator: Reorganise inner SQL query to use WITH Ian Jackson
2016-08-11 16:18 ` [OSSTEST PATCH 4/7] duration_estimator: Be able to estimate job duration up to a particular step Ian Jackson
2016-08-11 16:18 ` [OSSTEST PATCH 5/7] sg-report-flight: Fix misleading value in call to duration_estimator Ian Jackson
2016-08-11 16:18 ` [OSSTEST PATCH 6/7] sg-report-flight: Fix a missing newline in a DEBUG message Ian Jackson
2016-08-11 16:18 ` [OSSTEST PATCH 7/7] sg-report-flight: Report earlier, earlier step failures Ian Jackson
2016-08-11 17:05 ` [OSSTEST PATCH 0/7] Apropos of XTF: Improve failed step selection Wei Liu
2016-08-30 16:00 ` Wei Liu
2016-08-30 16:08 ` Ian Jackson
2016-08-30 16:13 ` Andrew Cooper
2016-09-05 18:08 ` Wei Liu
2016-09-06 9:45 ` Ian Jackson
2016-09-06 9:46 ` Wei Liu [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20160906094625.GL18255@citrix.com \
--to=wei.liu2@citrix.com \
--cc=ian.jackson@eu.citrix.com \
--cc=xen-devel@lists.xenproject.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.