Storing calibre database on NAS

luoto · 06-08-2012, 01:38 AM

Hello. I am trying to store my calibre database on to a NAS drive but running it on my Mac OSX10.7. It works well on local drive (thank you to the developer for the great tool!) but to save space I want to offload it to a drive mapped on my finder.

I am not trying to let it multi user access, but despite it letting me map it to a volume through the finder, with full r/w privs, it then throws up many errors.

I then copied the data to the NAS with the move library tool and things fail with a metadata read.

calibre, version 0.8.53
WARNING: Failed to read metadata: Failed to read metadata from the following:

Till_We_Eat_Again_nodrm.pdf
Traceback (most recent call last):
File "site-packages/calibre/gui2/add.py", line 127, in start
File "site-packages/calibre/gui2/add.py", line 217, in add
File "site-packages/calibre/library/database2.py", line 3239, in create_book_entry
File "site-packages/calibre/library/database2.py", line 2094, in set_metadata
File "site-packages/calibre/library/database2.py", line 643, in set_path
File "site-packages/calibre/library/sqlite.py", line 314, in run
DatabaseException: database is locked
RemoteTraceback (most recent call last):
File "site-packages/calibre/library/sqlite.py", line 271, in run
OperationalError: database is locked

Is one of the examples.

Is there any way around this as, with all my magazines and things, it is a lot of data (plus the NAS is backed up better!).

Thank you.

toddos · 06-08-2012, 01:50 AM

Try this.

luoto · 06-10-2012, 04:40 AM

Thanks. (Sorry for delay, I did not get a mail about the new posting).

I have read the link and I am not sure, sadly how to implement that within OSX so that it works then and works after a reboot.

Could this be something the development team could do within the application?

With kind regards,

toddos · 06-10-2012, 08:16 PM

Just to be clear, if you remount using nobrl does it work and you're just asking how to make it always mount that way? Or you're not sure how to mount as nobrl in the first place?

First, this is not a calibre issue but a Samba/OS X issue, so there's not really anything calibre can do about it. The linked post shows how to do that for other *nix-based systems that support /etc/fstab, but OS X apparently has deprecated fstab in favor of using automounter instead. So you just need to figure out how to configure SMB mount options for automounter. I don't have an OS X machine so I couldn't tell you how to do that, but I bet google knows.

luoto · 06-15-2012, 02:44 AM

Thanks. To be clear it was a "I don''t know how" in OSX type of thing. Is it a "fault" with the type of database used (not that I am casting blame or expecting a change). I think I can get an AFP connection if that helps. I will do some more googling as well over the weekend else will just have to stick with an extra drive locally which is less ideal but safer for the data than me messing under the hood !

Kind regards and thanks

06-08-2012, 01:38 AM	#1
luoto Member Posts: 15 Karma: 10 Join Date: Jun 2012 Device: ipad	Storing calibre database on NAS Hello. I am trying to store my calibre database on to a NAS drive but running it on my Mac OSX10.7. It works well on local drive (thank you to the developer for the great tool!) but to save space I want to offload it to a drive mapped on my finder. I am not trying to let it multi user access, but despite it letting me map it to a volume through the finder, with full r/w privs, it then throws up many errors. I then copied the data to the NAS with the move library tool and things fail with a metadata read. calibre, version 0.8.53 WARNING: Failed to read metadata: Failed to read metadata from the following: Till_We_Eat_Again_nodrm.pdf Traceback (most recent call last): File "site-packages/calibre/gui2/add.py", line 127, in start File "site-packages/calibre/gui2/add.py", line 217, in add File "site-packages/calibre/library/database2.py", line 3239, in create_book_entry File "site-packages/calibre/library/database2.py", line 2094, in set_metadata File "site-packages/calibre/library/database2.py", line 643, in set_path File "site-packages/calibre/library/sqlite.py", line 314, in run DatabaseException: database is locked RemoteTraceback (most recent call last): File "site-packages/calibre/library/sqlite.py", line 271, in run OperationalError: database is locked Is one of the examples. Is there any way around this as, with all my magazines and things, it is a lot of data (plus the NAS is backed up better!). Thank you.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calibre Library on Mounted NAS Drive	enjiro	Calibre	13	04-02-2018 06:13 AM
Calibre on Qnap NAS TS419P	2012	Related Tools	6	10-04-2016 01:28 PM
[HOW TO] Install Calibre in Intel-Based NAS	aruangra	Related Tools	9	01-19-2013 10:49 PM
Compiling Calibre on NAS	Yancoucou	Devices	3	01-14-2012 05:11 PM
Using Calibre on a NAS	Shawn_KY	Calibre	9	01-07-2011 01:24 AM

06-08-2012, 01:50 AM	#2
toddos Guru Posts: 695 Karma: 822675 Join Date: May 2010 Device: Kobo Aura, Nokia Lumia 920 (Freda)	Try this.

06-10-2012, 04:40 AM	#3
luoto Member Posts: 15 Karma: 10 Join Date: Jun 2012 Device: ipad	Thanks. (Sorry for delay, I did not get a mail about the new posting). I have read the link and I am not sure, sadly how to implement that within OSX so that it works then and works after a reboot. Could this be something the development team could do within the application? With kind regards,

06-10-2012, 08:16 PM	#4
toddos Guru Posts: 695 Karma: 822675 Join Date: May 2010 Device: Kobo Aura, Nokia Lumia 920 (Freda)	Just to be clear, if you remount using nobrl does it work and you're just asking how to make it always mount that way? Or you're not sure how to mount as nobrl in the first place? First, this is not a calibre issue but a Samba/OS X issue, so there's not really anything calibre can do about it. The linked post shows how to do that for other *nix-based systems that support /etc/fstab, but OS X apparently has deprecated fstab in favor of using automounter instead. So you just need to figure out how to configure SMB mount options for automounter. I don't have an OS X machine so I couldn't tell you how to do that, but I bet google knows.

06-15-2012, 02:44 AM	#5
luoto Member Posts: 15 Karma: 10 Join Date: Jun 2012 Device: ipad	Thanks. To be clear it was a "I don''t know how" in OSX type of thing. Is it a "fault" with the type of database used (not that I am casting blame or expecting a change). I think I can get an AFP connection if that helps. I will do some more googling as well over the weekend else will just have to stick with an extra drive locally which is less ideal but safer for the data than me messing under the hood ! Kind regards and thanks