SQL Error - Database locked when opening 2nd instance

Lordolin
Posts: 3
Joined: Sat Apr 07, 2018 12:27 pm
Contact:

SQL Error - Database locked when opening 2nd instance

Postby Lordolin » Sun Apr 08, 2018 3:13 pm

Hello again, I dont want to repost, I think it might be good to explain my problem differently to get some answer.
I just bought cintanotes and love it , however, when opening a second instance, I cant use it and get an SQL error : Database locked.
cintanotessqlerror.jpg
cintanotessqlerror.jpg (17.12 KiB) Viewed 16827 times

I am attaching a screenshot, also shown above.
Thanks , Oliver
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: SQL Error - Database locked when opening 2nd instance

Postby CintaNotes Developer » Tue Apr 17, 2018 8:29 am

It is not advised to work with same DB from multiple instances at the same time - it can lead to data loss.
But if you absolutely have to do it, to avoid the "database locked" error, exit CN and edit cintanotes.settings file:
change sqlite.pragma.locking_mode to "NORMAL".
Alex
Lordolin
Posts: 3
Joined: Sat Apr 07, 2018 12:27 pm
Contact:

Re: SQL Error - Database locked when opening 2nd instance

Postby Lordolin » Fri Apr 20, 2018 7:34 am

Thank you for the answer, how do I make the second instance of Cinta Notes use another DB on startup ? It seems to use the same DB automatically .... I do NOT want to work with the same database. THANKS HEAPS for this great software, Oliver
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: SQL Error - Database locked when opening 2nd instance

Postby CintaNotes Developer » Fri Apr 20, 2018 9:02 am

So that two instances of CN don't step on each other's toes, you need to have a separate copy of CN with its own cintanotes.settings file.
The easiest way to get it would be to use the portable version.
Alex

Return to “CintaNotes Personal Notes Manager”