SQLite unlock database: Difference between revisions

From GRASS-Wiki
Jump to navigation Jump to search
m (Retouched, re-wording)
No edit summary
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
'''Question'''
'''Question'''


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


'''Answer'''
'''Answer'''


Make sure the database file isn't read-only or that you don't have database already open by other application. E.g.
Make sure the database file isn't granted read-only permissions and/or that the database isn't already accessed by another application. E.g.:


  $ ps aux | grep sqlite
  $ ps aux | grep sqlite
Line 16: Line 16:
[[Category:FAQ]]
[[Category:FAQ]]
[[Category:SQLite]]
[[Category:SQLite]]
[[Category:database]]

Latest revision as of 09:35, 23 April 2015

Question

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

Answer

Make sure the database file isn't granted read-only permissions and/or that the database isn't already accessed by another 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