Page 1 of 1

Automatic database upgrade failed

Posted: Sat Oct 18, 2014 6:15 pm
by jwolfeld
Just upgraded to today's new version of CintaNotes. Seemed to upgrade correctly. My database file was upgraded automatically and a backup created. However when I tried to open the file it said: Class db::DatabaseException SQLite error 11: database disk image is malformed. I also noticed another popup: Precondition failed: tools::ptr<<class app::controls::TagSidebar>::get pointee.

For the moment I'm going go back to the previous CintaNotes version and restore the backup.

Windows System Information export is attached. I'd rather not attach the CintaNotes DB if possible, since it contains private information.

Thanks,
Jeff W.

Re: Automatic database upgrade failed

Posted: Mon Oct 20, 2014 6:10 am
by CintaNotes Developer
Hello Jeff,
Thanks a lot for the report!

Do you still have the corrupted database file? I suspect this could be the problem of your old file - the corruption was there, but was exposed by the upgrade, because the upgrade modifies the database schema.

To verify this, could you please do the following:

1) Download Sqlite shell utility from here: http://sqlite.org/2014/sqlite-shell-win ... 080700.zip
2) Make a copy of your 2.7.2 database file, put sqlite3.exe near it
3) run "sqlite3 cintanotes.db " (or whatever the name is)
4) type "pragma integrity_check", press Enter
5) tell me the results

If the result is "OK" would be great if you could do the same for the corrupted 2.8 file, if you still have it.

Thanks!

Re: Automatic database upgrade failed

Posted: Fri Oct 31, 2014 12:47 am
by jwolfeld
Thanks for the reply, Alex. I'll try that tomorrow.

In the mean time I'm going to figure out how to get the Forum to send me an email whenever I get a response to one of my posts. Then perhaps next time I won't take so long to get back to you!

Thanks,
Jeff W.

Re: Automatic database upgrade failed

Posted: Fri Oct 31, 2014 4:59 am
by CintaNotes Developer
I'll try that tomorrow.

Great, please let me know how it goes!

jwolfeld wrote:In the mean time I'm going to figure out how to get the Forum to send me an email whenever I get a response to one of my posts. Then perhaps next time I won't take so long to get back to you!


That's strange, I receive the notifications ok. Are you sure that you had "Notify me when a reply is posted" mark checked when you wrote the post?

Re: Automatic database upgrade failed

Posted: Sat Nov 08, 2014 6:06 pm
by rws
I have been getting the same problem.

pragma integrity_check;
wrong # of entries in index ix_Notes_Tags_tagid
wrong # of entries in index sqlite_autoindex_Notes_Tags_1

So what do I do ?

Re: Automatic database upgrade failed

Posted: Sat Nov 08, 2014 8:33 pm
by Thomas Lohrum
CintaNotes Developer wrote:That's strange, I receive the notifications ok. Are you sure that you had "Notify me when a reply is posted" mark checked when you wrote the post?

I have reported similar issues in the past. The notifications are not reliable! That is why i check the forum manually each day.

Thomas

Re: Automatic database upgrade failed

Posted: Mon Nov 10, 2014 1:49 pm
by CintaNotes Developer
rws wrote:I have been getting the same problem.

pragma integrity_check;
wrong # of entries in index ix_Notes_Tags_tagid
wrong # of entries in index sqlite_autoindex_Notes_Tags_1

So what do I do ?

Hi rws,
please do the following:
1) Exit CintaNotes
2) Rename your old database (e.g. to cintanotes0.db)
3) Start CintaNotes, it will create a new blank database
4) Import from your old (renamed) database using File/Import
5) (Optional) Delete the duplicate main section
6) Recreate your search- and sort-options

Please also refer to this page for tips how to fix it, in case the steps above don't help:
viewtopic.php?f=3&t=156&start=20#p7331

Please let me know if this helps!

Re: Automatic database upgrade failed

Posted: Mon Nov 10, 2014 1:54 pm
by CintaNotes Developer
Thomas Lohrum wrote:I have reported similar issues in the past. The notifications are not reliable! That is why i check the forum manually each day.


Finally it seems that I've found out what is the problem: https://www.phpbb.com/community/viewtop ... &t=2164504

I'll try to implement the suggested solution as the time permits.

Re: Automatic database upgrade failed

Posted: Mon Nov 10, 2014 7:47 pm
by rws
When I do that it says

"the notebook file 'c:\users\rws\appdata\roaming\cintanotes\backup\cintanotes (beofre upgrade to 2.7.2).2014-11-09_2022.db' was created by an older version of cintanotes. do you want to upgrade it? "

I click yes, and then it says:
"SQLite error 1: there is already another table or index with this name : NoteCache"
with 3 buttons "create new", "open existing", and "exit"

I click create new, and give it a dummy name "asdf".

I then try to import one of the backup .db (which has clean integrity_check)
and it again say "SQLite error 1: there is already another table or index with this name : NoteCache" with only one button "OK".
I click OK, but nothing is imported.

Any clues?
Thanks,



CintaNotes Developer wrote:
rws wrote:I have been getting the same problem.

pragma integrity_check;
wrong # of entries in index ix_Notes_Tags_tagid
wrong # of entries in index sqlite_autoindex_Notes_Tags_1

So what do I do ?

Hi rws,
please do the following:
1) Exit CintaNotes
2) Rename your old database (e.g. to cintanotes0.db)
3) Start CintaNotes, it will create a new blank database
4) Import from your old (renamed) database using File/Import
5) (Optional) Delete the duplicate main section
6) Recreate your search- and sort-options

Please also refer to this page for tips how to fix it, in case the steps above don't help:
viewtopic.php?f=3&t=156&start=20#p7331

Please let me know if this helps!

Re: Automatic database upgrade failed

Posted: Tue Nov 11, 2014 2:43 pm
by CintaNotes Developer
rws,
could you please try this version and tell me if it can upgrade the old files without errors?
Thanks!

CintaNotes_2_8_3_Beta0.zip
(6.74 MiB) Downloaded 311 times

Re: Automatic database upgrade failed

Posted: Tue Nov 11, 2014 5:16 pm
by rws
2.8.3_beta says there's already existing TextFormat.

I am emailing my data to the support email address,
please just treat it as private and use for debugging purpose only.
Thanks,
Robert

Re: Automatic database upgrade failed

Posted: Thu Nov 13, 2014 10:47 am
by CintaNotes Developer
Robert,
Thanks for your trust! I've fixed the file and sent it back to you - please check your mail.

Re: Automatic database upgrade failed

Posted: Fri Nov 14, 2014 2:14 am
by rws
What I'm seeing now is that the database will import, but there is about a 4 month gap of notes - (april to august 2014)
roughly 3/4 of the database do not show in cintanotes (the client).
The count show 301 notes, but I know there are over 1200, and I can see them just by
exporting to html. I installed the 2.8.2 and get the same result.
Robert

Re: Automatic database upgrade failed

Posted: Fri Nov 14, 2014 8:01 am
by CintaNotes Developer
Hi Robert,
I suspect the problem is that not all sections are selected. Please press Ctrl+Shift+Space to select all sections.

Please also try pressing F6 to show the section bar, to see in real time which sections are displayed.

Re: Automatic database upgrade failed

Posted: Tue Nov 18, 2014 12:45 am
by jwolfeld
CintaNotes Developer wrote:Hello Jeff,
Thanks a lot for the report!

Do you still have the corrupted database file? I suspect this could be the problem of your old file - the corruption was there, but was exposed by the upgrade, because the upgrade modifies the database schema.

To verify this, could you please do the following:

1) Download Sqlite shell utility from here: http://sqlite.org/2014/sqlite-shell-win ... 080700.zip
2) Make a copy of your 2.7.2 database file, put sqlite3.exe near it
3) run "sqlite3 cintanotes.db " (or whatever the name is)
4) type "pragma integrity_check", press Enter
5) tell me the results

If the result is "OK" would be great if you could do the same for the corrupted 2.8 file, if you still have it.

Thanks!


Rather than follow the instructions above I chose to export my database, upgrade the CintaNotes version, create a clean database file, and then import my data to it. That worked fine.

Thanks,
Jeff W.

Re: Automatic database upgrade failed

Posted: Tue Nov 18, 2014 11:20 am
by CintaNotes Developer
jwolfeld wrote:Rather than follow the instructions above I chose to export my database, upgrade the CintaNotes version, create a clean database file, and then import my data to it. That worked fine.

Well, glad for you :) BTW strictly speaking, the first export was unnecessary: you could have simply imported your old file into a new one.