09-24-2024, 11:26 PM | #1 |
Enthusiast
Posts: 37
Karma: 190
Join Date: Sep 2023
Device: Kobo Libra 2
|
Database Corruptions & Backups
Hello!
I'm on the latest version but I'm still getting database corruptions every week. Has anyone else been having this issue? Not sure why it happens. I have backups of my database, but my annotations, bookmarks, saved words, and reading progress don't transfer over when I copy over the DBs. Does anyone have any tips? Am I missing something? I copy over the BookReader.sqlite and KoboReader.sqlite files instead of everything Calibre backs up, but that should be sufficient. If it makes any difference, I do written annotations in my sideloaded ebooks Error received on the latest database corruption: row 10224 missing from index sqlite_autoindex_content_1 non-unique entry in index sqlite_autoindex_content_1 row 10248 missing from index sqlite_autoindex_content_1 non-unique entry in index sqlite_autoindex_content_1 row 10273 missing from index sqlite_autoindex_content_1 All database corruption errors follow similar errors with missing rows Any help is appreciated, thank you. |
09-24-2024, 11:33 PM | #2 |
Bibliophagist
Posts: 40,363
Karma: 156982136
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
That pattern of database corruption is generally an issue with the USB connection (a flaky cable, not safely ejecting, etc.). What does a database check show (either the check database from Kobo Utilities or an external SQLite application). Using SQLite Expert Personal, I tend to use the database check then vacuum and then re-index all tables which will help with some minor issues.
|
Advert | |
|
09-24-2024, 11:43 PM | #3 | |
Enthusiast
Posts: 37
Karma: 190
Join Date: Sep 2023
Device: Kobo Libra 2
|
Quote:
I've been safely ejecting my Kobo, but my apple cable is maybe 6 years old. The rubber near the connectors still cover the wires, so I assumed it was fine. I'll look into getting a replacement Thanks for the advice! Last edited by 1ily; 09-24-2024 at 11:50 PM. |
|
09-24-2024, 11:59 PM | #4 |
Bibliophagist
Posts: 40,363
Karma: 156982136
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Since SQLite Expert Personal is a Windows only program, I think that if you use the DB Browser SQLite, compact is equivalent to vacuum, Integrity Check would be equivalent to check database and Optimize would be closest to Reindex all tables without manually running REINDEX.
|
09-25-2024, 06:54 PM | #5 | |
Enthusiast
Posts: 37
Karma: 190
Join Date: Sep 2023
Device: Kobo Libra 2
|
I swapped out my cables and tried adding more eBooks to it (mix of epub and pdf). I got a "CorruptError: database disk image is malformed" after plugging it in and out a few times.
I safely ejected every time and made sure no processes were ongoing. I'm always plugging it in when my eReader is displaying my home screen. Database check returned this (it's actually much longer and I've shortened it) Quote:
|
|
Advert | |
|
09-25-2024, 08:43 PM | #6 |
Bibliophagist
Posts: 40,363
Karma: 156982136
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
If you have upgraded to firmware 4.38.23038 on your Libra 2, I'm out of ideas as to what can be causing your database corruption. Perhaps going to what I used on my Sage before the firmware update to the 4.38 version and reboot your Kobo before connecting to your computer. This was done using NickelMenu.
|
09-26-2024, 09:44 AM | #7 | |
Resident Curmudgeon
Posts: 76,309
Karma: 136006010
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
Quote:
|
|
09-26-2024, 03:21 PM | #8 | |
Bibliophagist
Posts: 40,363
Karma: 156982136
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
|
|
09-27-2024, 09:39 AM | #9 |
Guru
Posts: 990
Karma: 11000000
Join Date: Feb 2010
Location: Serbia
Device: Kindle PW5, Kobo Libra 2, Kindle PW1
|
Ha! that would be a first.
|
09-27-2024, 08:29 PM | #10 | |
Enthusiast
Posts: 37
Karma: 190
Join Date: Sep 2023
Device: Kobo Libra 2
|
Quote:
Haven't had an issue ever since I started rebooting before plugging it in. Thanks for the idea! |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't restore database from backups | sysiphus-corinth | Library Management | 7 | 11-22-2017 09:14 AM |
Glo Database & Read Count | ethanbeyer | Kobo Reader | 7 | 06-26-2013 03:58 AM |
Belt & Braces & Backups | Bricorn | Amazon Kindle | 3 | 02-07-2011 04:03 PM |
Rebuild Database? & Use Path instead of Filename? | gai-jin | Calibre | 0 | 07-20-2009 02:58 PM |