From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 6GXKKI8O5l4JTAAA0tVLHw (envelope-from ) for ; Sun, 14 Jun 2020 11:48:31 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id lAh4JI8O5l5aaQAAbx9fmQ (envelope-from ) for ; Sun, 14 Jun 2020 11:48:31 +0000 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 EA4899404D3 for ; Sun, 14 Jun 2020 11:48:30 +0000 (UTC) Received: from localhost ([::1]:51482 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jkR7l-0002KD-Oo for larch@yhetil.org; Sun, 14 Jun 2020 07:48:29 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58234) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jkR7Z-0002K4-2D for guix-devel@gnu.org; Sun, 14 Jun 2020 07:48:17 -0400 Received: from mira.cbaines.net ([212.71.252.8]:43088) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jkR7W-00021Y-ED for guix-devel@gnu.org; Sun, 14 Jun 2020 07:48:16 -0400 Received: from localhost (unknown [46.237.175.96]) by mira.cbaines.net (Postfix) with ESMTPSA id 2983827BBE1; Sun, 14 Jun 2020 12:48:12 +0100 (BST) Received: from localhost (localhost [local]) by localhost (OpenSMTPD) with ESMTPA id 51e01d95; Sun, 14 Jun 2020 11:48:09 +0000 (UTC) References: <20200609205342.613-1-mail@cbaines.net> <87mu577wv5.fsf@cbaines.net> <867dwaalcr.fsf@gmail.com> User-agent: mu4e 1.2.0; emacs 26.3 From: Christopher Baines To: zimoun Subject: Re: [PATCH] sql: Add a couple of indexes. In-reply-to: <867dwaalcr.fsf@gmail.com> Date: Sun, 14 Jun 2020 12:48:05 +0100 Message-ID: <87imft98cq.fsf@cbaines.net> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha512; protocol="application/pgp-signature" Received-SPF: pass client-ip=212.71.252.8; envelope-from=mail@cbaines.net; helo=mira.cbaines.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/06/14 07:48:12 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, UNPARSEABLE_RELAY=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: guix-devel@gnu.org Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: "Guix-devel" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of guix-devel-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-devel-bounces@gnu.org X-Spam-Score: -1.61 X-TUID: W+5EZoRc7GpW --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable zimoun writes: > Hi Chris, > > On Sat, 13 Jun 2020 at 17:29, Christopher Baines wrote: > >> I've pushed a rebased version of this patch now. I've also recofigured >> bayfront to apply these changes. Checking with guix weather, I think it >> might be helping. > > Nice! > > What about reconfigure ci.guix.gnu.org and close bug#41708? > > http://issues.guix.gnu.org/issue/41708 Indeed, hopefully that can happen soon. >> =E2=86=92 guix weather --substitute-urls=3Dhttps://bayfront.guix.gnu.org > > [...] > >> 13.8% (897 out of 6,519) of the missing items are queued >> at least 1,000 queued builds >> x86_64-linux: 1000 (100.0%) >> build rate: 9.34 builds per hour >> x86_64-linux: 9.34 builds per hour > > I think it is the first I see these results instead of the 504. :-) > With "guix e782756", it is: > > --8<---------------cut here---------------start------------->8--- > 65.7% substitutes available (9,425 out of 14,354) > at least 57,816.3 MiB of nars (compressed) > 97,343.9 MiB on disk (uncompressed) > 0.010 seconds per request (138.1 seconds in total) > 103.0 requests per second > > 0.0% (0 out of 4,929) of the missing items are queued > at least 1,000 queued builds > x86_64-linux: 1000 (100.0%) > build rate: 9.20 builds per hour > x86_64-linux: 9.20 builds per hour > --8<---------------cut here---------------end--------------->8--- > > Hum? Almost 1/3 of substitutes are not available and in the same time > not queued. Is it expected? Does it mean that 1/3 of the builds are > failing? Probably not, most likely canceled or a dependency failed to build. I looked at a recent revision using the Guix Data Service, and it's unclear [1]. Lots of builds are unknown, and I'm not sure why that would be. 1: http://data.guix.gnu.org/revision/d291b454bd402c88eed1464a1dfa058a2f6638= 74/builds --=-=-= Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQKTBAEBCgB9FiEEPonu50WOcg2XVOCyXiijOwuE9XcFAl7mDnVfFIAAAAAALgAo aXNzdWVyLWZwckBub3RhdGlvbnMub3BlbnBncC5maWZ0aGhvcnNlbWFuLm5ldDNF ODlFRUU3NDU4RTcyMEQ5NzU0RTBCMjVFMjhBMzNCMEI4NEY1NzcACgkQXiijOwuE 9Xcibw/9GuWBbiYFp3LZOIXGnGNFZKtN9OldYBB0VnkKJRDDQP/z2WhyTdNxqAVj 90LPp0FzfS8A7aMkq9KPheXsN2XLMhDn3lKSo2qaJlp7aC586jmrG4VquXO+Rsvr 2IFZTPndDG+iD0+xqtDgKrYNFRnSYBP8Gqy9zdjBdjtZLjwe30H7FRp20r0BfMz4 mNQoTpqamit1PdXZMh407i2dS5+nho1qumU6b31HRzw5KNRlXCdL790u3caOnL61 u1fgp4ctp3quvlcl7y2yJuq46COGA9dXqwDIovyJrDCK++0j92c5cH9OVL3Ynp9u kJd+xpEM0VkF9qk61JIHhxcALQSQQ7ZvL+0SOh1CliPiCTWhKJLbEpx9ngQrHadd xahwlnUmn5pXiUKjS2l+GhwBk+uoOohOIqEJmud9fHT/dB5S5UMQGUKKWYIkdfwq F4h2wGwbn36T3zovDt0aRLqX7fP4z3jILN/TF1wEadMgJf/px+eDLenImkY864AU jYUe1RhEhu+R4vulMkcjfu4Reylvd0JG7PkRy4PRaPGoW8J4PdV9iue2cVQC1Xoe NSkrsEHdFoHOVZRMgK7U63zzfUOCFot5HjwWK0/cKSv1dQRxIK2PKeSmBcefffi6 aSTbZcqO7OrjZfrb6WJxI9XfFMk6w3XS/EgieVXsEig0S62Id4o= =6n21 -----END PGP SIGNATURE----- --=-=-=--