Failed to Back Up Device Database

enuddleyarbl · 10-23-2025, 07:19 PM

EDIT: It looks like that error message is from Kobo Utilities, so I should have posted this elsewhere. But, it's OBE: I copied my previous database backup from Kobo Utilities to .kobo/KoboReader.sqlite, did a few re-updates and all seems well.

OP: Just plugged my Kobo Sage in to my Windows 11 computer and within Calibre got the following:

Code:

calibre, version 8.13.0 (win32, embedded-python: True)
Failed to back up device database: Failed: Backing up Kobo device database

row 378 missing from index sqlite_autoindex_AnalyticsEvents_1
non-unique entry in index sqlite_autoindex_AnalyticsEvents_1

Traceback (most recent call last):
  File "calibre\gui2\device.py", line 111, in run
  File "calibre_plugins.koboutilities.features.backup", line 216, in device_database_backup_job
Exception: 
row 378 missing from index sqlite_autoindex_AnalyticsEvents_1
non-unique entry in index sqlite_autoindex_AnalyticsEvents_1

It's been working fine for ages. Any suggestions on what to look for?

DNSB · 10-23-2025, 08:45 PM

That sounds like you have some database corruption. You might want to try using a SQLite utility such as SQLite Personal 5 to re-index all table and then vacuum to see if that clears up the errors. If not, go for the most recent backup that does not have the error.

JSWolf · 10-28-2025, 04:18 PM

You should be posting this in the Kobo Utilities thread.

10-23-2025, 07:19 PM	#1
enuddleyarbl Guru Posts: 793 Karma: 1538394 Join Date: Sep 2013 Device: Kobo Sage	Failed to Back Up Device Database EDIT: It looks like that error message is from Kobo Utilities, so I should have posted this elsewhere. But, it's OBE: I copied my previous database backup from Kobo Utilities to .kobo/KoboReader.sqlite, did a few re-updates and all seems well. OP: Just plugged my Kobo Sage in to my Windows 11 computer and within Calibre got the following: Code: calibre, version 8.13.0 (win32, embedded-python: True) Failed to back up device database: Failed: Backing up Kobo device database row 378 missing from index sqlite_autoindex_AnalyticsEvents_1 non-unique entry in index sqlite_autoindex_AnalyticsEvents_1 Traceback (most recent call last): File "calibre\gui2\device.py", line 111, in run File "calibre_plugins.koboutilities.features.backup", line 216, in device_database_backup_job Exception: row 378 missing from index sqlite_autoindex_AnalyticsEvents_1 non-unique entry in index sqlite_autoindex_AnalyticsEvents_1 It's been working fine for ages. Any suggestions on what to look for? Last edited by enuddleyarbl; 10-23-2025 at 08:17 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restoring database failed	Mycroft88	Calibre	5	08-05-2025 02:44 PM
Restoring database failed	jstavene	Library Management	3	02-27-2022 12:03 PM
"Failed: Backing up Kobo device database" - brand new Sage	jcf	Devices	10	01-12-2022 11:36 AM
Kobo Database backup failed	Filmbrain	Calibre	8	04-22-2021 11:57 PM
Restoring database failed	Lady Domino	Calibre	2	03-23-2012 02:12 PM

10-23-2025, 08:45 PM	#2
DNSB Bibliophagist Posts: 48,193 Karma: 174315444 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	That sounds like you have some database corruption. You might want to try using a SQLite utility such as SQLite Personal 5 to re-index all table and then vacuum to see if that clears up the errors. If not, go for the most recent backup that does not have the error.

10-28-2025, 04:18 PM	#3
JSWolf Resident Curmudgeon Posts: 80,786 Karma: 150249619 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	You should be posting this in the Kobo Utilities thread.

Advert