search

r-lib / revdepcheck

R package reverse dependency checking
https://revdepcheck.r-lib.org
Other
99 stars 31 forks source link

"Error: no such table: todo" #257

Open ms609 opened 4 years ago

ms609 commented 4 years ago

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 commented 4 years ago

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()?