06-15-2019, 12:30 PM | #1 |
Member
Posts: 10
Karma: 10
Join Date: Jul 2018
Device: kindle paperwhite
|
I think I broke my database
Overnight, I was had set a large number of files to auto-import to my Calibre database, which resides on an installed SD card. When I woke up this morning, the card had run out of space and now every time I try to open the database, I get the following error message. Can someone help me recover somehow?
Code:
calibre, version 3.44.0 ERROR: Startup error: There was an error during calibre startup. Parts of calibre may not function. Click Show details to learn more. Traceback (most recent call last): File "site-packages/calibre/gui2/main.py", line 291, in initialize_db_stage2 File "site-packages/calibre/gui2/main.py", line 235, in start_gui File "site-packages/calibre/gui2/ui.py", line 436, in initialize File "site-packages/calibre/gui2/init.py", line 780, in save_layout_state File "site-packages/calibre/gui2/library/views.py", line 635, in save_state File "site-packages/calibre/gui2/library/views.py", line 629, in write_state File "site-packages/calibre/db/cache.py", line 62, in call_func_with_lock File "site-packages/calibre/db/cache.py", line 616, in set_pref File "site-packages/calibre/db/backend.py", line 134, in set File "site-packages/calibre/db/backend.py", line 131, in __setitem__ SQLError: SQLError: no such savepoint: _apsw-0 |
06-15-2019, 06:20 PM | #2 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Scan and Repair the SD Card.
Copy the library to a proper HD. If Calibre will open it, use Calibre's Check Library function. Fix any etrors. If not, rename the bad library then run Calibre. It will create a new library. Go from there. |
06-15-2019, 06:37 PM | #3 |
Well trained by Cats
Posts: 30,373
Karma: 58053698
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
SD cards can fail without notice. Active Library duty does a lot of reads and writes. If you need more drive, get a USB drive or Get a bigger drive that fits, and clone your existing drive to it (allow the clone to use the entire drive), then swap in the new drive. This process usually takes about an hour
|
Tags |
database errors, sql error |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Aura I can't believe I broke it.... | booklover6 | Kobo Reader | 20 | 03-13-2015 04:58 PM |
I Broke My PE! | bobmutch | enTourage Archive | 8 | 05-23-2011 01:05 AM |
Calibre Database cp Kindle Database | mitch13 | Library Management | 1 | 05-22-2011 07:33 PM |
Broke my Kindle | hellraiser06 | Amazon Kindle | 39 | 02-14-2011 01:19 AM |
Opus Help! I think I broke it | Crusader | Bookeen | 19 | 12-07-2009 06:43 PM |