[Nix-dev] command_not_found_handle doesn't find programs.sqlite

[Samuel]

Hi,

After some update my command_not_found_handle started failing (I am
curently in nixos-16.03.714.69420c5)

> asdf
DBI connect('dbname=/nix/var/nix/profiles/per-user/root/channels/nixos/programs.sqlite','',...)
failed: unable to open database file at
/run/current-system/sw/bin/command-not-found line 13.
cannot open database
`/nix/var/nix/profiles/per-user/root/channels/nixos/programs.sqlite'
at /run/current-system/sw/bin/command-not-found line 13.

Ideas on how to troubleshoot this?

I searched for the programs.sqlite file and it seems that it stopped
being added a few profiles ago:

> find -L /nix/var/ -name programs.sqlite 2> /dev/null
/nix/var/nix/gcroots/profiles/per-user/root/channels-7-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-13-link/nixos-15.09/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-6-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-15-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-22-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-23-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-4-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-21-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-18-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-25-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-5-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-16-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-10-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-9-link/nixos-15.09/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-9-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-14-link/nixos-15.09/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-8-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-3-link/nixos/programs.sqlite
/nix/var/nix/gcroots/profiles/per-user/root/channels-24-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-7-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-13-link/nixos-15.09/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-6-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-15-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-22-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-23-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-4-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-21-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-18-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-25-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-5-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-16-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-10-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-9-link/nixos-15.09/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-9-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-14-link/nixos-15.09/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-8-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-3-link/nixos/programs.sqlite
/nix/var/nix/profiles/per-user/root/channels-24-link/nixos/programs.sqlite


> ls -ld /nix/var/nix/profiles/per-user/root/channels
lrwxrwxrwx 1 root root 16 May  8 17:56
/nix/var/nix/profiles/per-user/root/channels -> channels-28-link/

-- 
Samuel