Automatic database upgrade failed
-
- Posts: 16
- Joined: Wed Mar 07, 2012 5:53 pm
- Contact:
Automatic database upgrade failed
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.
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.
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
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!
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
-
- Posts: 16
- Joined: Wed Mar 07, 2012 5:53 pm
- Contact:
Re: Automatic database upgrade failed
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.
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.
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
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
-
- Posts: 6
- Joined: Fri Sep 19, 2014 6:21 pm
- Contact:
Re: Automatic database upgrade failed
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 ?
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 ?
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
Re: Automatic database upgrade failed
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
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
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
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
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
-
- Posts: 6
- Joined: Fri Sep 19, 2014 6:21 pm
- Contact:
Re: Automatic database upgrade failed
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,
"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!
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
rws,
could you please try this version and tell me if it can upgrade the old files without errors?
Thanks!
could you please try this version and tell me if it can upgrade the old files without errors?
Thanks!
Alex
-
- Posts: 6
- Joined: Fri Sep 19, 2014 6:21 pm
- Contact:
Re: Automatic database upgrade failed
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
I am emailing my data to the support email address,
please just treat it as private and use for debugging purpose only.
Thanks,
Robert
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
Robert,
Thanks for your trust! I've fixed the file and sent it back to you - please check your mail.
Thanks for your trust! I've fixed the file and sent it back to you - please check your mail.
Alex
-
- Posts: 6
- Joined: Fri Sep 19, 2014 6:21 pm
- Contact:
Re: Automatic database upgrade failed
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
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
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
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.
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
-
- Posts: 16
- Joined: Wed Mar 07, 2012 5:53 pm
- Contact:
Re: Automatic database upgrade failed
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.
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: Automatic database upgrade failed
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