Impossible to add books

Calibre69 · 03-17-2019, 02:40 AM

Hello,

Excuse me for my poor English ...

I will try to describe to you my problem that has appeared since yesterday.

I have version 3.40.1 of Calibre and I don't know what happened, but since yesterday, when I want to add an epub in my library, I have the following error message:

Traceback (most recent call last):
File "site-packages \ template \ gui2 \ add.py", line 413, in add_book
File "site-packages \ template \ db \ legacy.py", line 224, in create_book_entry
File "site-packages \ caliber \ db \ cache.py", line 63, in call_func_with_lock
File "site-packages \ template \ db \ cache.py", line 1557, in create_book_entry
File "site-packages \ template \ db \ backend.py", line 845, in execute
File "c: \ t \ t \ apsw-bdov6u \ apsw-3.23.1-r1 \ src \ cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database

I uninstalled and reinstalled Calibre, but I still have the same problem ...

Could you help me solve this annoying problem

Thanks a lot and have a good day

kovidgoyal · 03-17-2019, 03:12 AM

Exclude the calibre library folder from your antivirus.

Calibre69 · 03-17-2019, 07:10 AM

Hello Mumbai,

My Calibre library is in the "Documents" folder of W10, under the name "Calibration Library" and I can't exclude a folder from my Windows Defender anti-virus.
I set my anti virus to accept Calibre and it didn't not change anything ....
What else to do ???

Calibre69 · 03-17-2019, 10:11 AM

Path is C:\Users\User\Documents\Calibre Library

I have been using the program and this path for years error just happened 2 days ago when I tried to add a new book....

I installed Calibre on my other computer (W10) and I have NO problem, NO error message

So....

theducks · 03-17-2019, 12:21 PM

Does your username (windows logon) have any non-ASCII characters?

stumped · 03-17-2019, 01:52 PM

You CAN exclude folders from Windows defender Scans and checks.

https://www.addictivetips.com/window...er-windows-10/

You can also temporarily turn off defender to see if that is the cause for the problem. Or not

Calibre69 · 03-17-2019, 02:14 PM

So, no, I don't think ..... my windows password is a mix of numbers and lowercase letters (6 in all).

I tried a database restore that failed:
Traceback (most recent call last):
File "site-packages \ template \ db \ restore.py", line 127, in run
File "site-packages \ template \ db \ restore.py", line 279, in replace_db
File "shutil.py", line 97, in copyfile
IOError: [Errno 2] No such file or directory: u'C: \\ Users \\ US2 \\ Documents \\ Calibration Library \\ metadata_pre_restore.db '

I NEVER had this problem before and without touching windows defender..

It's a real mystery !!

DNSB · 03-17-2019, 02:50 PM

Could you try the following procedure:

Open Windows Defender Security Center.
Click on Virus & threat protection.
Click the Virus & threat protection settings option.
Turn off the Controlled folder access toggle switch.

You could also try adding calibre's application collection to the allowed list in the Controlled Folder area but it was easier for me to move my calibre libraries into a new directory directly under my user directory (C:\Users\David\Calibre) and point calibre at the new locations.

theducks · 03-17-2019, 03:46 PM

Quote:

Originally Posted by Calibre69

So, no, I don't think ..... my windows password is a mix of numbers and lowercase letters (6 in all).

I tried a database restore that failed:
Traceback (most recent call last):
File "site-packages \ template \ db \ restore.py", line 127, in run
File "site-packages \ template \ db \ restore.py", line 279, in replace_db
File "shutil.py", line 97, in copyfile
IOError: [Errno 2] No such file or directory: u'C: \\ Users \\ US2 \\ Documents \\ Calibration Library \\ metadata_pre_restore.db '

I NEVER had this problem before and without touching windows defender..

It's a real mystery !!

Is this your unique name, because it sure is not Calibre Library (the default, but not required )?

BetterRed · 03-17-2019, 06:03 PM

It could be Onedrive synching.

Recent versions of Windows 10 automatically synchronise the %USERRHOME%\Documents folder to OneDrive, for that reason since calibre version 3.30 the location of the default library changed from %USERRHOME%\Documents\Calibre Library to ???? - I'm not sure. This only affects new installations of course. Synching involves file locking and VSS trickery.

IIRC you could exclude the Calibre Library folder in Documents from OneDrive synching; or you could pause Onedrive synching when you're using calibre; or you could move your library to a location that Onedrive won't synch automatically - such as %USERRHOME%\Calibre\Library. I would opt for the third option

Move the library when calibre is not running, then when you start calibre it should ask where its library went and offer a dialogue to select the new location.

BR

Calibre69 · 03-18-2019, 02:24 AM

Good Morning,

YES, BINGO, I followed your advice and changed the location of my "Caliber library": I put it in C: \ Users \ US2 \ Calibration Library and ALL is working normally ... but I don't understand why ! Why this new location is good...now ???

It's really odd, because when I installed Calibre yesterday on my second ASUS laptop, I did not have these problems ... and my folder is in C: \ Users \ NOUS2 \ Documents \ Calibration Library.
This second computer has the same version of W10 ...

Everything appeared on my HP desktop, why ????
Can you explain that to me ???
A HUGE THANK YOU to you ALL

Have a very good day

stumped · 03-18-2019, 03:32 PM

Quote:

Originally Posted by BetterRed

It could be Onedrive synching.

Recent versions of Windows 10 automatically synchronise the %USERRHOME%\Documents folder to OneDrive, for that reason since calibre version 3.30 the location of the default library changed from %USERRHOME%\Documents\Calibre Library to ???? - I'm not sure. This only affects new installations of course. Synching involves file locking and VSS trickery.

IIRC you could exclude the Calibre Library folder in Documents from OneDrive synching; or you could pause Onedrive synching when you're using calibre; or you could move your library to a location....

BR

Good spot. One drive is harmless only if you don't use Microsoft accounts. It cannot then auto sync as it has nowhere to sync to....

BetterRed · 03-18-2019, 06:27 PM

@Calibre69 - One of the features of Onedrive (Microsoft's equivalent of Dropbox, Google Drive etc) is that it can maintain a replica of designated folders on MS's cloud servers. A recent version of Windows added the user's Documents, Pictures, and Music folders to the default list of folders Onedrive will replicate to the cloud.

Prior to calibre version 3.30 a new install of Calibre would create its default library ("Calibre Library") in the users Documents folder. The design of the calibre software assumes it has exclusive access to the current library. But the advent of Onedrive's replication of the Documents by default means calibre and Onedrive are trying to access the same data concurrently.

Since calibre version 3.30, the Welcome wizard creates the default library in the users Home directory, which removes it from Onedrive's default list of folders to replicate to the cloud.

If you want to keep a copy of your library on your Onedrive 'account' use a file synch tool that can interoperate with Onedrive - most of them can.

I won't speculate why things work on your ASUS and not on your HP, there are too many variables at play. I suggest you move your calibre libraries out of the Documents folder on both computers.

BR

DNSB · 03-19-2019, 12:42 AM

Quote:

Originally Posted by Calibre69

Good Morning,

YES, BINGO, I followed your advice and changed the location of my "Caliber library": I put it in C: \ Users \ US2 \ Calibration Library and ALL is working normally ... but I don't understand why ! Why this new location is good...now ???

It's really odd, because when I installed Calibre yesterday on my second ASUS laptop, I did not have these problems ... and my folder is in C: \ Users \ NOUS2 \ Documents \ Calibration Library.
This second computer has the same version of W10 ...

Everything appeared on my HP desktop, why ????
Can you explain that to me ???

I have seen several people have issues with updates to Windows Defender and access to files/directories in it's protected folders which includes the Documents directory. The weird part is that in theory, Documents is part of the default for protected folders but some people have it protected and others don't despite "I didn't make any changes"—something which any tech has heard all too often.

There have also been issues with OneDrive and other cloud storage providers where they synchronize the Documents directory which can and does make calibre very unhappy. I generally find it easier to move the calibre library directories to where they will not be synchronized and then to save a backup where it will be synchronized.

stumped · 03-19-2019, 02:27 AM

Quote:

Originally Posted by DNSB

There have also been issues with OneDrive and other cloud storage providers where they synchronize the Documents directory which can and does make calibre very unhappy. I generally find it easier to move the calibre library directories to where they will not be synchronized and then to save a backup where it will be synchronized.

maybe a warning is needed in calibre FAQ / documentation re this. as it installs a library into documents by default
its probably too tricky to detect if sync is ON for one drive during an install, and to warn at that stage ?

03-17-2019, 02:40 AM	#1
Calibre69 Member Posts: 13 Karma: 10 Join Date: Mar 2019 Device: Kobo Aura 4	Impossible to add books Hello, Excuse me for my poor English ... I will try to describe to you my problem that has appeared since yesterday. I have version 3.40.1 of Calibre and I don't know what happened, but since yesterday, when I want to add an epub in my library, I have the following error message: Traceback (most recent call last): File "site-packages \ template \ gui2 \ add.py", line 413, in add_book File "site-packages \ template \ db \ legacy.py", line 224, in create_book_entry File "site-packages \ caliber \ db \ cache.py", line 63, in call_func_with_lock File "site-packages \ template \ db \ cache.py", line 1557, in create_book_entry File "site-packages \ template \ db \ backend.py", line 845, in execute File "c: \ t \ t \ apsw-bdov6u \ apsw-3.23.1-r1 \ src \ cursor.c", line 236, in resetcursor CantOpenError: CantOpenError: unable to open database I uninstalled and reinstalled Calibre, but I still have the same problem ... Could you help me solve this annoying problem Thanks a lot and have a good day

03-17-2019, 02:50 PM	#8
DNSB Bibliophagist Posts: 45,439 Karma: 168808777 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	Could you try the following procedure: Open Windows Defender Security Center. Click on Virus & threat protection. Click the Virus & threat protection settings option. Turn off the Controlled folder access toggle switch. You could also try adding calibre's application collection to the allowed list in the Controlled Folder area but it was easier for me to move my calibre libraries into a new directory directly under my user directory (C:\Users\David\Calibre) and point calibre at the new locations.

03-18-2019, 06:27 PM	#13
BetterRed null operator (he/him) Posts: 21,662 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Calibre69 - One of the features of Onedrive (Microsoft's equivalent of Dropbox, Google Drive etc) is that it can maintain a replica of designated folders on MS's cloud servers. A recent version of Windows added the user's Documents, Pictures, and Music folders to the default list of folders Onedrive will replicate to the cloud. Prior to calibre version 3.30 a new install of Calibre would create its default library ("Calibre Library") in the users Documents folder. The design of the calibre software assumes it has exclusive access to the current library. But the advent of Onedrive's replication of the Documents by default means calibre and Onedrive are trying to access the same data concurrently. Since calibre version 3.30, the Welcome wizard creates the default library in the users Home directory, which removes it from Onedrive's default list of folders to replicate to the cloud. If you want to keep a copy of your library on your Onedrive 'account' use a file synch tool that can interoperate with Onedrive - most of them can. I won't speculate why things work on your ASUS and not on your HP, there are too many variables at play. I suggest you move your calibre libraries out of the Documents folder on both computers. BR Last edited by BetterRed; 03-19-2019 at 01:15 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vanishing auto add books during import, books left behind in auto add folder	jataadroid	Library Management	9	01-14-2018 11:43 PM
Impossible to add a font to an azw3. Is it a bug?	Ruskie_it	Editor	4	07-03-2017 07:02 AM
5 Reasons It’s Impossible to Find Funny Books	xg4bx	General Discussions	37	02-28-2014 08:17 AM
Trying to add large library of books - add books seems to have hung	nicknefarious	Library Management	1	06-18-2012 09:32 AM
I was told ya can use itunes to get audio books, so how do ya add the books to the K?	Dragoro	Amazon Kindle	27	04-16-2009 12:17 AM

03-17-2019, 03:12 AM	#2
kovidgoyal creator of calibre Posts: 45,253 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Exclude the calibre library folder from your antivirus.

03-17-2019, 07:10 AM	#3
Calibre69 Member Posts: 13 Karma: 10 Join Date: Mar 2019 Device: Kobo Aura 4	Hello Mumbai, My Calibre library is in the "Documents" folder of W10, under the name "Calibration Library" and I can't exclude a folder from my Windows Defender anti-virus. I set my anti virus to accept Calibre and it didn't not change anything .... What else to do ???

03-17-2019, 10:11 AM	#4
Calibre69 Member Posts: 13 Karma: 10 Join Date: Mar 2019 Device: Kobo Aura 4	Path is C:\Users\User\Documents\Calibre Library I have been using the program and this path for years error just happened 2 days ago when I tried to add a new book.... I installed Calibre on my other computer (W10) and I have NO problem, NO error message So....

03-17-2019, 12:21 PM	#5
theducks Well trained by Cats Posts: 30,946 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Does your username (windows logon) have any non-ASCII characters?

03-17-2019, 01:52 PM	#6
stumped Wizard Posts: 3,305 Karma: 10259306 Join Date: May 2016 Device: kobo forma, Kobo Libra, Huawei media Tab, fire HD10, PW3 HDX8.9,	You CAN exclude folders from Windows defender Scans and checks. https://www.addictivetips.com/window...er-windows-10/ You can also temporarily turn off defender to see if that is the cause for the problem. Or not

03-17-2019, 02:14 PM	#7
Calibre69 Member Posts: 13 Karma: 10 Join Date: Mar 2019 Device: Kobo Aura 4	So, no, I don't think ..... my windows password is a mix of numbers and lowercase letters (6 in all). I tried a database restore that failed: Traceback (most recent call last): File "site-packages \ template \ db \ restore.py", line 127, in run File "site-packages \ template \ db \ restore.py", line 279, in replace_db File "shutil.py", line 97, in copyfile IOError: [Errno 2] No such file or directory: u'C: \\ Users \\ US2 \\ Documents \\ Calibration Library \\ metadata_pre_restore.db ' I NEVER had this problem before and without touching windows defender.. It's a real mystery !!

03-17-2019, 06:03 PM	#10
BetterRed null operator (he/him) Posts: 21,662 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	It could be Onedrive synching. Recent versions of Windows 10 automatically synchronise the %USERRHOME%\Documents folder to OneDrive, for that reason since calibre version 3.30 the location of the default library changed from %USERRHOME%\Documents\Calibre Library to ???? - I'm not sure. This only affects new installations of course. Synching involves file locking and VSS trickery. IIRC you could exclude the Calibre Library folder in Documents from OneDrive synching; or you could pause Onedrive synching when you're using calibre; or you could move your library to a location that Onedrive won't synch automatically - such as %USERRHOME%\Calibre\Library. I would opt for the third option Move the library when calibre is not running, then when you start calibre it should ask where its library went and offer a dialogue to select the new location. BR

03-18-2019, 02:24 AM	#11
Calibre69 Member Posts: 13 Karma: 10 Join Date: Mar 2019 Device: Kobo Aura 4	Good Morning, YES, BINGO, I followed your advice and changed the location of my "Caliber library": I put it in C: \ Users \ US2 \ Calibration Library and ALL is working normally ... but I don't understand why ! Why this new location is good...now ??? It's really odd, because when I installed Calibre yesterday on my second ASUS laptop, I did not have these problems ... and my folder is in C: \ Users \ NOUS2 \ Documents \ Calibration Library. This second computer has the same version of W10 ... Everything appeared on my HP desktop, why ???? Can you explain that to me ??? A HUGE THANK YOU to you ALL Have a very good day

Advert

Advert