Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 10-04-2019, 05:40 PM   #1
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Question CAlibre 4.0 - Can't open database file errors

Upgraded to 4.0, tried to add some books and got an error (pasted below), went to library maintenance and check library, got the same sort of error about not being able to open the database file.

Code:
alibre, version 4.0.0
ERROR: Errors while adding: Failed to add any books, click "Show details" for more information


----------------------------------------------------------------------
Failed to add the book: Asteroid Discovery: A Gunner Fox Trilogy (The Asteroid Series Book 1)
	C:\Users\Chris\Downloads\As05teroidDiscoveryAGunnerFoxTrilogyT.epub
With error:
Traceback (most recent call last):
  File "site-packages\calibre\gui2\add.py", line 414, in add_book
  File "site-packages\calibre\db\legacy.py", line 225, in create_book_entry
  File "site-packages\calibre\db\cache.py", line 62, in call_func_with_lock
  File "site-packages\calibre\db\cache.py", line 1580, in create_book_entry
  File "site-packages\calibre\db\backend.py", line 874, in execute
  File "c:\t\t\apsw-tti2z1cq\src\cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file


Code:
calibre, version 4.0.0
ERROR: Failed: Database integrity check failed, click Show details for details.

Traceback (most recent call last):
  File "site-packages\calibre\gui2\dialogs\check_library.py", line 54, in vacuum
  File "site-packages\calibre\db\cache.py", line 62, in call_func_with_lock
  File "site-packages\calibre\db\cache.py", line 2076, in vacuum
  File "site-packages\calibre\db\backend.py", line 1145, in vacuum
  File "site-packages\calibre\db\backend.py", line 874, in execute
  File "c:\t\t\apsw-tti2z1cq\src\cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file
Also happens if I try to swap libraries or read a book in the program.

Any ideas on if I did something weird or wrong?

Thanks!
Chris

Last edited by hydin; 10-04-2019 at 05:45 PM.
hydin is offline   Reply With Quote
Old 10-04-2019, 06:13 PM   #2
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,196
Karma: 57978778
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
what is the FULL path to the Library?
theducks is offline   Reply With Quote
Advert
Old 10-04-2019, 06:36 PM   #3
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Full path is d:\librarycopy\Library for the main one.
hydin is offline   Reply With Quote
Old 10-04-2019, 06:39 PM   #4
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,796
Karma: 27405122
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by hydin View Post
Full path is d:\librarycopy\Library for the main one.
Is there a metadata.db file in that folder?

BR
BetterRed is offline   Reply With Quote
Old 10-04-2019, 06:45 PM   #5
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Yup! Checked and it's not marked as read only or hidden.
hydin is offline   Reply With Quote
Advert
Old 10-04-2019, 06:46 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,422
Karma: 134254362
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Try disabling your AV and see if that might be causing the problem.
JSWolf is offline   Reply With Quote
Old 10-04-2019, 06:51 PM   #7
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Nope, disabled all shields and active processes for the antivirus, still the same error. Even when swapping to a different library.

Note, I didn't change anything when I installed 4, just downloaded and installed. Same error now when I try to run 3.34 (the one I upgraded from), I get the same error about adding to the libraries, etc.

Chris
hydin is offline   Reply With Quote
Old 10-04-2019, 06:53 PM   #8
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,796
Karma: 27405122
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by JSWolf View Post
Try disabling your AV and see if that might be causing the problem.
And if that casts no light, try Safe mode.

BR
BetterRed is offline   Reply With Quote
Old 10-04-2019, 06:55 PM   #9
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,422
Karma: 134254362
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 BetterRed View Post
And if that casts no light, try Safe mode.

BR
That is a good idea.
JSWolf is offline   Reply With Quote
Old 10-04-2019, 08:14 PM   #10
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Same problem in safe mode.
hydin is offline   Reply With Quote
Old 10-04-2019, 08:19 PM   #11
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,796
Karma: 27405122
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Try creating a new library, if possible on another drive, and try to add a book to it.

BR
BetterRed is offline   Reply With Quote
Old 10-04-2019, 08:23 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,422
Karma: 134254362
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 hydin View Post
Same problem in safe mode.
make a copy of the database files do a restore database from the library maintenance menu when you click the database icon in the toolbar. That will rebuild the database and that should fix the problem.
JSWolf is offline   Reply With Quote
Old 10-04-2019, 09:00 PM   #13
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,196
Karma: 57978778
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by hydin View Post
Full path is d:\librarycopy\Library for the main one.
That isn't a DVD or CD drive? (D: is commonly that letter)
theducks is offline   Reply With Quote
Old 10-04-2019, 10:18 PM   #14
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Nah, no optical discs on the PC. Just lots and lots of hard drives. I'll try the backup idea mentioned above and let you guys know how it goes!

Thanks!
hydin is offline   Reply With Quote
Old 10-05-2019, 08:23 AM   #15
hydin
Connoisseur
hydin doesn't litterhydin doesn't litter
 
Posts: 66
Karma: 186
Join Date: Nov 2008
Device: Paperwhite, Nook Glowlight 3
Wow this is gonna take a while. I'll update in a day or two. If anyone is looking for programming feedback, some sort of percentage or something would be awesome. I'm just looking at a solid bar with a warning that this is gonna be a three step process.
hydin is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calibre metadata.db contains errors... Calibre2opds cannot open file. anamardoll Related Tools 25 02-12-2018 08:33 PM
Calibre 2.7 Unable to open Database file Gordo29 Devices 22 11-04-2016 11:10 PM
unable to open database file mihal.v Calibre 3 08-16-2014 09:44 AM
Unable to open database file wladdy Library Management 6 08-28-2012 05:04 AM
Unable to open database file JulieR Calibre 2 04-24-2009 04:40 AM


All times are GMT -4. The time now is 06:45 AM.


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