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?
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