diff --git a/lix/libstore/local-store.cc b/lix/libstore/local-store.cc
index d7cfe6874..865d4e030 100644
--- a/lix/libstore/local-store.cc
+++ b/lix/libstore/local-store.cc
@@ -73,6 +73,7 @@ struct LocalStore::DBState::Stmts {
     SQLiteStmt QueryDerivationOutputs;
     SQLiteStmt QueryPathFromHashPart;
     SQLiteStmt QueryValidPaths;
+    SQLiteStmt UpdateRegTime;
 };
 
 int getSchema(Path schemaPath)
@@ -296,7 +297,7 @@ void LocalStore::prepareStatements(DBState & state)
     state.stmts->RegisterValidPath = state.db.create(
         "insert into ValidPaths (path, hash, registrationTime, deriver, narSize, ultimate, sigs, ca) values (?, ?, ?, ?, ?, ?, ?, ?);");
     state.stmts->UpdatePathInfo = state.db.create(
-        "update ValidPaths set narSize = ?, hash = ?, ultimate = ?, sigs = ?, ca = ? where path = ?;");
+        "update ValidPaths set narSize = ?, hash = ?, ultimate = ?, sigs = ?, ca = ?, registrationTime = unixepoch() where path = ?;");
     state.stmts->AddReference = state.db.create(
         "insert or replace into Refs (referrer, reference) values (?, ?);");
     state.stmts->QueryPathInfo = state.db.create(
@@ -318,6 +319,7 @@ void LocalStore::prepareStatements(DBState & state)
     state.stmts->QueryPathFromHashPart = state.db.create(
         "select path from ValidPaths where path >= ? limit 1;");
     state.stmts->QueryValidPaths = state.db.create("select path from ValidPaths");
+    state.stmts->UpdateRegTime= state.db.create("update ValidPaths set registrationTime = unixepoch() where path = ?;");
 }
 
 
@@ -715,6 +717,7 @@ try {
 
 std::shared_ptr<const ValidPathInfo> LocalStore::queryPathInfoInternal(DBState & state, const StorePath & path)
 {
+    state.stmts->UpdateRegTime.use()(printStorePath(path)).exec();
     /* Get the path info. */
     auto useQueryPathInfo(state.stmts->QueryPathInfo.use()(printStorePath(path)));
 
@@ -779,6 +782,7 @@ void LocalStore::updatePathInfo(DBState & state, const ValidPathInfo & info)
 
 uint64_t LocalStore::queryValidPathId(DBState & state, const StorePath & path)
 {
+    state.stmts->UpdateRegTime.use()(printStorePath(path)).exec();
     auto use(state.stmts->QueryPathInfo.use()(printStorePath(path)));
     if (!use.next()) // TODO: I guess if SQLITE got corrupted..?
         throw InvalidPath("path '%s' does not exist in the Lix database", printStorePath(path));
@@ -788,6 +792,7 @@ uint64_t LocalStore::queryValidPathId(DBState & state, const StorePath & path)
 
 bool LocalStore::isValidPath_(DBState & state, const StorePath & path)
 {
+    state.stmts->UpdateRegTime.use()(printStorePath(path)).exec();
     return state.stmts->QueryPathInfo.use()(printStorePath(path)).next();
 }
 

How on earth does this not update registrationTime on a package when I build it? Edit: AAaaaaaaa I'm running the Nixpkgs daemon. It's getting too late 🤔

[lillecarl@shitbox] in [☸ kubernetes-admin@shitbox (nix-csi)]~/C/lix [🎋 main][!][🦀 v1.86.0][❄️  impure (lix-shell-env-env)][🗀 loaded/allowed][🐚fish][as🧙]
[03:00:38]❯ sudo -E ./build/lix/nix/nix path-info --store local /nix/store/0fc5496qwndd1m5lhxk58alv28ga0dn4-manifest.json --json | jq '.[0].registrationTime'
warning: $HOME ('/home/lillecarl') is not owned by you, falling back to the one defined in the 'passwd' file ('/root')
1761616839
[lillecarl@shitbox] in [☸ kubernetes-admin@shitbox (nix-csi)]~/C/lix [🎋 main][!][🦀 v1.86.0][❄️  impure (lix-shell-env-env)][🗀 loaded/allowed][🐚fish][as🧙]
[03:00:39]❯ sudo -E ./build/lix/nix/nix path-info --store local /nix/store/0fc5496qwndd1m5lhxk58alv28ga0dn4-manifest.json --json | jq '.[0].registrationTime'
warning: $HOME ('/home/lillecarl') is not owned by you, falling back to the one defined in the 'passwd' file ('/root')
1761616840

That's more like it, thanks!

113/139 lix:installcheck / functional-substitute-truncated-nar                      FAIL            0.60s   exit status 1
>>> MSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 MESON_BUILD_ROOT=/build/source/build MALLOC_PERTURB_=209 MESON_TEST_ITERATION=1 ASAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1 UBSAN_OPTIONS=halt_on_error=1:abort_on_error=1:print_summary=1:print_stacktrace=1 /nix/store/bwl0kc22rdai48lhf9jg4x4x240kmg84-python3-3.13.9-env/bin/python3 /build/source/meson/run-test.py substitute-truncated-nar.sh
 ✀  
stdout:
[FAIL]
stderr:
++(common/vars-and-functions.sh:314) trap onError ERR
+(init.sh:6) test -n /build/nix-test/substitute-truncated-nar
+(init.sh:7) test -d /build/nix-test/substitute-truncated-nar
+(init.sh:8) chmod -R u+w /build/nix-test/substitute-truncated-nar
+(init.sh:10) killDaemon
+(common/vars-and-functions.sh:122) [[ '' == '' ]]
+(common/vars-and-functions.sh:123) return
+(init.sh:11) rm -rf /build/nix-test/substitute-truncated-nar
+(init.sh:13) mkdir /build/nix-test/substitute-truncated-nar
+(init.sh:15) mkdir /build/nix-test/substitute-truncated-nar/store
+(init.sh:16) mkdir /build/nix-test/substitute-truncated-nar/var
+(init.sh:17) mkdir -p /build/nix-test/substitute-truncated-nar/var/log/nix/drvs
+(init.sh:18) mkdir /build/nix-test/substitute-truncated-nar/var/nix
+(init.sh:19) mkdir /build/nix-test/substitute-truncated-nar/etc
+(init.sh:21) cat
++(init.sh:21) whoami
+(init.sh:35) cat
+(init.sh:42) nix-store --init
+(init.sh:45) test -e /build/nix-test/substitute-truncated-nar/var/nix/db/db.sqlite
+++(/build/source/build/tests/functional/common/vars-and-functions.sh:314) trap onError ERR
++(common.sh:8) [[ -n '' ]]
+(substitute-truncated-nar.sh:3) BINARY_CACHE=file:///build/nix-test/substitute-truncated-nar/binary-cache
++(substitute-truncated-nar.sh:14) build
++(substitute-truncated-nar.sh:6) nix-build --no-out-link --expr $'derivation {\n        name = "text";\n        system = builtins.currentSystem;\n        builder = "/bin/sh";\n        args = [ "-c" "echo some text to make the nar less empty > $out" ];\n    }'
this derivation will be built:
  /build/nix-test/substitute-truncated-nar/store/xv50b2m33ys1574a8xlkbbxxhkywjpfi-text.drv
building '/build/nix-test/substitute-truncated-nar/store/xv50b2m33ys1574a8xlkbbxxhkywjpfi-text.drv'...
+(substitute-truncated-nar.sh:14) path=/build/nix-test/substitute-truncated-nar/store/phq31ijvr3g0y2wdnq55cmrawaawlf03-text
+(substitute-truncated-nar.sh:15) nix copy --to file:///build/nix-test/substitute-truncated-nar/binary-cache /build/nix-test/substitute-truncated-nar/store/phq31ijvr3g0y2wdnq55cmrawaawlf03-text
warning: you don't have Internet access; disabling some network-dependent features
copying 1 paths...
copying path '/build/nix-test/substitute-truncated-nar/store/phq31ijvr3g0y2wdnq55cmrawaawlf03-text' to 'file:///build/nix-test/substitute-truncated-nar/binary-cache'...
+(substitute-truncated-nar.sh:16) nix-collect-garbage
+(substitute-truncated-nar.sh:18) nar=0c3y7p42issm0ydjilwvk0drv958p4p4d2d6c7y5ksmzmbf7rfhg.nar.zst
+(substitute-truncated-nar.sh:20) '[' -e /build/nix-test/substitute-truncated-nar/binary-cache/nar/0c3y7p42issm0ydjilwvk0drv958p4p4d2d6c7y5ksmzmbf7rfhg.nar.zst ']'
+(substitute-truncated-nar.sh:20) fail 'long nar missing?'
+(/build/source/build/tests/functional/common/vars-and-functions.sh:193) echo 'long nar missing?'
long nar missing?
+(/build/source/build/tests/functional/common/vars-and-functions.sh:194) exit 1