Database Error (SQLite) Database is locked

64 views
Skip to first unread message

KEVIN HUNGAI

unread,
Mar 28, 2014, 9:22:33 AM3/28/14
to django...@googlegroups.com
Hi all  am using django-registration app in one of my projects and sqlite3 for the database. I keep getting  Database Error (SQLite) Database is locked   everytime i try access the login page. Can someone please assist me on where the issue might be

Thank you
Screenshot from 2014-03-28 16:18:37.png

willy Hakizimana

unread,
Mar 28, 2014, 12:28:34 PM3/28/14
to django...@googlegroups.com
I know this might be stupid question. Did you syncdb after you installed it?

Kelvin Wong

unread,
Mar 28, 2014, 5:05:20 PM3/28/14
to django...@googlegroups.com
You can try finding the lock (assuming you are on unix):

$ which fuser
/usr/bin/fuser

$ fuser db.sqlite3 
db.sqlite3: 84349

$ ps aux | grep 84349
kelvin   84349   0.0  0.1   491220   4776   ??  S    Fri03PM   3:24.57 /Applications/SQLite Database Browser.app

This shows candidates that might have locks on the db. You can try closing them or killing them (ie. kill 84349)

fuser - list process IDs of all processes that have one or more files open

K
Reply all
Reply to author
Forward
0 new messages