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 +PWfDWzQYWa3AgAAqHPOHw:P1 (envelope-from ) for ; Thu, 06 Jun 2024 17:06:20 +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 +PWfDWzQYWa3AgAAqHPOHw (envelope-from ) for ; Thu, 06 Jun 2024 17:06:20 +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=CIznI6UE; 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=1717686380; 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=9daQ6Zs0GRWeyWw6ZU8UR1MRJIszAV5R2WY80O2WXdQ=; b=N7HHZVL1NhYNJRbXodZa85fJnLbffaxg+ECiG6MVYVuc1kUYm+sQ3PhEdbueTrtYzAjD2U a8jweU+IMfJ66KIqjCfM1jjj/6JtjbqSv2iZ4ESs5TDXXIIdGnNdoQlRV2RmkzOTGnocd+ Qykg4EcXcoqNcU19oymXoGs6CTMwTa/sfqzo6bmOB04IBHOC7EnsnQ9XIWNd8+gaPjIJLQ HJIW5OmPVUziBNcts3YkJGwVGZc8mofO3B4BfdEEYYE+mIXsK+g3OBkCQS0DXuREpJxAkc Rnx8xdHSMk3QH6pN/13h0BNRslxS/elLTXlCWgKOOgU77Ptf3KOZS+N1xC1qpg== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1717686380; a=rsa-sha256; cv=none; b=QTZpalXMJ3kdp5uVZnVTYvO1G0aPjtxySPejw/bzX6ck29Ju7Gd0az6zIsn8k4aSMiLZPe +0k1bseCSkR1sTJ+xiBZo7/Cyd9FhWSsJOnTbfFNWRHv7I4kRyKAkj2Nck8B+Ic3m40eS9 rALF9t48IY3PpwflEGSzqe5oFRJeVVRaIuROlKCe8UqdOe52Y9f9VBlkldK1dK9Hq9e9fQ 9vr9Z1+VNZ+BPZdpFyA1yQ5K9KAvCOOJGAvtfdC68JUoazY6Sr/P5cnsQI4tknwRohz4o0 U0TLpMeCIIDxM/6LMjNq9o/bNeADCfx2RCR5wNPw+Kz5LG/cNq53xjlV2PXWQQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gnu.org header.s=fencepost-gnu-org header.b=CIznI6UE; 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 EFA9A7276D for ; Thu, 06 Jun 2024 17:06:19 +0200 (CEST) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1sFEgR-0007H0-Dq; Thu, 06 Jun 2024 11:05:43 -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 1sFEgP-0007Gm-22 for guix-devel@gnu.org; Thu, 06 Jun 2024 11:05:41 -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 1sFEgO-0007AM-A9; Thu, 06 Jun 2024 11:05:40 -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=9daQ6Zs0GRWeyWw6ZU8UR1MRJIszAV5R2WY80O2WXdQ=; b=CIznI6UEjh1MXbd1TPYR bnnFETjC1qWg1m7xn0Koz8bpuaRKDeW07TmbURyCyLYVs3FTHqLP5wUK/iRAukoUJFZ24r12rTqub MXG0rhetWhcN969V6WeKn3TVMi3Dwrdn5B9DYkRj+1NRPT4enqKGp3yZ3527nEnRSFdnlZ8VXwr3V Nym1yQ2a8vWdUL3ts/sihRoO+As+b8it7yaXU9NpsYHItTAD64Xblg871bPFtn/44q0A1qBOjkHt5 VqRkuPVUARTkIqK2mZhR0/tTPyPPVyw7qIokk724ziBILAkzNxizCFwoMsIEyHb1wKqnx16tpnczA r7KK3mrkGZxtoQ==; 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: <87bk4jjbdu.fsf@gnu.org> ("Ludovic =?utf-8?Q?Court=C3=A8s=22'?= =?utf-8?Q?s?= message of "Sun, 02 Jun 2024 23:14:05 +0200") References: <87y17on4ao.fsf@gnu.org> <87bk4jjbdu.fsf@gnu.org> X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: Nonidi 19 Prairial an 232 de la =?utf-8?Q?R=C3=A9vol?= =?utf-8?Q?ution=2C?= jour du Tilleul 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: Thu, 06 Jun 2024 17:05:32 +0200 Message-ID: <87ed9a3ydf.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: EFA9A7276D X-Migadu-Scanner: mx11.migadu.com X-TUID: EL+igY7XUZfV Hi Guix! Ludovic Court=C3=A8s skribis: > 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-s= erver=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=3D1= 7338588d4862b04e9e405c1244a2ea703b50d98 > > This is now deployed on ci.guix.gnu.org. This has been running for ~4 days now; the number of pending builds has significantly decreased (in particular, you=E2=80=99ll be delighted to get substitutes for =E2=80=98core-updates=E2=80=99!): https://ci.guix.gnu.org/metrics Almost all the x86 builds have been consumed: --8<---------------cut here---------------start------------->8--- cuirass=3D> select count(*) from builds where status =3D -2 and system =3D'= x86_64-linux'; count=20 ------- 748 (1 row) cuirass=3D> select count(*) from builds where status =3D -2 and system =3D'= i686-linux'; count=20 ------- 0 (1 row) cuirass=3D> select count(*) from builds where status =3D -2 and system =3D'= powerpc64le-linux'; count=20=20 -------- 110963 (1 row) cuirass=3D> select count(*) from builds where status =3D -2 ; count=20=20 -------- 382892 (1 row) --8<---------------cut here---------------end--------------->8--- The =E2=80=9CPending builds=E2=80=9D plot above shows we=E2=80=99re reachin= g a plateau: this is because the 382,000+ remaining builds are non-x86_64 and we lack resources for these platforms (Arm in particular). We should probably investigate and cancel builds that correspond to old evaluations or now-irrelevant jobsets. Ludo=E2=80=99.