New database creation problem

Hi all,
I am using LibreOffice on Ubuntu 18.04 and having a weird problem. When I try to create a new database LibreOffice Base complains that the database is being used by another process and throws an exception that it cannot create and hence find the lock file because (I believe) it cannot write the lock file to the folder because of some permissions mixup. Here is the error message i got:

SQL Status: 08001
Error code: -1

The database is already in use by another process: lockFile: org.hsqldb.persist.LockFile@f63f959c[file =/home/magharr/Downloads/odb01-Employees.odb.lck, exists=false, locked=false, valid=false, ] method: openRAF reason: /home/magharr/Downloads/odb01-Employees.odb.lck (Permission denied)

Now here is the part it gets weirder: When I download an .odb file and open it directly from firefox without saving (saving to firefox’s tmp folder, wherever the heck it is) it works error free. No permission issues whatsoever.

Any ideas?

Best Regards.


From what is posted, 18.04 is still Alpha. Don’t see any such problems in 17.10. You may want to report to Ubuntu as it would seem they would still be trying to correct problems in this release.

Please also see this post - The database is already in use by another process: lockFile

Thanks for the suggestions. I reported to Ubuntu as well. By the way LibreOffice 6 does not have this issue.

Just yesterday I’ve got the same problem opening an old database I’ve been using since years.
My Libreoffice is: Versione: Build ID: 1:5.4.5-0ubuntu0.17.10.1 and I’ve opened it without problems a couple of weeks ago.

Solved by upgrading to version 6 via PPA libreoffice

sudo add-apt-repository ppa:libreoffice/ppa

@marcoemme This is not an answer to the posted question. Please use comment for this type of post.