Database is locked

Questions about BrainVisa usage and installation

Moderators: denghien, riviere

Post Reply
francois
Posts: 63
Joined: Tue Jul 25, 2017 9:37 am

Database is locked

Post by francois »

Hello,

We're trying to update a large BrainVISA database mounted with NFS.
The update didn't work the first time because of issues with access rights between different users of different computers...
We fixed the issue and tried to start again the database update, but now we get the message "database is locked".
Which file should we delete to start again the database update?

Thanks
Francois
User avatar
riviere
Site Admin
Posts: 1361
Joined: Tue Jan 06, 2004 12:21 pm
Location: CEA NeuroSpin, Saint Aubin, France
Contact:

Re: Database is locked

Post by riviere »

Hi,
BrainVisa is using SQlite to manage its databases. SQLite works without a server, and uses a file locking mechanism to avoid concurrent access to the database. However this locking mechanism is provided by the filesystem, and it appears that NFS does not implement it correctly (NFS3 at least). We also have problems with shared databases on NFS. We generally try to have only one user updating / writing it, and the other users only reading it, but it's sometimes difficult to ensure.
When you are in this situation, you have to quit brainvisa, remove the .sqlite file (probably corrupted at this point) in the root directory of the brainvisa database, and run a new database update.
Denis
pdeman
Posts: 39
Joined: Thu Sep 17, 2015 4:09 pm
Location: moving sometimes

Re: Database is locked

Post by pdeman »

is there any plane "quitting" SQlite to something else ? If I remember well it was something in consideration before.
Post Reply