| 1 May 2026 |
 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 |
| BMG | Just double checking thanks | 19:28:49 |
| hexa | make sure to create a copy if you want to repeatedly try stuff | 19:29:00 |
| hexa | Simon Hauser also wanted access iirc | 19:29:07 |
| BMG | John Ericson: these are substitutions (type = 1) but they all have drv paths | 19:29:35 |
| BMG | lemme find the ones without | 19:29:39 |
| John Ericson | BMG: OK so the rule is drvPath is non null if and only if type =1 ? | 19:29:40 |
| John Ericson | oh ok | 19:29:45 |
| John Ericson | nevermind | 19:29:50 |
| John Ericson | you're already on it :) | 19:29:59 |
| BMG |
hydra=# select * from buildsteps where type = 1 and (drvPath is null or drvPath = '') order by build desc limit 50;
build | stepnr | type | drvpath | busy | status | errormsg | starttime | stoptime | machine | system | propagatedfrom | overhead | timesbuilt | isnondeterministic
----------+--------+------+---------+------+--------+----------+------------+------------+---------+--------+----------------+----------+------------+--------------------
23055221 | 1 | 1 | | 0 | 0 | | 1434148535 | 1434148558 | | | | | |
19983214 | 1 | 1 | | 0 | 0 | | 1424970676 | 1424970677 | | | | | |
19983213 | 1 | 1 | | 0 | 0 | | 1424968666 | 1424968669 | | | | | |
19282992 | 1 | 1 | | 0 | 0 | | 1422655368 | 1422655434 | | | | | |
19282987 | 1 | 1 | | 0 | 0 | | 1422655688 | 1422655691 | | | | | |
19282982 | 1 | 1 | | 0 | 0 | | 1422655654 | 1422655657 | | | | | |
19282975 | 1 | 1 | | 0 | 0 | | 1422655312 | 1422655340 | | | | | |
19282969 | 1 | 1 | | 0 | 0 | | 1422655331 | 1422655340 | | | | | |
19282960 | 1 | 1 | | 0 | 0 | | 1422655287 | 1422655336 | | | | | |
19282889 | 1 | 1 | | 0 | 0 | | 1422653936 | 1422653964 | | | | | |
19282885 | 1 | 1 | | 0 | 0 | | 1422653875 | 1422653885 | | | | | |
19282876 | 1 | 1 | | 0 | 0 | | 1422653864 | 1422653876 | | | | | |
19282861 | 1 | 1 | | 0 | 0 | | 1422653869 | 1422653889 | | | | | |
19282834 | 1 | 1 | | 0 | 0 | | 1422653890 | 1422653929 | | | | | |
19282817 | 1 | 1 | | 0 | 0 | | 1422653869 | 1422653885 | | | | | |
19282816 | 1 | 1 | | 0 | 0 | | 1422653838 | 1422653890 | | | | | |
19282814 | 1 | 1 | | 0 | 0 | | 1422653858 | 1422653870 | | | | | |
19282800 | 1 | 1 | | 0 | 0 | | 1422653840 | 1422653875 | | | | | |
19282799 | 1 | 1 | | 0 | 0 | | 1422653869 | 1422653876 | | | | | |
19282798 | 1 | 1 | | 0 | 0 | | 1422653861 | 1422653891 | | | | | |
19282794 | 1 | 1 | | 0 | 0 | | 1422653870 | 1422653878 | | | | | |
19282786 | 1 | 1 | | 0 | 0 | | 1422653853 | 1422653862 | | | | | |
19282779 | 1 | 1 | | 0 | 0 | | 1422653869 | 1422653878 | | | | | |
19282773 | 1 | 1 | | 0 | 0 | | 1422653850 | 1422653870 | | | | | |
19282770 | 1 | 1 | | 0 | 0 | | 1422653832 | 1422653849 | | | | | |
18847585 | 1 | 1 | | 0 | 0 | | 1421450352 | 1421450373 | | | | | |
18846807 | 1 | 1 | | 0 | 0 | | 1421450492 | 1421450493 | | | | | |
18846551 | 1 | 1 | | 0 | 0 | | 1421444177 | 1421444179 | | | | | |
18845974 | 43 | 1 | | 0 | 0 | | 1421437974 | 1421437981 | | | | | |
18845974 | 35 | 1 | | 0 | 0 | | 1421437960 | 1421437961 | | | | | |
18845974 | 15 | 1 | | 0 | 0 | | 1421437933 | 1421437934 | | | | | |
18845974 | 40 | 1 | | 0 | 0 | | 1421437970 | 1421437971 | | | | | |
18845974 | 21 | 1 | | 0 | 0 | | 1421437940 | 1421437940 | | | | | |
18845974 | 7 | 1 | | 0 | 0 | | 1421437923 | 1421437924 | | | | | |
18845974 | 8 | 1 | | 0 | 0 | | 1421437924 | 1421437925 | | | | | |
18845974 | 36 | 1 | | 0 | 0 | | 1421437961 | 1421437965 | | | | | |
18845974 | 30 | 1 | | 0 | 0 | | 1421437952 | 1421437953 | | | | | |
18845974 | 44 | 1 | | 0 | 0 | | 1421437981 | 1421437982 | | | | | |
18845974 | 18 | 1 | | 0 | 0 | | 1421437936 | 1421437938 | | | | | |
18845974 | 39 | 1 | | 0 | 0 | | 1421437969 | 1421437970 | | | | | |
18845974 | 27 | 1 | | 0 | 0 | | 1421437947 | 1421437950 | | | | | |
18845974 | 10 | 1 | | 0 | 0 | | 1421437926 | 1421437927 | | | | | |
18845974 | 13 | 1 | | 0 | 0 | | 1421437930 | 1421437932 | | | | | |
18845974 | 25 | 1 | | 0 | 0 | | 1421437945 | 1421437946 | | | | | |
18845974 | 32 | 1 | | 0 | 0 | | 1421437954 | 1421437955 | | | | | |
18845974 | 14 | 1 | | 0 | 0 | | 1421437932 | 1421437933 | | | | | |
18845974 | 34 | 1 | | 0 | 0 | | 1421437958 | 1421437960 | | | | | |
18845974 | 19 | 1 | | 0 | 0 | | 1421437938 | 1421437939 | | | | | |
18845974 | 38 | 1 | | 0 | 0 | | 1421437967 | 1421437969 | | | | | |
18845974 | 23 | 1 | | 0 | 0 | | 1421437942 | 1421437943 | | | | | |
| 19:30:36 |
| BMG | so this implies the drvPath being null or missing last happened for substitutions quite a ways back in the build number sequence | 19:31:01 |
| BMG | lemme see about making that starttime human readable | 19:31:12 |
| BMG | ding ding ding we have a winner:
hydra=# select build, type, drvPath, to_timestamp(starttime) from buildsteps where type = 1 and (drvPath is null or drvPath = '') order by build desc limit 50;
build | type | drvpath | to_timestamp
----------+------+---------+------------------------
23055221 | 1 | | 2015-06-12 22:35:35+00
19983214 | 1 | | 2015-02-26 17:11:16+00
19983213 | 1 | | 2015-02-26 16:37:46+00
19282992 | 1 | | 2015-01-30 22:02:48+00
19282987 | 1 | | 2015-01-30 22:08:08+00
19282982 | 1 | | 2015-01-30 22:07:34+00
19282975 | 1 | | 2015-01-30 22:01:52+00
19282969 | 1 | | 2015-01-30 22:02:11+00
19282960 | 1 | | 2015-01-30 22:01:27+00
19282889 | 1 | | 2015-01-30 21:38:56+00
19282885 | 1 | | 2015-01-30 21:37:55+00
19282876 | 1 | | 2015-01-30 21:37:44+00
19282861 | 1 | | 2015-01-30 21:37:49+00
19282834 | 1 | | 2015-01-30 21:38:10+00
19282817 | 1 | | 2015-01-30 21:37:49+00
19282816 | 1 | | 2015-01-30 21:37:18+00
19282814 | 1 | | 2015-01-30 21:37:38+00
19282800 | 1 | | 2015-01-30 21:37:20+00
19282799 | 1 | | 2015-01-30 21:37:49+00
19282798 | 1 | | 2015-01-30 21:37:41+00
19282794 | 1 | | 2015-01-30 21:37:50+00
19282786 | 1 | | 2015-01-30 21:37:33+00
19282779 | 1 | | 2015-01-30 21:37:49+00
19282773 | 1 | | 2015-01-30 21:37:30+00
19282770 | 1 | | 2015-01-30 21:37:12+00
18847585 | 1 | | 2015-01-16 23:19:12+00
18846807 | 1 | | 2015-01-16 23:21:32+00
18846551 | 1 | | 2015-01-16 21:36:17+00
18845974 | 1 | | 2015-01-16 19:52:54+00
18845974 | 1 | | 2015-01-16 19:52:40+00
18845974 | 1 | | 2015-01-16 19:52:13+00
18845974 | 1 | | 2015-01-16 19:52:50+00
18845974 | 1 | | 2015-01-16 19:52:20+00
18845974 | 1 | | 2015-01-16 19:52:03+00
18845974 | 1 | | 2015-01-16 19:52:04+00
18845974 | 1 | | 2015-01-16 19:52:41+00
18845974 | 1 | | 2015-01-16 19:52:32+00
18845974 | 1 | | 2015-01-16 19:53:01+00
18845974 | 1 | | 2015-01-16 19:52:16+00
18845974 | 1 | | 2015-01-16 19:52:49+00
18845974 | 1 | | 2015-01-16 19:52:27+00
18845974 | 1 | | 2015-01-16 19:52:06+00
18845974 | 1 | | 2015-01-16 19:52:10+00
18845974 | 1 | | 2015-01-16 19:52:25+00
18845974 | 1 | | 2015-01-16 19:52:34+00
18845974 | 1 | | 2015-01-16 19:52:12+00
18845974 | 1 | | 2015-01-16 19:52:38+00
18845974 | 1 | | 2015-01-16 19:52:18+00
18845974 | 1 | | 2015-01-16 19:52:47+00
18845974 | 1 | | 2015-01-16 19:52:22+00
(50 rows)
| 19:32:26 |
| BMG | According to this the last time a type = 1 had a null drvPath was 2015 | 19:32:41 |
| BMG | someone else confirm the query I'm using to be sure | 19:32:55 |
