Errors on Mac when library is on file server

[Dan__]

Running Mac. I've put the Calibre library on a Windows File Server. Everything works fine until the Mac suspends while Calibre is running. When you wake it up and try to perform any operation in Calibre is either says there are no formats:

calibre, version 0.8.30
ERROR: Format unavailable: Selected books have no formats

Then when the app exits, it says:
calibre, version 0.8.30
ERROR: Unhandled exception: <b>DatabaseException</b>:disk I/O error
RemoteTraceback (most recent call last):
File "site-packages/calibre/library/sqlite.py", line 271, in run
File "site-packages/calibre/library/sqlite.py", line 166, in get
OperationalError: disk I/O error

Traceback (most recent call last):
File "site-packages/calibre/gui2/actions/edit_metadata.py", line 175, in edit_metadata
File "site-packages/calibre/gui2/actions/edit_metadata.py", line 195, in do_edit_metadata
File "site-packages/calibre/gui2/metadata/single.py", line 976, in edit_metadata
File "site-packages/calibre/gui2/metadata/single.py", line 483, in start
File "site-packages/calibre/gui2/metadata/single.py", line 508, in do_one
File "site-packages/calibre/gui2/metadata/single.py", line 277, in __call__
File "site-packages/calibre/gui2/metadata/basic_widgets.py", line 1181, in initialize
File "site-packages/calibre/gui2/languages.py", line 31, in init_langs
File "site-packages/calibre/library/database2.py", line 2454, in get_languages_with_ids
File "site-packages/calibre/library/sqlite.py", line 314, in run
DatabaseException: disk I/O error
RemoteTraceback (most recent call last):
File "site-packages/calibre/library/sqlite.py", line 271, in run
File "site-packages/calibre/library/sqlite.py", line 166, in get
OperationalError: disk I/O error

[theducks]

Calibre is being run more as a 'desktop database'.
The first rule I learned back in (Paradox) DOS days: 'Never suspend' with the DB open.

Rule 2: Disable Disc caching, delayed writes can cause grief if all the files don't complete the write before the next fetch.

Rule3: Only use a solid (wired) network or you may end up simulating a rule 1or2 violation.

[Dan__]

Thanks

It is a wired network.

Disable disk caching where? A Calibre setting somewhere or the OS?

[theducks]

Originally Posted by Dan__

Thanks

It is a wired network.

Disable disk caching where? A Calibre setting somewhere or the OS?

No Sleeping is your prime priority.
Intel wired NIC's have a power management property defaulted to allow to sleep to save power. (and it does NOT appear in the Power Management settings, where you would expect )

Disk caching is and advanced setting in the O/S (usually near setting of VM or drive properties) : Allow fast removal is the wording for USB drives (they keep changing the location and wording, depending on OS version)

[Dan__]

Thanks again,

I can't see any obvious way to affect the cache behavior on Mac Lion. I think that unless Calibre could detect that it's host had just returned from a sleep state and reinit its network connections, that the situation is probably hopeless.

This prompts a different question. Can the Calibre app access a library and perform all its functions if the library is hosted on the calibre-server or is that only for use by e-book readers?

[theducks]

Originally Posted by Dan__

Thanks again,

I can't see any obvious way to affect the cache behavior on Mac Lion. I think that unless Calibre could detect that it's host had just returned from a sleep state and reinit its network connections, that the situation is probably hopeless.

This prompts a different question. Can the Calibre app access a library and perform all its functions if the library is hosted on the calibre-server or is that only for use by e-book readers?

No such beast.
Calibre is currently a single system program(it is run on any of the supported platforms)

There is a (read/fetch only) part that allows a remote to browse or fetch a copy using a standard web browser. No data changes are possible. It is called the Calibre content server and is configured in Preferences: Sharing... No limit (only O/S limited) on number of users.

The GUI is the normal way data is added or changed. Only one of these may access the Library at one time.

Another way to maintain data is Client-Host (Remote control) where the client (any OS) accesses the host using VNC or something similar. This works cross platform, the only warning is to Not set the host to reboot on loss of connection.

[Dan__]

Thank you