Unlock Database
Hi,
I don’t know how, but somehow pimatic has crashed over night. So I killed the process and tried to restart it. At first, this didn’t work, because I had to delete the pid-file. After that, pimatic still seems to have some problems:
06:28:29.210 [pimatic] error: SQLITE_BUSY: database is locked
However, according to fuser no one is accessing the database at the moment. So how do I “unlock” the database?
afaik sqlite does no other locking then the file lock (maybe it is locking the sqlite-wal file)
Most probably pimatic is still running. You can check with:
ps alx | grep pimatic
Normally the kill script should kill pimatic in any case:
sudo node_modules/pimatic/pimatic.js stop
It first tries to terminate the process normally, buf after an timeout send the kill signal.
If nothing helps a reboot should fix the problem finally. I would be interested in why pimatic crashed anything in the logs?