Difference between revisions of "SQLite unlock database"

From GRASS-Wiki
Jump to: navigation, search
(unlock database)
 
m (Retouched, re-wording)
Line 1: Line 1:
'''Q:''' GRASS module crashed and left sqlite database locked. How can I unlock sqlite database?
+
'''Question'''
  
'''A:''' Make sure the database file isn't read-only or that you don't have database already open by other application. E.g.
+
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
 
  $ ps aux | grep sqlite
Line 11: Line 15:
  
 
[[Category:FAQ]]
 
[[Category:FAQ]]
 +
[[Category:SQLite]]

Revision as of 03:32, 9 February 2013

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