Calibre unaccessible, if library in Google Drive

[chillybang]

After Calibre installation I added to it the path to library in my Google Drive. Since then I can't access it with the error "database is locked". Book import fails with the same error:

PHP Code:

Hinzufügen des Buches fehlgeschlagen:Лето волонтёра
    C:\Users\Orlov.MEDIAWORXDE\Downloads\Lukyanenko_Izmenyonnye_4_Leto-volontyora.693139.fb2.epub
Mit Fehler:
Traceback (most recent call last):
  File "calibre\gui2\add.py", line 458, in add_book
  File "calibre\db\legacy.py", line 341, in create_book_entry
  File "calibre\db\cache.py", line 77, in call_func_with_lock
  File "calibre\db\cache.py", line 1969, in create_book_entry
  File "calibre\db\backend.py", line 1022, in execute
apsw.BusyError: BusyError: database is locked 


What could I do? I see only deinstallation as hint

[jackie_w]

Originally Posted by chillybang

What could I do?

Better research maybe? Hopefully you've kept a good backup.

[ownedbycats]

Close Calibre and remove the library from Google Drive.

Open Calibre again. Go to Preferences > Run Welcome Wizard and the folder to your new library folder.

Then run Library > Library maintenance > Restore database. Expect this to take a while, a few hours at least. This will rebuild the database from the OPF backups.



If this doesn't work:
Create a new library. Do not put it in Google Drive.

Use Add from Folders and Subfolders and select your old library folder. This'll add your books to your new library.

[chillybang]

my question was rather: what could I do to run Calibre with a library in Google Drive?

Calibre doesnt start anymore. Error:

PHP Code:

calibre, version 6.14.0
FEHLER: Unbehandelter Ausnahmefehler: <b>BusyError</b>:BusyError: database is locked

calibre 6.14  embedded-python: True
Windows-10-10.0.19045-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19045')
Python 3.10.1
Windows: ('10', '10.0.19045', 'SP0', 'Multiprocessor Free')
Interface language: de
Traceback (most recent call last):
  File "calibre\gui2\ui.py", line 1236, in closeEvent
  File "calibre\gui2\ui.py", line 1081, in write_settings
  File "calibre\gui2\init.py", line 812, in save_layout_state
  File "calibre\gui2\library\views.py", line 835, in save_state
  File "calibre\gui2\library\views.py", line 829, in write_state
  File "calibre\db\cache.py", line 77, in call_func_with_lock
  File "calibre\db\cache.py", line 913, in set_pref
  File "calibre\db\backend.py", line 142, in set
  File "calibre\db\backend.py", line 129, in __setitem__
  File "calibre\db\backend.py", line 1022, in execute
apsw.BusyError: BusyError: database is locked 


[theducks]

Go read the Help: FAQ (kinda late on NAS/Cloud storage)
GD is known to be 100% incompatible with a Library (file structure)
(AFAIK You can Zip up your Library , The STORE that as a backup)

Every (new) user should absolutely read the FAQ before installing or changing things outside of Calibre.
Be wary, of the MR posts that say 'Works fine for me'. Some issues are listed because they are unpredictable. They are known to fail, just not when it will happen.

Calibre EXPECTS a local attached (internal or USB) drive and NO 2-way sync

[ownedbycats]

Originally Posted by chillybang

my question was rather: what could I do to run Calibre with a library in Google Drive?

You bloody don't! This was explained in the FAQ entry you were linked.

[chillybang]

Originally Posted by ownedbycats

You bloody don't! This was explained in the FAQ entry you were linked.

Hmm, with One Drive it worked for me like a charm... Thats the cause I'm asking.

[DNSB]

Originally Posted by chillybang

Hmm, with One Drive it worked for me like a charm... Thats the cause I'm asking.

One Drive and Google Drive are two very different products. Google Drive loves adding a (number) to the end of folder names as part of it's versioning. Sadly, calibre adds a (number) to folder names as part of it's database recovery capability. A rather basic incompatibility.

Basically, using anything other than a locally attached drive for storing your calibre library is a disaster waiting to happen. One misstep and you will needing that recent backup—you do have backups?

To quote the FAQ you were given the link to:

Even with these tools there is danger of data corruption/loss, so only do this if you are willing to live with that risk. In particular, be aware that Google Drive is incompatible with calibre, if you put your calibre library in Google Drive, you will suffer data loss. See this thread for details.

I'm going to assume from your continued posts, that you did not read WARNING - Google Drive Incompatible with Calibre!.