| 1 May 2026 |
 John Ericson | BMG: checking back in on the drv path non null :) | 15:49:48 |
 BMG | I was gonna have a look there but my key has been blatted again. It wasn't applied via nixos/infra and it seems some other changes have been rolled out | 17:18:06 |
| BMG | John Ericson: looking at the db schema, BuildSteps has a type column. It can be a build or a substitution. In the case of a substitution, isn't it valid to not have a drv path? | 17:21:57 |
| John Ericson | BMG: I was worried that might be the case but I do not know | 17:22:30 |
| John Ericson | it depends what is being substituted | 17:22:41 |
| John Ericson | I don't think inputSrcs gets a steps | 17:22:50 |
| BMG | Regardless, it's a simple enough query once I get access again:
SELECT count(*) AS missing_drvpath_steps
FROM BuildSteps
WHERE drvPath IS NULL OR drvPath = '';
| 17:22:50 |
| BMG | Mic92: can you add my key in a permanent sense? | 17:23:25 |
| BMG | cos I'll be poking around this more when I get around to the GC stuff anyway | 17:23:42 |
 Mic92 | In reply to @brian:bmcgee.ie
Mic92: can you add my key in a permanent sense? Do we still got NixOS config for it? | 17:27:56 |
| BMG | 🤷 lemme double check it's not something weird with my key | 17:29:59 |
| BMG | Nope, definitely doesn't like my key any more. It did yesterday | 17:30:36 |
 vcunat | We do. | 17:57:57 |
| vcunat | https://github.com/NixOS/infra/tree/main/build/haumea | 17:58:32 |
| vcunat | I can prepare the code now, etc. | 17:59:57 |
| vcunat | BMG you should be able to login again now. | 18:06:23 |
| vcunat | https://github.com/NixOS/infra/pull/1020 | 18:08:52 |
| BMG | Thanks, I can test it in a little bit | 18:43:05 |
| BMG | success 👍️ | 19:13:16 |
| BMG | John Ericson:
hydra=# select count(*) as missing_drvpaths from buildsteps where drvPath is null or drvPath = '';
missing_drvpaths
------------------
54014
(1 row)
| 19:16:57 |
| John Ericson | one row! | 19:17:30 |
| John Ericson | ahhh! | 19:17:32 |
| John Ericson | what fucked up step do we have here? :) | 19:17:45 |
| BMG | no you're mis reading, I'm odoing a count | 19:17:57 |
| 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 |
