Database is locked

Questions about BrainVisa usage and installation

Moderators: riviere, denghien

Posts: 61
Joined: Tue Jul 25, 2017 9:37 am

Database is locked

Postby francois » Mon Apr 30, 2018 4:45 pm


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?


User avatar
Site Admin
Posts: 1358
Joined: Tue Jan 06, 2004 12:21 pm
Location: CEA NeuroSpin, Saint Aubin, France

Re: Database is locked

Postby riviere » Mon Apr 30, 2018 5:59 pm

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.

Posts: 39
Joined: Thu Sep 17, 2015 4:09 pm
Location: moving sometimes

Re: Database is locked

Postby pdeman » Thu May 03, 2018 7:59 am

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

Return to “BrainVISA”

Who is online

Users browsing this forum: Bing [Bot] and 6 guests