SQLite unlock database

From GRASS-Wiki
Revision as of 10:32, 9 February 2013 by ⚠️NikosA (talk | contribs) (Retouched, re-wording)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Question

GRASS module crashed and left sqlite database locked. How can I unlock sqlite database?

Answer

Make sure the database file isn't read-only or that you don't have database already open by other application. E.g.

$ ps aux | grep sqlite
martin   21118  0.0  0.3  21456  3176 pts/1    S    Dec04   0:00 /usr/local/src/grass6_devel/dist.i686-pc-linux-gnu/driver/db/sqlite

To kill the process:

$ kill -9 21118