Database Exception SQLite Error 19

DStrohma
Posts: 18
Joined: Wed Mar 25, 2009 12:47 am
Contact:

Database Exception SQLite Error 19

Postby DStrohma » Mon Jun 03, 2013 8:34 am

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
Attachments
CintaNotes Bug.png
CintaNotes Bug.png (152.68 KiB) Viewed 10395 times
Thomas Lohrum
Posts: 1324
Joined: Tue Mar 08, 2011 11:15 am

Re: Database Exception SQLite Error 19

Postby Thomas Lohrum » Mon Jun 03, 2013 9:22 am

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database Exception SQLite Error 19

Postby CintaNotes Developer » Mon Jun 03, 2013 10:39 am

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 :)
Alex
DStrohma
Posts: 18
Joined: Wed Mar 25, 2009 12:47 am
Contact:

Re: Database Exception SQLite Error 19

Postby DStrohma » Mon Jun 03, 2013 11:24 am

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database Exception SQLite Error 19

Postby CintaNotes Developer » Thu Jun 06, 2013 6:20 am

Hi DStroma,

sorry but didn't receive the file.. could you please send it to support@cintanotes.com ?
Huge thanks in advance!
Alex
DStrohma
Posts: 18
Joined: Wed Mar 25, 2009 12:47 am
Contact:

Re: Database Exception SQLite Error 19

Postby DStrohma » Thu Jun 06, 2013 11:57 am

Hi,

i've send you the file per mail.

Cheers,
DS
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database Exception SQLite Error 19

Postby CintaNotes Developer » Fri Jun 07, 2013 4:46 am

I got it, thanks! Will get back to you as soon as we have any information.
Alex
DStrohma
Posts: 18
Joined: Wed Mar 25, 2009 12:47 am
Contact:

Re: Database Exception SQLite Error 19

Postby DStrohma » Fri Jun 14, 2013 12:08 pm

The provided fix workes perfectly. Thanks!
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database Exception SQLite Error 19

Postby CintaNotes Developer » Fri Jun 14, 2013 12:55 pm

Great to hear that, thank you very much for your help.
Of course we'll include the fix into the next update.
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database Exception SQLite Error 19

Postby CintaNotes Developer » Tue Jul 02, 2013 6:16 am

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.
Alex

Return to “Bug Reports”