My calibre database is corrupted and calibre can't fix it

septentrion · 03-20-2015, 01:16 PM

Hello

my library is on dropbox, not the harddrive of my computer. This morning it worked fine but this evening, when I start calibre version 2.21, it needs to restore the database (er, I have calibre in French so I hope I have the right words) because it is corrupted. I tired it 3 times but then it fails and here is the error message I get:

"calibre, version 2.21.0
ERREUR : Échec: La restauration de la base de données a échoué, cliquer sur Afficher les détails pour en apprendre davantage

Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 125, in run
File "site-packages\calibre\db\restore.py", line 277, in replace_db
WindowsError: [Error 32] Le processus ne peut pas acc�der au fichier car ce fichier est utilis� par un autre processus"

Windows error roughly translates as "the process can't access the file for this file is used by another processus".

What shoud I do? Move my library to another place? Or delete one file in my library folder?

Thanks for your help!

theducks · 03-20-2015, 02:44 PM

Quote:

Originally Posted by septentrion

Hello

my library is on dropbox, not the harddrive of my computer. This morning it worked fine but this evening, when I start calibre version 2.21, it needs to restore the database (er, I have calibre in French so I hope I have the right words) because it is corrupted. I tired it 3 times but then it fails and here is the error message I get:

"calibre, version 2.21.0
ERREUR : Échec: La restauration de la base de données a échoué, cliquer sur Afficher les détails pour en apprendre davantage

Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 125, in run
File "site-packages\calibre\db\restore.py", line 277, in replace_db
WindowsError: [Error 32] Le processus ne peut pas acc�der au fichier car ce fichier est utilis� par un autre processus"

Windows error roughly translates as "the process can't access the file for this file is used by another processus".

What shoud I do? Move my library to another place? Or delete one file in my library folder?

Thanks for your help!

Did you reboot? The file is currently blocked

Did you NORMALLY start with the content server or Wireless device Enabled?

eschwartz · 03-20-2015, 03:12 PM

Are you by any chance leaving Dropbox running? Very important -- do not EVER allow a sync program (whether cloud storage or local directory mirroring) to access your calibre library while calibre is running.

They will be fighting it out over who gets to access the files.

And then Bad Things happen, like corruption and duplication.

septentrion · 03-21-2015, 12:16 AM

Quote:

Originally Posted by theducks

Did you reboot? The file is currently blocked

Did you NORMALLY start with the content server or Wireless device Enabled?

Thanks for replying!

I shut down my computer in the morning and restarted it in the evening.

I normally start with dropbox, where my library is, running and then start calibre.

septentrion · 03-21-2015, 12:21 AM

Quote:

Originally Posted by eschwartz

Are you by any chance leaving Dropbox running? Very important -- do not EVER allow a sync program (whether cloud storage or local directory mirroring) to access your calibre library while calibre is running.

They will be fighting it out over who gets to access the files.

And then Bad Things happen, like corruption and duplication.

Thanks for your reply!

Yes, I do because my library is on Dropbox, not on the harddrive. It's never caused a problem before. And I save my library on other cloud storage services using the calibre function "save under..." (or something like that). I wasn't aware that running cloud services with calibre could cause troubles. Maybe I should just copy my library on my harddrive and use the cloud storage services just to save my library...

AnemicOak · 03-21-2015, 12:27 AM

Quote:

Originally Posted by septentrion

Yes, I do because my library is on Dropbox, not on the harddrive.

The library has to be on your computer hard drive in order to sync with DropBox (you can shut off the DropBox software & the files will still be there locally). DropBox contains a copy of whatever you have set to sync with it, usually what's in the computers local DropBox folder. In other words Calibre makes changes to your library that's stored on your hard drive and then it's sync'd to DropBox. The possible exception being backups made using the Save To Disk function you mention. Best practice is to pause the DropBox software then open Calibre and do whatever you're wanting to do (add books, edit meta data, etc.) then close Calibre and unpause BropBox so it can sync any changes you made.

BetterRed · 03-21-2015, 02:19 AM

Quote:

Originally Posted by septentrion

Thanks for your reply!

Yes, I do because my library is on Dropbox, not on the harddrive. It's never caused a problem before. And I save my library on other cloud storage services using the calibre function "save under..." (or something like that). I wasn't aware that running cloud services with calibre could cause troubles. Maybe I should just copy my library on my harddrive and use the cloud storage services just to save my library...

I think you should do that - see this ==>> I am getting errors with my calibre library on a networked drive/NAS?

Bottom line is, don't put your live library in the cloud... if you you it's almost certain to become corrupted... Keep a copy there, for sure

BR

eschwartz · 03-21-2015, 11:56 PM

Quote:

Originally Posted by septentrion

Thanks for your reply!

Yes, I do because my library is on Dropbox, not on the harddrive. It's never caused a problem before. And I save my library on other cloud storage services using the calibre function "save under..." (or something like that). I wasn't aware that running cloud services with calibre could cause troubles. Maybe I should just copy my library on my harddrive and use the cloud storage services just to save my library...

As AnemicOak pointed out, Dropbox is only syncing the files that are on your hard drive. If not, you couldn't use them at all.

Maybe you had troubles before and just didn't notice them, maybe not -- either way, it's dangerous.

It shouldn't be a problem to keep your library in Dropbox, just do what I and many other people have learned to do -- pause Dropbox while you use calibre.

You can also get fancy, and setup rotating incremental snapshots of your data, and copy that into Dropbox -- if you feel comfortable doing that.

There are different levels to keeping data safe and backed up.

PeterT · 03-22-2015, 12:18 AM

Not being a nay sayer but there actually are products out there that leverage Dropbox and provide access to the cloud based data without a local replica. See for instance Netdrive

eschwartz · 03-22-2015, 12:41 AM

Okay, yes. Theoretically you can do that.

I also have a script that fuse-mounts my copy.com cloud storage to my local machine. Such usage tends to be very slow due to the overhead of constantly downloading and uploading info -- much better to sync it all and just imagine that the local copy is a cache.

(I used it only to upload stuff without requiring a local install+sync.)

I feel safe assuming the vast majority of people are not doing any such thing.

cybmole · 03-22-2015, 02:53 AM

Quote:

Originally Posted by PeterT

Not being a nay sayer but there actually are products out there that leverage Dropbox and provide access to the cloud based data without a local replica. See for instance Netdrive

how does net drive solve the issues caused by keeping a live calibre library in dropbox. I read the blurb but could not see the answer

surely if I link a live calibre library to net drive & then carry out calibre operations, it can still mess up ?

septentrion · 03-22-2015, 07:00 AM

Quote:

Originally Posted by BetterRed

I think you should do that - see this ==>> I am getting errors with my calibre library on a networked drive/NAS?

Bottom line is, don't put your live library in the cloud... if you you it's almost certain to become corrupted... Keep a copy there, for sure

BR

Tahnk you for the link! I didn't know any of that.

septentrion · 03-22-2015, 07:01 AM

Quote:

Originally Posted by eschwartz

As AnemicOak pointed out, Dropbox is only syncing the files that are on your hard drive. If not, you couldn't use them at all.

Maybe you had troubles before and just didn't notice them, maybe not -- either way, it's dangerous.

It shouldn't be a problem to keep your library in Dropbox, just do what I and many other people have learned to do -- pause Dropbox while you use calibre.

You can also get fancy, and setup rotating incremental snapshots of your data, and copy that into Dropbox -- if you feel comfortable doing that.

There are different levels to keeping data safe and backed up.

Thank you for the advice. I think I'll stick with pausing dropbox while using calibre. Getting fancy seems kind of complicated.

eschwartz · 03-22-2015, 01:24 PM

I figured as much.

03-20-2015, 01:16 PM	#1
septentrion Addict Posts: 286 Karma: 5125274 Join Date: May 2012 Location: France Device: Kindle Paperwhite 2014, Kindle Voyage and Kindle Oasis 2	My calibre database is corrupted and calibre can't fix it Hello my library is on dropbox, not the harddrive of my computer. This morning it worked fine but this evening, when I start calibre version 2.21, it needs to restore the database (er, I have calibre in French so I hope I have the right words) because it is corrupted. I tired it 3 times but then it fails and here is the error message I get: "calibre, version 2.21.0 ERREUR : Échec: La restauration de la base de données a échoué, cliquer sur Afficher les détails pour en apprendre davantage Traceback (most recent call last): File "site-packages\calibre\db\restore.py", line 125, in run File "site-packages\calibre\db\restore.py", line 277, in replace_db WindowsError: [Error 32] Le processus ne peut pas acc�der au fichier car ce fichier est utilis� par un autre processus" Windows error roughly translates as "the process can't access the file for this file is used by another processus". What shoud I do? Move my library to another place? Or delete one file in my library folder? Thanks for your help!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Aura HD Help with corrupted database - Manually fix (easy, please)?	arspr	Kobo Reader	6	06-25-2014 10:47 AM
How to manually fix a (probably) corrupted database?	Lucas Malor	Kobo Reader	13	05-09-2013 08:01 PM
[Old Thread] Calibre database keeps getting corrupted on Win 7 - help!?!	jer989	Calibre	17	01-01-2013 03:36 PM
Calibre Mac & Windows (Corrupted Database)	ciscoswitch	Calibre	4	09-08-2010 01:29 PM
Calibre keeps saying database of books is corrupted. Media.xml file	seajewel	Calibre	8	02-26-2010 09:35 PM

03-20-2015, 03:12 PM	#3
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Are you by any chance leaving Dropbox running? Very important -- do not EVER allow a sync program (whether cloud storage or local directory mirroring) to access your calibre library while calibre is running. They will be fighting it out over who gets to access the files. And then Bad Things happen, like corruption and duplication.

03-22-2015, 12:18 AM	#9
PeterT Grand Sorcerer Posts: 13,511 Karma: 78910202 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	Not being a nay sayer but there actually are products out there that leverage Dropbox and provide access to the cloud based data without a local replica. See for instance Netdrive

03-22-2015, 12:41 AM	#10
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Okay, yes. Theoretically you can do that. I also have a script that fuse-mounts my copy.com cloud storage to my local machine. Such usage tends to be very slow due to the overhead of constantly downloading and uploading info -- much better to sync it all and just imagine that the local copy is a cache. (I used it only to upload stuff without requiring a local install+sync.) I feel safe assuming the vast majority of people are not doing any such thing.

03-22-2015, 01:24 PM	#14
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	I figured as much.

Advert

Advert