Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Devices

Notices

Reply
 
Thread Tools Search this Thread
Old 05-19-2024, 01:00 PM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 8,993
Karma: 62040409
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
[Kobo] Having database corruption issues?

This keeps coming up again and again, so I'm making a thread for easy linking. If a moderator is inclined, feel free to sticky it.

The current Kobo firmware has an glitch in which it occasionally fails to close the database while connecting to PC, often resulting in database corruption. If you look at the .kobo folder in your file manager, you may see an sqlite write-ahead log - which indicates that it exported to USB while the sqlite database was open.

I've personally had it happen under two circumstances:
  • connecting while a kepub is open.
  • Using a NickelMenu option to reconnect immediately after importing a large amount (50+) of books.

However, other users have also had it happen under other circumstances, including "at random."

If you have Kobo Utilities installed in Calibre, you'll get an error about a malformed database. If you don't, you may notice if metadata fails to update or the reading position keeps resetting back to the same spot.

Ensuring that you're on the home screen before connecting often (not always) helps with preventing the issue, but rebooting before connection is the most reliable way to keep it from happening. This NickelMenu config will add an easy-access reboot button to the main menu:

Code:
menu_item : main : Reboot Device : power : reboot
If it happens, there's two main ways to fix it.
  • Restore a database backup taken by Kobo Utilities. Extract the contents of the archived ZIP into the .kobo folder. This is preferred as you will not lose any reading positions or annotations.
  • If you have not a backup, logging in and out of your Kobo account. This reinitializes the database to a fresh slate, and re-imports any sideloaded books. Unfortunately, this also results in the loss of the reading positions and annotations for those sideloaded books.

    Even if you don't have a database backup here, Kobo Utilities is still of assistance: it's possible to save the reading position to a custom column beforehand and then restore it back to device afterwards.

Amendments to this post welcome.

Last edited by ownedbycats; 05-19-2024 at 01:52 PM.
ownedbycats is offline   Reply With Quote
Old 05-19-2024, 01:06 PM   #2
rantanplan
Weirdo
rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.
 
Posts: 695
Karma: 8910012
Join Date: Nov 2019
Location: Wuppertal, Germany
Device: Tolino Shine Color, Tolino Vision 6, Kobo Clara 2E, Boox Note Air 2+
I have made the observation, that using the option to completely shut down the device after X minutes helps to prevent any database corruption. I set this to 60 minutes and I also make sure to shut down the device and only start the device after connecting it to my PC, and I haven't had any database corruption for months.

Even though this is anecdotal at best, other users also seem to have good experiences by shutting the device completely off before connecting to a PC.

EDIT
You've already made the suggestion to use a reboot option in Nickelmenu, good idea.

Last edited by rantanplan; 05-19-2024 at 01:28 PM.
rantanplan is offline   Reply With Quote
Advert
Old 05-19-2024, 01:42 PM   #3
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 75,047
Karma: 131375774
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by rantanplan View Post
I have made the observation, that using the option to completely shut down the device after X minutes helps to prevent any database corruption. I set this to 60 minutes and I also make sure to shut down the device and only start the device after connecting it to my PC, and I haven't had any database corruption for months.

Even though this is anecdotal at best, other users also seem to have good experiences by shutting the device completely off before connecting to a PC.

EDIT
You've already made the suggestion to use a reboot option in Nickelmenu, good idea.
No need to shut down when not being used. That actually uses more battery doing that then a reboot just before plugging into the USB.
JSWolf is offline   Reply With Quote
Old 05-19-2024, 02:43 PM   #4
rantanplan
Weirdo
rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.rantanplan ought to be getting tired of karma fortunes by now.
 
Posts: 695
Karma: 8910012
Join Date: Nov 2019
Location: Wuppertal, Germany
Device: Tolino Shine Color, Tolino Vision 6, Kobo Clara 2E, Boox Note Air 2+
Quote:
Originally Posted by JSWolf View Post
No need to shut down when not being used. That actually uses more battery doing that then a reboot just before plugging into the USB.

I have ready access to several power outlets in my home, so I don’t have to worry about that 😁
rantanplan is offline   Reply With Quote
Old 06-24-2024, 04:03 PM   #5
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 8,993
Karma: 62040409
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Would a moderator consider pinning this? It's happened again.
ownedbycats is offline   Reply With Quote
Advert
Old 06-24-2024, 04:39 PM   #6
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 75,047
Karma: 131375774
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by ownedbycats View Post
Would a moderator consider pinning this? It's happened again.
It should be stickied in the Kobo forum so it will hopefully be seen before it becomes an issue.
JSWolf is offline   Reply With Quote
Old 06-24-2024, 05:00 PM   #7
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 8,993
Karma: 62040409
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Then people who come to the Calibre forum are less likely to see it.
ownedbycats is offline   Reply With Quote
Old 06-24-2024, 05:24 PM   #8
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,107
Karma: 57259780
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Forum Guidelines:
Threads are supposed ti be in the best place and not multi posted.

This is a Kobo specific issue
Hmm! I am having corruption with Brand X and not Brand Y
theducks is online now   Reply With Quote
Old 06-24-2024, 05:29 PM   #9
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 8,993
Karma: 62040409
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
By that logic, we should also move this thread and this one. After all, it only matters for Kindle books.

Last edited by ownedbycats; 06-24-2024 at 05:38 PM.
ownedbycats is offline   Reply With Quote
Old 07-05-2024, 01:06 PM   #10
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 75,047
Karma: 131375774
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by ownedbycats View Post
By that logic, we should also move this thread and this one. After all, it only matters for Kindle books.
I agree about moving the threads about Kindle Books to the Kindle forum.
JSWolf is offline   Reply With Quote
Old 07-05-2024, 03:22 PM   #11
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 37,852
Karma: 150333332
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Quote:
Originally Posted by ownedbycats View Post
By that logic, we should also move this thread and this one. After all, it only matters for Kindle books.
The difference being is that the Kobo database corruption issue has nothing to do with calibre since simply connecting your Kobo to a computer over USB could trigger the issue while the two threads you mention are connected to calibre importing Kindle format ebooks.

BTW, the latest 4.38.23038 firmware ( 4.39.23027 for the Libra Colour, Clara Colour and Clara BW ) do close the database before a USB connect so that source of database corruption has been fixed. It's still possible to corrupt that database by not safely ejecting, etc. but the major cause is no longer with us.
DNSB is offline   Reply With Quote
Old 07-05-2024, 05:31 PM   #12
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 75,047
Karma: 131375774
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by DNSB View Post
The difference being is that the Kobo database corruption issue has nothing to do with calibre since simply connecting your Kobo to a computer over USB could trigger the issue while the two threads you mention are connected to calibre importing Kindle format ebooks.

BTW, the latest 4.38.23038 firmware ( 4.39.23027 for the Libra Colour, Clara Colour and Clara BW ) do close the database before a USB connect so that source of database corruption has been fixed. It's still possible to corrupt that database by not safely ejecting, etc. but the major cause is no longer with us.
The overall problem is that when a problem arises such as the Kobo database corruption, the person with the problem who is reporting this problem does so where there thing it may be appropriate even though it's not.

Downloading Kindle eBooks and Kobo database corruption both have nothing to do with calibre. It's like someone posted epub questions in the Sigil forum because they are using Sigil even though it's not a Sigil issue.

I do think the staff should be more aware of this and move the threads to where they really belong and the age of the thread should not matter when moving the thread.
JSWolf is offline   Reply With Quote
Old 07-05-2024, 05:36 PM   #13
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 8,993
Karma: 62040409
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Calibre reports the issue in an error dialog, so users come here to ask about it. If this thread is moved to the Kobo subforum, they won't see it.
ownedbycats is offline   Reply With Quote
Old 07-05-2024, 07:01 PM   #14
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
PeterT's Avatar
 
Posts: 12,417
Karma: 74317822
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
@JSWolf if you're so concerned about posts / threads, rather than complaining in the threads, report them to the moderators / admins, let them decide where a thread belongs. Once reported once, just forget about it and accept it for what it's worth.
PeterT is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Kobo] Database corruption - thoughts? jonmach Devices 16 11-29-2023 09:04 AM
Kobo Forma possible database corruption, books keep "disappearing" pixelpaperyarn Kobo Reader 6 11-16-2023 04:47 PM
Database Corruption / FW 3.5.0 PeterT Kobo Reader 7 08-26-2014 04:10 PM
Database Corruption during Installation aronan Calibre 3 09-10-2010 01:17 AM
Database Corruption!! Alexander Turcic Announcements 0 07-22-2003 10:08 AM


All times are GMT -4. The time now is 11:11 PM.


MobileRead.com is a privately owned, operated and funded community.