Automatic database upgrade failed

jwolfeld
Posts: 16
Joined: Wed Mar 07, 2012 5:53 pm
Contact:

Automatic database upgrade failed

Postby jwolfeld » Sat Oct 18, 2014 6:15 pm

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Mon Oct 20, 2014 6:10 am

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!
Alex
jwolfeld
Posts: 16
Joined: Wed Mar 07, 2012 5:53 pm
Contact:

Re: Automatic database upgrade failed

Postby jwolfeld » Fri Oct 31, 2014 12:47 am

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Fri Oct 31, 2014 4:59 am

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?
Alex
rws
Posts: 6
Joined: Fri Sep 19, 2014 6:21 pm
Contact:

Re: Automatic database upgrade failed

Postby rws » Sat Nov 08, 2014 6:06 pm

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 ?
Thomas Lohrum
Posts: 1316
Joined: Tue Mar 08, 2011 11:15 am

Re: Automatic database upgrade failed

Postby Thomas Lohrum » Sat Nov 08, 2014 8:33 pm

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Mon Nov 10, 2014 1:49 pm

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Mon Nov 10, 2014 1:54 pm

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.
Alex
rws
Posts: 6
Joined: Fri Sep 19, 2014 6:21 pm
Contact:

Re: Automatic database upgrade failed

Postby rws » Mon Nov 10, 2014 7:47 pm

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Tue Nov 11, 2014 2:43 pm

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 297 times
Alex
rws
Posts: 6
Joined: Fri Sep 19, 2014 6:21 pm
Contact:

Re: Automatic database upgrade failed

Postby rws » Tue Nov 11, 2014 5:16 pm

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Thu Nov 13, 2014 10:47 am

Robert,
Thanks for your trust! I've fixed the file and sent it back to you - please check your mail.
Alex
rws
Posts: 6
Joined: Fri Sep 19, 2014 6:21 pm
Contact:

Re: Automatic database upgrade failed

Postby rws » Fri Nov 14, 2014 2:14 am

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Fri Nov 14, 2014 8:01 am

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.
Alex
jwolfeld
Posts: 16
Joined: Wed Mar 07, 2012 5:53 pm
Contact:

Re: Automatic database upgrade failed

Postby jwolfeld » Tue Nov 18, 2014 12:45 am

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

Re: Automatic database upgrade failed

Postby CintaNotes Developer » Tue Nov 18, 2014 11:20 am

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

Return to “Bug Reports”