Kind request on metadata.db

Jamz · 09-19-2010, 02:37 PM

It looks like calibre keeps a constant file open lock on metadata.db? It seems logical BUT is there a way to change it so it only opens the file when it needs to?

Reason: I keep my ebook/calibre library on a UNC share on my HP MediaSmart Homeserver (since I have several gb of books). And the server complains every day about the file lock as it needs the file closed so it can "duplicate" the file. (All files on the share are duplicated like Raid 5).

I imagine this could be a problem for backups as well.

Normally this wouldn't be a problem as I would only run calibre when needed except for I leave it open to grab daily news.

DoctorOhh · 09-19-2010, 10:26 PM

Quote:

Originally Posted by Jamz

It looks like calibre keeps a constant file open lock on metadata.db? It seems logical BUT is there a way to change it so it only opens the file when it needs to?

I don't know if this can be changed, but I run my Library in Dropbox and I'm using Dropbox version 0.8.103 which is a beta build. Dropbox now will sync the Metadata.db file every time it is updated, even in its locked open state. If I were to use their current stable release 0.7.11 then I would have to leave my machine on after I quit calibre for the file to be unlocked and synced to my internet storage.

This doesn't help you with your problem, but I wonder if there is a setting or patch that will allow your HP MediaSmart Homeserver to do the same?

kovidgoyal · 09-19-2010, 10:36 PM

This is out of my control (it's set by the sqlite library), so it cannot be changed.

Jamz · 09-20-2010, 11:25 AM

OK, I go for Plan B then

So, if I have my news set to grab at 8am every day, and I run Calibre after that time, will it then run the job or wait till the next day? And or is there a command line option to run Calibre to "fetch and send news only" some way?

I'm thinking I need to just run Calibre as a windows job daily for about 10 minutes every morning. Is there a graceful way to have calibre shutdown via command line?

Manichean · 09-20-2010, 07:05 PM

Quote:

Originally Posted by Jamz

OK, I go for Plan B then

So, if I have my news set to grab at 8am every day, and I run Calibre after that time, will it then run the job or wait till the next day? And or is there a command line option to run Calibre to "fetch and send news only" some way?

I'm thinking I need to just run Calibre as a windows job daily for about 10 minutes every morning. Is there a graceful way to have calibre shutdown via command line?

This thread should help. For sending, use the calibre-smtp command.

09-19-2010, 02:37 PM	#1
Jamz Member Posts: 12 Karma: 10 Join Date: Aug 2010 Device: Kindle 3	Kind request on metadata.db It looks like calibre keeps a constant file open lock on metadata.db? It seems logical BUT is there a way to change it so it only opens the file when it needs to? Reason: I keep my ebook/calibre library on a UNC share on my HP MediaSmart Homeserver (since I have several gb of books). And the server complains every day about the file lock as it needs the file closed so it can "duplicate" the file. (All files on the share are duplicated like Raid 5). I imagine this could be a problem for backups as well. Normally this wouldn't be a problem as I would only run calibre when needed except for I leave it open to grab daily news.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
series metadata feature request	speakingtohe	Calibre	4	07-01-2010 05:58 PM
Feature Request: Lock Metadata	carpii	Calibre	3	02-27-2010 04:34 PM
Feature Request - cover browse in the "Fetch Metadata from server" function	nathander13	Calibre	1	01-30-2010 02:11 PM
Export Metadata to epub/pdf/txt - feature request?	asktheeightball	Calibre	0	11-27-2009 04:35 PM
A different kind of wish list	ChrisI	Sony Reader	19	06-04-2008 05:59 AM

09-19-2010, 10:36 PM	#3
kovidgoyal creator of calibre Posts: 43,866 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	This is out of my control (it's set by the sqlite library), so it cannot be changed.

09-20-2010, 11:25 AM	#4
Jamz Member Posts: 12 Karma: 10 Join Date: Aug 2010 Device: Kindle 3	OK, I go for Plan B then So, if I have my news set to grab at 8am every day, and I run Calibre after that time, will it then run the job or wait till the next day? And or is there a command line option to run Calibre to "fetch and send news only" some way? I'm thinking I need to just run Calibre as a windows job daily for about 10 minutes every morning. Is there a graceful way to have calibre shutdown via command line?

Advert

Advert