Locked database

[kerschke]

Hi, is there a way to unlock a locked database? I already ran a couple of jobs on a cluster, but for some reason it is locked now.

Error in sqliteSendQuery(con, statement, bind.data) : 
  error in statement: database is locked

Now, I can not submit further jobs and I also can't collect the results any more :-/

[dagola]

You can try this: [http://stackoverflow.com/questions/151026/how-do-i-unlock-a-sqlite-database](How do I unlock a SQLite database).

In particular, second answer helped me from time to time. But sometimes it doesn't help. In those cases I copy the corrupted database and copy it back again:

cd /path/to/your/registry
cp BatchJobs.db BatchJobs.corrupt.db
mv BatchJobs.db BatchJobs.db.old
cp BatchJobs.corrupt.db BatchJobs.db

Usually, one of these this works.