From patchwork Fri Nov 8 18:49:53 2019 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Ian Jackson X-Patchwork-Id: 11235377 Return-Path: Received: from mail.kernel.org (pdx-korg-mail-1.web.codeaurora.org [172.30.200.123]) by pdx-korg-patchwork-2.web.codeaurora.org (Postfix) with ESMTP id 6B95F1747 for ; Fri, 8 Nov 2019 18:51:53 +0000 (UTC) Received: from lists.xenproject.org (lists.xenproject.org [192.237.175.120]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mail.kernel.org (Postfix) with ESMTPS id 486842087E for ; Fri, 8 Nov 2019 18:51:53 +0000 (UTC) Authentication-Results: mail.kernel.org; dkim=fail reason="signature verification failed" (1024-bit key) header.d=citrix.com header.i=@citrix.com header.b="CdJBDOQS" DMARC-Filter: OpenDMARC Filter v1.3.2 mail.kernel.org 486842087E Authentication-Results: mail.kernel.org; dmarc=fail (p=none dis=none) header.from=eu.citrix.com Authentication-Results: mail.kernel.org; spf=none smtp.mailfrom=xen-devel-bounces@lists.xenproject.org Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.89) (envelope-from ) id 1iT9LL-00086j-5s; Fri, 08 Nov 2019 18:50:47 +0000 Received: from all-amaz-eas1.inumbo.com ([34.197.232.57] helo=us1-amaz-eas2.inumbo.com) by lists.xenproject.org with esmtp (Exim 4.89) (envelope-from ) id 1iT9LK-00085b-6F for xen-devel@lists.xenproject.org; Fri, 08 Nov 2019 18:50:46 +0000 X-Inumbo-ID: 9e6198a8-0258-11ea-a1d6-12813bfff9fa Received: from esa2.hc3370-68.iphmx.com (unknown [216.71.145.153]) by us1-amaz-eas2.inumbo.com (Halon) with ESMTPS id 9e6198a8-0258-11ea-a1d6-12813bfff9fa; Fri, 08 Nov 2019 18:50:23 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=citrix.com; s=securemail; t=1573239023; h=from:to:cc:subject:date:message-id:in-reply-to: references:mime-version; bh=nI+8Vz43Y3pq0RgBdu5EoYZFGXDykGRVZpkx0C/orc8=; b=CdJBDOQS3t4Ytmeb4CydPp8jztEu/D4Gd6XKZMb+82mbI/u7WEc63DpO D20Ez/12T6WLAEOv+abNsnErG6/pwziS4xgP8scieLoYXQq51fXbJxkSS 568EOVHPkiHKCWmffRwmufTAwcPGFubNIzCjlBW/d6x+ywnPW/a6TFf1l Y=; Authentication-Results: esa2.hc3370-68.iphmx.com; dkim=none (message not signed) header.i=none; spf=None smtp.pra=ian.jackson@eu.citrix.com; spf=Pass smtp.mailfrom=Ian.Jackson@citrix.com; spf=None smtp.helo=postmaster@mail.citrix.com Received-SPF: None (esa2.hc3370-68.iphmx.com: no sender authenticity information available from domain of ian.jackson@eu.citrix.com) identity=pra; client-ip=162.221.158.21; receiver=esa2.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="ian.jackson@eu.citrix.com"; x-conformance=sidf_compatible Received-SPF: Pass (esa2.hc3370-68.iphmx.com: domain of Ian.Jackson@citrix.com designates 162.221.158.21 as permitted sender) identity=mailfrom; client-ip=162.221.158.21; receiver=esa2.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="Ian.Jackson@citrix.com"; x-conformance=sidf_compatible; x-record-type="v=spf1"; x-record-text="v=spf1 ip4:209.167.231.154 ip4:178.63.86.133 ip4:195.66.111.40/30 ip4:85.115.9.32/28 ip4:199.102.83.4 ip4:192.28.146.160 ip4:192.28.146.107 ip4:216.52.6.88 ip4:216.52.6.188 ip4:162.221.158.21 ip4:162.221.156.83 ip4:168.245.78.127 ~all" Received-SPF: None (esa2.hc3370-68.iphmx.com: no sender authenticity information available from domain of postmaster@mail.citrix.com) identity=helo; client-ip=162.221.158.21; receiver=esa2.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="postmaster@mail.citrix.com"; x-conformance=sidf_compatible IronPort-SDR: rXdRlxyQw5Gw9fS4Z91h2bGnWjpFqXqmurblOHNSIELQSeotXa6PchhOKagpMgymF1K2S15lMJ 480I5PGkX/Sfo1nqYtHS3HJdf5GqCglnqWaQMXtX6gJ+oif/qIBLTrmoQTOmijisvxK7tUa/gA bSsVZMsk8sE+EeoaJxKdXIeb9EfyBPikf9ihRS5IPYDKiK6O5aOCFltgqnur0AQcKfezy+vvBi 3UvprpQG8E/4bUDYA1pbrlhHauV+j4yJY+CyyQPQmRNNTwtO8Na80KOMqLmebY5h9W6cbPhoWY t1s= X-SBRS: 2.7 X-MesageID: 8076647 X-Ironport-Server: esa2.hc3370-68.iphmx.com X-Remote-IP: 162.221.158.21 X-Policy: $RELAYED X-IronPort-AV: E=Sophos;i="5.68,282,1569297600"; d="scan'208";a="8076647" From: Ian Jackson To: Date: Fri, 8 Nov 2019 18:49:53 +0000 Message-ID: <20191108185001.3319-6-ian.jackson@eu.citrix.com> X-Mailer: git-send-email 2.11.0 In-Reply-To: <20191108185001.3319-1-ian.jackson@eu.citrix.com> References: <20191108185001.3319-1-ian.jackson@eu.citrix.com> MIME-Version: 1.0 Subject: [Xen-devel] [OSSTEST PATCH 05/13] sg-report-host-history: Get job status from mainquery X-BeenThere: xen-devel@lists.xenproject.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Cc: Ian Jackson Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" We are going to need this as part of our data reuse cache key, so we need it this early. This change hardly slows the query down. Signed-off-by: Ian Jackson --- sg-report-host-history | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sg-report-host-history b/sg-report-host-history index d47784d9..81a7a8d8 100755 --- a/sg-report-host-history +++ b/sg-report-host-history @@ -122,8 +122,9 @@ sub mainquery () { our @params = keys %hosts; our $runvarq //= db_prepare(<