Database errors etc.

gnarf
Posts: 4
Joined: Tue Jun 18, 2013 9:18 am
Contact:

Database errors etc.

Postby gnarf » Tue Jun 18, 2013 9:23 am

I get all kinds of database errors since 1 week ago.
i can't edit and save my notes but I can open them OK.
I upgraded to 2.2.1 Beta a week ago while I was travelling, this temporaliry solved my problems for a few days.
The brand new version 2.2.3 have the same problem.

"Database malformed", "class err invalid state exception" after editing a note. :cry:
What is the cause of this?

I am a registrated user.
kp_denis
Moderator
Posts: 5
Joined: Thu Feb 21, 2013 8:25 am
Contact:

Re: Database errors etc.

Postby kp_denis » Tue Jun 18, 2013 10:39 am

Hello.

Please try attached CintaNotes.exe, this version contains database auto fixing logic.
If this doesn't solve problem, please send log file created by attached CN version (use menu option Help\Debug\Debug Logging) to support@cintanotes.com .

Best regards, Denis.
Attachments
cn.rar
(2.44 MiB) Downloaded 214 times
gnarf
Posts: 4
Joined: Tue Jun 18, 2013 9:18 am
Contact:

Re: Database errors etc.

Postby gnarf » Tue Jun 18, 2013 4:30 pm

Where can i find the file to send in? Looked but dunno what file you mean?
Thomas Lohrum
Posts: 1309
Joined: Tue Mar 08, 2011 11:15 am

Re: Database errors etc.

Postby Thomas Lohrum » Tue Jun 18, 2013 5:43 pm

gnarf wrote:Where can i find the file to send in? Looked but dunno what file you mean?

On Win7 you'll find it here C:\Users\<your user-name>\AppData\Roaming\CintaNotes\log.1.txt. The name of the log-file may vary. Thus check for the timestamp of the logfile.

Thomas
gnarf
Posts: 4
Joined: Tue Jun 18, 2013 9:18 am
Contact:

Re: Database errors etc.

Postby gnarf » Tue Jun 18, 2013 6:43 pm

Thomas Lohrum wrote:
gnarf wrote:Where can i find the file to send in? Looked but dunno what file you mean?

On Win7 you'll find it here C:\Users\<your user-name>\AppData\Roaming\CintaNotes\log.1.txt. The name of the log-file may vary. Thus check for the timestamp of the logfile.

Thomas


I will send you some files because same problem...
User avatar
CintaNotes Developer
Site Admin
Posts: 4654
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database errors etc.

Postby CintaNotes Developer » Thu Jun 20, 2013 1:32 am

gnarf wrote:I will send you some files because same problem...

Thank you, please check your mail..
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 4654
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Database errors etc.

Postby CintaNotes Developer » Tue Jul 02, 2013 6:12 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”