"Error: no such table: todo"

[ms609]

I have just installed the latest version of revdepcheck (95fa560) on R4.0.0, Windows 10.

I see

> revdepcheck::revdep_check()
-- INIT --------------------------------------------------- Computing revdeps --
Error: no such table: todo

I can't see any obvious way to debug this error. This occurs when running in a package's root directory, and when specifying the full path to the package.

[ms609]

I've been able to work around this error by deleting the revdep folder in my package's directory and starting again using usethis::use_revdep(). Fortunately for me, but unfortunately for producing a fix, I'm now unable to replicate the issue.

I suspect that the root cause was an interrupted run of revdep leaving the database in an unsatisfactory state; I note that if a revdep run is interrupted, the revdep/data.sqlite remain open in R, and thus impossible to delete in Windows without restarting R. I wonder whether this could be mitigated through deployment of a cleanup routine via on.exit()?