On 1/14/15, Roman Fleysher <[email protected]> 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: [email protected] [[email protected]] on > behalf of Richard Hipp [[email protected]] > 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 <[email protected]> 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: [email protected] [[email protected]] >> on >> behalf of Richard Hipp [[email protected]] >> 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 <[email protected]> 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 >>> [email protected] >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >> >> >> -- >> D. Richard Hipp >> [email protected] >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
