I Broke my database

[mike.katina]

I'm the only one using this laptop so I blame me for braking Calibre.

I've had for a while undeletable entries with nothing in the folders but the new one is I cannot drag and drop files in to add anymore.

I get this error . . .

[calibre, version 7.24.0
ERROR: Errors while adding: Failed to add any books, click "Show details" for more information


----------------------------------------------------------------------
Failed to add the book: File name here
With error:
Traceback (most recent call last):
File "calibre\gui2\add.py", line 457, in add_book
File "calibre\db\legacy.py", line 337, in create_book_entry
File "calibre\db\cache.py", line 85, in call_func_with_lock
File "calibre\db\cache.py", line 2147, in create_book_entry
File "calibre\db\backend.py", line 1147, in execute
File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 240, in resetcursor
apsw.CorruptError: CorruptError: database disk image is malformed]

I tried to recup from a backup but to nojoy

I stopped there to not brake it any further. I'm not afraid to work but this is way beyond my paygrade. I'm more like a hammer . . .

[mike.katina]

I forgot to add that I did all the standard stuff, upgraded everything, rebooted Calibre and the winX machine several time. I hope I can get help

[Comfy.n]

I believe you will be able to restore the library via Library Maintenance, but I would wait for the developers input on that log before doing anything

[JSWolf]

Originally Posted by Comfy.n

I believe you will be able to restore the library via Library Maintenance, but I would wait for the developers input on that log before doing anything

But maybe not back to the original state given that the OP tried to restore a backup that also was a fail.

[BetterRed]

Originally Posted by Comfy.n

I believe you will be able to restore the library via Library Maintenance, but I would wait for the developers input on that log before doing anything

↑ ↑ ↑ ✔

Also see ==>> https://manual.calibre-ebook.com/faq.html#id47

. . . you can run calibre as Administrator, but doing so will cause some functionality, such as drag and drop to not work.

BR

[Comfy.n]

Yep maybe not restorable to the original state, given also that the OP had noticed undeletable entries before.

As for the drag and drop not working issue, I've experienced that a few times in the past but I can't remember what worked to solve it.

[mike.katina]

right now, I'm running the plugin to embed metadata in case I have to restart from scratch

[JSWolf]

Originally Posted by mike.katina

right now, I'm running the plugin to embed metadata in case I have to restart from scratch

STOP! DON'T DO THIS! TRY TO FIX THE DATABASE BEFORE YOU MAKE ANY MORE BOTCHES!

[mike.katina]

well, okay got lucky a little, it crashed at 14% while having diner

[mike.katina]

ok stopped. And to add to the problem, here is the error message for the undeletable items

[
calibre, version 7.24.0
ERROR: Unhandled exception: <b>CorruptError</b>:CorruptError: database disk image is malformed

calibre 7.24 embedded-python: True
Windows-10-10.0.19045-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19045')
Python 3.11.5
Windows: ('10', '10.0.19045', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 19, 0) && DeDRM (7, 2, 1) && Package KFX (from KFX Input) (2, 19, 0) && Access Aide (0, 1, 15) && Audio M3U (1, 0, 0) && Author Book Count (2, 2, 3) && Author Book Count Hierarchy (1, 2, 5) && Barnes & Noble (1, 5, 6) && BookFusion Plugin (0, 8, 1) && CalibreSpy (1, 0, 92) && Check Books (0, 1, 8) && Clean Comments (0, 2, 1) && Clean Metadata (0, 0, 6) && Comicvine (0, 14, 2) && Comments Cleaner (1, 15, 0) && Count Pages (1, 13, 6) && DOC Input (1, 0, 1) && Ebook Translator (2, 3, 5) && Editor Chains (1, 1, 9) && Embed Comic Metadata (1, 6, 6) && EpubCheck (0, 2, 5) && EpubMerge (3, 2, 0) && EpubSplit (3, 10, 0) && Extract ISBN (1, 6, 5) && FanFicFare (4, 41, 0) && Fantastic Fiction (1, 7, 1) && Favourites Menu (1, 3, 1) && FictionDB (1, 4, 2) && Find Duplicates (1, 10, 9) && GetFileName (0, 2, 0) && Goodreads (1, 8, 2) && Goodreads More Tags (1, 2, 1, 2) && ISFDB3 (1, 4, 1) && Import List (1, 9, 4) && Job Spy (1, 0, 239) && KFX metadata reader (from KFX Input) (2, 19, 0) && From KFX (2, 19, 0) && KFX Input (2, 19, 0) && Kindle Collections (1, 7, 29) && Kindle hi-res covers (0, 5, 1) && KindleUnpack - The Plugin (0, 83, 1) && Kobo Metadata (1, 10, 0) && Kobo Utilities (2, 17, 2) && Last Modified (0, 8, 5) && Manage Series (1, 5, 2) && Mass Search-Replace (1, 8, 2) && Media File Importer (1, 0, 27) && Modify ePub (1, 8, 5) && Obok DeDRM (7, 2, 1) && Quality Check (1, 13, 16) && QuarantineAndScrub (3, 6, 122) && Reading List (1, 15, 4) && Reformat plugin (2, 4, 0) && Save Virtual Libraries To Column GUI (2, 3, 0) && Standard Ebooks (1, 0, 0) && TTS to MP3 (0, 6, 0) && View Manager (1, 10, 3) && Wikidata (2, 0, 0) && Wikidata gui (2, 0, 0) && ePub Extended Metadata {Writer} (0, 11, 4) && ePub Extended Metadata {Reader} (0, 11, 4) && ePub Extended Metadata (0, 11, 4)
Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 462, in delete_books
File "calibre\gui2\actions\delete.py", line 439, in do_library_delete
File "calibre\gui2\library\models.py", line 477, in delete_books_by_id
File "calibre\db\cache.py", line 85, in call_func_with_lock
File "calibre\db\cache.py", line 2225, in remove_books
File "calibre\db\backend.py", line 2324, in remove_books
File "calibre\db\backend.py", line 1159, in executemany
File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 240, in resetcursor
apsw.CorruptError: CorruptError: database disk image is malformed
]

[mike.katina]

and yes got to do a major cleanup, just fibured I'd fix the library before stirin it up even more.

[JSWolf]

Originally Posted by mike.katina

ok stopped. And to add to the problem, here is the error message for the undeletable items

Try this...

In calibre with the defective library selected, in the toolbar, right click the icon that shows the name of the library and select Library maintenance. Then select Restore Database. That will go through the library and read all the information in the metdata.opf files and recreate the database.

[Karellen]

Is it my imagination that there are regular reports of broken databases?

[JSWolf]

Originally Posted by Karellen

Is it my imagination that there are regular reports of broken databases?

I wonder if these reports are due to cloud syncing.

[Sirtel]

Originally Posted by JSWolf

I wonder if these reports are due to cloud syncing.

Or keeping libraries on networked drives...