Page 1 of 1

Database Exception SQLite Error 19

Posted: Mon Jun 03, 2013 8:34 am
by DStrohma
Hi,

i have a database file that is corrupted. That means: Ich can take a look at everything, but as soon as i change some specific things (or try to delete something) then i get this error and can't do anything anymore. The problem is reproducible.

Win7 64
Newest CintaNotes version right now (2.2)

I would love to work again with my notes and i can provide the database to analyze the problem but only if the data inside will be threated with security (will only provide the file to the developer).

Cheers,
DS

PS: See the screenshot for details

Re: Database Exception SQLite Error 19

Posted: Mon Jun 03, 2013 9:22 am
by Thomas Lohrum
Hi DStrohma,

i've just created a post, which will provide information on how to recreate your data.

Check here: http://www.cintanotes.com/forum/viewtopic.php?f=3&t=156&p=7331#p7331

Come back in case you need more help.

Please provide information, what caused your trouble. Is it reproducible? Please turn on debugging and provide a log in case this should happen again; see help\debug\[*] debug log.

Thanks for your help.

Thomas

Re: Database Exception SQLite Error 19

Posted: Mon Jun 03, 2013 10:39 am
by CintaNotes Developer
Hi DStrohma,
really sorry that this has happened. Do you have any idea what might have lead to this situation?
It would be very important to recreate the steps which lead to such corruption.

The best option for us is if you could send the corrupted database over to us,
but I understand very well that this might not be an option.

Also please follow Thomas's advice on data recovery - by now he's become an expert
on the topic :)

Re: Database Exception SQLite Error 19

Posted: Mon Jun 03, 2013 11:24 am
by DStrohma
I will send the developer the corrupted database file. Hope he can find the problem :)

Here is what i have done till the exception happened:
1) I had two caterories and created a new one (a new tab)
2) I added notes to the new tab (the tab was colled 'Akquise')
3) I tried to delete the note "Novero GmbH"
4) Got the exception.

I think the problem occured when i added the third category. Before that everything worked fine. There are also some other exceptions (but all database related) if i want to (for example) change a note - specifically the note "Arbeitszeit pro Woche" in another category.

Cheers

Re: Database Exception SQLite Error 19

Posted: Thu Jun 06, 2013 6:20 am
by CintaNotes Developer
Hi DStroma,

sorry but didn't receive the file.. could you please send it to support@cintanotes.com ?
Huge thanks in advance!

Re: Database Exception SQLite Error 19

Posted: Thu Jun 06, 2013 11:57 am
by DStrohma
Hi,

i've send you the file per mail.

Cheers,
DS

Re: Database Exception SQLite Error 19

Posted: Fri Jun 07, 2013 4:46 am
by CintaNotes Developer
I got it, thanks! Will get back to you as soon as we have any information.

Re: Database Exception SQLite Error 19

Posted: Fri Jun 14, 2013 12:08 pm
by DStrohma
The provided fix workes perfectly. Thanks!

Re: Database Exception SQLite Error 19

Posted: Fri Jun 14, 2013 12:55 pm
by CintaNotes Developer
Great to hear that, thank you very much for your help.
Of course we'll include the fix into the next update.

Re: Database Exception SQLite Error 19

Posted: Tue Jul 02, 2013 6:16 am
by CintaNotes Developer
In order to avoid DB corruption in future, I strongly advise to do the following:

open cintanotes.settings and change the lines
sqlite.pragma.journal_mode = MEMORY
to
sqlite.pragma.journal_mode = DELETE

and
sqlite.pragma.synchronous = OFF
to
sqlite.pragma.synchronous = NORMAL

People who need maximum reliability might also consider
sqlite.pragma.synchronous = FULL
(but it will make CN IO operations slower)

CintaNotes 2.3 will change dangerous settings automatically.