From nobody Mon Feb 9 17:37:27 2026 Delivered-To: importer@patchew.org Authentication-Results: mx.zohomail.com; dkim=fail; spf=none (zoho.com: 192.237.175.120 is neither permitted nor denied by domain of lists.xenproject.org) smtp.mailfrom=xen-devel-bounces@lists.xenproject.org; dmarc=fail(p=none dis=none) header.from=eu.citrix.com ARC-Seal: i=1; a=rsa-sha256; t=1573239095; cv=none; d=zoho.com; s=zohoarc; b=SrEtUiSimfXpdGBpV0DJLh3mfiIjz/3illdh+1AvOQ1B8dsz5SSpR/lYQdzgWZz3P4YdjwgN4RNY/Y606+szUpD1FTpMjB4hkHnmJg+5AwO6aRUm0Nkhvc6nXs13sefAzurYKNCtXFmGzwCV/e6JFSDdXZ3adH0JLybZECenHoQ= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zoho.com; s=zohoarc; t=1573239095; h=Content-Type:Content-Transfer-Encoding:Cc:Date:From:In-Reply-To:List-Subscribe:List-Post:List-Id:List-Help:List-Unsubscribe:MIME-Version:Message-ID:References:Sender:Subject:To; bh=fWptoeaSkO8Khv/eJ5oXSDbr8fXTNuUj7fUCcXvxp9I=; b=W5bndzcVwiKmiCmirkhk61vOILMR+W+ZLXX9JBHAJljW5QRJFCTIgHDe4r5BiE7jh57kAcHUnfm4My4y3QnW7vJsfMX8oosE19suD+oTKYxz8YDu6iTXT9PenECnThCZ+HWpi6tpi1jYclrJQxwqIVKPKLnFgktMeW12OB4DlRg= ARC-Authentication-Results: i=1; mx.zoho.com; dkim=fail; spf=none (zoho.com: 192.237.175.120 is neither permitted nor denied by domain of lists.xenproject.org) smtp.mailfrom=xen-devel-bounces@lists.xenproject.org; dmarc=fail header.from= (p=none dis=none) header.from= Return-Path: Received: from lists.xenproject.org (lists.xenproject.org [192.237.175.120]) by mx.zohomail.com with SMTPS id 1573239095300498.9076080715947; Fri, 8 Nov 2019 10:51:35 -0800 (PST) Received: from localhost ([127.0.0.1] helo=lists.xenproject.org) by lists.xenproject.org with esmtp (Exim 4.89) (envelope-from ) id 1iT9LC-0007xj-4t; Fri, 08 Nov 2019 18:50:38 +0000 Received: from us1-rack-iad1.inumbo.com ([172.99.69.81]) by lists.xenproject.org with esmtp (Exim 4.89) (envelope-from ) id 1iT9LA-0007wY-I1 for xen-devel@lists.xenproject.org; Fri, 08 Nov 2019 18:50:36 +0000 Received: from esa4.hc3370-68.iphmx.com (unknown [216.71.155.144]) by us1-rack-iad1.inumbo.com (Halon) with ESMTPS id 9a8d599c-0258-11ea-adbe-bc764e2007e4; Fri, 08 Nov 2019 18:50:16 +0000 (UTC) X-Inumbo-ID: 9a8d599c-0258-11ea-adbe-bc764e2007e4 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=citrix.com; s=securemail; t=1573239016; h=from:to:cc:subject:date:message-id:in-reply-to: references:mime-version; bh=UoZj1twCsqz4RD+oQF3WE6ZiGLkrhL4NtaEKo19J694=; b=CZlImhQGzjRyhhCiO6qksnl/Iv0/gbIWL5lYCo1sLTYq4t5+K8ehWY2h XUPvsd/fhtaKSqNG50PslidwOlINlPA+fXp96k0PvZ6ptszQ6gi/2BRJe Xg0o/4xkXN46OwU1bE66U7RA1SCNK6Y3o0IKfCCSXfd5LT36seCYvQBZA I=; Authentication-Results: esa4.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 (zoho.com: 192.237.175.120 is neither permitted nor denied by domain of lists.xenproject.org) client-ip=192.237.175.120; envelope-from=xen-devel-bounces@lists.xenproject.org; helo=lists.xenproject.org; Received-SPF: None (esa4.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=esa4.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="ian.jackson@eu.citrix.com"; x-conformance=sidf_compatible Received-SPF: Pass (esa4.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=esa4.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 (esa4.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=esa4.hc3370-68.iphmx.com; envelope-from="Ian.Jackson@citrix.com"; x-sender="postmaster@mail.citrix.com"; x-conformance=sidf_compatible IronPort-SDR: ruZtTklUsHsQJ8XEXXu5sytWtU6aYXdiMy35nK/i/u1+k7GD+X3mqwBtvWvB/R7gLvbsPEJLwA oNSaU6jfby5+eWMz6lD75F/InIZPWaQUXK0ERDx9OcVOT/jb8AbkwoxDhjk+0WCsO8WFXTdht6 waOHFhLCq+fIH79y9unTEA+s5I/KxBbCaPXb9L97M8Z4e6TMA2/qz7hwc0f1ds0SRvRJZM2aSQ K4TL6Ou2FUp/AkiLDWBtB9yvAEfxX4MTOJ9o9kvVRci0Y26OFicDG3hIm29d1v6OMptisA02hY wAw= X-SBRS: 2.7 X-MesageID: 8592083 X-Ironport-Server: esa4.hc3370-68.iphmx.com X-Remote-IP: 162.221.158.21 X-Policy: $RELAYED X-IronPort-AV: E=Sophos;i="5.68,283,1569297600"; d="scan'208";a="8592083" From: Ian Jackson To: Date: Fri, 8 Nov 2019 18:49:54 +0000 Message-ID: <20191108185001.3319-7-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 06/13] sg-report-host-history: Add $cachekey argument to jobquery 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 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" X-ZohoMail-DKIM: fail (Header signature does not verify) This key will distinguish the results of different queries we do per job. Right now it is not used, so no functional change. Signed-off-by: Ian Jackson --- sg-report-host-history | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/sg-report-host-history b/sg-report-host-history index 81a7a8d8..4c40cbec 100755 --- a/sg-report-host-history +++ b/sg-report-host-history @@ -109,7 +109,8 @@ END print DEBUG "MINFLIGHT $minflight\n"; } =20 -sub jobquery ($$) { +sub jobquery ($$$) { + my ($q, $jr, $cachekey) =3D @_; my ($q, $jr) =3D @_; $q->execute($jr->{flight}, $jr->{job}); return $q->fetchrow_hashref(); @@ -218,7 +219,7 @@ END foreach my $jr (@$inrows) { print DEBUG "JOB $jr->{flight}.$jr->{job} "; =20 - my $endedrow =3D jobquery($endedq, $jr); + my $endedrow =3D jobquery($endedq, $jr, 'e'); if (!$endedrow) { print DEBUG "no-finished\n"; next; @@ -235,8 +236,8 @@ END my $alternate =3D 0; foreach my $jr (@rows) { print DEBUG "JR $jr->{flight}.$jr->{job}\n"; - my $ir =3D jobquery($infoq, $jr); - my $ar =3D jobquery($allocdq, $jr); + my $ir =3D jobquery($infoq, $jr, 'i'); + my $ar =3D jobquery($allocdq, $jr, 'a'); my $ident =3D $jr->{name}; $jrunvarq->execute($jr->{flight}, $jr->{job}, $ident); my %runvars; --=20 2.11.0 _______________________________________________ Xen-devel mailing list Xen-devel@lists.xenproject.org https://lists.xenproject.org/mailman/listinfo/xen-devel