Re: [PATCH] sql: Add a couple of indexes.

[Christopher Baines]

zimoun <zimon.toutoune@gmail.com> writes:

> Hi Chris,
>
> On Sat, 13 Jun 2020 at 17:29, Christopher Baines <mail@cbaines.net> 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.

>> → guix weather --substitute-urls=https://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/d291b454bd402c88eed1464a1dfa058a2f663874/builds

signature.asc
Description: PGP signature