| 1 May 2026 |
 John Ericson | oh | 19:18:04 |
 BMG | * no you're mis reading, I'm doing a count | 19:18:04 |
| John Ericson | oh yeah | 19:18:07 |
| John Ericson | bummer | 19:18:08 |
| John Ericson | way more than 1 | 19:18:10 |
| John Ericson | are they current? | 19:18:32 |
| BMG | It's 0 for type = 0 which is builds:
hydra=# select count(*) as missing_drvpaths from buildsteps where type = 0 and drvPath is null or drvPath = '';
missing_drvpaths
------------------
0
| 19:18:33 |
| BMG | It's the substitutions where it's empty type = 1:
hydra=# select count(*) as missing_drvpaths from buildsteps where type = 1 and drvPath is null or drvPath = '';
missing_drvpaths
------------------
54014
| 19:18:58 |
| John Ericson | hmm ok | 19:19:20 |
| John Ericson | have a link to the newest one I cna see in the web app? | 19:19:35 |
| BMG | What you mean, the latest build? | 19:23:56 |
| BMG | Just to clarify Mic92 hexa haumea is retired right? This is being used to test changes to hydra, but it's not the main hydra db right? | 19:25:12 |
| John Ericson | BMG: err lastest build step whoops | 19:25:25 |
| BMG | hydra=# select * from buildsteps order by build desc limit 1;
build | stepnr | type | drvpath | busy | status | errormsg | starttime | stoptime | machine | system | propagatedfrom | overhead | timesbuilt | isnondeterministic
-----------+--------+------+-----------------------------------------------------------------------------------+------+--------+----------+-----------+----------+---------------------------------------------+--------------+----------------+----------+------------+--------------------
316215958 | 10 | 0 | /nix/store/9q5w2n67qxa5fg8zi4brpqvm13z0m09l-vm-test-run-containers-imperative.drv | 0 | 1 | | | | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | 316215949 | | |
(1 row)
| 19:25:39 |
| John Ericson | I am just curious what thse substitution steps look like wher they come from | 19:25:43 |
| John Ericson | thanks | 19:25:44 |
| BMG | Here's the last 50:
hydra=# select * from buildsteps order by build desc limit 50;
build | stepnr | type | drvpath | busy | status | errormsg | starttime | stoptime | machine | system | propagatedfrom | overhead | timesbuilt | isnondeterministic
-----------+--------+------+---------------------------------------------------------------------------------------------------+------+--------+----------+------------+------------+----------------------------------------------+---------------+----------------+----------+------------+--------------------
316215958 | 10 | 0 | /nix/store/9q5w2n67qxa5fg8zi4brpqvm13z0m09l-vm-test-run-containers-imperative.drv | 0 | 1 | | | | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | 316215949 | | |
316215958 | 9 | 0 | /nix/store/ss96kp8y7nisgmjvqcbj5as8qd6x7mdp-nixos-test-driver-installer-separateBoot.drv | 0 | 0 | | 1765660634 | 1765660656 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 3146 | 1 |
316215958 | 8 | 0 | /nix/store/ypl4r1hkrrzzdm0pwf5rf39qi47f3asp-nixos-test-driver-containers-imperative.drv | 0 | 0 | | 1765660579 | 1765660594 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1519 | 1 |
316215958 | 7 | 0 | /nix/store/l8qqv4k2zm60hmy4wjksr8llirfs33r5-nixos-vm.drv | 0 | 0 | | 1765660570 | 1765660571 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1940 | 1 |
316215958 | 6 | 0 | /nix/store/dq7j11169n4zxqwpj4xz756g4jfhq4dr-run-nixos-vm.drv | 0 | 0 | | 1765660560 | 1765660561 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1454 | 1 |
316215958 | 5 | 0 | /nix/store/yhvw4kmgvy09kyhk887d3zk9s03hwb8y-closure-info.drv | 0 | 0 | | 1765660550 | 1765660551 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 2869 | 1 |
316215958 | 4 | 0 | /nix/store/gxlzgsybz85vvp1x6j1ivlplhsq2pv8l-nixos-system-machine-test.drv | 0 | 0 | | 1765660542 | 1765660542 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1381 | 1 |
316215958 | 3 | 0 | /nix/store/6d413ahl3r5hf84bz2lgl8ds16yz0igc-etc.drv | 0 | 0 | | 1765660514 | 1765660515 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 4103 | 1 |
316215958 | 2 | 0 | /nix/store/a8aygv6gc7q5sddqqkhak7qzixc4xza4-stage-2-init.sh.drv | 0 | 0 | | 1765660510 | 1765660510 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1337 | 1 |
316215958 | 1 | 0 | /nix/store/sgayjfpk7k3ykpl68x153rq5iiw4pxaf-local-cmds.drv | 0 | 0 | | 1765660503 | 1765660504 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 2491 | 1 |
316215957 | 1 | 0 | /nix/store/c6vn222qbmspaxk52pg5cmix6w9w8nxc-nixpkgs-tarball-25.11pre903458.3ae3649b51d4.drv | 0 | 0 | | 1765659572 | 1765659759 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 460079 | 1 |
316215956 | 1 | 0 | /nix/store/zfsgyasqdj1aicg7cl4sshfawqca8gim-nixpkgs-release-checks.drv | 0 | 0 | | 1765659675 | 1765660616 | ssh://build@sleepy-brown.builder.nixos.org | x86_64-linux | | 16035 | 1 |
316215955 | 6 | 0 | /nix/store/a431apyn3bh1p9lx010iprqlpbmhy2l5-vm-test-run-installer-simpleUefiSystemdBoot.drv | 0 | 0 | | 1765660659 | 1765662175 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 2464 | 1 |
316215955 | 5 | 0 | /nix/store/4afxglkn9m1is0x2dh09v5dynmdvfmnf-nixos-test-driver-installer-simpleUefiSystemdBoot.drv | 0 | 0 | | 1765660642 | 1765660651 | ssh://build@sleepy-brown.builder.nixos.org | x86_64-linux | | 2045 | 1 |
316215955 | 4 | 0 | /nix/store/21j89s5vrbsrr7zkzi2hkiqg6zrb5kd9-nixos-vm.drv | 0 | 0 | | 1765660629 | 1765660629 | ssh://build@sleepy-brown.builder.nixos.org | x86_64-linux | | 3616 | 1 |
316215955 | 3 | 0 | /nix/store/xazcv19l3y3zz0j3gpims06b4ppzxjdn-run-nixos-vm.drv | 0 | 0 | | 1765660615 | 1765660616 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1558 | 1 |
316215955 | 2 | 0 | /nix/store/aj1kxhy1mp92ayzrn3x4vw6jp9jjf62r-closure-info.drv | 0 | 0 | | 1765660576 | 1765660576 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1896 | 1 |
316215955 | 1 | 0 | /nix/store/a6ac0f7znyha3hxkm3qqdlqj43wn6kv1-nixos-system-installer-test.drv | 0 | 0 | | 1765660558 | 1765660559 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1699 | 1 |
316215954 | 26 | 0 | /nix/store/b95ag40qng1gky81p444ayxs7wswvdl2-vm-test-run-installer-simpleUefiSystemdBoot.drv | 0 | 0 | | 1765660566 | 1765661994 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1832 | 1 |
316215954 | 25 | 0 | /nix/store/4j99y87v5azw8a26l2hwcrsfpfr52br0-nixos-test-driver-installer-simpleUefiSystemdBoot.drv | 0 | 0 | | 1765660548 | 1765660562 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 2615 | 1 |
316215954 | 24 | 0 | /nix/store/lv2xp4vrvk2azr6dnznd5vd5902q1zjv-nixos-vm.drv | 0 | 0 | | 1765660538 | 1765660538 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1733 | 1 |
316215954 | 23 | 0 | /nix/store/hdisqbr727wpl6ygmfgy3mv6cd0q4350-run-nixos-vm.drv | 0 | 0 | | 1765660529 | 1765660529 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1801 | 1 |
316215954 | 22 | 0 | /nix/store/hx96f2ys5ww4sd1drkvvy18wnb2bhx3w-closure-info.drv | 0 | 0 | | 1765660504 | 1765660504 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 4047 | 1 |
316215954 | 21 | 0 | /nix/store/73ivg9f8hs17ianscvbxvjflr105c66m-nixos-system-installer-test.drv | 0 | 0 | | 1765660492 | 1765660493 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 4474 | 1 |
316215954 | 20 | 0 | /nix/store/nxjq3ynpa8cxis3glr6xxa12y3vj9sap-stage-2-init.sh.drv | 0 | 0 | | 1765660471 | 1765660472 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1466 | 1 |
316215954 | 19 | 0 | /nix/store/b64gjh1f3hmv0cj06bmf22ahbg1w580i-local-cmds.drv | 0 | 0 | | 1765660467 | 1765660467 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1962 | 1 |
316215954 | 18 | 0 | /nix/store/92h8xr8gacmn6zn5vjsihlk7c2sla028-etc.drv | 0 | 0 | | 1765660476 | 1765660477 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 11681 | 1 |
316215954 | 17 | 0 | /nix/store/gsljn62rcpy70xvh0kx9jz1asgyvxid0-etc-nix-registry.json.drv | 0 | 0 | | 1765660458 | 1765660459 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1417 | 1 |
316215954 | 16 | 0 | /nix/store/ql1cjh4irga320arg78hzzjbm4gyb6ng-user-units.drv | 0 | 0 | | 1765659608 | 1765659608 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 4655 | 1 |
316215954 | 15 | 0 | /nix/store/ydhz5hm9844c5rkqr8zlmd266pj9b867-system-units.drv | 0 | 0 | | 1765659607 | 1765659609 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 4859 | 1 |
316215954 | 14 | 0 | /nix/store/1lgx4lbqs3lww5qisalcga653yllajzb-unit-dbus.service.drv | 0 | 0 | | 1765659599 | 1765659600 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 2278 | 1 |
316215954 | 13 | 0 | /nix/store/zay7z0l9jhicmkkj1vjlm1dk1rqi8iip-unit-dbus.service.drv | 0 | 0 | | 1765659598 | 1765659600 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 2839 | 1 |
316215954 | 12 | 0 | /nix/store/lgjh1j74bbs409i87mbl8c90wa37n5lw-unit-polkit.service.drv | 0 | 0 | | 1765659593 | 1765659594 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1705 | 1 |
316215954 | 11 | 0 | /nix/store/rhdc2k2a8ql204mgbjq0xfyx8mrjzbmg-X-Restart-Triggers-dbus.drv | 0 | 0 | | 1765659559 | 1765659560 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 2601 | 1 |
316215954 | 10 | 0 | /nix/store/p3dd918iq2d4bp7gxgq93989f6h4s1i4-X-Restart-Triggers-polkit.drv | 0 | 0 | | 1765659541 | 1765659541 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 2190 | 1 |
316215954 | 9 | 0 | /nix/store/xgw7vjbpr54wq525pdi1nmkcdjqs60dg-dbus-1.drv | 0 | 0 | | 1765659538 | 1765659539 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 3897 | 1 |
316215954 | 8 | 0 | /nix/store/5fpjs8nwkpdpjzrxl65za6p8dsza11qb-system-path.drv | 0 | 0 | | 1765659525 | 1765659526 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 6847 | 1 |
316215954 | 7 | 0 | /nix/store/f3qxxgv9i27adj07pvbwc9wc5a647cil-nixos-help.drv | 0 | 0 | | 1765659517 | 1765659517 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 1402 | 1 |
316215954 | 6 | 0 | /nix/store/6wm2d7ic2056p0qsi527g1yzwd6wzq7s-nixos-help.drv | 0 | 0 | | 1765659506 | 1765659506 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 2035 | 1 |
316215954 | 5 | 0 | /nix/store/vqkckrsn3g4fspfahyws2pjynyxfj6r2-nixos-configuration-reference-manpage.drv | 0 | 0 | | 1765659493 | 1765659500 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 3638 | 1 |
316215954 | 4 | 0 | /nix/store/7fvbiwkapn1mxp937iij5v8bw6pg8cb6-nixos-manual-html.drv | 0 | 0 | | 1765659482 | 1765659489 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 7959 | 1 |
316215954 | 3 | 0 | /nix/store/ypmhnkm546z9avcfbnyks08gr76d7bc2-options.json.drv | 0 | 0 | | 1765659472 | 1765659475 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 5090 | 1 |
316215954 | 2 | 0 | /nix/store/mi56miq0irvgpkaknqmjpzmn5a5gcrsa-lazy-options.json.drv | 0 | 0 | | 1765659445 | 1765659448 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 4549 | 1 |
316215954 | 1 | 0 | /nix/store/qp3dfil6i24vwsbyd6lpcc161y2hi3hc-nixos-25.11test.drv | 0 | 0 | | 1765659538 | 1765659551 | ssh://build@goofy-hopcroft.builder.nixos.org | aarch64-linux | | 902437 | 1 |
316215953 | 26 | 0 | /nix/store/98cd86s6cm0zk38nlkjfbnaa3fz4czc7-vm-test-run-installer-lvm.drv | 0 | 0 | | 1765660675 | 1765661121 | ssh://build@sleepy-brown.builder.nixos.org | x86_64-linux | | 2335 | 1 |
316215953 | 25 | 0 | /nix/store/nwpzl8pzzhqcdjl55lh3qih7qk5yjsig-nixos-test-driver-installer-lvm.drv | 0 | 0 | | 1765660641 | 1765660661 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1723 | 1 |
316215953 | 24 | 0 | /nix/store/5a2q4zdsc7cnr4dx0fg39nibq056qi6q-nixos-vm.drv | 0 | 0 | | 1765660625 | 1765660625 | ssh://build@sleepy-brown.builder.nixos.org | x86_64-linux | | 13554 | 1 |
316215953 | 23 | 0 | /nix/store/y6pvskhy6w8nrarnpf3bsvkl1yv144k3-run-nixos-vm.drv | 0 | 0 | | 1765660596 | 1765660596 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 1324 | 1 |
316215953 | 22 | 0 | /nix/store/p2j1cacvqi5pap7j9x06x8bnjspmwhxs-closure-info.drv | 0 | 0 | | 1765660568 | 1765660568 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 3366 | 1 |
316215953 | 21 | 0 | /nix/store/023jl08lc0py4r9j29cy9wyn4yyzw42d-nixos-system-installer-test.drv | 0 | 0 | | 1765660556 | 1765660556 | ssh://build@elated-minsky.builder.nixos.org | x86_64-linux | | 5565 | 1 |
(50 rows)
| 19:26:12 |
| John Ericson | sorry latest one with no drv path | 19:26:35 |
| John Ericson | latest substitiont one | 19:26:39 |
| John Ericson | * latest substitution one | 19:26:45 |
| BMG | running the query | 19:27:01 |
| BMG | it's taking some time... | 19:27:05 |
| John Ericson | hmm OK, maybe it has to scan for a while before it finds one | 19:27:31 |
| BMG | I removed the ordering and it returned faster | 19:27:33 |
| BMG | build | stepnr | type | drvpath | busy | status | errormsg | starttime | stoptime | machine | system | propagatedfrom | overhead | timesbuilt | isnondeterministic
-------+--------+------+---------+------+--------+----------+------------+------------+---------+--------+----------------+----------+------------+--------------------
6270 | 1 | 1 | | 0 | 0 | | 1237922035 | 1237922038 | | | | | |
850 | 8 | 1 | | 0 | 0 | | 1231782021 | 1231782025 | | | | | |
6177 | 17 | 1 | | 0 | 0 | | 1237923970 | 1237923974 | | | | | |
6120 | 5 | 1 | | 0 | 0 | | 1237921621 | 1237921788 | | | | | |
6010 | 1 | 1 | | 0 | 0 | | 1237921624 | 1237921705 | | | | | |
6202 | 1 | 1 | | 0 | 0 | | 1237923825 | 1237923845 | | | | | |
735 | 1 | 1 | | 0 | 0 | | 1231247385 | 1231247489 | | | | | |
6176 | 25 | 1 | | 0 | 0 | | 1237923840 | 1237923845 | | | | | |
6177 | 18 | 1 | | 0 | 0 | | 1237923974 | 1237923978 | | | | | |
6169 | 1 | 1 | | 0 | 0 | | 1237923845 | 1237923848 | | | | | |
| 19:27:41 |
| BMG | Let me let the ordered one run, those build numbers look very low | 19:27:56 |
| John Ericson | yeah | 19:28:21 |
| BMG | hydra=# select * from buildsteps where type = 1 order by build desc limit 10;
build | stepnr | type | drvpath | busy | status | errormsg | starttime | stoptime | machine | system | propagatedfrom | overhead | timesbuilt | isnondeterministic
-----------+--------+------+---------------------------------------------------------------------+------+--------+----------+------------+------------+---------+--------+----------------+----------+------------+--------------------
315357341 | 7 | 1 | /nix/store/zxcynkk0w31mpwx0h1k5jyfli8f06wl5-boehm-gc-8.2.8.drv | 0 | 0 | | 1764630249 | 1764630249 | | | | | |
315357341 | 6 | 1 | /nix/store/zxcynkk0w31mpwx0h1k5jyfli8f06wl5-boehm-gc-8.2.8.drv | 0 | 0 | | 1764630248 | 1764630249 | | | | | |
315357341 | 5 | 1 | /nix/store/zxcynkk0w31mpwx0h1k5jyfli8f06wl5-boehm-gc-8.2.8.drv | 0 | 0 | | 1764630243 | 1764630248 | | | | | |
315357341 | 4 | 1 | /nix/store/zxcynkk0w31mpwx0h1k5jyfli8f06wl5-boehm-gc-8.2.8.drv | 0 | 0 | | 1764630240 | 1764630243 | | | | | |
315357341 | 3 | 1 | /nix/store/9l75bg22ifgm4r4b4hkb3i151cnq35ws-boost-1.87.0.drv | 0 | 0 | | 1764630239 | 1764630239 | | | | | |
315357341 | 2 | 1 | /nix/store/9l75bg22ifgm4r4b4hkb3i151cnq35ws-boost-1.87.0.drv | 0 | 0 | | 1764630181 | 1764630239 | | | | | |
315357341 | 1 | 1 | /nix/store/9i5h0f2qmj7qa6h361a8h3wymy8x81m3-toml11-4.4.0.drv | 0 | 0 | | 1764630179 | 1764630181 | | | | | |
315112510 | 1 | 1 | /nix/store/qp84ncdb6if8jgkb463567rnpd8nrnja-etc-pam-environment.drv | 0 | 0 | | 1764320130 | 1764320131 | | | | | |
314026689 | 1 | 1 | /nix/store/ss65icf8vj3v0ij15sjari3y2j5hb4dd-source.drv | 0 | 0 | | 1763432547 | 1763432558 | | | | | |
312839011 | 1 | 1 | /nix/store/ljfjp456aqv7idcshjrhb2qnc78lr3ix-source.drv | 0 | 0 | | 1762821404 | 1762821428 | | | | | |
| 19:28:24 |
 hexa | yes, retired. | 19:28:35 |
| BMG | Must've just needed an index warming up or something | 19:28:37 |
