From patchwork Fri Aug 14 17:21:37 2020 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Ian Jackson X-Patchwork-Id: 11714959 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 2C88B618 for ; Fri, 14 Aug 2020 17:27:51 +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 847CD20791 for ; Fri, 14 Aug 2020 17:27:50 +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="bx2NKp19" DMARC-Filter: OpenDMARC Filter v1.3.2 mail.kernel.org 847CD20791 Authentication-Results: mail.kernel.org; dmarc=fail (p=reject dis=none) header.from=eu.citrix.com Authentication-Results: mail.kernel.org; spf=pass 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.92) (envelope-from ) id 1k6dUC-0005tg-6r; Fri, 14 Aug 2020 17:27:24 +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.92) (envelope-from ) id 1k6dQd-00024H-0k for xen-devel@lists.xenproject.org; Fri, 14 Aug 2020 17:23:43 +0000 X-Inumbo-ID: 760e6777-aa2f-4a1a-a86d-ef4f670b4791 Received: from esa5.hc3370-68.iphmx.com (unknown [216.71.155.168]) by us1-amaz-eas2.inumbo.com (Halon) with ESMTPS id 760e6777-aa2f-4a1a-a86d-ef4f670b4791; Fri, 14 Aug 2020 17:22:18 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=citrix.com; s=securemail; t=1597425738; h=from:to:cc:subject:date:message-id:in-reply-to: references:mime-version; bh=zLcHhKo1cmGICQ2dzNfIzPI8l1nwyFvOoh6iuMg7/JM=; b=bx2NKp19tbBnW4q0/AagMciZEdpWgUiet9wg5LeAZrUMhA9quBE+WMLk KzSrHr76JyeDhlfDLHVWj5XcTiByyOA8D2bEmm1v8NZxQ4iOXRxwCU+6e 14avMiGeLqgnQVKntdc7AdjU+dHoy0wOymZxVY7oA5e46fyL2zr5gIvs2 4=; Authentication-Results: esa5.hc3370-68.iphmx.com; dkim=none (message not signed) header.i=none IronPort-SDR: VZVhd9rwqwtWKEI/K/ZXRLl7EVsrakjNSOWIcBpLpsx/jCDOZkn0BqdG8WFs+zCFYIBTlTukA0 h7juCpDFUL/KX80J/DYcnhygLz85c0/ADnz8CNAp8ChooR4IyJhyPmgMPJqOiTSZeKlFGSxJoF oXoFf7hvZCFGbhzB9JwWvN4H/e2+8KJA9HOa9emrMyZqkcoNxmvH25IUeNJrJiyv22nIZCGX35 vQVmyQT2Vis+KM7uYz8clDy31YmfNHWZrKS9QQWQcFoEDnJkUxZ/d8/Kyx8FhoRGLzOhTCxuj6 ARY= X-SBRS: 2.7 X-MesageID: 24725183 X-Ironport-Server: esa5.hc3370-68.iphmx.com X-Remote-IP: 162.221.158.21 X-Policy: $RELAYED X-IronPort-AV: E=Sophos;i="5.76,313,1592884800"; d="scan'208";a="24725183" From: Ian Jackson To: CC: Ian Jackson Subject: [OSSTEST PATCH 32/60] sg-report-job-history: Prep for fork: Move $revisionsq query Date: Fri, 14 Aug 2020 18:21:37 +0100 Message-ID: <20200814172205.9624-33-ian.jackson@eu.citrix.com> X-Mailer: git-send-email 2.11.0 In-Reply-To: <20200814172205.9624-1-ian.jackson@eu.citrix.com> References: <20200814172205.9624-1-ian.jackson@eu.citrix.com> MIME-Version: 1.0 X-BeenThere: xen-devel@lists.xenproject.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Xen developer discussion List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Errors-To: xen-devel-bounces@lists.xenproject.org Sender: "Xen-devel" We will need to prepare this in add_revisions so that it works when we do each (job,branch) in a different process. It is OK that it is still global, becauswe we only call add_revisions in the children. Signed-off-by: Ian Jackson --- sg-report-job-history | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) diff --git a/sg-report-job-history b/sg-report-job-history index 47fc7a62..424053f1 100755 --- a/sg-report-job-history +++ b/sg-report-job-history @@ -89,15 +89,16 @@ if (defined($flight)) { push @jobs, $job; } -our $revisionsq= db_prepare(<execute($flightnum, $j); while (my $row= $revisionsq->fetchrow_hashref()) { my $n= $row->{name};