[Nix-dev] error: invalidating paths: foreign key constraint failed

[Marc Weber]

error: invalidating path `/nix/store/p2dhpd311sg6fvw59l4sppawmgiymj4w-pidgin-otr-3.2.0' in database: foreign key constraint failed

  nix-collect-garbage -d

causes lot's of those errors.

  delete from ValidPaths WHERE path = "THE PATH ABOVE";

Seems to fix it for one path, but much more such errors appear then for
different paths.

Looking at the scheme it looks like the second delete line in the trigger could
be added:

  DROP TRIGGER DeleteSelfRefs;
  CREATE TRIGGER DeleteSelfRefs before delete on ValidPaths
    begin
        delete from Refs where referrer = old.id and reference = old.id;
        delete from DerivationOutputs where drv = old.id;
    end;

But this didn't fix it !?

Before starting to add SQL-Logging or such to nix - has anybody seen
this error before as well?

Marc Weber