ci: Nix cache miss in "Run doctests" step of "Test (Nix)" CI job

[develop7]

Relevant CI log snippet:

Run nix-shell --run postgrest-test-doctests

Run nix-shell --run postgrest-test-doctests
  nix-shell --run postgrest-test-doctests
  shell: /usr/bin/script -qec "bash --noprofile --norc -eo pipefail {0}"
  env:
    NIX_PROFILES: /nix/var/nix/profiles/default /home/runner/.nix-profile
    NIX_USER_PROFILE_DIR: /nix/var/nix/profiles/per-user/runner
    NIX_SSL_CERT_FILE: /etc/ssl/certs/ca-certificates.crt
error: file 'nixpkgs' was not found in the Nix search path (add it using $NIX_PATH or -I)

       at «string»:1:9:

            1| (import <nixpkgs> {}).bashInteractive
             |         ^
will use bash from your environment
these 99 derivations will be built:
  /nix/store/08g6sswjmnyhg0gqb6ndzhb4xl0nms5j-parallel-curl-completion.drv
  /nix/store/0ra8qynlc45ljkjn7cys4fmdwrplss5k-postgrest-clean.drv
  /nix/store/a6if2axl6aq85cxyk80374a17bqsd4mh-hsie.drv
  /nix/store/0skhqj7d46r3zfga3x2wp5601qzfh4hy-hsie.drv
  /nix/store/14psnvvp8i720qrnph1hj1b3dk0y5cly-postgrest-coverage-draft-overlay.drv
  /nix/store/1h1z237gmixln495crqpi8x63d2ga069-postgrest-with-postgresql-14.drv
  /nix/store/1ihijli25vpa02f2rj2ybs35qz51xijq-postgrest-with-postgresql-10.drv
  /nix/store/vw99dz86pxhb89x7p8pj7wy8yl9kpyrp-postgrest-check-static.drv
  /nix/store/1n70mz2ykzxid3c6f79w4ly2nb5fv0dz-postgrest-check-static-completion.drv
  /nix/store/26nisyzdx3w5gw6j52rbhjbdr4l4ccnc-postgrest-dump-schema.drv
  /nix/store/2sb6bcvsjnzxyfzn6a53ml5jb2m3a7rw-postgrest-loadtest.drv
  /nix/store/rzs08np5plkx0yxr8nbz9cj92hzivj9r-postgrest-with-git.drv
  /nix/store/2sc4gl1gaczwjjx7f9k1y7ans8dwcgh4-postgrest-with-git-completion.drv
  /nix/store/3r3dmywjm4hf49bdzcsha3xzqpm7gi4z-postgrest-with-postgresql-15.drv
  /nix/store/429kh6p38sikynbpmrn7h92byf8nq7vb-postgrest-with-postgresql-9.6.drv
  /nix/store/nccr8y3axv780kvwbafxyfc5p7v78714-postgrest-hsie-minimal-imports.drv
  /nix/store/44w1aycyqgm4rw31zq67ybvf3q9svck4-postgrest-hsie-minimal-imports-completion.drv
  /nix/store/47dll0v3icfvrcd32gya7phpfsx5hqgr-postgrest-run.drv
  /nix/store/w0pavm7gaivciadffz1k21gzykhpyk13-python3.11-psycopg2cffi-2.8.1.drv
  /nix/store/w9fz0q2f3mi8v65s38mzbfivcx8bax8n-python3.11-psycopg2-2.9.7.drv
  /nix/store/v5nm9sz1x8iclgr0wjdnlsw73ywz92af-python3.11-sqlalchemy-utils-0.41.1.drv
  /nix/store/b2kbgycjkl9scray45k2cbdjc27p4jdx-python3.11-factory-boy-3.3.0.drv
  /nix/store/f1985pz5b523723k2dmcfni8qvb3hsy8-python3.11-pytest-randomly-3.13.0.drv
  /nix/store/yvxqd9z6y0xa851qvmm5bb46g47i8nv0-python3.11-httplib2-0.21.0.drv
  /nix/store/wpg516pd0n7ac2w8svnllr12zi2q1bpq-python3.11-lazr.restfulclient-0.14.5.drv
  /nix/store/4fyw39r0igm758msdjxpd31asc2qmy4l-python3.11-launchpadlib-1.11.0.drv
  /nix/store/5hzs00macw51dbia8kigay4n44s5yp39-postgrest-with-postgresql-16.drv
  /nix/store/5ja94b5qfrclbkiyzlfnr5fv1p9fyil6-postgrest-hsie-graph-symbols.drv
  /nix/store/ww16b44a1imdriz57fnznz37rdn9gcfa-postgrest-test-doctests.drv
  /nix/store/5zcgpr0kj67z8p1llvnzyggj17xgp13p-postgrest-test-doctests-completion.drv
  /nix/store/60jsi4by3i659x5apxxjjya66gj3wby4-postgrest-with-slow-pg.drv
  /nix/store/6h39hfny1afiqvrqw8ijc7pgjd8dmhvz-postgrest-coverage-draft-overlay-completion.drv
  /nix/store/bd047yjbzsmnlm5j22j4rxg93vpd08nv-postgrest-coverage.drv
  /nix/store/6j8cd9526kp7jf0qcqchm5dn0xqb96lf-postgrest-coverage-completion.drv
  /nix/store/6p08f5jwyab573dqd98sk4k8fhjpnr4w-postgrest-loadtest-against.drv
  /nix/store/7agm59yg8al7xq5d3qn1r9lpq33k89xx-postgrest-with-pgrst.drv
  /nix/store/7qg7x511xi68swid43zv26x1y0l9rzpk-postgrest-release-dockerhub-description.drv
  /nix/store/7qrmzrldvnwsx4wlkp9fkb39sd81cnyf-postgrest-with-postgresql-11.drv
  /nix/store/8p8p7whvszynxxsy243l3zlmnrpr60hb-postgrest-with-postgresql-11-completion.drv
  /nix/store/8r4qp98bynv88rk4n774fhhbn1862yfb-postgrest-style.drv
  /nix/store/nnll0ihkn28zw8zzy6zvqz9p5gb8ward-postgrest-with-all.drv
  /nix/store/8yivg7w83x0prl95i95kkjxy2g48hj4l-postgrest-with-all-completion.drv
  /nix/store/971vlanplnb5zrh0ilzrblxrsdg2ignd-postgrest-with-postgresql-13.drv
  /nix/store/9nz3hx4v8ln3rvi4569adlarn0m2jfw4-postgrest-run-completion.drv
  /nix/store/ilqn2xl8r7m17y4xwsj7wzgdmrg98j1y-postgrest-test-spec-idempotence.drv
  /nix/store/aklap0gdq65w5fmlx4dp9a4qrw5pys3d-postgrest-test-spec-idempotence-completion.drv
  /nix/store/b1qc3b728x7aln9ygdr9fr8mvcf4znyp-postgrest-loadtest-against-completion.drv
  /nix/store/bad7qkj9vzh88a8a85l2mspiqily01lh-postgrest-with-postgresql-16-completion.drv
  /nix/store/isg724f84gkjj48jh2mw7bvqw7a84zri-postgrest-release.drv
  /nix/store/bgyf4vg69ir95k9fkfdlqxjzp1qzca4y-postgrest-release-completion.drv
  /nix/store/bj6y8vagqgbzyl3cxg13jgkm9c9ckakx-postgrest-with-postgresql-9.6-completion.drv
  /nix/store/zj3yh00p67ci1mp06swlhwr6glmlqmmy-postgrest-push-cachix.drv
  /nix/store/bra3h4h0i70rg0agdp9k9vv9983496ml-postgrest-push-cachix-completion.drv
  /nix/store/rcfqrbx87wz6mlc2jgaqdrb0hgvclp6y-postgrest-repl.drv
  /nix/store/bzbbxqllj2ja90g2k37n9h8qhqzc4zzn-postgrest-repl-completion.drv
  /nix/store/d2my46b0d7i9y4rszcxnf7akwpcssmnk-postgrest-style-completion.drv
  /nix/store/vmbmnvqyd0sr6imhv6w7ln4rngqcsm1q-python3.11-breezy-3.3.4.drv
  /nix/store/maxsqb0hg31bvk7vvgxjgfi3hr8qghij-nix-prefetch-bzr.drv
  /nix/store/fvry8whr1z8xn3g6z6yqjf3ffwry5cch-nix-prefetch-scripts.drv
  /nix/store/d4h2lm278j8gy2x8x76r3vn7jmv03is6-cabal2nix-2.19.1.drv
  /nix/store/d5f8bijbiaq8spb8dmkzqa7d9r8m7scw-postgrest-git-hooks.drv
  /nix/store/d656kpkmd1nmf14pl214galrzfcn9pqd-postgrest-git-hooks-completion.drv
  /nix/store/vfcfxb32zn0wxlara7baln8rrdlsbxrg-postgrest-loadtest-report.drv
  /nix/store/didhyy09dz1v6cbym6ar22jkachhana7-postgrest-loadtest-report-completion.drv
  /nix/store/h3d0jaw5mwlgqrwrsaz7yy1907hwmhpc-postgrest-check.drv
  /nix/store/drkh46d39jmd6f28nhb72m0bzn93a7gy-postgrest-check-completion.drv
  /nix/store/yqb42c44fhxnxvdbrrsl6kaydkb3z38f-postgrest-test-io.drv
  /nix/store/dv5bin6a4pd8d635ir78cpiqv6lvyvvd-postgrest-test-io-completion.drv
  /nix/store/x7fvg8jrxf2c68j3q22fwwgjbb32rdpp-postgrest-with-postgresql-12.drv
  /nix/store/gv0njrkyi6lyklsdr3j7pshcpdkjkywv-postgrest-with-postgresql-12-completion.drv
  /nix/store/hlv60a397j5hj9f9y14xkfhxw46rddb4-postgrest-watch.drv
  /nix/store/w50klky26h5wcrjxvrdig6vhbw3j6i97-postgrest-with-slow-postgrest.drv
  /nix/store/hys7v7d8r7fn80ibkyznnxsji2a860hj-postgrest-with-slow-postgrest-completion.drv
  /nix/store/ipi5b9nz50wk80kgyfz0vnnykjhi4cwn-postgrest-watch-completion.drv
  /nix/store/iz287ziwb2kfvqifmiacyh16jn57cvcs-postgrest-with-pgrst-completion.drv
  /nix/store/j4xgd9qx466fcf593k64wy65h5jqnfk2-postgrest-with-postgresql-10-completion.drv
  /nix/store/jagda59rjk0pqgp41svfladqlf65jy1w-postgrest-with-postgresql-13-completion.drv
  /nix/store/vw85hy7hg6fqz73f290c6p9kxmygrpdn-postgrest-build.drv
  /nix/store/l9518n8fwgn39figzgh0ngsmz8lj0aan-postgrest-build-completion.drv
  /nix/store/lykx5bgif9y64mn7w7573gsc3m7q2a7k-postgrest-hsie-graph-modules.drv
  /nix/store/nw13j7fsjb6xz83yy0yckv5sayxdszlg-postgrest-lint.drv
  /nix/store/mpjdwxqkdjmpdly8q3v3i5vwnblwq1dq-postgrest-lint-completion.drv
  /nix/store/n4ds14pjla7k0fpcvy8qrk5f6aax4pyk-postgrest-clean-completion.drv
  /nix/store/nhqx3fkwq1lzjvrq4k1i261hay10fpz5-postgrest-hsie-graph-symbols-completion.drv
  /nix/store/y98kvf3ks5mvd9q5zq68zi3drwmkszgr-postgrest-nixpkgs-upgrade.drv
  /nix/store/pr1y11nwrvxfybcnfns8jmg2gsys8wj3-postgrest-nixpkgs-upgrade-completion.drv
  /nix/store/x1z38mq35n8dq0c0wmb0gk9yxinbj5dd-postgrest-style-check.drv
  /nix/store/qagcapvakiyjdizrs17w2bwpb71kb0x4-postgrest-style-check-completion.drv
  /nix/store/qxwr92q5w83j4sg4lq1lb649fah6mrw8-postgrest-with-postgresql-14-completion.drv
  /nix/store/r03pr0xjdya1iwgmw3jhjq19npqk786p-postgrest-with-slow-pg-completion.drv
  /nix/store/wrljrxdrdici9lbxxad08gy89aiyrrdj-postgrest-dump-minimal-imports.drv
  /nix/store/ribhfbnd3crhl6f1r5r3f01h0qylyq4g-postgrest-dump-minimal-imports-completion.drv
  /nix/store/zf1ifjy4z6ig8yam5ja34v173vbjsyn3-postgrest-test-spec.drv
  /nix/store/s6682m6gh7yd6l3i07z77r7irdxwhnf2-postgrest-test-spec-completion.drv
  /nix/store/vpjyfbyj6c2y8nrprbbapz87zqk2xcd0-postgrest-release-dockerhub-description-completion.drv
  /nix/store/w1ip03hflbnqiqjdj87aplirjrkdma5h-postgrest-loadtest-completion.drv
  /nix/store/yyj2rrafj56sqysxfy1mpy4c6bn87jr4-postgrest-with-postgresql-15-completion.drv
  /nix/store/zi5vzca3286ccn1fwylyg6vr02mfnqhz-postgrest-dump-schema-completion.drv
  /nix/store/zr4fwf8yizspya8h7apx6bkr12wsh5ii-postgrest-hsie-graph-modules-completion.drv
these 181 paths will be fetched (318.54 MiB download, 1845.29 MiB unpacked):
  /nix/store/00900qxkhiack10r0r1mgml249plqmkl-python3.11-mock-5.1.0
  /nix/store/04kcg3xgy0vfjjrm8ykvx3vcp6mrgzx9-python3.11-pyproject-hooks-1.0.0
  /nix/store/0h6xvqi2sqggnk9wj2k06hdhxrfnd6ay-python-output-dist-hook
  /nix/store/1a71q3af8kpvxh7lwnm2jxllh73hsiiz-lazr.restfulclient-0.14.5.tar.gz
  /nix/store/1ni18mfnmw0m25ikhmikbmg33r4ywnq5-source
  /nix/store/1ny7il03pvkmhcd3dig8m6m6jvz94jv0-windows_x86_64_msvc-0.48.5
  /nix/store/1pxann8pi6wbpshqnfvd10csxaf6slzm-python3.11-sphinx-better-theme-0.1.5
  /nix/store/25psn6sxk4198hrg0brkvx92k4jdz08r-python-namespaces-hook.sh

https://github.com/PostgREST/postgrest/actions/runs/7578002349/job/20651351522#step:6:16 (saved in run_7578002349_job_20651351522.txt)

[wolfgangwalther]

The corresponding PR touched with with tools set. This is imported in many tests, so will cause a lot of rebuilds.

This should be improved with some of the commits in #3211.