Thank you!! Roman ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Richard Hipp [d...@sqlite.org] Sent: Wednesday, January 14, 2015 1:31 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] database is locked
On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Thank you, Richard. > > You are correct, I made a typo: we have NFS not NTFS and I know they are > buggy. I always use the same node on our compute cluster to minimize > buffering issue. So, are you saying I can not clear the database lock and > must rebuild the database? Probably you can just restart the NFS lock manager. Rebuilding the database seems a bit extreme. > > Roman > ________________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Richard Hipp [d...@sqlite.org] > Sent: Wednesday, January 14, 2015 1:26 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] database is locked > > On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: >> SQLite shell version 3.7.2 >> on Linux 2.6.18 >> NTFS > > On Linux, SQLite uses posix advisory locks. All locks are > automatically released when the process dies (if they haven't been > already). If you have stuck locks, that indicates that you either > have a stuck process or a busted filesystem. I'm not sure how well > NTFS plays with Linux. I thought linux could only read NTFS. > > If you are using a network filesystem, all bets are off. Those are > usually pretty buggy with respect to locking. > >> >> >> >> ________________________________________ >> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] >> on >> behalf of Richard Hipp [d...@sqlite.org] >> Sent: Wednesday, January 14, 2015 12:50 PM >> To: General Discussion of SQLite Database >> Subject: Re: [sqlite] database is locked >> >> On 1/14/15, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: >>> Dear SQLiters, >>> >>> There has been a lot of discussion, I remember, on this subject by >>> others. >>> Please forgive me for asking this for a millionth time. >>> >>> I somehow got my database in a locked state. I updated a table yesterday >>> and >>> I am rather sure that no one on our multi-user system is updating it >>> now. >>> The time stamp on the file is from yesterday, showing correct time. I >>> need >>> to update a table (I use shell) and I get "database is locked". Is there >>> a >>> way to figure out what is happening? Clear the lock? >> >> What operating system and filesystem are you using? And are you >> specifying an alternative VFS for SQLite or using the default? >> >>> >>> Thank you for your help, >>> >>> Roman >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
