From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:403:58f0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms1.migadu.com with LMTPS id iOaeBoxKXWYUoAAAqHPOHw:P1 (envelope-from ) for ; Mon, 03 Jun 2024 06:46:04 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:58f0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id iOaeBoxKXWYUoAAAqHPOHw (envelope-from ) for ; Mon, 03 Jun 2024 06:46:04 +0200 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gnu.org header.s=fencepost-gnu-org header.b=Q6Uym9lF; dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org" ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1717389962; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=3W5/U9v32rjFobktZ0RCGlAdaqUBQ0zDUuRgbZNvwMg=; b=jReMXUiQxed9GGlEQTLD+MGJKPqAR45fnyp2sSOk840eIcNdNdXb6o2xzIkyShNSGP0mHl bjs6hk4BnMlrraBvlGfyUADpUg6TZhZU/A9/eTSz5sxu2J9N4tnZ5WWWhUNe4INMIvkokc dUj65jnmgcPE1bfZ0iSnbQgxxl2XR0YKLHwA9fc9LfKBAGr9HiFazH3iA18vG9Jt3K14FO YrjHQAsXY/9zpuseH/VCfPshSc4aEAc57G3qegY6KcMZdZPhvX5Y5kipiH12jwFUgpQrjM dC5Aab/nP5RU5jxJcsqT8ADjuDimiSamHBuO+I+vSa9Mv+xI8DNDFoZGbBd5VA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1717389962; a=rsa-sha256; cv=none; b=BEA4pTfZLnQA7NZUndgapZAv7mJD8BndJwCZEZT2nSOfTREOl+3cwEX8HEHUCV+xudoVaF mBxGyXWfBhrf+Uv/PzZ9jla8J5plesyov6753XzXUSOyyav1UPQ8WzWmY/z8cAEF5VPZ/Y I1ZBB1caU+u9Xi/BGfC8p51pEoASLutgY4OfxwX7n9uxDqHOnJS+F3u4RFL5gTZD+62V7j KgCIHugMfDUKm8X31Ng75IHnqxs4hmT9/B1Ow5C+PfjS2ijn1Ctbu0KxeFmvt1qA3KRZiC wxSzAq9iEuCkW6MTAjIGESX/wbG67JPpfGklit/M5RM2DIH9PjJxFytPAO4YnQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gnu.org header.s=fencepost-gnu-org header.b=Q6Uym9lF; dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org" Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id C31E167B51 for ; Mon, 03 Jun 2024 06:46:02 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1sDzAI-0006CB-5z; Mon, 03 Jun 2024 00:19:22 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sDz1R-0002xj-40 for guix-devel@gnu.org; Mon, 03 Jun 2024 00:10:13 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1sDsWl-0001gG-J5; Sun, 02 Jun 2024 17:14:07 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-Version:Date:References:In-Reply-To:Subject:To: From; bh=3W5/U9v32rjFobktZ0RCGlAdaqUBQ0zDUuRgbZNvwMg=; b=Q6Uym9lFZB2WD8FCVUcd L7DSgxm9+PPjC3or6ICQ3p9lHaAQwucnLe9A4k4CZjr+4Gp3o/29J0a0uuskY80MPomqL1TQvjFNf UBipvoTVOIq8DSyFuBVk/ocSW96YDwI65apV4r92q7NDmWVQM8TRgys602AIRE7dhqZxPOCHojun2 DH9kgUQqX6O3//hf6SMzyKBZuDCi5dQMksrEMYTbTiYaQm5VfcbW3RTYe7Xzd6WUM6/axED5vvr3u BUAIvghzln2wHgMjwuNBnDcNkHJkDsbyK3MvBO2Yhnf0UNQvanSXbVtUytNbQXajNzYaT4vXbAZ0F nwkQQR4Mp5jsyw==; From: =?utf-8?Q?Ludovic_Court=C3=A8s?= To: Lars-Dominik Braun Cc: guix-devel@gnu.org Subject: Re: CI is not processing jobs In-Reply-To: <87y17on4ao.fsf@gnu.org> ("Ludovic =?utf-8?Q?Court=C3=A8s=22'?= =?utf-8?Q?s?= message of "Sat, 01 Jun 2024 16:09:03 +0200") References: <87y17on4ao.fsf@gnu.org> X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: Quintidi 15 Prairial an 232 de la =?utf-8?Q?R=C3=A9v?= =?utf-8?Q?olution=2C?= jour de la Caille X-PGP-Key-ID: 0x090B11993D9AEBB5 X-PGP-Key: http://www.fdn.fr/~lcourtes/ludovic.asc X-PGP-Fingerprint: 3CE4 6455 8A84 FDC6 9DB4 0CFB 090B 1199 3D9A EBB5 X-OS: x86_64-pc-linux-gnu Date: Sun, 02 Jun 2024 23:14:05 +0200 Message-ID: <87bk4jjbdu.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: guix-devel-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Spam-Score: -8.10 X-Spam-Score: -8.10 X-Migadu-Queue-Id: C31E167B51 X-Migadu-Scanner: mx11.migadu.com X-TUID: 1wR+v//Isef4 Hi, Ludovic Court=C3=A8s skribis: > The longer story is that Ricardo noticed that the build backlog had been > growing for a couple of months (see =E2=80=9CPending builds=E2=80=9D): > > https://ci.guix.gnu.org/metrics > > We discussed this on guix-sysadmin and found that this was due to the > poor performance of a SQL query at the core of =E2=80=98cuirass remote-se= rver=E2=80=99 > that was roughly linear in the number of packages in the database. With > help from Chris Baines, this is now fixed: > > https://git.savannah.gnu.org/cgit/guix/guix-cuirass.git/commit/?id=3D17= 338588d4862b04e9e405c1244a2ea703b50d98 This is now deployed on ci.guix.gnu.org. So far all the workers are kept busy. We=E2=80=99ll have to see if it keep= s up over time. Ludo=E2=80=99.