gemini icon indicating copy to clipboard operation
gemini copied to clipboard

sqlalchemy.exc.OperationalError when using gemini amend command to upload new ped file

Open OskarSchnappauf opened this issue 6 years ago • 2 comments

Dear gemini team,

thank you so much for creating gemini, it is a great tool to browse through vcf-databases. However, since some days I get the following error when I try to upload a new pedigree file to my big gemini-database:

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked (Background on this error at: http://sqlalche.me/e/e3q8)

I hope you can help me with this issue.

Thank you, Oskar

OskarSchnappauf avatar Aug 01 '18 20:08 OskarSchnappauf

Hi, you might have a process that's accessing the database. Can you follow the answer given here ?

brentp avatar Aug 01 '18 20:08 brentp

Hi there, thank you so much for your quick reply. The following help: mv my.db temp.db cp temp.db my_new.db

However, its slightly annoying to do that frequently, especially if your database is really big.

Oskar

OskarSchnappauf avatar Aug 02 '18 13:08 OskarSchnappauf