Can't open error

Paltieldav · 02-24-2016, 10:24 AM

Hey all,

I enjoy been using calibre for awhile without issue and then a few days ago I got the following error message after starting it up.

Picture of error message is attached. I can't do anything. Can't edit, delete books, add books nothing other than see the list of books.

I've tried:
repairing the program option when installing Calibre
Checking database
Restore database.
And other things I can't recall.

Each one failed to fix the problem and the database couldn't be restore.

Any ideas? Thanks

HarryT · 02-24-2016, 11:45 AM

Sounds as if your database is hosed. Retrieve the most recent database file from your backup. This is why we make backups!

Paltieldav · 02-24-2016, 11:52 AM

Quote:

Originally Posted by HarryT

Sounds as if your database is hosed. Retrieve the most recent database file from your backup. This is why we make backups!

I tried that. It spent over 24 hours trying from backup and in the end it failed.

HarryT · 02-24-2016, 11:54 AM

No, not the entire calibre library, just the database file "metadata.db" (in the root of your calibre library directory). It will only be a few MB. Just copy it from whatever your backup medium is.

theducks · 02-24-2016, 01:45 PM

Where is the Database (full path)?

Paltieldav · 02-24-2016, 07:15 PM

Quote:

Originally Posted by theducks

Where is the Database (full path)?

Not sure if this is what you meant. D:\Calibre

I have one harddrive in my laptop that partitioned into C and D.

I tried the back up it didnt work either

theducks · 02-24-2016, 07:58 PM

OK, you are using a local drive

Have you checked these?
http://manual.calibre-ebook.com/faq....ing-on-windows

Paltieldav · 02-25-2016, 09:37 AM

Quote:

Originally Posted by theducks

OK, you are using a local drive

Have you checked these?
http://manual.calibre-ebook.com/faq....ing-on-windows

Sadly that didn't work. It's starts normally but no books appear.

Paltieldav · 02-25-2016, 09:46 AM

So I figured I would just have to add all the books again. So I tested one book and got the following error:

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

----------------------------------------------------------------------
Failed to add the book: It Doesn't Take a Hero
D:\Norman Schwarzkopf\It Doesn't Take a Hero (15)\metadata.opf
With error:
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 369, in add_book
File "site-packages\calibre\db\legacy.py", line 214, in create_book_entry
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1519, in create_book_entry
File "site-packages\calibre\db\cache.py", line 1248, in set_metadata
File "site-packages\calibre\db\cache.py", line 1075, in update_path
File "site-packages\calibre\db\backend.py", line 1530, in update_path
File "site-packages\calibre\db\tables.py", line 130, in set_path
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

Paltieldav · 02-25-2016, 09:50 AM

Ok Very Weird. I tired adding the same book again without the opf file again it didn't work but I got the duplicate book found pop up asking if I wanted to add it. Iloooked in the Calibre folder and the book was added but not showing in the program.

Now Im more confused.

Paltieldav · 02-25-2016, 09:58 AM

I created a new library and the book was aded properly to that folder. Something is corrupt about my original folder and I dont know what.

theducks · 02-25-2016, 10:01 AM

Quote:

Originally Posted by Paltieldav

Ok Very Weird. I tired adding the same book again without the opf file again it didn't work but I got the duplicate book found pop up asking if I wanted to add it. Iloooked in the Calibre folder and the book was added but not showing in the program.

Now Im more confused.

Duplicate book implies your DB is intact and your VIEW is (severely

) filtered

The upper Left corner should look like:

But there is still a DB locked issue

Restart in Debug mode, try adding a NEW book
then post the debug log (wrap in [spoiler] tags please

Paltieldav · 02-25-2016, 10:09 AM

Quote:

Originally Posted by theducks

Duplicate book implies your DB is intact and your VIEW is (severely

) filtered

The upper Left corner should look like:

But there is still a DB locked issue

Restart in Debug mode, try adding a NEW book
then post the debug log (wrap in [spoiler] tags please

Tried adding a book

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

----------------------------------------------------------------------
Failed to add the book: Catch-22
D:/down/25 Books To Make You LOL/Catch-22 - Joseph Heller.epub
With error:
Traceback (most recent call last):
File "site-packages\calibre\gui2\add.py", line 369, in add_book
File "site-packages\calibre\db\legacy.py", line 214, in create_book_entry
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1509, in create_book_entry
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

Tried closing the Program and got this:

calibre, version 2.51.0
ERROR: Unhandled exception: <b>CantOpenError</b>:CantOpenError: unable to open database file

calibre 2.51 embedded-python: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Fantastic Fiction Adults && FictionDB && Author Book Count Hierarchy && Barnes & Noble && Find Duplicates && EpubMerge && QuarantineAndScrub && FanFicFare && Goodreads && Manage Series && Library Codes && Embed Comic Metadata && Job Spy && Goodreads Sync && Prettify Cover && Fantastic Fiction && MultiColumnSearch && Consolidate All Library Metadata && Clean Metadata
Traceback (most recent call last):
File "site-packages\calibre\gui2\ui.py", line 938, in closeEvent
File "site-packages\calibre\gui2\ui.py", line 836, in write_settings
File "site-packages\calibre\gui2\init.py", line 603, in save_layout_state
File "site-packages\calibre\gui2\library\views.py", line 530, in save_state
File "site-packages\calibre\gui2\library\views.py", line 524, in write_state
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 594, in set_pref
File "site-packages\calibre\db\backend.py", line 127, in set
File "site-packages\calibre\db\backend.py", line 123, in __setitem__
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

Here is the Bug Log
calibre Debug log
calibre 2.51 embedded-python: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Fantastic Fiction Adults && FictionDB && Author Book Count Hierarchy && Barnes & Noble && Find Duplicates && EpubMerge && QuarantineAndScrub && FanFicFare && Goodreads && Manage Series && Library Codes && Embed Comic Metadata && Job Spy && Goodreads Sync && Prettify Cover && Fantastic Fiction && MultiColumnSearch && Consolidate All Library Metadata && Clean Metadata
Starting up...
EpubMerge

EBUG:calibre_plugins.epubmerge.epubmerg e_plugin(152):macmenuhack file_path:C:\Users\PDB\AppData\Roaming\calibre\plu gins\fanficfare_macmenuhack.txt
FFF:INFO:calibre_plugins.fanficfare_plugin.prefs(1 39):Attempting to read settings from predecessor--FFDL
FFF:INFO:calibre_plugins.fanficfare_plugin.prefs(1 44):Using default settings
FFF

EBUG:calibre_plugins.fanficfare_plugin.fff_pl ugin(185):Plugin FanFicFare macmenuhack file_path:C:\Users\PDB\AppData\Roaming\calibre\plu gins\fanficfare_macmenuhack.txt
HttpHelper::__init__: proxy=None
Started up in 49.05 seconds with 21 books
FFF:INFO:calibre_plugins.fanficfare_plugin.prefs(1 39):Attempting to read settings from predecessor--FFDL
FFF:INFO:calibre_plugins.fanficfare_plugin.prefs(1 44):Using default settings
Exception in thread Thread-9:
Traceback (most recent call last):
File "threading.py", line 810, in __bootstrap_inner
File "site-packages\calibre\db\backup.py", line 52, in run
File "site-packages\calibre\db\backup.py", line 83, in do_one
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1116, in clear_dirtied
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

calibre 2.51 embedded-python: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Fantastic Fiction Adults && FictionDB && Author Book Count Hierarchy && Barnes & Noble && Find Duplicates && EpubMerge && QuarantineAndScrub && FanFicFare && Goodreads && Manage Series && Library Codes && Embed Comic Metadata && Job Spy && Goodreads Sync && Prettify Cover && Fantastic Fiction && MultiColumnSearch && Consolidate All Library Metadata && Clean Metadata
Traceback (most recent call last):
File "site-packages\calibre\gui2\__init__.py", line 413, in dispatch
File "site-packages\calibre\gui2\actions\choose_library.py", line 569, in switch_requested
File "site-packages\calibre\gui2\ui.py", line 663, in library_moved
File "site-packages\calibre\gui2\library\views.py", line 727, in set_database
File "site-packages\calibre\gui2\library\views.py", line 530, in save_state
File "site-packages\calibre\gui2\library\views.py", line 524, in write_state
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 594, in set_pref
File "site-packages\calibre\db\backend.py", line 127, in set
File "site-packages\calibre\db\backend.py", line 123, in __setitem__
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

calibre 2.51 embedded-python: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Fantastic Fiction Adults && FictionDB && Author Book Count Hierarchy && Barnes & Noble && Find Duplicates && EpubMerge && QuarantineAndScrub && FanFicFare && Goodreads && Manage Series && Library Codes && Embed Comic Metadata && Job Spy && Goodreads Sync && Prettify Cover && Fantastic Fiction && MultiColumnSearch && Consolidate All Library Metadata && Clean Metadata
Traceback (most recent call last):
File "site-packages\calibre\gui2\__init__.py", line 413, in dispatch
File "site-packages\calibre\gui2\actions\choose_library.py", line 569, in switch_requested
File "site-packages\calibre\gui2\ui.py", line 663, in library_moved
File "site-packages\calibre\gui2\library\views.py", line 727, in set_database
File "site-packages\calibre\gui2\library\views.py", line 530, in save_state
File "site-packages\calibre\gui2\library\views.py", line 524, in write_state
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 594, in set_pref
File "site-packages\calibre\db\backend.py", line 127, in set
File "site-packages\calibre\db\backend.py", line 123, in __setitem__
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

Added 0 books in 3.2 seconds
calibre 2.51 embedded-python: True is64bit: False
Windows-7-6.1.7601-SP1 Windows ('32bit', 'WindowsPE')
('Windows', '7', '6.1.7601')
Python 2.7.9
Windows: ('7', '6.1.7601', 'SP1', 'Multiprocessor Free')
Successfully initialized third party plugins: Fantastic Fiction Adults && FictionDB && Author Book Count Hierarchy && Barnes & Noble && Find Duplicates && EpubMerge && QuarantineAndScrub && FanFicFare && Goodreads && Manage Series && Library Codes && Embed Comic Metadata && Job Spy && Goodreads Sync && Prettify Cover && Fantastic Fiction && MultiColumnSearch && Consolidate All Library Metadata && Clean Metadata
Traceback (most recent call last):
File "site-packages\calibre\gui2\ui.py", line 938, in closeEvent
File "site-packages\calibre\gui2\ui.py", line 836, in write_settings
File "site-packages\calibre\gui2\init.py", line 603, in save_layout_state
File "site-packages\calibre\gui2\library\views.py", line 530, in save_state
File "site-packages\calibre\gui2\library\views.py", line 524, in write_state
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 594, in set_pref
File "site-packages\calibre\db\backend.py", line 127, in set
File "site-packages\calibre\db\backend.py", line 123, in __setitem__
File "site-packages\calibre\db\backend.py", line 808, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

HarryT · 02-25-2016, 10:14 AM

Do you have any kind of sync process running on your Calibre library folder? Dropbox, or anything like that?

Paltieldav · 02-25-2016, 10:18 AM

Quote:

Originally Posted by HarryT

Do you have any kind of sync process running on your Calibre library folder? Dropbox, or anything like that?

No. Unless something is running that i dont know

02-24-2016, 10:24 AM	#1
Paltieldav Enthusiast Posts: 25 Karma: 10 Join Date: Feb 2016 Device: Amazon Kindle Fire	Can't open error Hey all, I enjoy been using calibre for awhile without issue and then a few days ago I got the following error message after starting it up. Picture of error message is attached. I can't do anything. Can't edit, delete books, add books nothing other than see the list of books. I've tried: repairing the program option when installing Calibre Checking database Restore database. And other things I can't recall. Each one failed to fix the problem and the database couldn't be restore. Any ideas? Thanks Attached Thumbnails

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't Open Error	Fiat_Lux	Calibre	10	09-27-2015 03:36 PM
open with plugin error	french imp	Plugins	1	07-19-2012 05:23 PM
E-Book Open Error	musesinspire	Calibre	4	05-29-2012 04:32 PM
ERROR: Could not open ebook: [Error 123]	kappsta	Calibre	6	03-11-2012 02:13 PM

02-24-2016, 11:45 AM	#2
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383099 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	Sounds as if your database is hosed. Retrieve the most recent database file from your backup. This is why we make backups!

02-24-2016, 11:54 AM	#4
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383099 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	No, not the entire calibre library, just the database file "metadata.db" (in the root of your calibre library directory). It will only be a few MB. Just copy it from whatever your backup medium is.

02-24-2016, 01:45 PM	#5
theducks Well trained by Cats Posts: 31,054 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Where is the Database (full path)?

02-24-2016, 07:58 PM	#7
theducks Well trained by Cats Posts: 31,054 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	OK, you are using a local drive Have you checked these? http://manual.calibre-ebook.com/faq....ing-on-windows

02-25-2016, 09:46 AM	#9
Paltieldav Enthusiast Posts: 25 Karma: 10 Join Date: Feb 2016 Device: Amazon Kindle Fire	So I figured I would just have to add all the books again. So I tested one book and got the following error: calibre, version 2.51.0 ERROR: Errors while adding: Failed to add any books, click "Show details" for more information ---------------------------------------------------------------------- Failed to add the book: It Doesn't Take a Hero D:\Norman Schwarzkopf\It Doesn't Take a Hero (15)\metadata.opf With error: Traceback (most recent call last): File "site-packages\calibre\gui2\add.py", line 369, in add_book File "site-packages\calibre\db\legacy.py", line 214, in create_book_entry File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock File "site-packages\calibre\db\cache.py", line 1519, in create_book_entry File "site-packages\calibre\db\cache.py", line 1248, in set_metadata File "site-packages\calibre\db\cache.py", line 1075, in update_path File "site-packages\calibre\db\backend.py", line 1530, in update_path File "site-packages\calibre\db\tables.py", line 130, in set_path File "site-packages\calibre\db\backend.py", line 808, in execute File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor CantOpenError: CantOpenError: unable to open database file

02-25-2016, 09:50 AM	#10
Paltieldav Enthusiast Posts: 25 Karma: 10 Join Date: Feb 2016 Device: Amazon Kindle Fire	Ok Very Weird. I tired adding the same book again without the opf file again it didn't work but I got the duplicate book found pop up asking if I wanted to add it. Iloooked in the Calibre folder and the book was added but not showing in the program. Now Im more confused.

02-25-2016, 09:58 AM	#11
Paltieldav Enthusiast Posts: 25 Karma: 10 Join Date: Feb 2016 Device: Amazon Kindle Fire	I created a new library and the book was aded properly to that folder. Something is corrupt about my original folder and I dont know what.

02-25-2016, 10:14 AM	#14
HarryT eBook Enthusiast Posts: 85,544 Karma: 93383099 Join Date: Nov 2006 Location: UK Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6	Do you have any kind of sync process running on your Calibre library folder? Dropbox, or anything like that?

Advert

Advert